On 29/04/11 16:03, michel@xxxxxxxxxx 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
