Can apache log into a mySQL table?

Can apache log into a mySQL table on the local server?

Thank you very much, Bizzk

You can pipe that to a script and have your script insert the data into MySQL. In the real world, nobody is fool enough to do this to replace your existing logging mechanism. What you probably should do is to post process your logs via a cronjob.

Is this done before? Are there any scripts I can use or do I have to code it myself? When you say "post process" do you mean an update every 15 minutes or something?

>> When you say "post process" do you mean an update every 15 minutes or something?

Not exactly. I mean, do not change the Apache logging mechanism using a pipe | and pipe to a script. Why? Not reliable and slow and insecure. Post process it is to insert your rotated logs to a database, not as a logging replacement with your script. The rotated logs are the one sApache not currently write to, thus can be removed or inserted to a database or whatever.

You mean I should rotate my logs, and then use a script to insert the rotated logs into mySQL?

In the apache manual I found the following utitlity: rotatelogs.
They say that that utility also uses the pipe feature. Do you recommend using this utility to rotate my logs?

Once the logs are being rotated how can I insert them into mySQL? I have never done anything like that before. I suppose I have to get some kind of script or program and that changes the format to an *.sql file and run a cronjob to insert it every hour?

Thanks, Bizzk

>> Do you recommend using this utility to rotate my logs?

rotatelog has an advantage for rotating your Apache log without restarting your server. What I've been saying was to suggest you not to log to a database in realtime. If you must insert your log to mysql, post process it to a mysql-acceptable-format with your script, then run a cronjob to actually inserting the data to mysql.

I think I understand what you mean, thanks. I think I will use some log analysing tool for the log stats, instead of writing my own mySQL/php tool. Those log utilties are actually quite smart!