Client does not support authentication protocol requested by server
am 21.03.2006 17:25:54 von AndrewA strange case
Machines involved:
Machines A and B - two seemingly exact same systems and MySQL server installations. A third machine (machine C) tries to connect to A and B, via Perl DBI. Strangely, connection C->A succeeds, but when attempting C->B, connection fails with the error in my subject line.
Both A and B are Fedora Core 4 (same kernel). Both have MySQL version 5.1.7.beta installed and the servers are running fine on each. In both systems the file "/etc/my.cnf" has the line "old_passwords=1" (in the [mysqld] section).
I run a perl script from machine C, with exact same connecting code, (except for the username, passowrd, database, etc.), looping over the two sets of authentication tokens; a connection to A is established, but, trying to connect to B, the script returns:
DBI connect('database=cif;host=xxx.xxx.xxx.xxx;port=3306','xxxx' ,...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at ./test_load_db.pl line 126
(i've "x"-ed out the actual tokens)
Furthermore, when I try to connect from C to B, WITHOUT perl, just using the command-line mysql client
(i.e.,
prompt>mysql -uusername -password -Dcif -hxxx.xxx.xxx.xxx
),
I succeed!
What could ever be the problem with the failing Perl DBI (C->B) connection, if everything is OK with a C->A connection (with and without Perl), and, in addition, a command-line C->B connection works?
Also, FWIW, I don't have root on machine C; i'm a mere client at the mercy of administrators (I suppose I could install a local DBI, if need be, but fear it might be a hastle and a lot of time, which I can't afford at the moment.)
TIA
andrew
--
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