Noe the access.log is delimited with " " , can anyone know how to make
is delimited with "," , that easy import to database format

Thanks

[ Post a follow-up to this message ]

We are not having any supported configuration to achieve it,

But we can do this as,

 tr -s ' ' ',' access.log > access_db.log

 It will change ' ' to , there so that you can use it for database logging t
here.

 proxy# tail -2 access.log
1097612518.590    298 10.1.4.10 TCP_MISS/200 2911 GET http://www.google.com/
 - DIRECT/66.102.7.104 text/html
1097612565.970    192 10.1.4.10 TCP_MISS/200 2911 GET http://www.google.com/
 - DIRECT/66.102.7.104 text/html
proxy# tail -2 access.log | tr -s ' ' ','
1097612518.590,298,10.1.4.10,TCP_MISS/200,2911,GET,http://www.google.com/,-,DIRECT

1097612565.970,192,10.1.4.10,TCP_MISS/200,2911,GET,http://www.google.com/,-,DIRECT


 HTH.

REgards,
Muthukumar.

+++++++++++++++++++++++++++++
Visolve Squid Support Team.
URL: http://squid.visolve.com/squid/index.htm
Mail: support@visolve.com
++++++++++++++++++++++++++++++

[ Post a follow-up to this message ]