How to cancel the client blocking

hello

How do you cancel the effect of client blocking?

my sync clients are blocked and I cannot see any setting to revert that.

Reading the source code of the app I see no way to revert a client block.

Nextcloud server 18.0.11 on raspian

So I had to RESTART the client application to reallow authorization. I guess this is a nextcloud client bug.

[nickvergessen]

its 30mins timeout. then it should work again

I was blocked since yesterday when I removed the offending files, so I think it's a client bug that forgets to repoll the server block status.

nice idea: the 30min delay should be documented in readme and app description :)

[MaxiMii05]

I had the same problem. Additional documentation would be appreciated.
For me, I had to not just restart the client but also the Nextcloud server container to get it working again.

[nickvergessen]

A restart of the server is definetly not needed.
I checked to code again, it's actually 60 mins blocking. The 30 mins is the cooldown from the last strike and only after 5 strikes the client is blocked completely.

[MaxiMii05]

A restart of the server is definetly not needed.

The restarting of the server might have coincidently lined up with the expiration of the 60 min timer.
Either way, further documentation or a method to manually unblock a client again would be appreciated.

[kachapman]

What happens if it is blocked completely? Has there been any work on a manually unblocking solution?

[bombaglad]

it says you can unblock in settings but there is no option anywhere in settings

[0x617374726F]

You can manually remove the entries in the database:
SELECT * FROM `oc_preferences` WHERE `appid` = 'ransomware_protection';

[PavanKeshav]

Hi, I was able to effectively cancel client blocking by setting up a trigger which overwrites the block.
login as root on your server
login to mysql server of nextcloud
example for ubuntu snap nextcloud installation:
nextcloud.mysql-client
then run sql scripts to create the trigger
use nextcloud;
delimiter //
CREATE trigger clear_blocks_on_clients BEFORE INSERT on oc_preferences FOR EACH ROW BEGIN SET NEW.configkey = 'last_strikes'; SET NEW.configvalue = '[]'; END;//
delimiter ;
commit;

there is no need to restart nextcloud server as its a sql trigger.