CentOS - Aug 2009 - Bugzilla not working following RHEL to CentOS migration

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 at 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 at 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 at 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 at neodymium bugzilla]# perl --version

This is perl, v5.8.8 built for x86_64-linux-thread-multi

[root at 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 at 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 at 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 at 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 at 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 at neodymium bugzilla]# perl --version
>
> This is perl, v5.8.8 built for x86_64-linux-thread-multi
>
> [root at 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 at centos.org
> http://lists.centos.org/mailman/listinfo/centos

Hi,

On Tue, Aug 11, 2009 at 05:23, Chris Ross<cnts5645 at tebibyte.org>
wrote:
> [root at 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 Ross<cnts5645 at 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