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

    cPanelTristan Quality Assurance Analyst
    Staff Member

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

    Question about eximstats_spam_check

    goodmove, Aug 27, 2018, in forum: E-mail Discussion
    Replies:
    1
    Views:
    100
    cPanelLauren
    Aug 27, 2018
  2. stbolen

    /var/cpanel/eximstats_db.sqlite3 size issue

    stbolen, Aug 7, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    227
    cPanelLauren
    Aug 8, 2018
  3. ruiz

    Change eximstats_spam_check in crontab

    ruiz, Jul 29, 2018, in forum: E-mail Discussion
    Replies:
    3
    Views:
    104
    cPanelMichael
    Aug 2, 2018
  4. smartrange

    warn [eximstats_spam_check]

    smartrange, May 24, 2018, in forum: E-mail Discussion
    Replies:
    6
    Views:
    275
    cPanelLauren
    Jun 5, 2018
  5. swbrains

    SOLVED [CPANEL-20345] eximstats_spam_check cron job always sends root notification

    swbrains, Apr 2, 2018, in forum: E-mail Discussion
    Replies:
    14
    Views:
    1,475
    cPanelMichael
    Aug 7, 2018

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.
    Accept Learn More...
    Dismiss Notice