Re: can apache log to MySQL ?

["Chad A. Adlawan" <chadi@myphilippines.com>]

> 
> another way to do it is to write a small perl (or whatever) program
> which reads apache log entries on stdin and injects them into a database
> - should be less than 20 lines of perl using DBI.
> 

   but the problem is, i cant code in PERL :-(

   any good souls out there who have the free time to write that 20 lines of code ?  :-)

cheers,
chad

PS.  i recently found out that you can actually use mysql itself to read a datafile and inject it to some table.  that can be done by:

LOAD DATA INFILE '/var/log/apache/access.log' INTO TABLE table_name
FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY '"';

since apache logs "date/time" (%t in apaches LogFormat) inside an "[" and an "]", i replaced all "[]"'s w/ an '"' ...  everything seemed to have worked very well and very smoothly until i found out that some User-Agent logs contains something like ""Mozilla/4.6 "en" (Win95; I)"" ...  the "en" thingy confused that MySQL directive :-( ...  any inputs anyone ???

thanks again.