Hi all,
recently i realize that i have a dream: collectign all the web logs
of my 4 web servers to a single db, in real time, to let th eusers make
analisys on it.THe bad thign was the necessity to have a db capable of do
not slowly down the apache.I found a little contrib opn th epgsql dir (:))
and i adapt it to mysql.Ok now it is working like a charm, i continue to do
log in a file locally on each web server, but send , and made also buffer,
to the db that reside on a single machine.Everything works good for a
day,,b ut the next day i found error , of broken pipe.TH eproblem is that
when th eapache do not send anything , the mysql connection to the db is
broken and at the first insert, the pipe is broken.
How do adjsut this?? i do not think it is an apach eproblme because th efiel
log works good like always, th eonly broken pipe is the connectio beetwen
the client to the server mysql.
Here are th escript i use on the httpd.conf:
LogFormat "insert into access values ( '%h', '%l', '%u', '%t' , '%r', '%{Referer}i',
%T, %s, %b );"
TransferLog '| su -c "sed \"s/, - );$/, -1 );/\" |/usr/local/mysql/bin/mysql -h
mysql.db.intranet -u nobody"'
...and of course if the web is always active it works good...
Thanks
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
