Apache2, Logging to MySQL Request for Insight :)

Darryl Clarke smartssa at gmail.com
Sat Apr 8 01:57:25 UTC 2006


I've recently setup Apache2 to log to mysql using a pipe, and it
appears to work ok.

Basically what I've done is made a LogFormat with an insert statement,
and then a CustomLog "|/usr/bin/mysql -h [server] [dbname]"

It works well, and appears to not lose log records when mysql is
stopped (i don't plan on it being stopped but I checked anyways)

My concern is with behaviour and caveats. Before I carry on and take
it all the way, I'd like to know if anybody has any insight on any
issues that may arise using this type of method.

~ Darryl  ~ smartssa at gmail.com
~ http://darrylclarke.com

More information about the ubuntu-users mailing list