Hi all,
I have a script in perl accessing a db in another machine every 5 minutes (by crontab), and I have had this error 'host blocked' 2 or 3 times, in 2 or 3 weeks (not regularly). http://www.mysql.com/doc/B/l/Blocked_host.html >From this link, I read that it is due to interrupted connexions or something like this, and it is adviced to increase max_connect_errors. However, before increasing this variable, I would like to debug which in my network or in my script cause these errors. I already activated the 'warnings' option in the server, but I did not get anything. Have you any idea on how to debug this ? or what can cause these errors ? Connections are normally closed in the script, and I have gotten any errors apart the host blocked error : DBI->connect(database=radius;host=1.2 3 4) failed: Host 'host' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' at /usr/local/bin/mysql_hp-hc.pl line 79 db : Connexion refused !!! Thanks in advance, @+ -- DouRiX --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
