You could write one yourself, as squid supports a 'logfile' daemon,
or try mysar. It reads the squid logfile and import all content into a
mysql database.
get it at mysar.sf.net
and the fast C code version at www.polaco.pro.br/mysar
Wundy wrote:
Hi!
I currently have a transparent squid in place that used squidguard as a
blocking filter.
squid version is 2.6 STABLE.
I would like to import the access.log into a database for safe keeping and
easy access with queries.
a request from the company I do the internschip with.
I have read various pieces that Squid3.0 would support this but I can't find
any solid info on it.
is it still in development ? and if so is it stable enough to try it ?
My other option would be to write a perl script that reads access.log and
imports it into the database.
I have a question with this. is it possible to read the access.log and
afterwards clear the file so that I can just read the entire file everytime
I sync the database ? how would squid react to this clearing ?
also Squid rotates the logfiles. I currently have logfile rotate set to 0 so
It wouldn't rotate then ? but everything gets logged to access.log.1 . Can I
still change this ?
