eximstats mysql table remains empty - users cannot "Trace Emails" in cpanel

[santrix]

Hi - the title says it all really... eximstats mysql tables remain empty - users cannot "Trace Emails" in cpanel. Have restarted exim and tailwatch. Any clues as to what could be causing this - only seeing this on one of several servers.

 

[cPanelTristan]

Re: eximstats mysql table remains empty - users cannot "Trace Emails" in cp

Does the eximstats database exist?

mysql -e "show tables in eximstats"

If that does return data, do you see any errors about eximstats in /usr/local/cpanel/logs/tailwatchd_log file?

grep eximstats /usr/local/cpanel/logs/tailwatchd_log

 

[santrix]

Re: eximstats mysql table remains empty - users cannot "Trace Emails" in cp

Hi - sorry for delay in replying. Yep the four tables are definitely there and are all consistent.

Checking tailwatchd_log for 'eximstats' showed up a pile of this:

DBI connect('eximstats:localhost','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/TailWatch/Eximstats.pm line 849

MySQL is running and the socket appears correct:

srwxrwxrwx 1 mysql mysql 0 Jun 9 03:03 /var/lib/mysql/mysql.sock=

Any clues?

 

[cPanelTristan]

Re: eximstats mysql table remains empty - users cannot "Trace Emails" in cp

Hi,
Could you try resetting the eximstats password:

/usr/local/cpanel/bin/generate_eximstats_pass

After doing that, find out the new password:

/usr/local/cpanel/bin/eximstatspass

Then check you can enter MySQL as that user:

mysql -u eximstats -pnewpass

Please replace newpass with the password.

If the above does not fix it, please submit a ticket for us to investigate further.

Thanks!

 

[santrix]

Re: eximstats mysql table remains empty - users cannot "Trace Emails" in cp

Thanks Tristan

Tried that - three times to be sure... The password gets returned without a linefeed, but it's pretty clear what it is in each instance.

ERROR 1045 (28000): Access denied for user 'eximstats'@'localhost' (using password: YES)

I'll submit a ticket!

 

[cPanelTristan]

Re: eximstats mysql table remains empty - users cannot "Trace Emails" in cp

Actually, I believe I made an error above. I placed a space after -p for newpass, but MySQL requires the password to be immediately after the -p without a space, so I've revised my post above. Regardless, a ticket is probably a good idea. Please let us know the ticket number after you've opened one.

Thanks!