apache log to mysql database

Problems with the Linux version of XAMPP, questions, comments, and anything related.

apache log to mysql database

Postby Josh18657 » 21. December 2007 23:11

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
Josh18657
 
Posts: 3
Joined: 21. December 2007 22:58

Postby skuipers » 23. December 2007 08:24

There is much information available on the internet, f.i. here
skuipers
 
Posts: 99
Joined: 21. January 2005 16:27
Location: The Netherlands

Postby Josh18657 » 23. December 2007 16:24

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
Josh18657
 
Posts: 3
Joined: 21. December 2007 22:58

Postby skuipers » 25. December 2007 07:06

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.
skuipers
 
Posts: 99
Joined: 21. January 2005 16:27
Location: The Netherlands

Postby Josh18657 » 29. December 2007 18:36

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
Josh18657
 
Posts: 3
Joined: 21. December 2007 22:58


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 3 guests