Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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

Discussion in 'E-mail Discussion' started by santrix, Jul 10, 2012.

  1. santrix

    santrix Well-Known Member

    Joined:
    Nov 30, 2008
    Messages:
    223
    Likes Received:
    2
    Trophy Points:
    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.
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. santrix

    santrix Well-Known Member

    Joined:
    Nov 30, 2008
    Messages:
    223
    Likes Received:
    2
    Trophy Points:
    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?
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. santrix

    santrix Well-Known Member

    Joined:
    Nov 30, 2008
    Messages:
    223
    Likes Received:
    2
    Trophy Points:
    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!
     
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice