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.

Mail Delivery Reports not working

Discussion in 'E-mail Discussions' started by NikRB, May 21, 2015.

  1. NikRB

    NikRB Registered

    Joined:
    May 21, 2015
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Perth, Australia
    cPanel Access Level:
    Root Administrator
    I am not receiving any logs in the mail delivery reports.
    I tried to repair the exim tables and ended up deleting all the data that was in them (not sure if that was a good idea).

    This is the output of
    Code:
    /usr/local/cpanel/logs/tailwatchd_log
    Code:
    [6362] [2015-05-07 03:13:37 +0000] [Cpanel::TailWatch] [INFO] Opened /var/cpanel/sql/eximstats.sql in append mode
    Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/eximstats.sql.
      mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
      mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Once you are sure all is well you can remove /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/eximstats.sql.
      mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
      mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Once you are sure all is well you can remove /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/eximstats.sql.
      mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
      mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Once you are sure all is well you can remove /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/eximstats.sql.
      mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
      mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Once you are sure all is well you can remove /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 65.
    Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 65.
    Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 65.
    [24772] [2015-05-15 01:45:58 +0800] [Cpanel::TailWatch] [INFO] Opened /var/cpanel/sql/eximstats.sql in append mode
    Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 65.
    Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 65.
    Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 65.
    Waiting for “mysql” to start ……Cpanel::DBI::Mysql connect('','eximstats',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBI.pm line 65.
        150514 23:58:02 [Warning] /usr/sbin/mysqld: Forcing close of thread 22612  user: 'eximstats'
        150507 16:32:19 [Warning] /usr/sbin/mysqld: Forcing close of thread 5  user: 'eximstats'
    Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/eximstats.sql.
      mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
      mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Once you are sure all is well you can remove /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/eximstats.sql.
      mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
      mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Once you are sure all is well you can remove /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/eximstats.sql.
      mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
      mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy
    Once you are sure all is well you can remove /var/cpanel/sql/eximstats.sql.tmp_working_copy
    DBD::mysql::st execute failed: Incorrect key file for table './eximstats/sends.MYI'; try to repair it at /usr/local/cpanel/Cpanel/TailWatch/Eximstats.pm line 1039, <GEN0> line 15.
    [1953] [2015-05-21 02:33:12 +0800] [Cpanel::TailWatch::Eximstats] [ERR] SQL Failed with error (Incorrect key file for table './eximstats/sends.MYI'; try to repair it): INSERT  INTO sends (mailtime,msgid,processed,domain,email,user,size,host,ip,auth,localsender,unique_id) VALUES(FROM_UNIXTIME('1432146041'),'1Yv8bh-00042a-
    
    - Personal Details Snipped - 
    Not sure how to fix it, any help appreciated.
    I am a bit of a novice so code examples of how to fix are appreciated.

    Thank yoy
     
    #1 NikRB, May 21, 2015
    Last edited by a moderator: May 21, 2015
  2. lldeepakll

    lldeepakll Well-Known Member

    Joined:
    May 20, 2012
    Messages:
    86
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    India
    cPanel Access Level:
    Root Administrator
  3. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    I can see your eximstats databases is crashed and due to that you are getting this issues, Can you please try to repir it with the following command and give a try again.

    Code:
    mysqlcheck -r eximstats
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    Please let us know if the issue persists after repairing the eximstats database per the instructions in the previous posts.

    Thank you.
     
  5. NikRB

    NikRB Registered

    Joined:
    May 21, 2015
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Perth, Australia
    cPanel Access Level:
    Root Administrator
    The actual option to track exim was turned off by mistake in WHM, enabled and everything was fine. It's in the service manager if anyone makes the same mistake.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page