Henry McGuinness wrote:
Hi again,
Thought this might be of interest: The same version of
DBD_MySQL (2.9004) worked fine with MySQL 4.0.21. So
either DBD-MySQL* needs changes to deal with the new
password scheme or there's a problem with 4.1.5 in
particular (?)
cheers
Henry
*my version is the same as the latest on CPAN
DBD-mysql must be compiled against the 4.1 MySQL client
libraries. The 4.0 libraries don't know how to authenticate
to a MySQL 4.1 server unless the server is running with
--old-passwords.
--- [EMAIL PROTECTED] wrote:
Henry,
Have you tried any of these fixes?
http://dev.mysql.com/doc/mysql/en/Old_client.html
Are you sure you're running MySQL 4.1.5 because the
'upgrade client' error
is typically caused by using a post 4.1.1 password
scheme with a pre 4.1.1
client.
Elliot
Elliot M. Fielstein, Ph.D.
Neuropsychologist and Health Systems Specialist
VA Medical Center, Nashville TN
and
Assistant Professor of Psychiatry and
Research Fellow in Biomedical Informatics
Vanderbilt University Medical Center
-----Original Message-----
From: Henry McGuinness
[mailto:[EMAIL PROTECTED]
Sent: Monday, October 11, 2004 12:15 PM
To: [EMAIL PROTECTED]
Subject: DBD::mysql
Hi folks,
This seems to be a DBI issue. I've just reinstalled
most things so I'm running:
Activestate Perl 5.8.4
MySQL 4.1.5 ("gamma" but it should be ok surely?)
DBI 1.43
DBD::MySQL 2.9004
running on Windows XP professional.
Tried to do a simple select (works fine from MYSQL
in
command prompt - users have the right privileges).
From a perl script or from Apache I get the
following
message:
"Client does not support authentication protocol
requested by server; consider upgrading MySQL
client"
Relevant code:
use DBI;
my $dbh =
DBI->connect("dbi:mysql:namesDB;host=localhost",".....",".....")
or die "Can't make 1st database connect:
$DBI::errstr\n";
my $sth1 = $dbh->prepare("SELECT name, address FROM
tbl_people WHERE (Txtname = ?)");
$sth1->execute("Dave");
while (@res=$sth1->fetchrow_array) {
print "@res[0] : @res[3]: @res[4]\n\n" ;
}
$sth1->finish();
$dbh->disconnect();
(Have also tried without the "host=localhost" part
of
the connect statement)
Anyone seen this/know what's going on?
thanks
Henry
