cPanel / DBI / mySQL / Exim issue

I have recently come across a problem with cPanel/Fedora and DBI. After a recent
update of cpanel the exim stats script stopped working, and produces the
following error:

Starting eximstats: DBI connect('eximstats:localhost','eximstats',...) failed:
Client does not support authentication protocol requested by server; consider
upgrading MySQL client at /usr/local/cpanel/bin/eximstats line 262
Can't Connect at /usr/local/cpanel/bin/eximstats line 265.


I sent a ticket to cpanel, which they replied:

by saying to add the old-password=1 to the my.cnf file, which did not work, then
they performed the following on the server:

mysql -V
mysql: unknown variable 'old_passwords=1'


So I removed it from /etc/my.cnf

# mysql -V
mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)


via CLI it works:

# mysql -ueximstats -pIOcgBuMJ eximstats Welcome to the MySQL monitor. Commands
end with ; or \g.
Your MySQL connection id is 574 to server version: 4.1.10a-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye

vie DBI it does not:

# perl -MDBI -e
'DBI->connect("DBI:mysql:eximstats:localhost","eximstats","IOcgBuMJ") or die
DBI->errstr;'
DBI connect('eximstats:localhost','eximstats',...) failed: Client does not
support authentication protocol requested by server; consider upgrading MySQL
client at -e line 1 Client does not support authentication protocol requested
by server; consider upgrading MySQL client at -e line 1.

while root's does:

# perl -MDBI -e 'DBI->connect("DBI:mysql:test:localhost","root","iosdFYEv") or
die DBI->errstr;'



After that did not work, they directed me to your list, in the hopes you could
give me some assistance with how to resolve this. Any help you can offer is
much appreicated.

Chris


.

Relevant Pages

  • RE: :mysql
    ... Are you sure you're running MySQL 4.1.5 because the 'upgrade client' error ... This seems to be a DBI issue. ...
    (perl.dbi.users)
  • Newbie Question: DBI and MySQL Connection Issues
    ... I am using DBI to connect to MySQL. ... Couldn't connect to database: Client does not support ...
    (perl.dbi.users)
  • RE: :mysql
    ... DBD_MySQL worked fine with MySQL 4.0.21. ... > 'upgrade client' error ... > From: Henry McGuinness ... > This seems to be a DBI issue. ...
    (perl.dbi.users)
  • Re: Some free utilities for Java, with Hebrew support.
    ... mostly separate from the one for replacing the client library. ... Then you're a MySQL reseller, by the sounds of it, rather than a MySQL ... I.e. they might use MySQL server and client, ... competing libraries, so I'd expect to see it happen sooner or later. ...
    (comp.lang.java.programmer)
  • Re: Confusion about database updates
    ... all connecting to the same database server. ... MySQL can easily handle many simultaneous clients. ... AlphaCluster all open multiple connections to a MySQL server running on ... Let the MySQL server do that when your client ...
    (comp.lang.java.databases)