Hi, Thanks you very much.
I found script from below URL for piped logs and modified according to my requirement. http://www.gossamer-threads.com/lists/apache/users/204847?search_string=mod_log_mysql;#204847 Regards, Samir. On Wed, Jul 9, 2008 at 5:16 AM, Rich Schumacher <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> >> 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 < >>> [EMAIL PROTECTED]> 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. >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>> >> >