[Mod_log_sql] need to remove forward slash from request_uri

jeffs jeffs at speakeasy.net
Mon Feb 16 19:43:53 EST 2009


Pardon my stupidity -- I see that the select statement can be used 
effectively in getting the data out from the mysql logs.  My intention 
was to filter out the forward slash prior to it being written to the logs.

Still having a problem, though, getting mysql_log to log subsequent hits 
on the same file request.

If anyone has an idea on why this might be happening I would appreciate 
a holler.

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/b7870bc2/attachment.html 


More information about the Mod_log_sql mailing list