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.

WatchMySQL is now a WHM plug-in

Discussion in 'General Discussion' started by shaun, Feb 4, 2011.

Thread Status:
Not open for further replies.
  1. shaun

    shaun Well-Known Member

    Joined:
    Nov 9, 2001
    Messages:
    698
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Clemente, Ca
    Just shooting out a update for those of you who may already be using our WatchMySQL script. The script has now been converted into a WHM plug-in. Their are also a few new features. Admins can now set limits by user, by package, or just set a global limit. User limits override package and global limits, and package limits override global limits. The new version also supports backgrounding so you no longer have to start it with a &.

    Check it out here: NDCHost - WatchMySQL plugin for cPanel/WHM

    Let us know what you think, or if you have any problems!
     
  2. rhenderson

    rhenderson Well-Known Member

    Joined:
    Apr 21, 2005
    Messages:
    785
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Oklahoma
    cPanel Access Level:
    Root Administrator
    Errors

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/local/cpanel/whostmgr/docroot/watchmysql/watchmysql.class.php on line 218

    Then

    MySQL Server Connection Failed: Access denied for user '"root"'@'localhost' (using password: YES)
    Access denied for user '"root"'@'localhost' (using password: YES)

    I just changed my cPanel license to NDCHost so let me know if you want to look at it.

    The script is running, so it just appears to be the WHM portion not working.
     
    #2 rhenderson, Feb 4, 2011
    Last edited: Feb 4, 2011
  3. shaun

    shaun Well-Known Member

    Joined:
    Nov 9, 2001
    Messages:
    698
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Clemente, Ca
    Does your /root/.my.cnf file have the correct mysql details in it?

    yes if you want, open a ticket with us and we can take a closer look at it!
     
  4. rhenderson

    rhenderson Well-Known Member

    Joined:
    Apr 21, 2005
    Messages:
    785
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Oklahoma
    cPanel Access Level:
    Root Administrator
    Hi,

    Not 100% positive if that is the correct password or not....I will change it and see if that file changes.

    Randy
     
  5. rhenderson

    rhenderson Well-Known Member

    Joined:
    Apr 21, 2005
    Messages:
    785
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Oklahoma
    cPanel Access Level:
    Root Administrator
    I changed it and still have the same error, I will put in a ticket.

    Lol, got an error trying submit a helpdesk ticket after loggins into NDCHost website.

    [Warning]: Cannot modify header information - headers already sent by (output started at /home/helpdesk/public_html/__swift/library/User/class.SWIFT_User.php:538) (client/class.Controller_Submit.php:460)

    But I did get assigned a ticket ZAL-228-19332, I guess because it was only a warning error, but the rest of the page was blank, I got a screen shot of it if you want it.
     
    #5 rhenderson, Feb 4, 2011
    Last edited: Feb 4, 2011
  6. rhenderson

    rhenderson Well-Known Member

    Joined:
    Apr 21, 2005
    Messages:
    785
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Oklahoma
    cPanel Access Level:
    Root Administrator
    I found the issue, in .my.cnf file my password was in "quotes", once they were removed it started working fine. Thankd for providing this script!

    However, everytime I run the script the quotes are put back in the file, strange....
     
    #6 rhenderson, Feb 4, 2011
    Last edited: Feb 4, 2011
  7. shaun

    shaun Well-Known Member

    Joined:
    Nov 9, 2001
    Messages:
    698
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Clemente, Ca
    Sorry about that! Some of cPanels scripts add the double quotes to /root/.my.cnf and some dont. WatchMySQL version 4 should work for you now! Log into the WHM, click on the plugin and you should see a new version notice at the top, click the upgrade link.

    As for the ticket desk issue, we made the mistake of upgrading to kayako (or fusion) version 4, they released it as stable but it's far from that, full of bugs and problems, and no fix's :mad: I'll look into the problem!
     
  8. rlshosting

    rlshosting Well-Known Member

    Joined:
    Apr 23, 2009
    Messages:
    170
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United States
    cPanel Access Level:
    Root Administrator
  9. rhenderson

    rhenderson Well-Known Member

    Joined:
    Apr 21, 2005
    Messages:
    785
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Oklahoma
    cPanel Access Level:
    Root Administrator
    Yes that corrected the issue, thanks!

    Randy
     
  10. shaun

    shaun Well-Known Member

    Joined:
    Nov 9, 2001
    Messages:
    698
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Clemente, Ca
  11. texo

    texo Well-Known Member

    Joined:
    Mar 28, 2007
    Messages:
    143
    Likes Received:
    0
    Trophy Points:
    16
    I would liek to test this, but I don't see any uninstall instructions. How can we uninstall it, if necessary?
     
  12. shaun

    shaun Well-Known Member

    Joined:
    Nov 9, 2001
    Messages:
    698
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Clemente, Ca
    There is a uninstall script in the installer directory, but here's how to do it.

    rm -f /usr/local/cpanel/whostmgr/docroot/cgi/addon_watchmysql.php
    rm -rf /usr/local/cpanel/whostmgr/docroot/watchmysql
    rm -f /usr/sbin/watchmysql
    rm -f /etc/watchmysql.config
    rm -f /etc/watchmysql.userlimits
    rm -f /etc/watchmysql.packagelimits
    rm -f /etc/chkserv.d/watchmysql
    rm -f /etc/init.d/watchmysql
     
  13. nixgurus

    nixgurus Member

    Joined:
    Feb 16, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Google
    cPanel Access Level:
    Root Administrator
    When I install both WatchMySQL & Account DNS Check both stop working a white blank page shows. But when I remove WatchMySQL plugin then account dns check working fine. Is there any compatibility issue?
     
  14. Sparrow-Sean

    Sparrow-Sean Member

    Joined:
    Jul 15, 2008
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Queanbeyan, Australia
    Installed this and it works perfectly! :)

    I cannot remember the support officers name, I think perhaps Steve or Steven was very helpful where it came to the use on a CloudLinux system.

    Seems to work as they described it would.

    Thanks for the great application.
     
  15. bhanuprasad1981

    bhanuprasad1981 Well-Known Member

    Joined:
    Aug 5, 2008
    Messages:
    222
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    been using it past some days , i took a look at its main page , got shocked to see one user was having 500+ connections running past 30+ minutes but script didnt kill them any idea why ?global limit is 300 and package limit for that user is 200 but still not killed.
     
  16. k-planethost

    k-planethost Well-Known Member

    Joined:
    Sep 22, 2009
    Messages:
    199
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    Athens Greece
    how can you restart the service ?
    appears to be down now and takes ages to load from whm-plugin
    also i believe that is just monitoring the databases and not kill the extra connections
     
    #16 k-planethost, Mar 30, 2011
    Last edited: Mar 30, 2011
  17. bhanuprasad1981

    bhanuprasad1981 Well-Known Member

    Joined:
    Aug 5, 2008
    Messages:
    222
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    same for me , it just notifies, doesn't kill extra connection or all connections of abusing user :(
     
  18. shaun

    shaun Well-Known Member

    Joined:
    Nov 9, 2001
    Messages:
    698
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Clemente, Ca
  19. k-planethost

    k-planethost Well-Known Member

    Joined:
    Sep 22, 2009
    Messages:
    199
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    Athens Greece
    the issue with taking long with the script to load from plugins had disappeared to one of the servers after few changes that i did

    WDW-358-86890
    i had submit a ticket to see the rest thanks for the link of the support area
     
  20. shaun

    shaun Well-Known Member

    Joined:
    Nov 9, 2001
    Messages:
    698
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    San Clemente, Ca
    WatchMySQL version 6 is now out. This version corrects a problem on cPanel servers where the script would not kill MySQL connections as the primary cPanel user ( username Vs. username_dbuser ).

    If anybody has any other problems please contact us! support@ndchost.com
     
Loading...
Thread Status:
Not open for further replies.

Share This Page