Buzilla issue: "Can't connect to local MySQL server through socket '/tmp/mysql.sock'"
 

OS: FC3
Perl: 5.8.5
mysql : Ver 14.7 Distrib 4.1.10a
Apache: 2.0
Bugzilla: 2.18

When click the login button on the bugzilla front page I get the error:

DBI connect('host=localhost;database=bugs;port=3306','bugs',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (13) at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 597
DBI::__ANON__('undef', 'undef') called at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 648
DBI::connect('DBI', 'DBI:mysql:host=localhost;database=bugs;port=3306', '', '', 'HASH(0x9e9b38c)') called at Bugzilla/DB.pm line 146
Bugzilla::DB::_connect('DBI:mysql:host=localhost;database=bugs;port=3306') called at Bugzilla/DB.pm line 138
Bugzilla::DB::connect_main() called at Bugzilla.pm line 143
Bugzilla::dbh('Bugzilla') called at Bugzilla/Auth/CGI.pm line 154
Bugzilla::Auth::CGI::login('Bugzilla::Auth::CGI', 2) called at Bugzilla.pm line 74
Bugzilla::login('Bugzilla', 2) called at /var/www/html/bugzilla/query.cgi line 61
at Bugzilla/DB.pm line 146


I've temporarially removed the bugzilla db user's (bugs) password.

I have tested that mysql is working with the following command:
mysql -u bugs -S/tmp/mysql.sock -P3306

The socket file is there and the permissions seem wide open

[root@Sydney tmp]# ls -l /tmp/mysql.sock
srwxrwxrwx 1 mysql mysql 0 Mar 22 12:01 /tmp/mysql.sock


Any thoughts?

More Info
 

Since the original post I asked some friends for help. One mentioned that I should try it with a db password set for bugs (bugzilla's db user), so I set the password to"vtest" both in the "/var/www/html/bugzilla/localconfig" and in mysql.


One also gave me a perl script to test with:

#!/usr/bin/perl -w

use DBI;
use strict;

my $dbh = DBI->connect('DBI:mysql:bugs:localhost',
'bugs', # username
'vtest', # password
);
if (!$dbh) { die "Cannot connect to database" }
my $query = 'select count(*) from attachments';
my $sth = $dbh->prepare($query);
if (!$sth) { die "Illegal query; $query" };
$sth->execute;
while (my @row=$sth->fetchrow_array) {
print "$row[0]\n";
}
$sth->finish;


The script worked fine.



Other friend had me change my host file from :
127.0.0.1 localhost.localdomain localhost

to

127.0.0.1 localhost localhost.localdomain


to ensure that it was using bugs@localhost to login (instead of bugs@localhost.localdomain).

I should also mention that I installed bugzilla and mysql manually (without the rpms).

I've tried all of this and I am still getting the same error. Any help would be appreciated.

Thank you.

Has this problem cleared?
Recently I met the same question with you.So I wonder if you
has solved it.

Additionally, my OS is right FC3, too. It seems reasonable to
throw our doubt on FC3...

RE: Has this problem cleared?
 

Hmm. That post was over 2 years ago .. I can't remember the details of how we resolved it but we did. I believe that in the end we downloaded the rpms and installed using them.

Good luck.
-Vito