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.
