1 message in com.mysql.lists.perl#08S01 Bad handshake with DBD::mysql ...
FromSent OnAttachments
Bryan O'Shea17 Jun 2006 19:00 
Subject:#08S01 Bad handshake with DBD::mysql and Net::MySQL
From:Bryan O'Shea (bry@rieselsieve.com)
Date:06/17/2006 07:00:40 PM
List:com.mysql.lists.perl

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