[Mod_log_sql] need to remove forward slash from request_uri

[jeffs]

Thanks for the help.

I know about the substring function but I'm at a loss as to where to put 
this string...

I cannot find any suitable interface within which to plug it in...  the 
mod_log_sql program writes directly to the mysql database so where do I 
insert this code?

Is there a filter function in phpmyadmin that I cannot find?

Sorry for my newbie question but I'm confounded here.

Another issue I'm having is that although if I tail -f 
/var/log/apache2/other_vhosts_access.log I can see the requests coming 
in for requests for the same file, but mod_log_mysql is only logging the 
first occurrence of the log, not subsequent hits and I need all hits to 
be logged even if the request is for the same file.

As I stated in my previous post, the scenario is very simple.  All file 
requests are always going to look like this:

098sdafmasf90q89234rjqwe.jpg

with the string before the .jpg being the only thing that changes.

I've setup the sites-available to only log this:

LogSQLRequestAccept .jpg

which indeed is working, but only the first request shows up, not subsequent hits although tailing other_vhosts_access.log indeed shows the subsequent hits coming in.

Thanks for your assistance.







Edward Rudd wrote:
> The simplest is to use SQL to remove the first character from the  
> field when selecting
>
> SELECT SUBSTRING(request_uri,2) as request_uri FROM myloggingtable
>
>
> On Feb 16, 2009, at 4:25 PM, jeffs wrote:
>
>   
>> I have mysql logging working perfectly.  I only need to either:
>>
>> a) use some mysql command to remove the forward slash from uri that is
>> being input into the uri_request field, or
>>
>> b) stop the forward slash from being recorded in the mysql database in
>> the first place.
>>
>> Either way, I need to not have the forward slash get recorded into the
>> request_uri field.  In this particular logging scenario I am using,
>> uri's will always look like:
>>
>> /098sdafmasf90q89234rjqwe.jpg
>>
>> as recorded by log_mysql.
>>
>> I need it to look like:
>>
>> 098sdafmasf90q89234rjqwe.jpg
>>
>> is there a way to do this?
>>
>> Thank you very much
>> _______________________________________________
>> Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/
>>
>> To unsubscribe send an e-mail to
>> mod_log_sql-unsubscribe at lists.outoforder.cc
>>     
>
> _______________________________________________
> Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/
>
> To unsubscribe send an e-mail to 
> mod_log_sql-unsubscribe at lists.outoforder.cc
>
>
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20090216/fff66f01/attachment.html