<!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">
Thanks you for your assistance. I replaced the table and all is good
now. I think it must have gotten corrupted or something somehow.<br>
<br>
Anyway, there is no way to filter out the content of the request_uri
before it is written to database, I presume.<br>
<br>
Thanks<br>
<br>
Edward Rudd wrote:
<blockquote
cite="mid:634E6A65-40D7-4710-8441-CF4DBB506447@outoforder.cc"
type="cite">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@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 moz-do-not-send="true"
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 moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true" 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>
</div>
_______________________________________________<br>
Download the latest version at <a moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:mod_log_sql-unsubscribe@lists.outoforder.cc">mod_log_sql-unsubscribe@lists.outoforder.cc</a><br>
</blockquote>
</div>
<br>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
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>