Kevin Coyner writes: > > I've followed this thread with interest, and so this morning decided > to give the time quotas a try. My squid and squidGuard set-up has > been clicking along nicely for many months since I set it up, so I > thought it would be a simple matter of making a couple edits to my > squidGuard.conf. > > Unfortunately, it didn't work out that way. <portions snipped>
> Any thoughts on why I can't even get to first base on this one? > > Using Debian Sid, and squidGuard -v gives: > SquidGuard: 1.2.0 Sleepycat Software: Berkeley DB 4.1.25: > (December 19, 2002) Kevin, you may have solved the case of the broken userquotas! Looking at your squidGuard -v: you are running DB 4.1x. I've got to believe that you are running squidGuard from the text files, right? (meaning that you have not run the squidGuard -C command to pre-build the .db files) Here's a quick recap of what we have figured out so far about squidGuard and db versions: The squidGuard installation instructions were not updated after squidGuard 1.2.0 was released. The installation instructions say you must use a 2.x version of DB. The readme file in the squidGuard tarball says it is compatible with db versions 2.7.7 and 3.2x. We've found that to be true if you are running squidGuard from the text files. If, however, you wish to create the .db files, you find that the 2.7.7 version does not work, and the 3.2x version does work. There was a post from the author in October 2002 stating that he had added support for Db 4.1 into squidGuard 1..2.1: http://marc.theaimsgroup.com/?l=squidguard&m=103477692125832&w=2 (He also said it was many times slower than previous versions.) So jumping back to the userquota issue that is on the table... Here's my squidGuard -v: SquidGuard: 1.2.0 Sleepycat Software: Berkeley DB 3.2.9: (January 24, 2001). It may be that userquotas requires DB support that is version 3.2x-specific. Andi Hari: What output do you get from 'squidGuard -v'? Anyone else have userquotas working? What version of DB are you running? Rick > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Kevin Coyner > Sent: Sunday, March 23, 2003 8:16 PM > To: [EMAIL PROTECTED] > Subject: Re: help me please.. > > > > > On Sat, Mar 22, 2003 at 04:56:42PM -0600, Rick Matthews wrote...... > > > Andi Hari writes: > > > > > > Hi, my squidguard looks not working. > > > > > > Below are my squid.conf,squidguard.conf > > > > > --- squid.conf listing clipped ----- > > > > I've made a few recommended changes to your squidGuard.conf below. > > If your squidGuard has been working properly (excluding userquota), > > then userquota should work for you using the squidGuard.conf below. > > Hi > > I've followed this thread with interest, and so this morning decided to > give the time quotas a try. My squid and squidGuard set-up has been > clicking along nicely for many months since I set it up, so I thought it > would be a simple matter of making a couple edits to my squidGuard.conf. > > Unfortunately, it didn't work out that way. I added the line > > userquota 300 60 daily > > to a src section > > and restarted squid, only to find that squidGuard wouldn't load. It > gave the following error msgs: > > 2003-03-23 21:09:50 [30823] syntax error in configfile > /etc/squid/squidGuard.conf line 63 > > Of course, line 63 is the userquota line. I've appended my > squidGuard.conf to the bottom of this post. > > Any thoughts on why I can't even get to first base on this one? > > Using Debian Sid, and squidGuard -v gives: > SquidGuard: 1.2.0 Sleepycat Software: Berkeley DB 4.1.25: (December 19, > 2002) > > Thanks, Kevin > > ----------------- > squidGuard.conf > > # CONFIG FILE FOR SQUIDGUARD > # > > dbhome /var/lib/squidguard/db > logdir /var/log/squid > > # > # TIME RULES: > # abbrev for weekdays: > # s = sun, m = mon, t =tue, w = wed, h = thu, f = fri, a = sat > > time workhours { > weekly mtwhf 08:00 - 16:30 > date *-*-01 08:00 - 16:30 > } > > time studytime { > weekly mtwh 15:00 - 19:00 > } > > > time ryanfuntime { > weekly * 00:00 - 15:00 > weekly * 19:00 - 24:00 > weekly friday 00:00 - 24:00 > weekly saturday 00:00 - 24:00 > weekly sunday 00:00 - 24:00 > } > > > time wakeuptime { > weekly mtwhf 06:00 - 07:30 > } > > > # > # SOURCE ADDRESSES: > # > > src ryan { > ip 10.10.10.153 > } > > src alison { > ip 10.10.10.154 > } > > src hawkwood { > ip 10.10.10.152-10.10.10.250 > # userquota 300 60 daily > } > > src adult { > ip 10.10.10.12-10.10.10.151 > } > > > > > # > # DESTINATION CLASSES: > # > > dest porn { > domainlist blacklists/porn/domains > urllist blacklists/porn/urls > redirect > http://127.0.0.1/cgi-bin/squidGuard.cgi?clientaddr=%a&clientname=%n&clientident=%i&srcclass=%s&targetclass=%t&url=%u > log blocked.log > } > > dest local { > domainlist local/domains > } > > # > # ACCESS CONTROL LISTS > # > > acl { > ryan within ryanfuntime { > pass !porn any > } else { > pass local none > } > > > alison within wakeuptime { > pass local none > } else { > pass !porn any > } > > hawkwood { > pass !porn any > } > > adult { > pass any > } > > > default { > pass none > redirect > http://127.0.0.1/cgi-bin/squidGuard.cgi?clientaddr=%a&clientname=%n&clientident=%i&srcclass=%s&targetclass=%t&url=%u > } > } > > ## end of squidGuard.conf > >
