Convert apache HTTP combined logs into SQL (and import it into a mysql database eventually)
source: snippets.dzone.com
you need to extract the data in your http server log files and put it in a database to query it with your usual tools using SQL. this perl script does just this.
it was hard to find it, that’s why i put it here.
#!/usr/bin/perl -w # Written by Aaron Jenson. # Original source: http://www.visualprose.com/software.php # Updated to work under Perl 5.6.1 by Edward Rudd # Updated 24 march 2007 by Slim Amamou <slim.amamou@alpha-studios.com> # - output SQL with the option '--sql' # - added SQL create table script to the HELP # # NOTE : you need the TimeDate library (http://search.cpan.org/dist/TimeDate/) # Lire la suite...