1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Resource Usage shows nothing in cPanel.

Discussion in 'CloudLinux' started by vixon, Feb 29, 2012.

  1. vixon

    vixon Member

    Joined:
    Sep 23, 2009
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Estonia
    Hello,

    There is some fault with "Resource Usage Overview" function in cPanel, it doesn't work and gives:

    And in WHM > CloudLinux LVE Manager everything is showing up correctly.

    Please suggest how to fix this.
     
  2. iseletsk

    iseletsk Member

    Joined:
    Mar 3, 2010
    Messages:
    161
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Princeton, New Jersey, United States
    What is the output of:

    lveinfo --period=1d --user=XXX
    where XXX is the username of the user for which you see "no activity"
     
  3. vixon

    vixon Member

    Joined:
    Sep 23, 2009
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Estonia
    I have tried that and there is no output for any users.
     
  4. iseletsk

    iseletsk Member

    Joined:
    Mar 3, 2010
    Messages:
    161
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Princeton, New Jersey, United States
    What exactly do you see in WHM -> LVE Manager?
    Also, try doing:
    grep lvestat /var/log/messages
     
  5. vixon

    vixon Member

    Joined:
    Sep 23, 2009
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Estonia
    Mar 1 15:06:04 a14 lvestats-server[1841]: <class 'sqlite3.OperationalError'>: no such table: last_run
    Mar 1 15:06:19 a14 lvestats-server[1841]: <class 'sqlite3.OperationalError'>: no such table: last_run
    ..

    In WHM's LVE Manager I see things working as normal, the statistics doesn't work just in cPanel.
     
  6. iseletsk

    iseletsk Member

    Joined:
    Mar 3, 2010
    Messages:
    161
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Princeton, New Jersey, United States
    I am pretty sure that if you switch to [stats] tab in WHM's LVE Manager -- it will not show things as well.

    Please, do the following:
    service lvestats stop
    killall -9 lvestats-server
    rm -rf /var/log/lveinfo.db
    service lvestats start

    That should re-create the database/fix the issue.
     
  7. vixon

    vixon Member

    Joined:
    Sep 23, 2009
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Estonia
    It solved the issue! Many thanks :)

    Btw the database file locates in our server in /var/lve/
     
  8. iseletsk

    iseletsk Member

    Joined:
    Mar 3, 2010
    Messages:
    161
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Princeton, New Jersey, United States
    Yes, sorry ... it is still an early morning here :)
     

Share This Page