Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Hosting Security and Technology Tutorials : eximstats after reinstall still failed

[bahiadatacenter]

Hi all,

The eximstats the my dedicated is failed.

I´m forced reinstall services /scripts/upcp --force, but the eximstats still failed.

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 264
Can't Connect at /usr/local/cpanel/bin/eximstats line 267.

Sugestions?

Regards,

André

[adam]

Search the cPanel forums, this fix has been posted there atleast a dozen times...

[ub3r]

A customer of ours had this problem earlier tonight, and when i searched WHT i found this thread where nobody provided a solution. I did the following to fix it:

/scripts/realperlinstaller --force DBD::mysql
/scripts/restartsrv_eximstats
/etc/init.d/chkservd restart

If anybody else has that problem, and the above commands don't fix it, you should start another thread.

[BURSTWayne]

Try reinstalling mysql (/scripts/mysqlup --force)

[ThinkSupport]

The problem you are receiving is because it seems you have upgraded your mysql and as the error states "Client does not support authentication protocol requested by server" your mysql version is not supporting old authentication methods.

To fix this simply edit the /etc/my.cnf and add the following variable :

old-passwords

Also confirm that the following has been enabled in whm -> tweak settings -> Use old style (4.0) passwords with mySQL 4.1 (required if you have problems with php apps authenticating)

Then restart mysql followed by eximstats :

/scripts/restartsrv_mysql
/scripts/restartsrv_eximstats

This should fix the problem.

[ub3r]

If you're upgrading from mysql 4.0 to mysql 4.1, and you encounter this error when attempting to use any script that makes use of DBD::MySQL, run the following:

/scripts/realperlinstaller --force DBD::mysql

everything will work perfectly after that.

[getweb]

Ha! Works like a charm for me as well. Thank you, ub3r

[jacksony]

thanks man! this thread really helps! the solution that works for me is this :

/scripts/realperlinstaller --force DBD::mysql
/scripts/restartsrv_eximstats
/etc/init.d/chkservd restart