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!

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

Discussion in 'E-mail Discussion' started by serdars, Jun 15, 2011.

  1. serdars

    serdars Member

    Joined:
    May 24, 2011
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    51
    Hi all!

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

    What should I do?
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,514
    Likes Received:
    425
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. serdars

    serdars Member

    Joined:
    May 24, 2011
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    51
    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?
     

    Attached Files:

    • mr.jpg
      mr.jpg
      File size:
      62.2 KB
      Views:
      130
    #3 serdars, Jun 15, 2011
    Last edited: Jun 15, 2011
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,514
    Likes Received:
    425
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Got it. Same here, empty. Please put in a ticket about this to cPanel Support.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. serdars

    serdars Member

    Joined:
    May 24, 2011
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    51
    Can it be about eximstats's db?
     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,183
    Likes Received:
    1,935
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,514
    Likes Received:
    425
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Ticket opened Michael: ID #1631534
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. serdars

    serdars Member

    Joined:
    May 24, 2011
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    51
    Thnx Michael :)
    But I fixed with using
    Code:
    /usr/local/cpanel/bin/updateeximstats
    :)
    I'll remember these commands, added my brain!:)
     
  9. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,514
    Likes Received:
    425
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  10. crazyaboutlinux

    crazyaboutlinux Well-Known Member

    Joined:
    Nov 3, 2007
    Messages:
    939
    Likes Received:
    0
    Trophy Points:
    66
    is the stat was immediately update after this command ???
     
  11. storminternet

    storminternet Well-Known Member

    Joined:
    Nov 2, 2011
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    66
    cPanel Access Level:
    Root Administrator
    Yes stats should be updated by above command.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  12. crazyaboutlinux

    crazyaboutlinux Well-Known Member

    Joined:
    Nov 3, 2007
    Messages:
    939
    Likes Received:
    0
    Trophy Points:
    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
     
  13. crazyaboutlinux

    crazyaboutlinux Well-Known Member

    Joined:
    Nov 3, 2007
    Messages:
    939
    Likes Received:
    0
    Trophy Points:
    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 ??
     
  14. storminternet

    storminternet Well-Known Member

    Joined:
    Nov 2, 2011
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    66
    cPanel Access Level:
    Root Administrator
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice