303576 - all tests are successful but bugzilla still won't run

Status: RESOLVED WORKSFORME

(Bugzilla :: Installation & Upgrading, defect)

Description

[Paul]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030922
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030922

I had to install a new version of bugzilla.

Here is the symptom.
Non-database pages are working
html pages are working
jpgs are working

The test script works:

./testserver.pl http://localhost/bugzilla-2.18.3/
TEST-OK Webserver is running under group id in $webservergroup.
TEST-OK Got ant picture.
TEST-OK Webserver is executing CGIs.
TEST-OK Webserver is preventing fetch of
http://localhost/bugzilla-2.18.3/localconfig.

also checksetup works:
Checking perl modules ...
Checking for       AppConfig (v1.52)   ok: found v1.56
Checking for             CGI (v2.93)   ok: found v3.11
Checking for    Data::Dumper (any)     ok: found v2.12
Checking for    Date::Format (v2.21)   ok: found v2.22
Checking for             DBI (v1.36)   ok: found v1.48
Checking for      DBD::mysql (v2.1010) ok: found v2.1021
Checking for      File::Spec (v0.82)   ok: found v0.83
Checking for      File::Temp (any)     ok: found v0.13
Checking for        Template (v2.08)   ok: found v2.14
Checking for      Text::Wrap (v2001.0131) ok: found v2001.0929
 
The following Perl modules are optional:
Checking for              GD (v1.20)    not found
Checking for     Chart::Base (v1.0)     not found
Checking for     XML::Parser (any)     ok: found v2.31
Checking for       GD::Graph (any)      not found
Checking for GD::Text::Align (any)      not found
Checking for     PatchReader (v0.9.4)   not found
 
If you you want to see graphical bug charts (plotting historical data over
time), you should install libgd and the following Perl modules:
 
GD:          /usr/bin/perl -MCPAN -e 'install "GD"'
Chart:       /usr/bin/perl -MCPAN -e 'install "Chart::Base"'
 
If you you want to see graphical bug reports (bar, pie and line charts of
current data), you should install libgd and the following Perl modules:
 
GD:              /usr/bin/perl -MCPAN -e 'install "GD"'
GD::Graph:       /usr/bin/perl -MCPAN -e 'install "GD::Graph"'
GD::Text::Align: /usr/bin/perl -MCPAN -e 'install "GD::Text::Align"'
 
If you want to see pretty HTML views of patches, you should install the
PatchReader module:
PatchReader: /usr/bin/perl -MCPAN -e 'install "PatchReader"'
Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for    MySQL Server (v3.23.41) ok: found v4.1.13-standard-log

But the tests seem incomplete because I get this error on every database connection:

Reproducible: Always

Steps to Reproduce:
install bugzilla 2.18.3

Actual Results:  
Software error:

DBI
connect('host=localhost;database=bugs;port=3306;mysql_socket=/var/lib/mysql/mysql.sock','bugs',...)
failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) at
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBI.pm line 609
	DBI::__ANON__('undef','undef') called at
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBI.pm line 666
	DBI::connect('DBI','DBI:mysql:host=localhost;database=bugs;port=3306;mysql_socket...','','','HASH(0x8773498)') called at Bugzilla/DB.pm line 146
	Bugzilla::DB::_connect('DBI:mysql:host=localhost;database=bugs;port=3306;mysql_socket...') called at Bugzilla/DB.pm line 138
	Bugzilla::DB::connect_main() called at Bugzilla.pm line 143
	Bugzilla::dbh('Bugzilla') called at Bugzilla.pm line 157
	Bugzilla::dbwritesallowed('Bugzilla') called at globals.pl line 355
	main::GetVersionTable() called at Bugzilla/Search.pm line 75
	Bugzilla::Search::init('Bugzilla::Search=HASH(0x8766ee8)') called at
Bugzilla/Search.pm line 54
	Bugzilla::Search::new('Bugzilla::Search','fields','ARRAY(0x85979d0)','params','Bugzilla::CGI=HASH(0x8733c40)') called at /var/www/html/bugzilla-2.18.3/buglist.cgi line 704
 at Bugzilla/DB.pm line 146


Expected Results:  
The tests would have the same result as the webserver.

Comment 1

[Paul]

I see these 2 wonderful errors popup if I run from the command line:

[Fri Aug  5 11:24:05 2005] query.cgi: Use of uninitialized value in pattern
match (m//) at (eval 21) line 4.
[Fri Aug  5 11:24:05 2005] query.cgi: Use of uninitialized value in pattern
match (m//) at (eval 21) line 4.

Comment 2

[Paul]

Turned out to be an older version of DBD::mysql

Comment 3

[Adam Guthrie]

Paul, if this is now working please resolve this bug as WORKSFORME.

Comment 4

[Dave Miller [:justdave]]

I was going to say when I first saw this, it looks like an incompatible version
of DBD::mysql.  (version was compiled against a different MySQL server)

Resolving per comment 2.

Comment 5

[Paul]

The problem here is that all the tests passed, but Bugzilla didn't work.
Although my problem is gone, the checksetup.pl and testserver.pl should 
be "enhanced" to illustrate what was wrong.

Oh well, leave it closed.

Comment 6

[Max Kanat-Alexander]

(In reply to comment #5)
> The problem here is that all the tests passed, but Bugzilla didn't work.
> Although my problem is gone, the checksetup.pl and testserver.pl should 
> be "enhanced" to illustrate what was wrong.

  Actually, usually checksetup does fail when it can't connect to the DB, and
it's probably even more likely to do so in 2.20. But I do see your point. :-)
checksetup should fail if the web interface is going to fail, and if it's
something that checksetup can actually figure out. :-)

  I'm going to leave this as WFM, but I'll still take your point into consideration.