Re: [squid-users] log_db_daemon - Advice ?

2013-04-08 Thread Marcello Romani

Il 06/04/2013 10:01, Roland RoLaNd ha scritto:

Dear all,

I have squid 2.7 stable9 running in transparent mode.
i'd like to store all logs into a mysql database.

i've created the requested squid_log(access_log) with it's privileges as 
mentioned.
and added the following to my squid.conf:
access_log daemon:/SomePassword squid
according to what i've googled thus far, i need to add a log daemon directive 
that points to logfile-daemon_mysql.pl
though cannot find that script under these locations:

/etc/squid/*
/usr/local/*
nor under this 
ftp://mirror.aarnet.edu.au/pub/squid/squid/squid-2.7.STABLE9.tar.gz

advice on how to proceed, would be greatly appreciated

PS: i don't have a problem in upgrading to squid3 as this is a lab environment 
before switching to production.  



Amos' advice is obviously sound, but you could also have a look here:

http://sourceforge.net/projects/logmysqldaemon/

--
Marcello Romani


[squid-users] log_db_daemon - Advice ?

2013-04-06 Thread Roland RoLaNd
Dear all,

I have squid 2.7 stable9 running in transparent mode.
i'd like to store all logs into a mysql database.

i've created the requested squid_log(access_log) with it'sĀ privilegesĀ as 
mentioned.
and added the following to my squid.conf:
access_log daemon:/SomePassword squid
according to what i've googled thus far, i need to add a log daemon directive 
that points to logfile-daemon_mysql.pl
though cannot find that script under these locations:

/etc/squid/*
/usr/local/*
nor under this 
ftp://mirror.aarnet.edu.au/pub/squid/squid/squid-2.7.STABLE9.tar.gz

advice on how to proceed, would be greatly appreciated

PS: i don't have a problem in upgrading to squid3 as this is a lab environment 
before switching to production.

Re: [squid-users] log_db_daemon - Advice ?

2013-04-06 Thread Amos Jeffries

On 6/04/2013 9:01 p.m., Roland RoLaNd wrote:

Dear all,

I have squid 2.7 stable9 running in transparent mode.
i'd like to store all logs into a mysql database.

i've created the requested squid_log(access_log) with it's privileges as 
mentioned.
and added the following to my squid.conf:
access_log daemon:/SomePassword squid
according to what i've googled thus far, i need to add a log daemon directive 
that points to logfile-daemon_mysql.pl
though cannot find that script under these locations:

/etc/squid/*
/usr/local/*
nor under this 
ftp://mirror.aarnet.edu.au/pub/squid/squid/squid-2.7.STABLE9.tar.gz


It is not part of Squid-2. The DB daemon was only added in squid-3.3, 
and the usage difffers a bit.


That said, you can build the squid-3.3 sources and run the daemon helper 
it builds under 2.7 if you want to.



advice on how to proceed, would be greatly appreciated

PS: i don't have a problem in upgrading to squid3 as this is a lab environment 
before switching to production.  


It really is well past time to attempt that switch.


Amos