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

santrix

Well-Known Member
Nov 30, 2008
225
2
68
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

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Re: eximstats mysql table remains empty - users cannot "Trace Emails" in cp

Does the eximstats database exist?

Code:
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?

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

santrix

Well-Known Member
Nov 30, 2008
225
2
68
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

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Re: eximstats mysql table remains empty - users cannot "Trace Emails" in cp

Hi,
Could you try resetting the eximstats password:

Code:
/usr/local/cpanel/bin/generate_eximstats_pass
After doing that, find out the new password:

Code:
/usr/local/cpanel/bin/eximstatspass
Then check you can enter MySQL as that user:

Code:
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

Well-Known Member
Nov 30, 2008
225
2
68
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

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
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!