Mail Delivery Reports showing no logs

[kbs]

Hello, I have 2 cpanels servers and 1 dns-only, all of them working very well.

I have one of them that's having problems with the "Mail Delivery Reports", no matter what I use to filter, I'm getting 0 results. If I login with a shell, I can grep without any problems the logs located in /var/log, but this tool is very handy for those people that don't have any linux experience.

Where should I look?

Thanks

 

[soumya.tr]

I am also having the same issue.

@kbs: Did you get the solution for this.

 

[Oleg.Gricik]

I'm experiencing the same problem.
Can someone from cPanel staff check this?

 

[Infopro]

Do you happen to have MailScanner installed by chance?

Assuming you do just for a moment, and you also have MailScanner FE as well, go to mailScanner FE and find the "MailScanner" disable button and disable MailScanner, just to test of course. You'll want to turn it back on after testing MDR.

I may be wasting your time here, but, in Mail Delivery Reports, when you first open the page, don't touch anything, just click Run Report. In the bottom section of window, that little gear icon, click that, on bottom of this menu click "Rest to Default"

Does this help at all?

 

[kazaa]

I am having the same issue on one of my machines. Did poster find any solution?

 

[cPanelTristan]

Please submit a ticket and provide the ticket number here for tracking purposes. Thanks!

 

[leenabm]

Hi,

We are having the same problem. Both " Mail Delivery Reports" and "View Sent Summary" are not showing any details. Any help appreciated.

 

[cPanelTristan]

As yet, no-one has posted a ticket number indicating a ticket was opened for us to see how it was resolved. If you'd like to be the first one to do that, it would be greatly appreciated. Tickets can be submitted in WHM > Support Center > Contact cPanel or using the link in my signature. Please post the number here afterward for us to ensure the details are logged on what was the issue. Thanks!

 

[kazaa]

Just submitted ticket, thanks 3018482

 

[kazaa]

The reason it wasn't showing anything is because eximstats was disabled:


The mail reports in WHM are pulled from the information in eximstats. In the future you can check if it's enabled in WHM Main >> Service Configuration >> Service Manager. I enabled eximstats and the database is now populating. It may take a while since there's a lot of information in your exim log and your load may spike a little while it does this, however it will return to normal once it's completed if the load does increase.

Thanks!!!

 

[Infopro]

Thanks for posting back to help others.

 

[mandarin]

The reason it wasn't showing anything is because eximstats was disabled:


The mail reports in WHM are pulled from the information in eximstats. In the future you can check if it's enabled in WHM Main >> Service Configuration >> Service Manager. I enabled eximstats and the database is now populating. It may take a while since there's a lot of information in your exim log and your load may spike a little while it does this, however it will return to normal once it's completed if the load does increase.

Thanks!!!

I'm not seeing delivery reports but exim stats are on. Tried turning off, on again next day but still no joy.

Has to be something else.

 

[uk01]

I'm not seeing delivery reports but exim stats are on. Tried turning off, on again next day but still no joy.

Has to be something else.

Hi we have the same problem, used to work but doesn't now.
We've done the same as you, turn exim stats on and off, still no logs. Needed them today aswell to prove to a customer that their email was working!

Must be a cpanel/whm update which has done this?

 

[Infopro]

You might want to open a ticket to cPanel Support. In WHM, top right corner of any page find the Support Menu. On it, Contact cPanel.

Please do post back what you find out, and/or post the ticket number here in this thread if you wouldn't mind.

Thanks!

 

[sonicsam]

Just to add my name to the list, this is happening on one of our servers, eximstats is already enabled.

 

[cPanelTristan]

Please do the following to check what eximstats is doing when tailwatchd tries to process it:

grep eximstats /usr/local/cpanel/logs/tailwatchd_log

If you see something like the following:

DBI connect('eximstats:localhost','eximstats',...) failed: Access denied for user 'eximstats'@'localhost' (using password: YES) at /usr/local/cpanel/Cpanel/TailWatch/Eximstats.pm line 862.

