Allowed/blocked ip list

[Kamele0N 12]

I have mistakenly imported some 46.000+ ips under a wrong tab (allowed ip list instead of under blocked ip list)..... 

 

And now there is no option in synology to delete all 46.000+ ips under a one go! 

 

Is there any chance to do that under a, SSH connection? 

 

Identical problem like here (to clarify my problem) : https://community.synology.com/enu/forum/1/post/127297?page=1&sort=oldest

 

Tnx in advance. 

[Kamele0N 12]

Status update....manage to delete that list via SSH from a turitorial on internet and additional help of my IT friend... 

 

1) connect via SSH on your NAS 

2) login as root! (otherwise wont work)..... Sudo -i

3)  cd /etc

4) sqlite3 synoautoblock.db

5) header on

6) select * from AutoBlockIP;

7) delete from AutoBlockIP;  (it deletes BOTH allowed and blocked list) 

8.) quit

 

restart your NAS

 

Thats all folks

[Orphée 216]

Step 6 isn't necessary. It Just list table content.

[nexuscan 1]

hello friend,

 

thank you so much for that solution!

 

stay safe!

[Kamele0N 12]

Does anybody understand why I cant acess  /etc/synoautoblock.db under ROOT account?

I added 2 pictures.....

 

Edited December 4, 2021 by Kamele0N

[Stephanie Sy 1]

On 8/28/2021 at 3:46 PM, Kamele0N said:

Status update....manage to delete that list via SSH from a turitorial on internet and additional help of my IT friend... 

 

1) connect via SSH on your NAS 

2) login as root! (otherwise wont work)..... Sudo -i

3)  cd /etc

4) sqlite3 synoautoblock.db

5) header on

6) select * from AutoBlockIP;

7) delete from AutoBlockIP;  (it deletes BOTH allowed and blocked list) 

8.) quit

 

restart your NAS

 

Thats all folks

 

Thanks for this, it helps.