Proxy blacklist doesn't work

[Faust (Roman)]

Hello
I have the same problem how to solve it?
2020-12-04 10:44:21 [5176] ufdbCategory gamble
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/gamble/domains”
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] FATAL ERROR: sgDbInit: cannot read from “/var/squidGuard/blacklists/gamble/domains.ufdb” (read-only): No such file or directory *****
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] ERROR: URL database table “/var/squidGuard/blacklists/gamble/domains” is empty and is ignored *****
2020-12-04 10:44:21 [5176] ufdbCategory chemistry
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/science/chemistry/domains”
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] FATAL ERROR: sgDbInit: cannot read from “/var/squidGuard/blacklists/science/chemistry/domains.ufdb” (read-only): No such file or directory *****
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] ERROR: URL database table “/var/squidGuard/blacklists/science/chemistry/domains” is empty and is ignored *****
2020-12-04 10:44:21 [5176] ufdbCategory files
2020-12-04 10:44:21 [5176] ufdbCategoryExpressionList /var/squidGuard/blacklists/custom/files/expressions
2020-12-04 10:44:21 [5176] loading regular expressions from “/var/squidGuard/blacklists/custom/files/expressions”
2020-12-04 10:44:21 [5176] ufdbCategory pets
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/hobby/pets/domains”
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] FATAL ERROR: sgDbInit: cannot read from “/var/squidGuard/blacklists/hobby/pets/domains.ufdb” (read-only): No such file or directory *****
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] ERROR: URL database table “/var/squidGuard/blacklists/hobby/pets/domains” is empty and is ignored *****
2020-12-04 10:44:21 [5176] ufdbCategory bikes
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/automobile/bikes/domains”
2020-12-04 10:44:21 [5176] ufdbCategory aggressive
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/aggressive/domains”
2020-12-04 10:44:21 [5176] ufdbCategory radiotv
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/radiotv/domains”
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] FATAL ERROR: sgDbInit: cannot read from “/var/squidGuard/blacklists/radiotv/domains.ufdb” (read-only): No such file or directory *****
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] ERROR: URL database table “/var/squidGuard/blacklists/radiotv/domains” is empty and is ignored *****
2020-12-04 10:44:21 [5176] ufdbCategory violence
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/violence/domains”
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] FATAL ERROR: sgDbInit: cannot read from “/var/squidGuard/blacklists/violence/domains.ufdb” (read-only): No such file or directory *****
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] ERROR: URL database table “/var/squidGuard/blacklists/violence/domains” is empty and is ignored *****
2020-12-04 10:44:21 [5176] ufdbCategory cars
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/automobile/cars/domains”
2020-12-04 10:44:21 [5176] ufdbCategory travel
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/recreation/travel/domains”
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] FATAL ERROR: sgDbInit: cannot read from “/var/squidGuard/blacklists/recreation/travel/domains.ufdb” (read-only): No such file or directory *****
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] ERROR: URL database table “/var/squidGuard/blacklists/recreation/travel/domains” is empty and is ignored *****
2020-12-04 10:44:21 [5176] ufdbCategory martialarts
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/recreation/martialarts/domains”
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] FATAL ERROR: sgDbInit: cannot read from “/var/squidGuard/blacklists/recreation/martialarts/domains.ufdb” (read-only): No such file or directory *****
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] ERROR: URL database table “/var/squidGuard/blacklists/recreation/martialarts/domains” is empty and is ignored *****
2020-12-04 10:44:21 [5176] ufdbCategory webradio
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/webradio/domains”
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] FATAL ERROR: sgDbInit: cannot read from “/var/squidGuard/blacklists/webradio/domains.ufdb” (read-only): No such file or directory *****
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] ERROR: URL database table “/var/squidGuard/blacklists/webradio/domains” is empty and is ignored *****
2020-12-04 10:44:21 [5176] ufdbCategory wellness
2020-12-04 10:44:21 [5176] loading URL table from “/var/squidGuard/blacklists/recreation/wellness/domains”
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] FATAL ERROR: sgDbInit: cannot read from “/var/squidGuard/blacklists/recreation/wellness/domains.ufdb” (read-only): No such file or directory *****
2020-12-04 10:44:21 [5176]
2020-12-04 10:44:21 [5176] ERROR: URL database table “/var/squidGuard/blacklists/recreation/wellness/domains” is empty and is ignored *****

