Kamele0N Posted August 28, 2021 Share #1 Posted August 28, 2021 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. Quote Link to comment Share on other sites More sharing options...
0 Kamele0N Posted August 28, 2021 Author Share #2 Posted August 28, 2021 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 3 Quote Link to comment Share on other sites More sharing options...
0 Orphée Posted August 28, 2021 Share #3 Posted August 28, 2021 Step 6 isn't necessary. It Just list table content. Quote Link to comment Share on other sites More sharing options...
0 nexuscan Posted August 30, 2021 Share #4 Posted August 30, 2021 hello friend, thank you so much for that solution! stay safe! 1 Quote Link to comment Share on other sites More sharing options...
0 Kamele0N Posted December 4, 2021 Author Share #5 Posted December 4, 2021 (edited) Does anybody understand why I cant acess /etc/synoautoblock.db under ROOT account? I added 2 pictures..... Edited December 4, 2021 by Kamele0N Quote Link to comment Share on other sites More sharing options...
0 Stephanie Sy Posted January 3, 2022 Share #6 Posted January 3, 2022 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. 1 Quote Link to comment Share on other sites More sharing options...
Question
Kamele0N
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.
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.