Page MenuHomePhabricator

Clean up OTRS/Znuny addresses handles by gsuite
Open, MediumPublic

Description

The OTRS/Znuny database contains a number of email addresses which are actually handles by gsuite. As such email will never get delivered to orts/zunny

ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: board@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: press@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: donations@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: security@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: postmaster@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: postmaster@wikipedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: privacy@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: legal-en@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: business@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: wm-cz@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: legal-tm-vio@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: ux@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: glam@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: improve@wikimedia.org
ERROR:/usr/local/bin/otrs_aliases:email is handled by gsuite: board@wikimedia.org

It would be useful to understand if theses emails should be removed from zunny or if we can ignore this.

Related Objects

StatusSubtypeAssignedTask
OpenNone

Event Timeline

jbond triaged this task as Medium priority.Jun 2 2021, 1:05 PM
jbond created this task.

Change 697785 had a related patch set uploaded (by Jbond; author: John Bond):

[operations/puppet@production] P:mail::mx: update systemd timer so that it fails silently

https://gerrit.wikimedia.org/r/697785

Change 697785 merged by Jbond:

[operations/puppet@production] P:mail::mx: update systemd timer so that it fails silently

https://gerrit.wikimedia.org/r/697785

jbond added a parent task: Restricted Task.Jun 2 2021, 2:02 PM
jbond added a subscriber: Keegan.

@Keegan I notice you working on the orts/znuny migration and wondered if you would be able to advice on this task, or point me to someone who may know more. thanks

(VRTS admin:) Except of glam@wikimedia.org, all listed mail addresses are deactivated in Znuny/OTRS, so no further actions necessary. For glam@wikimedia.org there is still a queue. @Sadads (Astinson (WMF)) is the only user with access to this queue. If the queue can be closed, we can also deactivate this mail address in Znuny. For this, please send a request to otrs-admins@lists.wikimedia.org.

@DC thanks for the update, do you know what database attribute i could use to exclude deactivated emails from my query. im curently using the following SQL statment to get all otrs emails

SELECT value0, create_time, change_time FROM system_address

@Sadads are you able to confirm if glam@wikimedia.org can be deactivated in OTRS, as far as i can tell no emails addresses to this email will be delivered to to OTRS and will instead be delivered to the google smtp servers

$ sudo exim -bt glam@wikimedia.org                                                                                                                      
glam@wikimedia.org
  router = ldap_group, transport = remote_smtp
  host aspmx.l.google.com [172.217.222.26]

@Keegan I notice you working on the orts/znuny migration and wondered if you would be able to advice on this task, or point me to someone who may know more. thanks

@jbond my utmost apologies for not replying to this earlier! These errors can be ignored, they will never go away AFAIK. These are the result of email addresses that used to be processed through OTRS/Znuny LTS, but were usurped by gsuite handling. When this occurs the old emails were invalidated and disabled from OTRS/Znuny LTS, but they cannot be deleted and so they will forever log errors unless/until the ability to delete unused emails is added as functionality.

@jbond my utmost apologies for not replying to this earlier! These errors can be ignored, they will never go away AFAIK. These are the result of email addresses that used to be processed through OTRS/Znuny LTS, but were usurped by gsuite handling. When this occurs the old emails were invalidated and disabled from OTRS/Znuny LTS, but they cannot be deleted and so they will forever log errors unless/until the ability to delete unused emails is added as functionality.

@Keegan I suppose this is still the case as of today? If it's just this small list of legacy addressed then we'd simply add them to the export script and filter them out as known false positives.

  1. Let's review if the new Znuny version enabled removal of unused emails and remove them if possible
  2. If not, then let's filter the emails in the export script (in profile::mail::vrts)

cc @Quiddity in case there are any comments about the above

@MoritzMuehlenhoff I cannot say for sure as I have not worked in this area for several years, but I cannot imagine that the situation has changed.