Then review the other eximstats thread that should help on that error:

http://forums.cpanel.net/f43/eximst...t-trace-emails-cpanel-284401.html#post1190792

I did also want to mention something that is very helpful to do. If you have an issue and search and read only one thread, it isn't as likely you'll find the solution. Read at least 3-5 threads or spend at least 15-30 minutes before posting. One thread might well have no useful information, so that's why reading multiple different ones will be more beneficial. The thread I link to above is far more detailed in what to check than this current thread.

 

[kbs]

Please do the following to check what eximstats is doing when tailwatchd tries to process it:

grep eximstats /usr/local/cpanel/logs/tailwatchd_log

If you see something like the following:

DBI connect('eximstats:localhost','eximstats',...) failed: Access denied for user 'eximstats'@'localhost' (using password: YES) at /usr/local/cpanel/Cpanel/TailWatch/Eximstats.pm line 862.

Thanks Tristan, that help!

DBD::mysql::st execute failed: Table './eximstats/sends' is marked as crashed and should be repaired at /usr/local/cpanel/Cpanel/TailWatch/Eximstats.pm line 1005, <GEN0> line 2808.
[8231] [2012-09-12 04:25:09 -0300] [Cpanel::TailWatch::Eximstats] [ERR] SQL Failed with error (Table './eximstats/sends' is marked as crashed and should be repaired): INSERT DELAYED INTO sends (mailtime,msgid,processed,domain,email,user,size,host,ip,auth,localsender) VALUES(FROM_UNIXTIME('1347434709'),'1TBhJt-0008YA-4r','0','','[email protected]','-remote-','0','xsv4ylvl.net','115.124.79.38','unauthorized','0')
DBD::mysql::st execute failed: Table './eximstats/sends' is marked as crashed and should be repaired at /usr/local/cpanel/Cpanel/TailWatch/Eximstats.pm line 1005, <GEN0> line 2814.

My DB was broken

 

[sonicsam]

Thanks Tristan, that help!

DBD::mysql::st execute failed: Table './eximstats/sends' is marked as crashed and should be repaired at /usr/local/cpanel/Cpanel/TailWatch/Eximstats.pm line 1005, <GEN0> line 2808.
[8231] [2012-09-12 04:25:09 -0300] [Cpanel::TailWatch::Eximstats] [ERR] SQL Failed with error (Table './eximstats/sends' is marked as crashed and should be repaired): INSERT DELAYED INTO sends (mailtime,msgid,processed,domain,email,user,size,host,ip,auth,localsender) VALUES(FROM_UNIXTIME('1347434709'),'1TBhJt-0008YA-4r','0','','[email protected]','-remote-','0','xsv4ylvl.net','115.124.79.38','unauthorized','0')
DBD::mysql::st execute failed: Table './eximstats/sends' is marked as crashed and should be repaired at /usr/local/cpanel/Cpanel/TailWatch/Eximstats.pm line 1005, <GEN0> line 2814.

My DB was broken

Mine was exactly the same, tables 'sends' and 'failures' reported as cashed, repaired them from phpmyadmin and this fixed he problem, now I see logs in whm.

 

[IRBiddlecombe]

We have a situation where some of the domains work with the delivery reports and some do not.

# grep eximstats /usr/local/cpanel/logs/tailwatchd_log
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 252
[2011-03-10 22:25:36 +0200] [Cpanel::TailWatch] [INFO] Opened /var/cpanel/sql/eximstats.sql in append mode
[24893] [2012-06-25 14:06:02 +0200] [Cpanel::TailWatch::Eximstats] [SQLERR] Fetching group_stats for domains failed. Do you need to run /usr/local/cpanel/bin/updateeximstats? The exact error was: Unknown column 'x.domain' in 'field list'
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

Am I correct in assuming that I need to update first? (I have CPanel updates but we have not done it yet because the mysql is not compatible).

 

[cPanelMichael]

Do you notice any error messages when running "/usr/local/cpanel/bin/updateeximstats" via the command line?

Thank you.