Kamele0N 12 Posted August 28, 2021 Share 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 post Share on other sites
0 Kamele0N 12 Posted August 28, 2021 Author Share 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 post Share on other sites
0 Orphée 216 Posted August 28, 2021 Share Posted August 28, 2021 Step 6 isn't necessary. It Just list table content. Quote Link to post Share on other sites
0 nexuscan 1 Posted August 30, 2021 Share Posted August 30, 2021 hello friend, thank you so much for that solution! stay safe! 1 Quote Link to post Share on other sites
0 Kamele0N 12 Posted December 4, 2021 Author Share 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 post Share on other sites
0 Stephanie Sy 1 Posted January 3 Share Posted January 3 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 post Share on other sites
Question
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.
Link to post
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.