[SOLVED] custom squidguard blacklists

tripialos · 02-18-2014, 04:45 AM

Greetings

I am trying to create my own custom squidguard lists and so far i have no success. As far as i understood, you create the blacklists by using a text file, say urls, which contains all urls to block and by executing the command "squidGuard -C urls" you then create/convert the text file to a database file. Hence when completed you have two files:

urls and urls.db

My problem is that when i try to create my own lists, the db files are not created. For example, i downloaded a porn blacklist and when executed the command to convert the text file to a db it all went well.

I then created a text file called url with a single entry (microsoft.com), executed the command to make the db file but ..... no db file.

have checked permissions and seem to be ok.

here is also some terminal output

Code:

root@server:/var/lib/squidguard/db$ ll
total 68
drwxr-sr-x 17 proxy proxy 4096 Feb 18 14:17 ./
drwxr-xr-x  4 root  root  4096 May  9  2013 ../
drwxr-xr-x  2 proxy proxy 4096 May  9  2013 ads/
drwxr-xr-x  2 proxy proxy 4096 May  9  2013 aggressive/
drwxr-xr-x  2 proxy proxy 4096 May  9  2013 audio-video/
drwxr-sr-x  2 proxy proxy 4096 Feb 18 14:11 customlist/
drwxr-xr-x  2 proxy proxy 4096 May  9  2013 drugs/
drwxr-xr-x  2 proxy proxy 4096 May  9  2013 gambling/
drwxr-xr-x  2 proxy proxy 4096 Feb 18 14:14 hacking/
drwxr-xr-x  2 proxy proxy 4096 May  9  2013 mail/
drwxr-xr-x  2 proxy proxy 4096 Feb 18 14:12 porn/
drwxr-xr-x  2 proxy proxy 4096 Feb 18 14:19 proxy/
drwxr-xr-x  2 proxy proxy 4096 Feb 18 14:19 redirector/
drwxr-xr-x  2 proxy proxy 4096 Feb 18 14:19 spyware/
drwxr-xr-x  2 proxy proxy 4096 Feb 18 14:19 suspect/
drwxr-xr-x  2 proxy proxy 4096 Feb 18 14:19 violence/
drwxr-xr-x  2 proxy proxy 4096 Feb 18 14:23 warez/

root@server:/var/lib/squidguard/db$ ls warez/
domains  domains.db  urls  urls.db

root@server:/var/lib/squidguard/db$ ls customlist/
domains  urls

root@server:/var/lib/squidguard/db$ squidGuard -C customlist/urls 
root@server:/var/lib/squidguard/db$ squidGuard -C customlist/domains 

root@server:/var/lib/squidguard/db$ ls customlist/
domains  urls

root@server:/var/lib/squidguard/db$ ll customlist/
total 16
drwxr-sr-x  2 proxy proxy 4096 Feb 18 14:11 ./
drwxr-sr-x 17 proxy proxy 4096 Feb 18 14:17 ../
-rwxr-xr-x  1 proxy proxy   13 Feb 18 14:11 domains*
-rwxr-xr-x  1 proxy proxy   14 Feb 18 14:11 urls*

root@server:/var/lib/squidguard/db$

Also i noticed that despite the fact i specify which file to use in order to create a list, squidguard uses all available files under the db folder.

Quote:

2014-02-18 14:47:56 [13707] init domainlist /var/lib/squidguard/db/porn/domains
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/porn/domains.db
2014-02-18 14:47:56 [13707] init urllist /var/lib/squidguard/db/porn/urls
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/porn/urls.db
2014-02-18 14:47:56 [13707] init domainlist /var/lib/squidguard/db/ads/domains
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/ads/domains.db
2014-02-18 14:47:56 [13707] init urllist /var/lib/squidguard/db/ads/urls
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/ads/urls.db
2014-02-18 14:47:56 [13707] init domainlist /var/lib/squidguard/db/aggressive/domains
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/aggressive/domains.db
2014-02-18 14:47:56 [13707] init urllist /var/lib/squidguard/db/aggressive/urls
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/aggressive/urls.db
2014-02-18 14:47:56 [13707] init domainlist /var/lib/squidguard/db/drugs/domains
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/drugs/domains.db
2014-02-18 14:47:56 [13707] init urllist /var/lib/squidguard/db/drugs/urls
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/drugs/urls.db
2014-02-18 14:47:56 [13707] init domainlist /var/lib/squidguard/db/hacking/domains
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/hacking/domains.db
2014-02-18 14:47:56 [13707] init urllist /var/lib/squidguard/db/hacking/urls
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/hacking/urls.db
2014-02-18 14:47:56 [13707] init domainlist /var/lib/squidguard/db/proxy/domains
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/proxy/domains.db
2014-02-18 14:47:56 [13707] init urllist /var/lib/squidguard/db/proxy/urls
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/proxy/urls.db
2014-02-18 14:47:56 [13707] init domainlist /var/lib/squidguard/db/redirector/domains
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/redirector/domains.db
2014-02-18 14:47:56 [13707] init urllist /var/lib/squidguard/db/redirector/urls
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/redirector/urls.db
2014-02-18 14:47:56 [13707] init domainlist /var/lib/squidguard/db/spyware/domains
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/spyware/domains.db
2014-02-18 14:47:56 [13707] init urllist /var/lib/squidguard/db/spyware/urls
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/spyware/urls.db
2014-02-18 14:47:56 [13707] init domainlist /var/lib/squidguard/db/suspect/domains
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/suspect/domains.db
2014-02-18 14:47:56 [13707] init urllist /var/lib/squidguard/db/suspect/urls
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/suspect/urls.db
2014-02-18 14:47:56 [13707] init domainlist /var/lib/squidguard/db/violence/domains
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/violence/domains.db
2014-02-18 14:47:56 [13707] init urllist /var/lib/squidguard/db/violence/urls
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/violence/urls.db
2014-02-18 14:47:56 [13707] init domainlist /var/lib/squidguard/db/warez/domains
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/warez/domains.db
2014-02-18 14:47:56 [13707] init urllist /var/lib/squidguard/db/warez/urls
2014-02-18 14:47:56 [13707] loading dbfile /var/lib/squidguard/db/warez/urls.db
2014-02-18 14:47:56 [13707] destblock good missing active content, set inactive
2014-02-18 14:47:56 [13707] destblock local missing active content, set inactive
2014-02-18 14:47:56 [13707] squidGuard 1.2.0 started (1392720476.149)
2014-02-18 14:47:56 [13707] db update done
2014-02-18 14:47:56 [13707] squidGuard stopped (1392720476.156)

Any squidguard guru around that knows the trick?

thanks

tripialos · 02-18-2014, 05:37 AM

GOT IT!!!

from the documentation of squidguard:

Quote:

Only those files are converted you specified to block or whitelist in your squidGuard.conf file.

The reason why dbs files were not created was, as stated above, because i haven't actually "used" the list in my config files, hence, if have a list which is not used/declared on the config file the squidGuard command will not convert the list to .db file