Re: [squid-users] Common log file format conversion??

On 29/04/11 16:03, michel_at_casa.co.cu wrote:
> Hi List
>
> I recently installed Mysar utility for generating reports from Squid
> logs, but the script does importer.php only import files in native
> format logs into the database.
>
> I modified the configuration of my squid to generate logs in native
> mode, since even here there are no problems, statistics generated Mysar
> me perfectly.
>
> Where is the problem?

You already said the answer to that:
   "the script does importer.php only import files in native format logs"

>
> Well, but I have several logs in common format, which would convert to
> import into my database.
>
> There is a program or script that allows to convert several common log
> files in native format?

Maybe, but unlikely. Apache "common" format is missing many fields that
are present in the native "squid" format. Conversion is usually the
other way around, forcing squid logs into a format the apache log
analyzers can handle.

>
> and that in turn allows to import the logs converted to mysql??

Squid-3.2 bundles with a DB logging daemon, log_db_daemon. Also
available from sourceforge under the name log_mysql_daemon.

That depends on your mysql database accepting squid native log format
though. It provides many useful DB views, but is still a little rough
around the edges on the graphing and display areas (ie none exist publicly).

Amos

-- 
Please be using
   Current Stable Squid 2.7.STABLE9 or 3.1.12
   Beta testers wanted for 3.2.0.7 and 3.1.12.1