[Mod_log_sql] need to remove forward slash from request_uri

[Edward Rudd]

Can you post your mod_log_sql config?? (apache config lines)

On Feb 16, 2009, at 7:43 PM, jeffs wrote:

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