Mail Delivery Reports not working

NikRB

• May 21, 2015 22:10

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
/usr/local/cpanel/logs/tailwatchd_log

[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, 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

• 

  lldeepakll

  • May 22, 2015 07:09

  Hello, Review the following eximstats thread as it might be helpful for you.

  0
• 

  24x7server

  • May 22, 2015 12:01

  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.
  mysqlcheck -r eximstats
  

  0
• 

  cPanelMichael

  • May 22, 2015 14:56

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

  0
• 

  NikRB

  • May 28, 2015 15:26

  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.

  0
• 

  cPanelMichael

  • May 28, 2015 16:04

  I am happy to see the issue is now resolved. Thank you for updating us with the outcome.

  0

Please sign in to leave a comment.