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.AmosHi, 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.
-- Marcello Romani Responsabile IT Ottotecnica s.r.l. http://www.ottotecnica.com
Attachment:
squid-mysql-log-0.4.tar.gz
Description: application/gzip
