How to recover Admin host locked out, IP band, Admin account active [#3308634]

Problem/Motivation

Hello and thank you for any leads...
I (Admin user 1) can't log into website. error message:
"This host is not allowed to log in to In Low Gear 4x4 בהילוך נמוך . Please contact your site administrator.
The IP address 2.55.180.120 is banned at In Low Gear 4x4 בהילוך נמוך , and will not be able to access any of its content from now on. Please contact the site administrator."

Steps to reproduce

Actions taken:
1. Cleared band IP from table blocked_ips
2. Cleared relevant IP from flood table
3. Cleared all cache tables.
4. Set user 1 status to "1" in users table
5. Delete relevant entries from table login_security in database. Credit to poker10!!!

Issue closed

Proposed resolution

1. May it have to do with login tracking?
2. Should / can I delete relevant IP log ins?
3. Looks like "The IP address 2.55.180.120 is banned at In Low Gear 4x4 בהילוך נמוך , and will not be able to access any of its content from now on. Please contact the site administrator." originates from Login security module. (Thank you Poker10)

Thank you for any lead...

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet

Comments

Comment #1

8 September 2022 at 14:49

Michael G created an issue. See original summary.

Comment #2

poker10 commented 8 September 2022 at 15:20

It seems like that this error message is triggered by Login Security module, so you need to also clear some variables used by this module.

https://git.drupalcode.org/project/login_security/-/blob/7.x-1.x/login_security.module#L159

Comment #3

Michael G commented 8 September 2022 at 16:45

poker10, thank you. I do have Login Security installed but
don't know if it is causing the IP block, why and how to "neutralize" the module with no site damage...

Comment #4

Michael G commented 8 September 2022 at 16:57

Issue summary:

View changes

Comment #5

poker10 commented 8 September 2022 at 18:55

I have not worked with this module, but according to the source code try opening the login_security_track database table and clear the relevant IPs from that table. That should help. This is how that variable is fetched:

'@ip_current_count' => db_select('login_security_track', 'lst')
    ->fields('lst', array('id'))
    ->condition('host', $ipaddress)
    ->countQuery()
    ->execute()
    ->fetchField(),

Comment #6

Michael G commented 8 September 2022 at 19:53

Bingo Poker10 !!!
You'r suggestion to delete relevant entries in table login_security was 100% right.

Thank you very much!!!
Next time you are in Israel, call me and you will get 50% off one of my private adventure day tours.
site: www.inlowgear.co.il

Thank you again!!!

Issue closed.

Comment #7

Michael G commented 8 September 2022 at 19:55