%%%OTRS has a list of email addresses that it is configured to handleOTRS has a list of email addresses that it is configured to handle. The list is stored in mysql, and our mx's check the list as part of their message routing logic.
@faidon found ~160 addresses in the OTRS database which will never see email for various reasons. In some cases we don't even own the domain, in others routes to other destinations preempt the OTRS lookup.
Part of the reason this happens is that OTRS provides no way to delete addresses. You can mark them invalid or temporary-invalid, but that's it.
Faidon adjusted exim's OTRS mysql query to only include addresses which are 'valid'.
We should go through these ~160 addresses in OTRS and mark them invalid, and possibly add a note explaining where they route to. This will help avoid future confusion. THere's the list is%%%t:
- 10urodziny at wikimedia
%%%stored in mysql, and our mx's check the list as part of their message routing%%% - abuse at wikimedia
%%%logic.%%% - abuse at wikimedia
%%%Faidon found ~160 addresses in the OTRS database which will never see email for%%% - academy at wikimedia
%%%various reasons. In some cases we don't even own the domain, in others routes%%% - adhesions at wikimedia
%%%to other destinations preempt the OTRS lookup.%%% - adressvergabe at wikimedia
%%%Part of the reason this happens is that OTRS provides no way to delete%%% - ahair at wikimedia
%%%addresses. You can mark them invalid or temporary-invalid, but that's it.%%% - akademie at wikimedia
%%%Faidon adjusted exim's OTRS mysql query to only include addresses which are%%% - akl at wikipedia
%%%'valid'.%%% - bibstip at wikimedia
%%%We should go through these ~160 addresses in OTRS and mark them invalid, and%%% - bilderschatz at wikimedia
%%%possibly add a note explaining where they route to. This will help avoid future%%% - bilderwettbewerb at wikimedia
%%%confusion. Here's the list:%%% - bilderwettbewerb at wikipedia
%%%<10urodziny - bildung at wikimedia>%%%
%%%<abuse - board at wikimedia>%%%
%%%<abuse - board at wikimedia>%%%
%%%<academy - boutique at wikimedia>%%%
%%%<adhesion - business at wikimedia>%%%
%%%<adressvergabe - campus at wikimedia>%%%
%%%<ahair - community at wikimedia>%%%
%%%<akademie - communitys at wikimedia>%%%
%%%<akl - communitys at wikipmedia>%%%
%%%<bibstip - conference at wikimedia>%%%
%%%<bilderschatz - contact at wikimedia>%%%
%%%<bilderwettbewerb - daily-article-l-owner at wikimedia>%%%lists
%%%<bilderwettbewerb - diversity at wikipmedia>%%%
%%%<bildung - donate at wikimedia>%%%
%%%<board - donateurs at wikimedia>%%%
%%%<board - donation at wikimedia>%%%
%%%<boutique - donation at wikimpedia>%%%
%%%<busines - donations at wikimedia>%%%
%%%<campu - donations at wikimedia>%%%
%%%<community - donations at wikimpedia>%%%
%%%<communitys - dons-auto at wikimedia>%%%
%%%<communitys - dons-FR at wikimedia>%%%
%%%<conference - dons at wikimedia>%%%
%%%<contact - dons at wikimedia>%%%
%%%<daily-article-l-owner - fax at lists>%%%wikimedia
%%%<diversity - foerderer at wikimedia>%%%
%%%<donate - forum at wikimedia>%%%
%%%<donateurs - freiwillige at wikimedia>%%%vorstand
%%%<donation - fundraiser at wikimedia>%%%
%%%<donation - fundraising at wikipmedia>%%%
%%%<donations - hackathon at wikimedia>%%%
%%%<donations - hackathon at wikimedia>%%%
%%%<donations - helpdesk-l at wikipmedia>%%%
%%%<dons-auto - helpdesk-l at wikimpedia>%%%
%%%<dons-FR - hochschule at wikimedia>%%%
%%%<dons - hochschulprogramm at wikimedia>%%%
%%%<dons - hostmaster at wikimedia>%%%
%%%<fax - hostmaster at wikimpedia>%%%
%%%<foerderer - https at wikimedia>%%%
%%%<forum - ideen at wikimedia>%%%
%%%<freiwillig - improve at vorstand>%%%wikimedia
%%%<fundraiser - info at wvikimedia>%%%ja
%%%<fundraising - info at wikimedia>%%%i
%%%<hackathon - info at wikimedia>%%%icon
%%%<hackathon - info at wikimedia>%%%lovesearth
%%%<helpdesk-l - info at wikimedia>%%%lovesmonuments
%%%<helpdesk-l - info at wikipedia>%%%lovesmonuments
%%%<hochschule - info at wikimedia>%%%lovesmonuments
%%%<hochschulprogramm - info at wikimedia>%%%lovesmonuments
%%%<hostmaster - info at wikimedia>%%%
%%%<hostmaster - info at wikipmedia>%%%
%%%<https - info at wikimedia>%%%
%%%<ideen - info at wikimedia>%%%
%%%<improve - info at wikimedia>%%%
%%%< - info at vwikimedija>%%%a
%%%< - info at wiki>%%%media
%%%< - info at wikicon>%%%media
%%%< - info at wikilovesearth>%%%media
%%%<i - Info at wikilovesmonuments>%%%media
%%%< - info at wikilovesmonuments>%%%media
%%%< - info at wikilovesmonuments>%%%media
%%%< - info at wikilovesmonuments>%%%media
%%%< - info at wikimedia>%%%conferentie
%%%< - info at wikimpedia>%%%
%%%<info - jobs at wikimedia>%%%
%%%<info - jobs at wikimpedia>%%%
%%%<info - kompass2020 at wikimedia>%%%
%%%<info - kontakt at wikimedia>%%%
%%%<info - kultur at wikimedia>%%%
%%%<info - legal-en at wikimedia>%%%
%%%<inf - legal-tm-vio at wikimedia>%%%
%%%<Info - legal at wikimedia>%%%
%%%<info - legal at wikimedia>%%%
%%%<info - litstip at wikimedia>%%%
%%%<info at - mitglieder@wikimedia>%%%,de
%%%<info at wikimediaconferentie>%%% - mitgliederbetreuung at wikimedia
%%%<info - mitgliedschaft at wikipmedia>%%%
%%%<jobs - mv2009 at wikimedia>%%%
%%%<jobs - mv2010 at wikipmedia>%%%
%%%<kompass202 - mv2010 at wikimedia>%%%
%%%<kontakt - mv2011 at wikimedia>%%%
%%%<kultur - mv at wikimedia>%%%
%%%<legal-en - namemaster at wikimedia>%%%
%%%<legal-tm-vio - namemaster at wikimedia>%%%
%%%<legal - noc at wikimedia>%%%
%%%<legal - noc at wikimedia>%%%
%%%<litstip - oer at wikimedia>%%%
%%%mitglieder@ - office at wikimedia,de%%%
%%%<mitgliederbetreuung - orders at wikimedia>%%%
%%%<mitgliedschaft - otrs at wikimedia>%%%
%%%<mv2009 - paypal at wikimedia>%%%
%%%<mv2010 - paypal at wikimedia>%%%
%%%<mv2010 - permissions at wikimedia>%%%
%%%<mv2011 - postmaster at wikimedia>%%%
%%%<mv - postmaster at wikimedia>%%%
%%%<name - postmaster at wikimedia>%%%
%%%<name - postmaster at wikimpedia>%%%
%%%<noc - press at wikimedia>%%%
%%%<noc - press at wikimedia>%%%
%%%<oer - press at wikimedia>%%%
%%%<office - press at wikimedia>%%%
%%%<order - press at wikimedia>%%%
%%%<otr - press at wikimpedia>%%%
%%%<paypal - presse-de at wikimedia>%%%
%%%<paypal - presse at wikimedia>%%%
%%%<permissions - presse at wikimedia>%%%
%%%<postmaster - presse at wikimedia>%%%
%%%<postmaster - presse at wikimpedia>%%%
%%%<postmaster - privacy at wikimedia>%%%
%%%<postmaster - projekte at wikipmedia>%%%
%%%<press - referenten at wikimedia>%%%
%%%<press - root at wikimedia>%%%hemlock
%%%<press - root at wikimedia>%%%zedler
%%%<press - schule at wikimedia>%%%
%%%<press - security at wikimedia>%%%
%%%<press - security at wikipedia>%%%
%%%<presse-de - shop at wikimedia>%%%
%%%<presse - silberwissen at wikimedia>%%%
%%%<press - spende at wikimedia>%%%
%%%<presse at - spenden@wikimedia>%%%,de
%%%<press - stammtische at wikipedia>%%%
%%%<privacy - technik at wikimedia>%%%
%%%<projekte - technikpool at wikimedia>%%%
%%%<referenten - toolserver at wikimedia>%%%
%%%<root - treffen at hemlock>%%%wikimedia
%%%<root - ts-admins at zedler>%%%toolserver
%%%<schule - ts-admins at wikimedia>%%%
%%%<secur - usability at wikimedia>%%%vorstand
%%%<security - ux at wikipmedia>%%%
%%%<shop - verein at wikimedia>%%%
%%%<silberwissen - volunteering at wikimedia>%%%
%%%<spende - webmaster at wikimedia>%%%
%%%spenden@ - webmaster at wikimedia,de%%%
%%%<stammtische - webmaster at wikipmedia>%%%
%%%<technik - webmaster at wikimpedia>%%%
%%%<technikpool - wiki-skills at wikimedia>%%%
%%%<toolserver - wikilovesmonuments at wikimedia>%%%
%%%<treffen - wikilovesmonuments at wikimedia>%%%mnederland
%%%<ts-admins - wikimania at toolserver>%%%wikimedia
%%%<ts-admins - wikimediaforum-berlin at wikimedia>%%%
%%%<usability at vorstand>%%% - wikimediaforum-nrw at wikimedia
%%%<ux - wikiversity at wikimedia>%%%
%%%<verein - wlm at wikimedia>%%%
%%%<volunteering - zarzad at wikimedia>%%%
%%%<webmaster - zedler-admins at wikimedia>%%%
%%%<webmaster at wikimedia>%%%
%%%<webmaster at wikimedia>%%%
%%%<webmaster at wikipedia>%%%
%%%<wiki-skills at wikimedia>%%%
%%%<wikilovesmonuments at wikimedia>%%%
%%%<wikilovesmonuments at wmnederland>%%%
%%%<wikimania at wikimedia>%%%
%%%<wikimediaforum-berlin at wikimedia>%%%
%%%<wikimediaforum-nrw at wikimedia>%%%
%%%<wikiversity at wikimedia>%%%
%%%<wlm at wikimedia>%%%
%%%<zarzad at wikimedia>%%%
%%%<zedler-admins at wikimedia>%%%
%%%<zedler at wikimedia>%%%
%%%<zehn at wikimedia>%%% - zedler at wikimedia
- zehn at wikimedia