Hi All

I have been trying to find a way to write Apache Log data to a MySql db
via a pipe log directive.

So far I have this:

LogFormat "%v:*:%B:*:%u:*:%f:*:%h:*:%a:*:%s:*:%{%Y-%m-%d
%H:%M:%S%z}t:*:%{Content-type:}o:*:%U:*:%{Referer}i:*:%{User-Agent}i:*:%
{cookie}n" mysqllog

As my Logformat directive. It is delimited by ":*:".

Now the log part I am having problems with.

CustomLog "|/usr/local/bin/php phplog.php" mysqllog

I was thinking that I should write in the phplog.php all the connection
stuff and load Logformat data in to it but I don’t know where or how to
get the data. I don’t want to write the log file then read it in as that
defeats the object I am looking to do.

I don’t want to use mod_sql thing as I am not allowed to compile new
modules.

So I think I am asking what do I put into this:

$loaddata = mysql_query("insert into table .......")

To load the data from LogFormat.

If you can advise or help with this I will be most thank full.

Dave C
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.463 / Virus Database: 262 - Release Date: 17/03/2003
 


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to