Re: need to remove forward slash from request_uri
Edward Rudd <[email protected]> Mon, 16 Feb 2009 20:11:48 -0500
| Newsgroups | gmane.comp.apache.mod-log-sql |
|---|---|
| Message-ID | <[email protected]> |
--===============0274551746==
Content-Type: multipart/alternative; boundary=Apple-Mail-769-975354969
--Apple-Mail-769-975354969
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit
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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
>>>
>> _______________________________________________
>> 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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
>>
>>
>>
>
> _______________________________________________
> 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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
--Apple-Mail-769-975354969
Content-Type: text/html;
charset=US-ASCII
Content-Transfer-Encoding: 7bit
<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Can you post your mod_log_sql config?? (apache config lines)<div><br><div><div>On Feb 16, 2009, at 7:43 PM, jeffs wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"> <div bgcolor="#ffffff" text="#000000"> 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.<br> <br> Still having a problem, though, getting mysql_log to log subsequent hits on the same file request.<br> <br> If anyone has an idea on why this might be happening I would appreciate a holler.<br> <br> Edward Rudd wrote: <blockquote cite="
mid:D72B6692-F0F4-4A3B-98E0-EDB60C61AE03-l4c2hbCm6dz5FsjnhOxw3g@public.gmane.org" type="cite"> <pre wrap="">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:
</pre> <blockquote type="cite"> <pre wrap="">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 <a class="moz-txt-link-freetext" href="http://www.outoforder.cc/projects/apache/mod_log_sql/">http://www.outoforder.cc/projects/apache/mod_log_sql/</a>
To unsubscribe send an e-mail to
<a class="moz-txt-link-abbreviated" href="mailto:mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org">mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org</a>
</pre> </blockquote> <pre wrap=""><!---->_______________________________________________
Download the latest version at <a class="moz-txt-link-freetext" href="http://www.outoforder.cc/projects/apache/mod_log_sql/">http://www.outoforder.cc/projects/apache/mod_log_sql/</a>
To unsubscribe send an e-mail to
<a class="moz-txt-link-abbreviated" href="mailto:mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org">mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org</a>
</pre> </blockquote> <br> </div> _______________________________________________<br>Download the latest version at <a href="http://www.outoforder.cc/projects/apache/mod_log_sql/">http://www.outoforder.cc/projects/apache/mod_log_sql/</a><br><br>To unsubscribe send an e-mail to <br><a href="mailto:mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org">mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org</a><br></blockquote></div><br></div></body></html>
--Apple-Mail-769-975354969--
--===============0274551746==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
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-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
--===============0274551746==--