[m.traeumner (Michael Träumner)]

Hi and welcome to the community.
Your problem looks like you haven’t synced your ufdbguard with a list and your blacklist aren’t created. Please let us know what you have done till now? Also it would be good to which blacklist you use.

[Faust (Roman)]

I am using Shalla Lists. I added a new category and my web filter stopped working, all categories got unlimited access to the Internet. Yesterday I updated Netshserver to the latest version and updated ufbdguarg to the latest version but that didn’t help. Shalla files are there and they are updated on a schedule.

[m.traeumner (Michael Träumner)]

@Faust

FATAL ERROR: sgDbInit: cannot read from “/var/squidGuard/blacklists/recreation/wellness/domains.ufdb” (read-only): No such file or directory *****

We have to look if the folders and files exists and have the right owner and permissions. Please do it with the terminal.
To compare, here is mine. (I have the university list, so there are other categories.

[root@groupware ~]# cd /var/squidGuard/blacklists/
[root@groupware blacklists]# ls -al
total 192
drwxr-xr-x  66 squid squid  4096 Dec  4 08:54 .
drwxr-xr-x.  4 root  root     46 Dec  4 08:47 ..
lrwxrwxrwx   1 squid squid     9 May 11  2005 ads -> publicite
drwxr-xr-x   2 squid squid   140 Dec  4 08:54 adult
lrwxrwxrwx   1 squid squid     8 May 11  2005 aggressive -> agressif
drwxr-xr-x   2 squid squid    85 Dec  4 08:54 agressif
drwxr-xr-x   2 squid squid    54 Dec  4 08:54 arjel
drwxr-xr-x   2 squid squid    54 Dec  4 08:54 associations_religieuses
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 astrology
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 audio-video
drwxr-xr-x   2 squid squid    54 Dec  4 08:54 bank
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 bitcoin
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 blog
drwxr-xr-x   2 ufdb  squid     6 Dec  4 08:54 cache.execlists
-rw-r--r--   1 squid squid 78194 Apr 17  2014 cc-by-sa-4-0.pdf
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 celebrity
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 chat
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 child
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 cleaning
drwxr-xr-x   2 squid squid    54 Dec  4 08:54 cooking
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 cryptojacking
drwxr-xr-x   5 squid squid    53 Dec  4 08:54 custom
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 dangerous_material
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 dating
drwxr-xr-x   2 squid squid    54 Dec  4 08:54 ddos
drwxr-xr-x   2 squid squid    54 Dec  4 08:54 dialer
drwxr-xr-x   2 squid squid    54 Dec  4 08:54 doh
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 download
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 drogue
lrwxrwxrwx   1 squid squid     6 May 11  2005 drugs -> drogue
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 educational_games
drwxr-xr-x   2 squid squid    41 Dec  4 08:54 exceptions_liste_bu
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 filehosting
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 financial
drwxr-xr-x   2 squid squid    85 Dec  4 08:54 forums
drwxr-xr-x   2 squid squid    79 Dec  4 08:54 gambling
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 games
-rw-r--r--   1 squid squid 26953 Oct 15  2019 global_usage
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 hacking
drwxr-xr-x   2 squid squid    54 Dec  4 08:54 jobsearch
-rw-r--r--   1 squid squid 78194 Apr 17  2014 LICENSE.pdf
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 lingerie
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 liste_blanche
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 liste_bu
lrwxrwxrwx   1 squid squid     6 May 11  2005 mail -> forums
drwxr-xr-x   2 squid squid    85 Dec  4 08:54 malware
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 manga
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 marketingware
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 mixed_adult
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 mobile-phone
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 phishing
lrwxrwxrwx   1 squid squid     5 May 11  2005 porn -> adult
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 press
lrwxrwxrwx   1 squid squid    10 May 11  2005 proxy -> redirector
drwxr-xr-x   2 squid squid    85 Dec  4 08:54 publicite
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 radio
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 reaffected
drwxr-xr-x   2 squid squid    85 Dec  4 08:54 redirector
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 remote-control
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 sect
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 sexual_education
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 shopping
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 shortener
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 social_networks
drwxr-xr-x   2 squid squid    85 Dec  4 08:54 special
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 sports
drwxr-xr-x   2 squid squid    54 Dec  4 08:54 stalkerware
drwxr-xr-x   2 squid squid    85 Dec  4 08:54 strict_redirector
drwxr-xr-x   2 squid squid   106 Dec  4 08:54 strong_redirector
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 translation
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 tricheur
drwxr-xr-x   2 squid squid    54 Dec  4 08:54 update
lrwxrwxrwx   1 squid squid     8 May 11  2005 violence -> agressif
drwxr-xr-x   2 squid squid    41 Dec  4 08:54 vpn
drwxr-xr-x   2 squid squid    85 Dec  4 08:54 warez
drwxr-xr-x   2 squid squid    66 Dec  4 08:54 webmail

[root@groupware blacklists]# cd webmail
[root@groupware webmail]# ls -al
total 24
drwxr-xr-x  2 squid squid   66 Dec  4 08:54 .
drwxr-xr-x 66 squid squid 4096 Dec  4 08:54 ..
-rw-r--r--  1 squid squid 5755 Nov 29 07:10 domains
-rw-r--r--  1 squid squid 2303 Dec  4 08:54 domains.ufdb
-rw-r--r--  1 squid squid  238 Nov 29 07:10 urls
-rw-r--r--  1 squid squid   12 Jan  9  2013 usage

[Faust (Roman)]

[root@netshserver blacklists]# ls -al
total 60
drwxr-xr-x 59 squid squid 4096 Dec 4 12:40 .
drwxrwxr-x. 4 root root 46 Dec 4 11:55 …
drwxr-xr-x 2 squid squid 53 Dec 4 12:17 adv
drwxr-xr-x 2 squid squid 53 Dec 4 12:17 aggressive
drwxr-xr-x 2 squid squid 53 Dec 4 12:17 alcohol
drwxr-xr-x 2 squid squid 53 Dec 4 12:17 anonvpn
drwxr-xr-x 6 squid squid 58 May 16 2016 automobile
drwxrwx— 2 ufdb squid 4096 Dec 4 12:47 cache.execlists
drwxr-xr-x 2 squid squid 53 Dec 4 12:17 chat
-rw-r----- 1 squid squid 803 Mar 9 2008 COPYRIGHT
drwxr-xr-x 2 squid squid 53 Dec 4 12:17 costtraps
drwxr-xr-x 10 squid squid 157 Dec 4 11:55 custom
drwxr-xr-x 2 squid squid 33 Oct 5 03:32 dating
drwxr-xr-x 2 squid squid 33 Jul 24 02:10 downloads
drwxr-xr-x 2 squid squid 33 Nov 27 20:40 drugs
drwxr-xr-x 2 squid squid 33 Jul 13 03:59 dynamic
drwxr-xr-x 3 squid squid 21 Jun 12 2016 education
drwxr-xr-x 8 squid squid 104 Jul 27 05:23 finance
drwxr-xr-x 2 squid squid 33 Jul 18 05:21 fortunetelling
drwxr-xr-x 2 squid squid 33 Aug 17 04:07 forum
drwxr-xr-x 2 squid squid 33 Nov 17 19:50 gamble
-rw-r–r-- 1 squid squid 47413 Aug 6 2015 global_usage
drwxr-xr-x 2 squid squid 33 May 1 2016 government
drwxr-xr-x 2 squid squid 33 May 15 2016 hacking
drwxr-xr-x 7 squid squid 88 Jul 27 05:46 hobby
drwxr-xr-x 2 squid squid 33 Jan 24 2016 homestyle
drwxr-xr-x 2 squid squid 33 Jul 19 02:16 hospitals
drwxr-xr-x 2 squid squid 33 May 15 2016 imagehosting
drwxr-xr-x 2 squid squid 33 Jul 28 23:49 isp
drwxr-xr-x 2 squid squid 33 Jul 18 05:45 jobsearch
drwxr-xr-x 2 squid squid 33 Apr 3 2016 library
drwxr-xr-x 2 squid squid 33 Jul 18 05:24 military
drwxr-xr-x 2 squid squid 33 Sep 21 00:57 models
drwxr-xr-x 2 squid squid 33 Oct 5 03:45 movies
drwxr-xr-x 2 squid squid 33 Jul 19 23:23 music
drwxr-xr-x 2 squid squid 33 Aug 21 16:02 news
drwxr-xr-x 2 squid squid 33 Apr 3 2016 podcasts
drwxr-xr-x 2 squid squid 33 Jul 23 01:11 politics
drwxr-xr-x 2 squid squid 33 Nov 24 01:05 porn
drwxr-xr-x 2 squid squid 33 Jul 23 01:16 radiotv
drwxr-xr-x 8 squid squid 101 Mar 2 2020 recreation
drwxr-xr-x 2 squid squid 33 Jul 19 06:18 redirector
drwxr-xr-x 2 squid squid 33 Jul 23 01:21 religion
drwxr-xr-x 2 squid squid 33 Jan 6 2016 remotecontrol
drwxr-xr-x 2 squid squid 33 Jul 13 19:27 ringtones
drwxr-xr-x 4 squid squid 40 Feb 4 2013 science
drwxr-xr-x 2 squid squid 33 Oct 6 19:14 searchengines
drwxr-xr-x 4 squid squid 39 Jul 12 23:53 sex
drwxr-xr-x 2 squid squid 33 Nov 27 20:39 shopping
drwxr-xr-x 2 squid squid 33 Oct 5 03:08 socialnet
drwxr-xr-x 2 squid squid 33 Nov 27 20:42 spyware
drwxr-xr-x 2 squid squid 33 Nov 30 18:56 tracker
drwxr-xr-x 2 squid squid 33 Mar 28 2016 updatesites
drwxr-xr-x 2 squid squid 33 Nov 27 17:25 urlshortener
drwxr-xr-x 2 squid squid 33 Dec 29 2015 violence
drwxr-xr-x 2 squid squid 33 Jul 18 20:58 warez
drwxr-xr-x 2 squid squid 33 May 22 2016 weapons
drwxr-xr-x 2 squid squid 33 Oct 16 15:39 webmail
drwxr-xr-x 2 squid squid 33 Jul 6 2015 webphone
drwxr-xr-x 2 squid squid 33 Jun 12 2016 webradio
drwxr-xr-x 2 squid squid 33 Jul 13 04:10 webtv

drwxr-xr-x 2 squid squid 33 Oct 16 15:39 .
drwxr-xr-x 59 squid squid 4096 Dec 4 12:40 …
-rw-r----- 1 squid squid 57189 Oct 16 15:39 domains
-rw-r----- 1 squid squid 6873 Jun 12 2016 urls

[m.traeumner (Michael Träumner)]

Could you please try to build the db files manually. This should be the command:

/usr/sbin/ufdbConvertDB -d blacklists

[m.traeumner (Michael Träumner)]

@Faust
Did it work to rebuild the db file?

[Faust (Roman)]

Hi.
Yes, thanks worked. The error was in the category with spaces in the name, I had to remove it. But why there were no database files.

[m.traeumner (Michael Träumner)]

@Faust

But why there were no database files.

Do you have them now?

[Faust (Roman)]

Yes, after rebuild and they updated

[m.traeumner (Michael Träumner)]

I’m happy to hear, that it completly works now.

@Faust

But why there were no database files.

I think it couldn’t be build because of the “wrong name”. Next time they should be build automatically.

Could you mark this topic as solved please:

Howto mark a topic as solved

Now we have an amazing feature on our community platform which helps to mark a topic as SOLVED As the OP (topic creator) you will have a button that allows you to accept an answer [image] Accepted answers are highlighted in the topic list: [image] Accepted answers are highlighted on the initial topic: [image] This kind of action is enabled only for topic into the Support category Happy support!