[squid-users] Collecting squid logs to DB

[Amos Jeffries]

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.

Amos