Hi, I encounter a very strange problem while trying to update my databases. My problem is very similar to the one described here: http://marc.theaimsgroup.com/?l=squidguard&m=102008640828326&w=2
I tried to contact Morris MAYNARD and asked him if he solved that
problem and he replied he didn't.
So, here is how the blacklists directory looks like:
.
|-- ads
| |-- domains
| |-- domains.db
| |-- urls
| `-- urls.db
|-- aggressive
| |-- domains
| |-- domains.db
| |-- urls
| `-- urls.db
|-- audio-video
| |-- domains
| |-- domains.db
| |-- urls
| `-- urls.db
|-- drugs
| |-- domains
| |-- domains.db
| |-- urls
| `-- urls.db
|-- gambling
| |-- domains
| |-- domains.db
| |-- urls
| `-- urls.db
|-- hacking
| |-- domains
| |-- domains.db
| |-- urls
| `-- urls.db
|-- mail
| |-- domains
| `-- domains.db
|-- porn
| |-- domains
| |-- domains.db
| |-- expressions
| |-- urls
| `-- urls.db
|-- proxy
| |-- domains
| |-- domains.db
| |-- urls
| `-- urls.db
|-- violence
| |-- domains
| |-- domains.db
| |-- expressions
| |-- urls
| `-- urls.db
`-- warez
|-- domains
|-- domains.db
|-- urls
`-- urls.db
OK, now I download the latest blacklists tarball and copy the files in
the good places, so I got:
# find -name \*.diff
./ads/domains.diff
./ads/urls.diff
./aggressive/domains.diff
./aggressive/urls.diff
./audio-video/domains.diff
./audio-video/urls.diff
./drugs/domains.diff
./drugs/urls.diff
./gambling/domains.diff
./hacking/domains.diff
./hacking/urls.diff
./proxy/domains.diff
./warez/domains.diff
Let's update the databases now:
# /usr/sbin/squidGuard -d -u
2002-06-10 15:47:25 [6268] init domainlist /var/squidGuard/ads/domains
2002-06-10 15:47:25 [6268] loading dbfile /var/squidGuard/ads/domains.db
2002-06-10 15:47:25 [6268] update dbfile /var/squidGuard/ads/domains.db
2002-06-10 15:47:25 [6268] update: added 8185 entries, deleted 51 entries
2002-06-10 15:47:25 [6268] init urllist /var/squidGuard/ads/urls
2002-06-10 15:47:25 [6268] loading dbfile /var/squidGuard/ads/urls.db
2002-06-10 15:47:25 [6268] update dbfile /var/squidGuard/ads/urls.db
2002-06-10 15:47:25 [6268] update: added 2 entries, deleted 2 entries
2002-06-10 15:47:25 [6268] init domainlist /var/squidGuard/aggressive/domains
2002-06-10 15:47:25 [6268] loading dbfile /var/squidGuard/aggressive/domains.db
2002-06-10 15:47:25 [6268] update dbfile /var/squidGuard/aggressive/domains.db
2002-06-10 15:47:25 [6268] update: added 8 entries, deleted 3 entries
2002-06-10 15:47:25 [6268] init urllist /var/squidGuard/aggressive/urls
2002-06-10 15:47:25 [6268] loading dbfile /var/squidGuard/aggressive/urls.db
2002-06-10 15:47:25 [6268] update dbfile /var/squidGuard/aggressive/urls.db
2002-06-10 15:47:25 [6268] /var/squidGuard/aggressive/urls.diff`%: No such file or
directory
2002-06-10 15:47:25 [6268] going into emergency mode
<Need to press Ctrl-C to stop squidGuard>
As you can see, the filename "/var/squidGuard/aggressive/urls.diff`%"
can't be found. Note the "`%" at the end of the file ?!!
Let's continue:
# rm -f /var/squidGuard/aggressive/urls.diff
# /usr/sbin/squidGuard -d -u
2002-06-10 15:49:43 [6270] init domainlist /var/squidGuard/ads/domains
2002-06-10 15:49:43 [6270] loading dbfile /var/squidGuard/ads/domains.db
2002-06-10 15:49:43 [6270] update dbfile /var/squidGuard/ads/domains.db
2002-06-10 15:49:43 [6270] update: added 8185 entries, deleted 51 entries
[...]
2002-06-10 15:49:43 [6270] init domainlist /var/squidGuard/hacking/domains
2002-06-10 15:49:43 [6270] loading dbfile /var/squidGuard/hacking/domains.db
2002-06-10 15:49:43 [6270] update dbfile /var/squidGuard/hacking/domains.db
2002-06-10 15:49:43 [6270] /var/squidGuard/hacking/domains.diff`$: No such file or
directory
2002-06-10 15:49:43 [6270] going into emergency mode
<Ctrl-C>
Same problem with the file "/var/squidGuard/hacking/domains.diff`$"...
# rm -f /var/squidGuard/hacking/domains.diff
# /usr/sbin/squidGuard -d -u
[...]
002-06-10 15:51:50 [6272] squidGuard 1.2.0 started (1023717110.078)
2002-06-10 15:51:50 [6272] db update done
Now, after having deleted the two files everything seems to be OK... But
these two databases were not updated :(
=======================================================================
I tried something different
1) I've edited my squidGuard.conf and replace those entries:
dest aggressive {
domainlist aggressive/domains
# urllist aggressive/urls
urllist aggressive/testurls
}
dest hacking {
# domainlist hacking/domains
domainlist hacking/testdomains
urllist hacking/urls
}
2) I've just copied the 2 files listed above to another name:
# cp aggressive/urls aggressive/testurls
# cp hacking/domains hacking/testdomains
3) I've Created the *.db file
# /usr/sbin/squidGuard -d -C all
[...]
2002-06-10 15:59:19 [6280] init urllist /var/squidGuard/aggressive/testurls
2002-06-10 15:59:19 [6280] create new dbfile /var/squidGuard/aggressive/testurls.db
[...]
2002-06-10 15:59:20 [6280] init domainlist /var/squidGuard/hacking/testdomains
2002-06-10 15:59:20 [6280] create new dbfile /var/squidGuard/hacking/testdomains.db
[...]
2002-06-10 15:59:22 [6280] squidGuard 1.2.0 started (1023717559.881)
2002-06-10 15:59:22 [6280] db update done
As you can see, everything seems to be good. Now, I copy the diff files
and I rename 'aggressive/urls.diff' to 'aggressive/testurls.diff' and
'hacking/domains.diff' to 'hacking/testdomains.diff':
# mv aggressive/urls.diff aggressive/testurls.diff
# mv hacking/domains.diff hacking/testdomains.diff
And now...:
# /usr/sbin/squidGuard -d -u
[...]
2002-06-10 16:05:20 [6418] init urllist /var/squidGuard/aggressive/testurls
2002-06-10 16:05:20 [6418] loading dbfile /var/squidGuard/aggressive/testurls.db
2002-06-10 16:05:20 [6418] update dbfile /var/squidGuard/aggressive/testurls.db
2002-06-10 16:05:20 [6418] update: added 6 entries, deleted 1 entries
[...]
2002-06-10 16:05:20 [6418] init domainlist /var/squidGuard/hacking/testdomains
2002-06-10 16:05:20 [6418] loading dbfile /var/squidGuard/hacking/testdomains.db
2002-06-10 16:05:20 [6418] update dbfile /var/squidGuard/hacking/testdomains.db
2002-06-10 16:05:20 [6418] update: added 23 entries, deleted 4 entries
[...]
2002-06-10 16:05:20 [6418] squidGuard 1.2.0 started (1023717920.201)
2002-06-10 16:05:20 [6418] db update done
Voila.
If I just rename the files, it now works without any problems... I don't
really understand why, if I don't rename the files, this problem occurs.
I hope someone will find a fix for that problem (which really looks like
a bug).
Don't hesitate to tell me if you need more infos...
Kind regards,
Gilles.
PS: I forgot, here is the list of the program used:
- RedHat Linux v7.3
- squidGuard v1.2.0
- Berkeley DB v3.3.11
--
/ Gilles CHAUVIN / CRDP de Haute-Normandie /
/ E-mail: [EMAIL PROTECTED] / GnuPG: 0x2E89DBB7 /
msg00932/pgp00000.pgp
Description: PGP signature
