[Forum] Banned IP addresses have admin locked out too... need assistance

[etbliss]

Somehow the admin's IP has been blocked & locked out of the admin control panel.

We would like to clean out the banned IP addresses, but cannot get in to accomplish that task.

Any assistance on how to get into CP would be greatly appreciated.


EtBliss

[Trevor Hannant]

***TAKE A BACKUP OF YOUR DATABASE BEFORE RUNNING ANY QUERY AGAINST IT***

Run this in phpMyAdmin:

UPDATE PREFIX_setting SET value = "" WHERE varname = "banip";

If your tables use a prefix, change PREFIX_ to that prefix, if not, remove that from the query. This will clear all banned IP addresses from the database and let you log in again - be VERY careful about what you're entering when you restore IP addresses to that field in AdminCP

[etbliss]

Thank you. Your response was very fast! Impressive.

[etbliss]

***TAKE A BACKUP OF YOUR DATABASE BEFORE RUNNING ANY QUERY AGAINST IT***

Run this in phpMyAdmin:

UPDATE PREFIX_setting SET value = "" WHERE varname = "banip";

If your tables use a prefix, change PREFIX_ to that prefix, if not, remove that from the query. This will clear all banned IP addresses from the database and let you log in again - be VERY careful about what you're entering when you restore IP addresses to that field in AdminCP

Our web person ran the query and we are still locked out. Is there a plan "B"

Thank you

[LockedOnLaw]

What is the contents of your htaccess file?

[etbliss]

I just looked in the directory and the only file I found was in a backup folder and this was the only data in the file.

AuthType Basic
AuthName "User Backups"
AuthUserFile /home/content/23/6745723/html/stats/.statspwd
require valid-user
Options +Indexes

[beishe8]

Our web person ran the query and we are still locked out. Is there a plan "B"

Thank you

You can try a proxy such as http://anonymouse.org
Go to the ACP with it , delete the banned IPs, change the admin's password.

[etbliss]

You can try a proxy such as http://anonymouse.org
Go to the ACP with it , delete the banned IPs, change the admin's password.

I had tried that, and attempted again just now, and still locked out. Awfully frustrating. Anything else I can try?

Thank you...

Tom

[Mark.B]

What is the actual error message the admin gets when he tries to log in?

[LockedOnLaw]

You can use tools.php from the "Do Not Upload" folder to create a new admin account and unban any IP addresses banned from the AdminCP. You may have to use this tool via proxy in order to use an IP address which is not banned.

[etbliss]

What is the actual error message the admin gets when he tries to log in?

"Sorry. The administrator has banned your IP address. To contact the administrator click here"

http://www.architecturalphotographers.org/forum/login.php?do=login

[Mark.B]

I am getting that error too. This is not the login strikes system causing this...the site is behaving as if all IPs are banned.

Could be a number of causes. Please drop me a PM regarding this.

[Mark.B]

For the record, this is now fixed with some magic from tools.php.

[Loco.M]

You can use tools.php from the "Do Not Upload" folder to create a new admin account and unban any IP addresses banned from the AdminCP. You may have to use this tool via proxy in order to use an IP address which is not banned.

This is the best answer ^^

*edit* I see it worked too

[Mark.B]

This is the best answer ^^

*edit* I see it worked too

It did, but not quite the way described.

Creating a new admin account would have simply run into the same problem...the issue was that NOBODY could access the site, as all sessions were getting an IP banned message.