The usual eximstats error @ cPanel fixed
Initially check if eximstats is enabled at /var/cpanel/cpanel.config. Most of the time the error is caused because of a database connectivity issue. The password set fr eximstats may not work at mysql and hence stats cannot connect.
A snip of the usual error :
Starting eximstats: DBI connect('eximstats:localhost','eximstats',...) failed: Access denied for user: 'eximstats@localhost' (Using password: YES) at /usr/local/cpanel/bin/eximstats line 258
The fix is to correct the database permissions at mysql wrt eximstats. You need to get the password used by eximstats to connect to mysql; this is available at the file /usr/local/cpanel/etc/eximstats.sql
I am pasting a snip of the file which tells you the password:
REPLACE INTO user (host, user, password)
VALUES (
'localhost',
'eximstats',
-- IMPORTANT: Change this password!
password('DzfIRJGM')
);
In this case "DzfIRJGM" is the password. Copy that one.
Login to mysql.
mysql -u root -pXXXXXX
XXXXXXX = MySql password.
mysql > update mysql.user set password=password("DzfIRJGM") where user="eximstats";
mysql> flush privileges;
msyql> quit
This will fix the error and you will no longer get a mysql connectivity problemo.
Another error that you see is:
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.
Th fix is to reinstall the DBD:mysql perl module. Do:
/scripts/realperlinstaller --force Bundle::DBD::mysql
Sometimes after a Mysql upgrade it so happens that the error appears as:
Client does not support authentication protocol requested by server; consider upgrading MySQL client.
I have seen this happen mostly at CentOs servers, and the easiest fix is to put the variable "old-passwords = 1" at /etc/my.cnf and restart Mysql Server.
Here comes another one:
Starting eximstats: Can't locate auto/Cpanel/cPanelFunctions/getmydbhost.al in @INC (@INC contains: /usr/lib/perl5/5.8.4/i686-linux /usr/lib/perl5/5.8.4 /usr/lib/perl5/site_perl/5.8.4/i686-linux /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl . /usr/local/cpanel /usr/local/cpanel /scripts /usr/local/cpanel /scripts) at /usr/local/cpanel/bin/starteximstats line 25
This probabaly is a release related error. You might want to upgrade perl from http://layer1.cpanel.net/
Nikhil Thomas
Chief Consultant.
