From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 14256 invoked by alias); 22 Sep 2010 22:24:54 -0000 Received: (qmail 14241 invoked by uid 22791); 22 Sep 2010 22:24:53 -0000 X-SWARE-Spam-Status: No, hits=0.1 required=5.0 tests=BAYES_40,FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,TW_NH,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: sourceware.org Received: from imr-da06.mx.aol.com (HELO imr-da06.mx.aol.com) (205.188.169.203) by sourceware.org (qpsmtpd/0.43rc1) with ESMTP; Wed, 22 Sep 2010 22:24:48 +0000 Received: from mtaout-db06.r1000.mx.aol.com (mtaout-db06.r1000.mx.aol.com [172.29.51.198]) by imr-da06.mx.aol.com (8.14.1/8.14.1) with ESMTP id o8MMOet7014750 for ; Wed, 22 Sep 2010 18:24:40 -0400 Received: from [192.168.0.2] (43-163.1-85.cust.bluewin.ch [85.1.163.43]) by mtaout-db06.r1000.mx.aol.com (MUA/Third Party Client Interface) with ESMTPA id 7873AE0000B2 for ; Wed, 22 Sep 2010 18:24:39 -0400 (EDT) Message-ID: <4C9A8226.1050208@netscape.net> Date: Wed, 22 Sep 2010 22:24:00 -0000 From: =?ISO-8859-1?Q?Fr=E9d=E9ric_Buclin?= Reply-To: LpSolit@netscape.net User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr; rv:1.9.2.9) Gecko/20100915 Lightning/1.0b2 Thunderbird/3.1.4 MIME-Version: 1.0 To: overseers@sourceware.org Subject: Bugzilla upgrade check-list Content-Type: multipart/mixed; boundary="------------000608070002050004070100" x-aol-global-disposition: G X-AOL-VSS-INFO: 5400.1158/63272 X-AOL-VSS-CODE: clean X-AOL-SCOLL-SCORE: 0:2:326449088:93952408 X-AOL-SCOLL-URL_COUNT: 0 x-aol-sid: 3039ac1d33c64c9a82272611 X-AOL-IP: 85.1.163.43 Mailing-List: contact overseers-help@sourceware.org; run by ezmlm Precedence: bulk List-Id: List-Archive: List-Post: List-Help: , Sender: overseers-owner@sourceware.org X-SW-Source: 2010-q3/txt/msg00100.txt.bz2 This is a multi-part message in MIME format. --------------000608070002050004070100 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-length: 106 Here is my check-list for the GCC Bugzilla upgrade tomorrow. May be useful for future upgrades. Frédéric --------------000608070002050004070100 Content-Type: text/plain; name="bugzilla_checklist.txt" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="bugzilla_checklist.txt" Content-length: 2617 HOW-TO: UPGRADE BUGZILLA FROM 2.20 to 3.6.x =========================================== Pre-upgrade ----------- 1. Run sanitycheck.cgi from 2.20. Make sure there are no errors besides the invalid email address ones (currently, bug 45728 should have everconfirmed = 1). 2. Set the shutdownhtml parameter to "

GCC Bugzilla is down for maintainance. Downtime: 3 hours (18:00 - 21:00 GMT)

". 3. Backup the DB: mysqldump -u root -p bugs > ~/bugs_backup_20100923.sql 4. Delete the localconfig file and the data/ repository from the *test* (3.6.2) installation, i.e. bugzilla-test/localconfig and bugzilla-test/data/. 5. Copy the localconfig file and data/ repository from the 2.20 installation into the 3.6.2 one. 3.6.2 will now point to the production DB. 6. Rename the production bugzilla/ repository to e.g. bugzilla-old/. Then rename bugzilla-test/ to bugzilla/, so that Apache points to it. Upgrade ------- 1. Run checksetup.pl once. It will stop quickly, because there are some new parameters in localconfig. No need to edit them; the defaults are fine. 2. Run checksetup.pl again. It's going to upgrade the DB for real (InnoDB, new defaults, etc...). It's going to take a while. 3. Once the upgrade completed, run contrib/recode.pl to convert the DB to UTF8: contrib/recode.pl --guess --show-failures --charset=cp1252 4. Turn on the utf8 parameter (by accessing editparams.cgi directly, because all other pages are unavailable due to the shutdown). Bugzilla will ask you to run checksetup.pl again to finalize the move to UTF8. 5. Run checksetup.pl for the 3rd (and last) time. Now it will focus on converting the DB to UTF8. Post-upgrade ------------ 1. Turn on the allow_attachment_display parameter. 2. Set mail_delivery_method to "SMTP". 3. Clear the shutdownhtml parameter. We need to access other admin pages. 4. Only allow UNCONFIRMED for new bugs. 5. Set "disable bugmail" to true for gcc-bugzilla@gcc.gnu.org. 6. Disable the gcc-bugs@gcc.gnu.org, java-prs@gcc.gnu.org and bug-classpath@gnu.org user accounts. They should only get bugmail. 7. For all 3 mailing-lists above, use sudo to fix email settings: no email should be sent for keyword changes and "other" changes only. 8. Run sanitycheck.cgi again, to make sure no new errors are being detected. Post-upgrade (outside Bugzilla) ------------------------------- 1. Fix the Subjet of commit messages: Bug NNN must become [Bug NNN]. 2. Incoming emails must be redirected to bugzilla/email_in.pl. Wishlist -------- - Only members of the reconfirmers group can edit the reconfirmed_on field. (still wanted?) --------------000608070002050004070100--