Re: Request processing/logging according to HTTP GET/POST parameter (Apache Users)

On Wed, Jul 9, 2008 at 5:16 AM, Rich Schumacher <rich.schu@xxxxxxxxx> wrote:

Samir,

In regards to #2 and #3:
Yes, you could write your own module to accomplish this, but the flexibility you're seeking is already possible. Using Apache's piped logs feature you can pipe the log data to a custom written script via STDIN. This script can then do whatever you want with this information and make decisions based on the request.

Here are a bunch of links that contain some good information.

Piped logs information:
http://httpd.apache.org/docs/2.2/logs.html#piped

Tutorial using Perl:
http://www.sudleyplace.com/pipederrorlogs.html

mod_log_config variables:
http://httpd.apache.org/docs/2.0/mod/mod_log_config.html#formats

Please note that you can use whatever language you want in your script, as long as it can accept input from STDIN.

Hope that clears it up.

Cheers,

Rich

On Mon, Jul 7, 2008 at 8:52 PM, Samir Ghodasara <ghodasarasamir@xxxxxxxxx> wrote:

Hey Rich,

1) I found mod_log_mysql help from http://bitbrook.de/software/mod_log_mysql/

but what i want to read request parameter and log according to that before serving response file as i don't want to store all the request data in mysql.

2) what do you mean by "you can always create your own custom logging script and direct Apache to use that.".you mean to say i have write module like apache mod_log_mysql.
Please give me some more detail.

3) Is their any way to invoke shell script/CGI script/Perl script as request listener and script will have access to request parameter/Header/URL.

Thanks & Regards,
Samir.

On Mon, Jul 7, 2008 at 10:27 PM, Rich Schumacher <rich.schu@xxxxxxxxx> wrote:

Hey Samir,

Have you looked into mod_log_sql or mod_log_mysql? I don't know the specifics, but they look like they might accomplish what you need. If not, you can always create your own custom logging script and direct Apache to use that.

Cheers,

Rich

On Sun, Jul 6, 2008 at 10:22 PM, Samir Ghodasara <ghodasarasamir@xxxxxxxxx> wrote:

Hi,

i have setup apache (httpd-2.2.4 on suse linux 10.0) for static content.but i want request logs in database according to HTTP GET/POST request parameter.

EX..htttp://localhost/video.html?msisdn=123&id=11

and i want to capture above request logs in to database with request URL,time,date and request parameter.

one way i found to filter access_log on daily basic and dump in to database.

is their any other better and which will go very nearer to live data ?

Please help ..

Regards,
Samir.