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

2003-07-20 Thread Henrik Nordstrom
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/, [EMAIL PROTECTED]


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

2003-07-20 Thread Schelstraete Bart
Chris Wilcox wrote:

Morning all,

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?


Chris,

There was a project for this, but as far as I know that project doesn't 
exist anymore.
And on the other side..If you will write every access to a 
database,  I think this wo'nt be very good for the performance.

rgrds,

 Bart

--
Is that a radio in your pocket, or are you just happy to hear us? C-dance!


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

2003-07-20 Thread Chris Wilcox
Morning all,

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?

Thanks for any replies,

nry

_
Stay in touch with absent friends - get MSN Messenger 
http://www.msn.co.uk/messenger