Re: [squid-users] problem with logging to mysql

On 15/05/2012 5:12 p.m., Jan Malaník wrote:
> 2012/5/15 Amos Jeffries<squid3_at_treenet.co.nz>:
>> On 15/05/2012 1:56 a.m., Jan Malaník wrote:
>>> Good day,
>>> I have a problem with logging to mysql. I tried this configuration:
>>> logformat squid %tl;%>a;%>A;%ru;%un;%Ss
>>> access_log daemon:/127.0.0.1/report/surf/squid/squid squid
>>> logfile_daemon /usr/local/sbin/log_mysql_daemon.pl
>>>
>>> But it wrote during start:
>>> /etc/init.d/squid3 start
>>>
>>> Starting Squid HTTP Proxy 3.x: squid3Creating Squid HTTP Proxy 3.x
>>> cache structure ... (warning).
>>> 2012/05/14 15:16:58| cache_cf.cc(363) parseOneConfigFile:
>>> squid.conf:2309 unrecognized: 'logfile_daemon'
>>> 2012/05/14 15:16:58| cache_cf.cc(363) parseOneConfigFile:
>>> squid.conf:2309 unrecognized: 'logfile_daemon'
>>> Why this happen?
>>>
>>> Then I found log_db_daemon directive, but I don't know howto configure it.
>>>
>>> Please can someone help me?
>>
>> You need squid 2.7 or 3.2+ to use logfile_daemon.
>>
>> It looks like you are running a packaged Squid from Debian or a derivative.
>> Which would be 3.1 series Squid, not 3.2 yet.
>>
>> Amos
> Yes I use debian stable. You want to say in other version then 2.7 or
> 3.2there isn't logfile_daemon directive?

Yes.

> Please can you explain me howto use
> log_db_daemon(http://www1.it.squid-cache.org/Versions/v3/3.HEAD/manuals/log_db_daemon)?
> It's possible to use it?

Only in a version which supports logfile_daemon.

For older versions you can apparently use squidtaild to send the log
elsewhere. I've not used it myself though so YMMV.

Amos
Received on Tue May 15 2012 - 09:12:19 MDT