Bugzilla.wikimedia.org

Our Bugzilla installation is at https://bugzilla.wikimedia.org/, with attachments hosted at http://bug-attachment.wikimedia.org/ . The attachment domain only allows downloading of attachments.

Hardware

• isidore - web frontend
• db9 - DB master
• db10 - DB slave

Related services

• lists.wikimedia.org - wikibugs-l notification list
  • wikibugs IRC bot

Software

• Apache+Perl
• MySQL
• Bugzilla
  • With custom templates and tweaks

Upgrade from 3.0.8 to 3.4.4

These are the steps pdhanda used to upgrade her test machine. If you encounter problems or the instructions are incorrect, contact her.

• Test Machine Software
  • Ubuntu 8.04.3
  • Mysql 5.0.51a
  • Apache2
  • Perl v5.8.8

• Back up the existing Bugzilla 3.0.8 MySQL database
• Back up the entire Bugzilla 3.0.8 install directory and move it out of the way (we're going to re install the new version)
  • We're are going to need the <bugzilla_home>/localconfig and <bugzilla_home>/data/params files for the new insatall
• Start with an apt-get upgrade
• Upgrade CPAN to the latest version using sudo perl -MCPAN -e 'install Bundle::CPAN'
• Download and extract Bugzilla 3.4.4
• Download our custom skin and templates from [TBD]
• Copy the <old_bugzilla>/localconfig file into <Bugzilla3.4.4_home>/localconfig
• Copy the <old_bugzilla>/data/params file into <Bugzilla3.4.4_home>/data/params
• Add our custom skins and templates

          cd <Bugzilla3.4.4_home>
          mkdir skins/custom
          cp -r skins/standard/* skins/custom/
          mkdir template/en/custom
          cp -r template/en/default/* template/en/custom/
          tar xvzf <download_location>/bugzilla_3-4-4_vector.tgz

• Run the <Bugzilla3.4.4_home>/checksetup.pl script which will do the database migration and fix all your directory permissions. This may take a while.
• The part of the checksetup script that we're interested in is the missing Perl Modules. It will look something like this

        COMMANDS TO INSTALL REQUIRED MODULES (You *must* run all these commands
and then re-run checksetup.pl):

            /usr/bin/perl install-module.pl DateTime::TimeZone
            /usr/bin/perl install-module.pl Email::Send
            /usr/bin/perl install-module.pl Email::MIME
            /usr/bin/perl install-module.pl Email::MIME::Encodings
            /usr/bin/perl install-module.pl Email::MIME::Modifier

I installed the modules using CPAN instead

          perl -MCPAN -e shell
          install DateTime::TimeZone
          <repeat for each module listed above>

• Run the checksetup script again to make sure everything is in order

How to recover in a hurry

Its a good thing we backed up out database and Bugzilla 3.0.8 home directory as part of the upgrade

• Move the backed up Bugzilla back to its original location
• Restore the MySQL database from the backup dump
• Run the checksetup.pl script

Notes

• Switched to SSL 2008-02

Patches

• the custom template...
• some linking patches...
• globalwatchers preference patch