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.

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

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

  1. serdars

    serdars Member

    Joined:
    May 24, 2011
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    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:
    14,450
    Likes Received:
    195
    Trophy Points:
    63
    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?
     
  3. serdars

    serdars Member

    Joined:
    May 24, 2011
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    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:
      129
    #3 serdars, Jun 15, 2011
    Last edited: Jun 15, 2011
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,450
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Got it. Same here, empty. Please put in a ticket about this to cPanel Support.
     
  5. serdars

    serdars Member

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

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  7. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,450
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Ticket opened Michael: ID #1631534
     
  8. serdars

    serdars Member

    Joined:
    May 24, 2011
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    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:
    14,450
    Likes Received:
    195
    Trophy Points:
    63
    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.
     
  10. crazyaboutlinux

    crazyaboutlinux Well-Known Member

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

    storminternet Well-Known Member

    Joined:
    Nov 2, 2011
    Messages:
    462
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Yes stats should be updated by above command.
     
  12. crazyaboutlinux

    crazyaboutlinux Well-Known Member

    Joined:
    Nov 3, 2007
    Messages:
    938
    Likes Received:
    0
    Trophy Points:
    16
    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:
    938
    Likes Received:
    0
    Trophy Points:
    16
    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:
    462
    Likes Received:
    0
    Trophy Points:
    16
    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
     
Loading...

Share This Page