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.

mySQL Error

Discussion in 'General Discussion' started by ukhost, Oct 12, 2002.

  1. ukhost

    ukhost Well-Known Member

    Joined:
    Jan 8, 2002
    Messages:
    222
    Likes Received:
    0
    Trophy Points:
    16
    Hi All,

    One of the sites we host is getting the following message every few hours on there site:

    Warning: Host '&server was here&' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/&username&/public_html/adodb/adodb-mysql.inc.php on line 113

    Warning: MySQL Connection Failed: Host '&server was here&' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/&username&/public_html/adodb/adodb-mysql.inc.php on line 113

    I know that running mysqladmin flush-hosts fixes this but how can we prevent it in the first place?

    Kind Regards,

    Neil
     
  2. ukhost

    ukhost Well-Known Member

    Joined:
    Jan 8, 2002
    Messages:
    222
    Likes Received:
    0
    Trophy Points:
    16
    Anyone know how to fix/stop this from happening?

    Kind Regards,

    Neil
     
  3. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    I am interested in an answer on the above question.

    cPanel.net Support Ticket Number:
     
  4. fgauthier

    fgauthier Member
    PartnerNOC

    Joined:
    Feb 22, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    increase the max connection limit in my.cnf

    cPanel.net Support Ticket Number:
     
  5. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    Where is my.cnf located?

    cPanel.net Support Ticket Number:
     
  6. NiN

    NiN Active Member

    Joined:
    Apr 30, 2003
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Braga, Portugal
    /etc/my.cnf

    cPanel.net Support Ticket Number:
     
  7. amal

    amal Well-Known Member

    Joined:
    Nov 22, 2003
    Messages:
    155
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Same errror

    I'm also getting the same error... :-(

    Warning: mysql_pconnect(): Host 'HOSTNAME' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/xyz/public_html/common/db.php on line 43

    I tried increasing the max connection errors in /etc/my.cnf, and restarted mysql... It didn't work

    It automatically corrects itself after a few hours. But the problem is the error is coming back time and again. Any help on this matter is highly appreciated...

    Thanks in Advance. :)
     
Loading...

Share This Page