Dear listmates,
I've recently moved a server from RHEL5 to CentOS 5.3 after it was decided not to renew the subscripton. Everything works beautifully except for Bugzilla, which throws MySQL errors. For example, the sanitycheck.cgi page says:
# # #
Bugzilla – Sanity Check
* Home * | New * | Search * | * | Reports * * | My Votes * | Preferences * | Administration * | Log out bugzilla@grandeye.com
Bugzilla is checking the referential integrity of your database. This may take several minutes to complete.
Errors, if any, will be emphasized like this. Depending on the errors found, some links will be displayed allowing you to easily fix them. Fixing these errors will automatically run this script again (so be aware that it may take an even longer time than the first run).
OK, now running sanity checks.
Checking references to classifications.id...
... from products.classification_id.
Checking references to keyworddefs.id...
... from keywords.keywordid.
Checking references to fielddefs.id...
... from bugs_activity.fieldid.
... from profiles_activity.fieldid.
Checking references to flagtypes.id...
... from flags.type_id.
... from flagexclusions.type_id.
... from flaginclusions.type_id.
Checking references to bugs.bug_id...
... from bugs_activity.bug_id.
... from bug_group_map.bug_id.
... from bugs_fulltext.bug_id. Software error:
DBD::mysql::st execute failed: Table 'bugs.bugs_fulltext' doesn't exist [for Statement "SELECT DISTINCT bugs_fulltext.bug_id FROM bugs_fulltext LEFT JOIN bugs ON bugs_fulltext.bug_id = bugs.bug_id WHERE bugs.bug_id IS NULL AND bugs_fulltext.bug_id IS NOT NULL"] at /var/www/html/bugzilla/sanitycheck.cgi line 428 main::CrossCheck('bugs', 'bug_id', 'ARRAY(0x1760b5a0)', 'ARRAY(0x18298ba0)', 'ARRAY(0x18298830)', 'ARRAY(0x1814a150)', 'ARRAY(0x17f0bf50)', 'ARRAY(0x18298840)', 'ARRAY(0x18298850)', ...) called at /var/www/html/bugzilla/sanitycheck.cgi line 469
For help, please send mail to the webmaster (root@localhost), giving this error message and the time and date of the error.
# # #
bugzilla, mysql and perl are fully up-to-date according to yum, I have checked that the database is OK but restored a suitable (mysqldump) backup anyway.
[root@neodymium bugzilla]# rpm -qa bugzilla mysql perl mysql-5.0.45-7.el5 bugzilla-3.2.4-1.el5 mysql-5.0.45-7.el5 perl-5.8.8-18.el5_3.1 [root@neodymium bugzilla]# perl --version
This is perl, v5.8.8 built for x86_64-linux-thread-multi
[root@neodymium bugzilla]# mysql --version mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using readline 5.0
Googling hasn't helped beyond suggesting this has happened to others following RHEL upgrading Bugzilla 3.0.2 to 3.2.4 in July for security. Sadly, that didn't show the way out of it.
Any help would be gratefully accepted.
Many thanks, Chris R.
Sorry for top post blame my iPhone It looks like there is a mySql table missing between the old and new versions of bugzilla. Look for a script in the newer version that performs the table updates HTH
Rob Kampen 407-341-3815
On Aug 11, 2009, at 5:23 AM, Chris Ross cnts5645@tebibyte.org wrote:
Dear listmates,
I've recently moved a server from RHEL5 to CentOS 5.3 after it was decided not to renew the subscripton. Everything works beautifully except for Bugzilla, which throws MySQL errors. For example, the sanitycheck.cgi page says:
# # #
Bugzilla – Sanity Check
* Home * | New * | Search * | * | Reports * * | My Votes * | Preferences * | Administration * | Log out bugzilla@grandeye.comBugzilla is checking the referential integrity of your database. This may take several minutes to complete.
Errors, if any, will be emphasized like this. Depending on the errors found, some links will be displayed allowing you to easily fix them. Fixing these errors will automatically run this script again (so be aware that it may take an even longer time than the first run).
OK, now running sanity checks.
Checking references to classifications.id...
... from products.classification_id.
Checking references to keyworddefs.id...
... from keywords.keywordid.
Checking references to fielddefs.id...
... from bugs_activity.fieldid.
... from profiles_activity.fieldid.
Checking references to flagtypes.id...
... from flags.type_id.
... from flagexclusions.type_id.
... from flaginclusions.type_id.
Checking references to bugs.bug_id...
... from bugs_activity.bug_id.
... from bug_group_map.bug_id.
... from bugs_fulltext.bug_id. Software error:
DBD::mysql::st execute failed: Table 'bugs.bugs_fulltext' doesn't exist [for Statement "SELECT DISTINCT bugs_fulltext.bug_id FROM bugs_fulltext LEFT JOIN bugs ON bugs_fulltext.bug_id = bugs.bug_id WHERE bugs.bug_id IS NULL AND bugs_fulltext.bug_id IS NOT NULL"] at /var/www/html/bugzilla/sanitycheck.cgi line 428 main::CrossCheck('bugs', 'bug_id', 'ARRAY(0x1760b5a0)', 'ARRAY(0x18298ba0)', 'ARRAY(0x18298830)', 'ARRAY(0x1814a150)', 'ARRAY(0x17f0bf50)', 'ARRAY(0x18298840)', 'ARRAY(0x18298850)', ...) called at /var/www/html/bugzilla/sanitycheck.cgi line 469
For help, please send mail to the webmaster (root@localhost), giving this error message and the time and date of the error.
# # #
bugzilla, mysql and perl are fully up-to-date according to yum, I have checked that the database is OK but restored a suitable (mysqldump) backup anyway.
[root@neodymium bugzilla]# rpm -qa bugzilla mysql perl mysql-5.0.45-7.el5 bugzilla-3.2.4-1.el5 mysql-5.0.45-7.el5 perl-5.8.8-18.el5_3.1 [root@neodymium bugzilla]# perl --version
This is perl, v5.8.8 built for x86_64-linux-thread-multi
[root@neodymium bugzilla]# mysql --version mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using readline 5.0
Googling hasn't helped beyond suggesting this has happened to others following RHEL upgrading Bugzilla 3.0.2 to 3.2.4 in July for security. Sadly, that didn't show the way out of it.
Any help would be gratefully accepted.
Many thanks, Chris R. _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On 08/11/2009 11:20 AM, Rob Kampen wrote:
Sorry for top post blame my iPhone It looks like there is a mySql table missing between the old and new versions of bugzilla. Look for a script in the newer version that performs the table updates HTH
The nearest would be the checksetup.pl script. That reports Bugzilla requires DBD::mysql 4.0 or later and that I should install it from CPAN (see below). I currently have perl-DBD-MySQL-3.0007-2.el5 which is the latest one from yum.
So, if the RHEL's yum upgrade of Bugzilla from 3.0.2 to 3.2.4 also required that perl-DBD-MySQL be upgraded to 4.0 or later, why wasn't it? Ergo I conclude that in fact it's not needed and that something else is wrong. I can't be the only person running Bugzilla on CentOS/RHEL 5! It does mean that checksetup.pl doesn't complete though. Obviously installing from CPAN is not the right answer.
Many thanks, Chris R.
[root@neodymium bugzilla]# ./checksetup.pl * This is Bugzilla 3.2.4 on perl 5.8.8 * Running on Linux 2.6.18-128.4.1.el5 #1 SMP Tue Aug 4 20:19:25 EDT 2009
Checking perl modules... Checking for CGI.pm (v3.21) ok: found v3.44 Checking for TimeDate (v2.21) ok: found v2.22 Checking for PathTools (v0.84) ok: found v3.12 Checking for DBI (v1.41) ok: found v1.52 Checking for Template-Toolkit (v2.15) ok: found v2.18 Checking for Email-Send (v2.00) ok: found v2.185 Checking for Email-MIME (v1.861) ok: found v1.863 Checking for Email-MIME-Encodings (v1.313) ok: found v1.313 Checking for Email-MIME-Modifier (v1.442) ok: found v1.444
Checking available perl DBD modules... Checking for DBD-Pg (v1.45) ok: found v1.49 Checking for DBD-mysql (v4.00) found v3.0007 Checking for DBD-Oracle (v1.19) not found
The following Perl modules are optional: Checking for GD (v1.20) not found Checking for Chart (v1.0) not found Checking for Template-GD (any) not found Checking for GDTextUtil (any) not found Checking for GDGraph (any) not found Checking for XML-Twig (any) ok: found v3.26 Checking for MIME-tools (v5.406) ok: found v5.420 Checking for libwww-perl (any) ok: found v2.033 Checking for PatchReader (v0.9.4) ok: found v0.9.5 Checking for PerlMagick (any) not found Checking for perl-ldap (any) ok: found v0.33 Checking for Authen-SASL (any) ok: found v2.12 Checking for RadiusPerl (any) ok: found v0.13 Checking for SOAP-Lite (any) not found Checking for HTML-Parser (v3.40) ok: found v3.56 Checking for HTML-Scrubber (any) ok: found v0.08 Checking for Email-MIME-Attachment-Stripper (any) ok: found v1.313 Checking for Email-Reply (any) ok: found v1.201 Checking for mod_perl (v1.999022) ok: found v2.000004 ********************************************************************** * OPTIONAL MODULES * ********************************************************************** * Certain Perl modules are not required by Bugzilla, but by * * installing the latest version you gain access to additional * * features. * * * * The optional modules you do not have installed are listed below, * * with the name of the feature they enable. If you want to install * * one of these modules, just run the appropriate command in the * * "COMMANDS TO INSTALL" section. * **********************************************************************
*********************************************************************** * MODULE NAME * ENABLES FEATURE(S) * *********************************************************************** * GD * Graphical Reports, New Charts, Old Charts * * Chart * New Charts, Old Charts * * Template-GD * Graphical Reports * * GDTextUtil * Graphical Reports * * GDGraph * Graphical Reports * * PerlMagick * Optionally Convert BMP Attachments to PNGs * * SOAP-Lite * XML-RPC Interface * *********************************************************************** COMMANDS TO INSTALL:
GD: /usr/bin/perl install-module.pl GD Chart: /usr/bin/perl install-module.pl Chart::Base Template-GD: /usr/bin/perl install-module.pl Template::Plugin::GD::Image GDTextUtil: /usr/bin/perl install-module.pl GD::Text GDGraph: /usr/bin/perl install-module.pl GD::Graph PerlMagick: /usr/bin/perl install-module.pl Image::Magick SOAP-Lite: /usr/bin/perl install-module.pl SOAP::Lite
To attempt an automatic install of every required and optional module with one command, do:
/usr/bin/perl install-module.pl --all
Reading /etc/bugzilla/localconfig... Checking for DBD-mysql (v4.00) found v3.0007
For MySQL, Bugzilla requires that perl's DBD::mysql 4.00 or later be installed. To install this module, run the following command (as root):
/usr/bin/perl install-module.pl DBD::mysql
[root@neodymium bugzilla]# rpm -qa *DBD* perl-DBD-MySQL-3.0007-2.el5 perl-DBD-Pg-1.49-2.el5_3.1
[root@neodymium bugzilla]# nice yum upgrade perl-DBD-MySQL Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * epel: ftp.uni-koeln.de * rpmfusion-nonfree-updates-testing: rpmfusion.famillecollet.com * rpmfusion-free-updates: rpmfusion.famillecollet.com * rpmfusion-nonfree-updates: rpmfusion.famillecollet.com * rpmfusion-free-updates-testing: rpmfusion.famillecollet.com * base: mirror.answerstolove.com * extras: mirror.answerstolove.com * addons: mirror.answerstolove.com * updates: mirror.answerstolove.com epel | 2.3 kB 00:00 Not using downloaded repomd.xml because it is older than what we have: Current : Wed Aug 5 20:36:52 2009 Downloaded: Fri Jul 31 22:06:47 2009 rpmfusion-nonfree-updates-testing | 2.8 kB 00:00 home_elektritter_kdesvn | 951 B 00:00 rpmfusion-free-updates | 2.8 kB 00:00 rpmfusion-nonfree-updates | 2.8 kB 00:00 rpmfusion-free-updates-testing | 2.8 kB 00:00 base | 1.1 kB 00:00 extras | 1.1 kB 00:00 addons | 951 B 00:00 updates | 951 B 00:00 Setting up Upgrade Process No Packages marked for Update
Hi,
On Tue, Aug 11, 2009 at 05:23, Chris Rosscnts5645@tebibyte.org wrote:
[root@neodymium bugzilla]# rpm -qa bugzilla mysql perl mysql-5.0.45-7.el5 bugzilla-3.2.4-1.el5 mysql-5.0.45-7.el5 perl-5.8.8-18.el5_3.1
Where is this Bugzilla package from? CentOS does not include any Bugzilla packages... I expect that RHEL does not either (otherwise it would be in CentOS).
I know EPEL has a Bugzilla package, I used it in the past, but AFAIR it installs under /usr/share/bugzilla and not under /var/www/html/bugzilla as you've shown in your post...
Also, I do have an install of Bugzilla here and it does not have any bugs_fulltext table... I had 3.0 before and upgraded it to 3.2, and AFAIR that table never existed in my setup. The 3.0 I used was a rebuild from Fedora SRPM, then in 3.2 I switched to a source code install, I decided to switch since I had to keep both versions working for a while, now I set it up in a way that I can have parallel installations in the future easily as well.
On Tue, Aug 11, 2009 at 06:47, Chris Rosscnts5645@tebibyte.org wrote:
So, if the RHEL's yum upgrade of Bugzilla from 3.0.2 to 3.2.4 also required that perl-DBD-MySQL be upgraded to 4.0 or later, why wasn't it? Ergo I conclude that in fact it's not needed and that something else is wrong. I can't be the only person running Bugzilla on CentOS/RHEL 5! It does mean that checksetup.pl doesn't complete though. Obviously installing from CPAN is not the right answer.
I can tell you that RPMforge has all the RPMs for Perl modules required by Bugzilla. Acutally, all those needed to run Bugzilla 3.4 were recently built. The only exception is the CGI module that is bundled with Perl itself so cannot be easily upgraded in a standalone RPM... For that one, though, it's possible to use Bugzilla's install-module.pl script, that will install the needed module version from CPAN, but only inside Bugzilla's tree, in a way that does not conflict with the O.S. and so it should be safe from RPM upgrades.
HTH, Filipe
On 08/11/2009 02:30 PM, Filipe Brandenburger wrote:
On Tue, Aug 11, 2009 at 05:23, Chris Rosscnts5645@tebibyte.org wrote:
[root@neodymium bugzilla]# rpm -qa bugzilla mysql perl mysql-5.0.45-7.el5 bugzilla-3.2.4-1.el5 mysql-5.0.45-7.el5 perl-5.8.8-18.el5_3.1
Where is this Bugzilla package from? CentOS does not include any Bugzilla packages... I expect that RHEL does not either (otherwise it would be in CentOS).
It is from EPEL.
I know EPEL has a Bugzilla package, I used it in the past, but AFAIR it installs under /usr/share/bugzilla and not under /var/www/html/bugzilla as you've shown in your post...
I'd made /var/www/html/bugzilla a link to /usr/share/bugzilla on this machine.
Enabling epel-testing meant yum upgraded to bugzilla-3.2.4-2.el5.noarch whose checksetup.pl script now checks for DBD::mysql 3.00 or later (instead of 4.00), which succeeds. I guess that was a bug which has now been fixed.
Many thanks, Chris R.
-
Chris Ross -
Filipe Brandenburger -
Rob Kampen