Mysql problem

kshkid · 03-30-2007, 03:12 AM

Hi,

Am using mysql version 14.12

Code:

#! /opt/third-party/bin/perl
   
   use DBI;
   
   my $dsn = "DBI:mysql:database=mydb;" . "mysql_read_default_file=/home/work/db/my.cnf";
   my $username = "user";
   my $password = "user";
  
     
   my $dbh = DBI->connect($dsn, $username, $password) || die "Unable to acquire dB Handle:$DBI::errstr\n";
   
   
   $dbh->disconnect();
   
   exit 0

Code:

Error:

Unable to acquire dB Handle:Client does not support authentication protocol requested by server; consider upgrading MySQL client

I tried to specify only the socket file and not the my.cnf file

Code:

#! /opt/third-party/bin/perl
   
   use DBI;
   
   my $dsn = "DBI:mysql:database=mydb;socket=/home/work/db/mysql.sock";
   my $username = "user";
   my $password = "user";
  
     
   my $dbh = DBI->connect($dsn, $username, $password) || die "Unable to acquire dB Handle:$DBI::errstr\n";
   
   
   $dbh->disconnect();
   
   exit 0

Code:

Error:
Unable to acquire dB Handle:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

Could you show some pointers, I tried searching in the forum but could not find anything related

Thanks

Guttorm · 03-30-2007, 04:20 AM

Hi

I've gotten this error message too - upgrading from 4.0 to 4.1. The problem is that the server is using a different password encryption and the client doesn't support it.

There are many ways to solve this, look at:
http://dev.mysql.com/doc/refman/5.1/en/old-client.html

kshkid · 03-30-2007, 04:37 AM

Thanks for the reply

But why is there a different kind of error, when I do specify the socket file to be used than the default one? Isnt that the right way of specifying the socket file ?

kshkid · 03-30-2007, 04:41 AM

Adding to the point,

I have this kind of error only when I try to connect and access the data through perl code.

Everything seems to be fine when running through command line and there is no such error reported!

Could there be a problem with the perl code ?

Guttorm · 03-30-2007, 08:24 AM

Hi again.

I think the Perl code has nothing to do with it. The problem is the version of the mysql client library that Perl uses. The page I mentioned has different solutions.

Why the socket example doesn't work is not very clear. The command mysqladmin will show you the socket that mysql uses. You will have to specify the same socket on the server and on the client.

kshkid · 03-30-2007, 01:00 PM

It worked !

problem seems to be in the version of perl

with perl version 5.8.0 it didnt work

with perl version 5.6.1 it worked

i need to understand what made the difference !!

if that is the case, if the code is working only with a single version it would be really difficult to dig in to the problem!

Any reason what changing the version of perl made it to work ?

Thanks again!

Guttorm · 03-30-2007, 01:26 PM

Well, it's explained on that link I posted.