[squid-users] Collecting squid logs to DB

[Amos Jeffries]

On 05/05/18 17:19, Amos Jeffries wrote:
> On 05/05/18 10:20, Alex K wrote:
>> Hi all,
>>
>> I had a previous setup on Debian 7 with squid and I was using mysar to
>> collect squid logs and store them to DB and provide some browsing report
>> at the end of the day.
>> Now at Debian 9, trying to upgrade the whole setup, I see that mysar
>> does not compile.
>>
>> Checking around I found mysar-ng but this has compilation issues on
>> Debian 9 also.
>> Do you suggest any tool that does this job? Does squid support logging
>> to DB natively? (I am using mysql/mariadb)
>>
> 
> Squid-3 comes with log_db_daemon helper which stores to any SQL database
> in realtime. You still need something else to do the analysis of that data.
>  <http://www.squid-cache.org/Versions/v3/3.5/manuals/log_db_daemon.html>
> 
> 
>> Some other tool I stumbled on is https://github.com/paranormal/blooper.
> 
> Blooper is a fork of the logmysqldaemon (aka log_db_daemon) re-written
> in ruby instead of native C/C++ code.

Sorry, that should have been Ruby instead of Perl.

Amos