Re: [squid-users] Get Squid to log to MySql database?

From: Henrik Nordstrom <hno@dont-contact.us>
Date: Sun, 20 Jul 2003 21:39:41 +0200

On Sunday 20 July 2003 12.53, Chris Wilcox wrote:

> After a fair amount of searching I'm none-the-wiser on this one.
> Is there any way (easy preferred but not essential!) I can get
> Squid to log directly to a MySql database or do I need to regularly
> run a script via cron to put the squid logfile into MySql?

The easiest way is to run a small login monitoring daemon, monitoring
the log file and dumping it into mysql while Squid writes the log.
Much easier and more efficient than messing around with a cron job.

The File::Tail perl module is an excellent basis of such monitoring
daemon.

-- 
Donations welcome if you consider my Free Squid support helpful.
https://www.paypal.com/xclick/business=hno%40squid-cache.org
If you need commercial Squid support or cost effective Squid or
firewall appliances please refer to MARA Systems AB, Sweden
http://www.marasystems.com/, info@marasystems.com
Received on Sun Jul 20 2003 - 13:40:33 MDT

This archive was generated by hypermail pre-2.1.9 : Tue Dec 09 2003 - 17:18:12 MST