Re: [squid-users] Squid Logging

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