How can i unblock an IP (blocked through brute force detection)?

[lukas]

Somehow, i managed to be blocked on my nextcloud instance (nc 11 beta). Seems like i’ve made too much failing login attempts through thunderbird.
No my connection is throttled. How can i unban my IP? Is there a time-limit on the ban?

[Schmu]

Hi,

connect to mysql and run the following query for your IP:
DELETE FROM oc_bruteforce_attempts WHERE ip = 'aaa.bbb.ccc.ddd';

[lukas]

Works again! Thank you!

[BenBold]

I have no experience with SQL - is it possible to administrate this in the admin section?

[lukas]

@BenBold hey, i can assist you. It’s not possible to do this within an admin session.
How do you host your instance? Have you access to the database?

[BenBold]

well - its running on our web server preinstalled by the webhoster - very nice so far.
but just one account is blocked now.

i have ssh access to the server.

[lukas]

Is the database running on the same server you have access to?
Then you could start the mysql-console with something like: mysql --user=user_name --password db_name).

[Calmly]

Alternatively, you could just add the IP address in Admin --> Security --> Brute-force IP whitelist

HTH

[BenBold]

Thank You Calmly !!
That was solving a lot of problems but i still get the following message for the calendar:

Warning core Login failed: ‘UserName’ (Remote IP: xxxxxx)

[Wikinaut]

Run (as root)

To show entries:
mysql -e "use nextcloud;select * from oc_bruteforce_attempts;"

To delete all these entries:
mysql -e "use nextcloud;delete from oc_bruteforce_attempts;"

[TheRojam]

You can also use the occ client:
$ php occ security:bruteforce:reset <ip-adresse>

If you have an reverse proxy runnig you may want to add some special things to your nextcloud config.php:

 'trusted_proxies' => array('192.168.1.1'),
 'forwarded_for_headers' => array('HTTP_X_FORWARDED_FOR'),

While 192.168.1.1 is the local IP address of your reverse proxy.

[Pascacio]

Hi, it seems that option was removed in the actual version , 24.0.4.

[Pascacio]

Hi, I’m running Nextcloud on Hestia, from these commands I get " Unknown database ‘nextcloud’"
Also tried with "sudo -u www-data php /var/www/nextcloud/occ security:bruteforce:reset but it seems the wrong directory. Does anyone know the right path for Hestia CP installation?
thank you!

[Brecht_W]

This helped me.
After a year i received this issue and i think it was because of this:
‘forwarded_for_headers’ => array(‘HTTP_X_FORWARDED_FOR’)

Thank you