Re: [squid-users] squid/squidGuard/MySQL Problem

I forgot to add here.

When I restart/reload squid, all the MySQL queries in squidGuard fire as
squid is restarting/reloading, and all the 'debugging' files get written
to. Then when I have any browser activity, squidGuard operates
correctly and blocks sites in the blacklists, but none of the MySQL
queries fire ever again (ditto with 'debugging' files).

Murrah Boswell

OTR Comm wrote:
>
> Hello,
>
> I am running squid-3.0-PRE3-20030924 and have squidGuard-1.2 as my
> redirector. I have hacked squidGuard to support MySQL queries. When I
> run squidGuard in test mode from the command line, I can query MySQL
> with no problems, and I can write to a 'debugging' file while I am
> testing my code development.
>
> My problem is that when I call this hacked version of squidGuard from
> squid, none of the MySQL queries work and none of my 'debugging' files
> are being written to. This is only when squid makes the call to
> squidGuard.
>
> squid, squidGuard, and my apache server all run as nobody in this test
> environment. All squid and squidGuard files are owned by nobody.root,
> and both owner and group have rwx permissions on files and directories.
>
> I can 'su nobody' and run squidGuard from the command line, and the
> MySQL queries work okay and the 'debugging' files get written to.
>
> I asked this questions at the squidGuard list, but didn't get any help.
> I really believe it is a squid problem, so I am asking the question
> here.
>
> This issue is holding me up in my code development, so if anyone knows
> what night be going on here, please let me know.
>
> Also, if there are ways to put squid in a 'stepper debugging mode,' I
> would appreciate help in how to do this. I would like to watch squid
> call squidGuard, and then step into squidGuard and step through the code
> as it executes. Is this possible? Is this something that I can compile
> in at build time?
>
> Thanks,
> Murrah Boswell
Received on Thu Oct 09 2003 - 10:21:26 MDT