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:
    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.
     
    #1 santrix, Jul 10, 2012
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,622
    Likes Received:
    24
    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
     
    #2 cPanelTristan, Jul 10, 2012
  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?
     
    #3 santrix, Jul 14, 2012
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,622
    Likes Received:
    24
    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!
     
    #4 cPanelTristan, Jul 14, 2012
  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!
     
    #5 santrix, Jul 14, 2012
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,622
    Likes Received:
    24
    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!
     
    #6 cPanelTristan, Jul 14, 2012
(You must log in or sign up to post here.)
Loading...
Similar Threads - eximstats mysql table
  1. Philip R.

    pruning eximstats sqlite

    Philip R., Apr 27, 2017, in forum: E-mail Discussions
    Replies:
    3
    Views:
    486
    Philip R.
    Apr 28, 2017
  2. Lievano93

    Eximstats database missing after WHM upgrade

    Lievano93, Apr 26, 2017, in forum: E-mail Discussions
    Replies:
    2
    Views:
    396
    cPanelMichael
    Apr 27, 2017
  3. JedCavins

    Prune Eximstats

    JedCavins, Jan 22, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    273
    cPanelMichael
    Jan 23, 2017
  4. urgido

    SOLVED Table './eximstats/sends' is marked as crashed

    urgido, Jan 16, 2017, in forum: E-mail Discussions
    Replies:
    9
    Views:
    579
    urgido
    Feb 15, 2017
  5. speedcom

    SOLVED Database Error: Table './eximstats/sends

    speedcom, Dec 20, 2016, in forum: E-mail Discussions
    Replies:
    3
    Views:
    605
    speedcom
    Dec 23, 2016

Share This Page