I can't see Main >> Email >> View Relayers 's reports

serdars

Member
May 24, 2011
12
0
51
Hi all!

I can't see Main >> Email >> View Relayers 's reports in 3 days.

What should I do?
 

serdars

Member
May 24, 2011
12
0
51
Not sure I understand, the view relayers page does not work, or there is no link to it in WHM for you to get there?
I added ps.
Normally, I should be see the reports that how many people and account sent mail in a day.But I can't see that?It's empty?
 

Attachments

Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,226
463
Hello :)

You may want to ensure that Tailwatchd and Eximstats are enabled via:

"WHM >> Service Configuration >> Service Manager"

If they are enabled, you can check to see if the eximstats database is corrupted via the following command:

Code:
# mysqlcheck eximstats
If it is corrupted, try repairing it via:

Code:
# mysqlcheck --repair eximstats
You can also ensure there is no unprocessed SQL in /var/cpanel/sql/eximstats.sql by running the following commands:

Code:
# mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
# /usr/local/cpanel/libexec/tailwatchd --restart
# mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy
If the issue still persists after that, please consider opening a support ticket via the following URL:

Submit A Ticket

Thank you.
 

serdars

Member
May 24, 2011
12
0
51
Thnx Michael :)
But I fixed with using
Code:
/usr/local/cpanel/bin/updateeximstats
:)
I'll remember these commands, added my brain!:)
 

Infopro

Well-Known Member
May 20, 2003
17,085
518
613
Pennsylvania
cPanel Access Level
Root Administrator
Twitter
Ticket opened Michael: ID #1631534
Should have looked a bit closer here, new settings to Exim needed to reset ACL config to defaults and save. This page now works. Interestingly enough I only got the email about doing so, when I did the task. Not before hand to let me know it needed done.

I'll close that ticket.
 

crazyaboutlinux

Well-Known Member
Nov 3, 2007
939
1
66
was the stats immediately update by the command ??

i had ran this command
PHP:
/usr/local/cpanel/bin/updateeximstats
17 hours ago but the stats is not updated yet
 

crazyaboutlinux

Well-Known Member
Nov 3, 2007
939
1
66
Hi Michael

I am having the exact issue so did ran fixed provided by "serdars" but it doesn't worked for me

then i ran # mysqlcheck eximstats

output
PHP:
-bash-3.2# mysqlcheck eximstats
eximstats.defers                                   OK
eximstats.failures                                 OK
eximstats.sends                                    OK
eximstats.smtp
warning  : Table is marked as crashed
warning  : 4 clients are using or haven't closed the table properly
error    : Invalid key block position: 156781562029034101  key block size: 1024
 file_length: 9295872
error    : key delete-link-chain corrupted
error    : Corrupt
Is the whole database corrupted ?

if i run "mysqlcheck --repair eximstats" will it create any other issue ??
 

storminternet

Well-Known Member
Nov 2, 2011
460
0
66
cPanel Access Level
Root Administrator
Hi Michael

I am having the exact issue so did ran fixed provided by "serdars" but it doesn't worked for me

then i ran # mysqlcheck eximstats

output
PHP:
-bash-3.2# mysqlcheck eximstats
eximstats.defers                                   OK
eximstats.failures                                 OK
eximstats.sends                                    OK
eximstats.smtp
warning  : Table is marked as crashed
warning  : 4 clients are using or haven't closed the table properly
error    : Invalid key block position: 156781562029034101  key block size: 1024
 file_length: 9295872
error    : key delete-link-chain corrupted
error    : Corrupt
Is the whole database corrupted ?

if i run "mysqlcheck --repair eximstats" will it create any other issue ??
Yes it seems to be database need to repair. Try the following command to repair it. That shouldn't cause any problem

mysqlcheck --repair eximstats