<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body 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@outoforder.cc"
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@lists.outoforder.cc">mod_log_sql-unsubscribe@lists.outoforder.cc</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@lists.outoforder.cc">mod_log_sql-unsubscribe@lists.outoforder.cc</a>
</pre>
</blockquote>
<br>
</body>
</html>