Last modified: 2014-02-27 21:43:24 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T63453, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 61453 - Bugzilla Weekly Report to wikitech-l@ fails due to move: "DB connection failure FAILED"
Bugzilla Weekly Report to wikitech-l@ fails due to move: "DB connection failu...
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
Bugzilla (Other open bugs)
unspecified
All All
: Highest major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-02-17 03:22 UTC by Alex Monk
Modified: 2014-02-27 21:43 UTC (History)
7 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Alex Monk 2014-02-17 03:22:20 UTC
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.
Comment 1 Sam Reed (reedy) 2014-02-17 03:24:05 UTC
(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? ;)
Comment 3 Daniel Zahn 2014-02-18 14:50:04 UTC
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.
Comment 4 Daniel Zahn 2014-02-18 15:03:55 UTC
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/
Comment 5 Daniel Zahn 2014-02-18 15:25:04 UTC
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.
Comment 6 Daniel Zahn 2014-02-18 15:31:56 UTC
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?:)
Comment 7 Daniel Zahn 2014-02-18 15:36:49 UTC
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
Comment 8 Andre Klapper 2014-02-26 15:13:50 UTC
(In reply to Daniel Zahn from comment #7)
> please keep open to make me put the manual change into puppet

ping
Comment 9 Daniel Zahn 2014-02-27 07:57:50 UTC
(In reply to Andre Klapper from comment #8)
> ping


https://gerrit.wikimedia.org/r/#/c/115865/1
Comment 10 Daniel Zahn 2014-02-27 21:43:24 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links