Nextcloud version: 20.0.6
Operating system and version: Unraid 6.8.3
The issue you are facing:
I had problems logging into an account on a phone, which triggered my IP Address being added to my own server’s brute force table, which means every single time I login from my IP, it’s always throttled by 30 seconds.
Whitelisting in the Brute Force Settings does not work. The only time it does work is if I put a 0 after the slash notation for my WAN IP, which is effectively the same as disabling Brute Force security altogether.
I am running my Nextcloud Server on Unraid using MariaDB. I found an old thread about this exact problem, and tried the solution, writing:
MariaDB [mydatabase]> DELETE FROM oc_bruteforce_attempts WHERE ip = 'my.wan.ip.address';
But got:
Query OK, 0 rows affected (0.001 sec)
Which means it obviously did not work.
Seeing as the Brute Force Settings are not working, how do I clear my Brute Force table in my database?
Is this the first time you’ve seen this error? (Y/N): Yes
Steps to replicate it:
- Have Brute Force settings turned on.
- Keep entering the incorrect password several times until the IP gets marked and throttled.
- You are now unable to log in on this IP without waiting 30 seconds.