Page 1 of 1

apache log to mysql database

PostPosted: 21. December 2007 23:11
by Josh18657
I was wondering if there is a way to have apache save a log to a database table?

I have this set in my conf file but I would rather it be saved to a databse
Code: Select all
LogFormat "%h*%{%m}t*%{%d}t*%{%Y}t*%>s*%b" transfer
CustomLog logs/transfer_log transfer


I would split it up into pieces of course and have the pieces saved in different fields.

Josh

PostPosted: 23. December 2007 08:24
by skuipers
There is much information available on the internet, f.i. here

PostPosted: 23. December 2007 16:24
by Josh18657
skuipers wrote:There is much information available on the internet, f.i. here


mod_log_sql is what I was looking for but is it compiled with the xampp apache?
If so that's great :) but I didn't see it in the module list in the config file.

Thanks for the help
Josh

PostPosted: 25. December 2007 07:06
by skuipers
The module is not available in basic XAMPP. You will have to add it to the XAMPP/Apache set up.

See the mod_log_sql homepage for all relevant nformation on this module.

PostPosted: 29. December 2007 18:36
by Josh18657
skuipers wrote:The module is not available in basic XAMPP. You will have to add it to the XAMPP/Apache set up.

See the mod_log_sql homepage for all relevant nformation on this module.


think I need a little more help :(

I am using these instructions - http://www.outoforder.cc/projects/apach ... pter=/2/2/

downloaded and extracted - mod_log_sql v1.99

also downloaded and extracted the xampp dev package

run the following command - ./configure --with-apxs=/opt/lampp/bin/apxs --with-mysql=/opt/lampp/lib/mysql

and get the following error - configure: error: libmysqlclient is needed for MySQL support

any idea what I'm doing wrong :(

thanks in advance
Josh