The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

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

  1. santrix

    santrix Well-Known Member

    Joined:
    Nov 30, 2008
    Messages:
    223
    Likes Received:
    2
    Trophy Points:
    18
    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,623
    Likes Received:
    21
    Trophy Points:
    38
    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
     
  3. santrix

    santrix Well-Known Member

    Joined:
    Nov 30, 2008
    Messages:
    223
    Likes Received:
    2
    Trophy Points:
    18
    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,623
    Likes Received:
    21
    Trophy Points:
    38
    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!
     
  5. santrix

    santrix Well-Known Member

    Joined:
    Nov 30, 2008
    Messages:
    223
    Likes Received:
    2
    Trophy Points:
    18
    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,623
    Likes Received:
    21
    Trophy Points:
    38
    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!
     
Loading...

Share This Page