#08S01 Bad handshake with DBD::mysql and Net::MySQL

#08S01 Bad handshake with DBD::mysql and Net::MySQL

am 18.06.2006 04:01:03 von Bryan

Hi all,

I'm having a problem using Perl to connect to two different mysql
servers with the same program. It started off as one box, but I thought
"oh, let me try it on this other box", and it's a problem as well.

Box #1: MySQL Server 4.1.19 and Client 4.1.19, Perl 5.8.6
Box #2: MySQL Server 5.0.22 and Client 5.0.22, Perl 5.8.6

Here's the connection lines:
my $database = DBI->connect("DBI:mysql:perlboinc", "boinc", "") ||
die("Failed connecting to ".$hostname);
for the DBD::mysql

and

my $database = Net::MySQL->new("localhost", "perlboinc", "boinc",
"r13s3lb01nc") || die("Failed connecting to ".$hostname);
for the Net::MySQL edition

Both times, the program returns "#08S01 Bad Handshake" when connecting,
but neither the Query/Connection (main) nor the Error log shows any
activity when the client tries to connect.

Both perl modules were compiled in the last couple of days, and the
MySQL Server/Clients had already been running their respective versions
before the CPAN install of the two modules. The program itself runs
fine on another server.

Any guidance on how to fix the error or even a beginning of how to
troubleshoot, since I can't find any logs recording the problem, would
be greatly appreciated.

Thanks!

Bryan
Stats Administrator
Riesel Sieve Project



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org