Rossz wrote:
> >
> Yep, did that.  However, I found the problem.
> 
> I dug a bit more and found a message that mentioned that despite the 
> claims, it does NOT work with db 2.7.?.  I tried to upgrade to a more 
> recent version but I get compile errors when I try to build squidGuard.  
> I'd post the error message but I've already locked down my other system 
> and am leaving for the night.  Somethig about incorrect number of 
> parameters.

Here's my install checklist (for Red Hat) for db 3.2.9:

- - - - - db-3.2.9 install checklist - - - - -
<Download db-3.2.9.tar.gz from this page:>
http://www.sleepycat.com/download/patchlogsdb.shtml
<Copy db-3.2.9.tar.gz to /usr/local/src>
'tar zxvf db-3.2.9.tar.gz'
<Download the two patches for 3.2.9 from this page:>
http://www.sleepycat.com/download/patchlogsdb.shtml
<Copy patch.3.2.9.1 to /usr/local/src/db-3.2.9>
<Copy patch.3.2.9.2 to /usr/local/src/db-3.2.9>
'cd db-3.2.9'
<'pwd' should show /usr/local/src/db-3.2.9>
'patch -p0 < patch.3.2.9.1'
'patch -p0 < patch.3.2.9.2'
'cd build_unix'
'../dist/configure'
'make'
'make install'
'cd ../..'
'echo /usr/local/BerkeleyDB.3.2/lib >> /etc/ld.so.conf'
'ldconfig'
<Copy squidGuard-1.2.0.tar.gz to /usr/local/src>
'tar zxvf squidGuard-1.2.0.tar.gz'
'cd squidGuard-1.2.0'
'./configure --with-db=/usr/local/BerkeleyDB.3.2'
'make'
'make install'

NOTE:
The .db files created with BerkeleyDB cannot be used with
BerkeleyDB 3. If you are using the prebuilt .db files,
rm *.db and do a squidGuard -d -C all
- - - - - - end of checklist - - - - - - - - -

> I'm using the textfile lists for the moment.  Which is perfectly ok 
> for our small whitelist system, but eventually I will be requiring 
> all systems use the proxy and implement a blacklist for them.

Here's something that might make you a little more comfortable about
running text files in the interim... Whether you are using text files
or pre-built db files, squidGuard stores all of the domains and urls 
in in-memory-only B-trees at startup.  Obviously the pre-built db
files load much faster than building new ones.  But once squidGuard
is up and accepting transactions there is no speed difference 
between a system started with text files and one started with db 
files.  I'm not trying to minimize the benefit of the db files, just
wanted you to know specifically where the performance hit appears.

Rick



Reply via email to