Re: authenticate_program bombs out

Mike Everest wrote:

> from my reading, the redirect_program (which is the next part of my equation
> ;-) works on a similar principle. that makes squid just the easiest thing
> to work with.

It does.

> but all good things have their down-ers: i want to log to a sql database
> :( as far as i can tell, it will mean touching the source - bummer.

On the todo list I think.. but in the mean time you can "work around" it
outside Squid. There are at least two approaches on how to do this
without modifying code:

a) Use a "log-tail daemon" that reads Squid's log file and forwards the
entries to a SQL server, combined with semi-frequent log rotation to
keep the on-disk size down.

b) Logging to a pipe where another daemon listens, completely avoiding
touching disk.

The "log-tail" approach has the big benefit that Squid does not care if
the log daemon is bogged down and cannot keep up with the request rate.
It simply continues to log to the log file, from where the SQL logger
then tries to catch up when time permits.

--
Henrik Nordstrom
Squid hacker