[Mod_log_sql] need to remove forward slash from request_uri
jeffs
jeffs at speakeasy.net
Mon Feb 16 21:54:53 EST 2009
Thanks you for your assistance. I replaced the table and all is good
now. I think it must have gotten corrupted or something somehow.
Anyway, there is no way to filter out the content of the request_uri
before it is written to database, I presume.
Thanks
Edward Rudd wrote:
> 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
>> <mailto: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/1b8f28d3/attachment-0001.html
More information about the Mod_log_sql
mailing list