Marcello Romani ha scritto:
Amos Jeffries ha scritto:
Marcello Romani wrote:
Amos Jeffries ha scritto:
Ressa wrote:
Hi,
I was wondering can I made the squid log their activities to the
database server (such as MySQL or something) and is there any tools
can provide information from those database.
Thanks
't would be a rarity. Especially as Squid does not natively support
database logging and the daemon is still a relatively new feature.
Amos
Hi,
I have developed a perl script that does just that.
I have tested it against squid 2.7.head a few months ago, but I think
it should work fine on any squid version with daemon: feature.
Can I send an attachment to the mailing list or is there a
better/preferred method for this kind of things ?
Depends on what you want done with it.
If you just want it to be publicly known, mentioning it everywhere
like here is a good start.
If you want it published somewhere like the wiki, I can do that for
you. Or you can get a wiki account setup and add it to the LogDaemon
page yourself.
If you want it included in the Squid sources Henrik and I have
different procedures based on the stability of our branches.
* For Squid-2 it needs to have a bugzilla as a feature request for
tracking purposes.
* For Squid-3 an attachment in email to squid-dev@... mailing list
for auditing is still sufficient to get it into 3.2 where daemon will be.
Amos
The script works fine for me, but has received little testing (I dont
run an ISP ;-) so I attach it here so anyone interested can try it. I'm
of course open to suggestions and improvements.
I've seen a page on the squid wiki were log analyzers are listed. It
seeems to me that page is open to contributions, so maybe my script
could be listed there too ? I ask this because the sql scripts that
create the schema also include a number of views that perform some
analysis on the log rows.
Hint to myself: look at the bottom of the page ;-)
--
Marcello Romani
Responsabile IT
Ottotecnica s.r.l.
http://www.ottotecnica.com
