View Full Version : Unblock with 'mysqladmin flush-hosts'


wifistudios
07-26-2005, 12:28 AM
:banghead:

Good Day,

I am trying to install the PayPal Assistant for the first time on my website. I already added the PHP files to a folder on the server /paypal/ and made my temp folder have 777 access.

The following error comes up when I try to run the script:

Warning: mysql_connect(): Host 'blazecast6.rdns.net' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/realnota/public_html/paypal/functions.php on line 21
Could not connectHost 'blazecast6.rdns.net' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

Please assist.

Thank You,
~jefe

Jafo
07-26-2005, 08:58 AM
Hmm, sounds like you need to flush your MySQL server. This usually happens when someone is trying to login too many times with an incorrect password and MySQL scrams:

http://dev.mysql.com/doc/mysql/en/blocked-host.html

wifistudios
08-26-2005, 11:21 AM
I am still having the same issue. I deleted all accounts for user name and db from MYSQL, and I also renamed everything differently in both the .php files and db.

The following error comes up when I try to run the script:

Warning: mysql_connect(): Host 'blazecast6.rdns.net' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/realnota/public_html/paypal/functions.php on line 21
Could not connectHost 'blazecast6.rdns.net' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

This is the path to my paypal file in my server from the FTP Client, /public_html/paypal/ , is this correct?

I also added the paypal.cgi file to this directory /www/cgi-bin/ , is that correct also?

Is there anyway to get this installed under my site?

Thank you.

Jafo
08-26-2005, 11:54 AM
Did you issue a mysqladmin flush-hosts command?

wifistudios
08-26-2005, 12:10 PM
How do I do that if I am using a cPanel? How can I get to the shell?

Jafo
08-26-2005, 12:37 PM
Well, I have never used Cpanel. What type of MySQL admin program does Cpanel use?

wifistudios
08-26-2005, 12:42 PM
Operating system Linux
Service Status Click to View
Kernel version 2.4.21-27.0.2.ELsmp
Machine Type i686
Apache version 1.3.33 (Unix)
PERL version 5.8.1
Path to PERL /usr/bin/perl
Path to sendmail /usr/sbin/sendmail
Installed Perl Modules Click to View
PHP version 4.3.11
MySQL version 4.0.22-standard
cPanel Build 10.2.0-STABLE 83


You can use phpMyAdmin to administrate your MySQL databases in a web based environment.

Let me know if you would like a free account. jefe@wifistudios.com

Jafo
08-26-2005, 12:48 PM
Then you would issue the command through phpMyAdmin.

wifistudios
08-26-2005, 01:00 PM
They do not offer shell access through phpMyAdmin.

Jafo
08-26-2005, 01:06 PM
Shell access? Not needed. It has been a while since I used that script but I believe you login to phpMyAdmin, select the database in question, click the SQL tab, and type in the command: flush hosts.

wifistudios
08-26-2005, 01:13 PM
Error
SQL-query:

FLUSH HOSTS
MySQL said:

#1227 - Access denied. You need the RELOAD privilege for this operation

Jafo
08-26-2005, 01:15 PM
Then you will have to have your sys admin flush it then.