(In reply to Alex Monk from comment #0)

See http://lists.wikimedia.org/pipermail/wikitech-l/2014-February/074511.html

Sent from kaulen in pmtpa, but BZ got moved to zirconium in eqiad.

Sam guesses it's not using db9/db10 which is the problem.

It being bugzilla. I'm guessing the script is still using db9/10

I'm also guessing this cronjob is probably not puppeti[sz]ed? ;)

Moved in https://git.wikimedia.org/commitdiff/operations%2Fpuppet.git/92c959ce03569b99b81feee66ad8c33724a3543e

Script is now at
https://git.wikimedia.org/blob/operations%2Fpuppet.git/d4ecffb804817b3569bcd96339047d24b46a62a4/modules%2Fbugzilla%2Ftemplates%2Fscripts%2Fbugzilla_report.php.erb and user is defined in https://git.wikimedia.org/blob/operations%2Fpuppet.git/d4ecffb804817b3569bcd96339047d24b46a62a4/modules%2Fbugzilla%2Fmanifests%2Freporter.pp

deleted old cron jobs on kaulen. the actual problem was just removing the old crons on the old server, I'd say. remember, puppet doesn't remove anything and we sure did not want to keep it as "ensure => absent" on kaulen forever.

Sam, actually.. no, I puppetized that:) We also had DB host and pass replaced by variables.. but the oversight was a hardcoded value left for the db _name. We just switched that from "bugzilla3" to simply "bugzilla" on db1001, because we wanted to clean up the old databases and by now it's BZ4 anyways..

https://gerrit.wikimedia.org/r/#/c/113961/

arg, yea yea, the script was puppetized, the user was.. all but the actual cron command. I added it manually and sent the report to Krenair and Andre.. Now we just gotta check if wikitech-l accepts the sender. I'll fix the cron before the next report.

haha, nice, wikitech-l sender filters: reporter@isidore.wikimedia.org

<-- set to zirconium instead (how did this ever work from kaulen?:)

Filter rules to match against the headers of a message.:python vs php

wut?:)

so after fixing the sender filter on the list side and also fixing the mail command (it changed between distros):

http://lists.wikimedia.org/pipermail/wikitech-l/2014-February/074555.html

please keep open to make me put the manual change into puppet

(In reply to Daniel Zahn from comment #7)

please keep open to make me put the manual change into puppet

ping

(In reply to Andre Klapper from comment #8)

ping

https://gerrit.wikimedia.org/r/#/c/115865/1

merged, confirmed on zirconium.

that just puppetized the live hack which was already working. so we should be done here.

notice: /Stage[main]/Bugzilla::Reporter/Cron[bugzilla_reporter_cron]/ensure: created

before, manual tmp. fix:

0 03 * * mon php -q /home/reporter/bugzilla_report.php | mail -s "Bugzilla Weekly Report" wikitech-l@lists.wikimedia.org > /dev/null

now, puppet:

0 3 * * 1 php -q /home/reporter/bugzilla_report.php | mail -s "Bugzilla Weekly Report" wikitech-l@lists.wikimedia.org > /dev/null

also removed the manual one and ran puppet twice. closing.