Re: cPanel / DBI / mySQL / Exim issue

[Ron Savage]

 On Wed, 27 Apr 2005 10:06:24 -0400, [EMAIL PROTECTED] wrote:

Hi

Search this page

http://savage.net.au/Perl/html/upgrade-mysql.html

for old_password.

--
Cheers
Ron Savage, [EMAIL PROTECTED] on 28/04/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company

Re: cPanel / DBI / mySQL / Exim issue

[Rudy Lippan]

On Wed, 27 Apr 2005 [EMAIL PROTECTED] wrote:

> 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.


To get DBD::mysql to talk the new protocol, you will need to rebuild DBD::mysql 
against the new mysql client libraries. 

Rudy

Re: cPanel / DBI / mySQL / Exim issue

[JupiterHost.Net]

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.
Er, you may want to not show your passwords on a public list...
They were right, its not a cPanel issue. Have you upgraded MySQL lately?
You might need to downgrade or figure out the old_password=1 thing for 
your config.

Have you tried changing your privilege tables to the new format that the 
version of MySQL uses?

cPanel / DBI / mySQL / Exim issue

[webmaster]

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