From mboxrd@z Thu Jan  1 00:00:00 1970
X-Msuck: nntp://news.gmane.io/gmane.comp.sysutils.supervision.general/584
Path: main.gmane.org!not-for-mail
From: rolphin@grosgay.com
Newsgroups: gmane.comp.sysutils.supervision.general
Subject: Logging everything in the database
Date: Thu, 23 Sep 2004 10:47:49 +0200
Message-ID: <1095929269.41528db5a0c17@mail.games-expert.com>
NNTP-Posting-Host: deer.gmane.org
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: sea.gmane.org 1095929324 2703 80.91.229.6 (23 Sep 2004 08:48:44 GMT)
X-Complaints-To: usenet@sea.gmane.org
NNTP-Posting-Date: Thu, 23 Sep 2004 08:48:44 +0000 (UTC)
Original-X-From: supervision-return-823-gcsg-supervision=m.gmane.org@list.skarnet.org Thu Sep 23 10:48:28 2004
Return-path: <supervision-return-823-gcsg-supervision=m.gmane.org@list.skarnet.org>
Original-Received: from antah.skarnet.org ([212.85.147.14] ident=qmailr)
	by deer.gmane.org with smtp (Exim 3.35 #1 (Debian))
	id 1CAPHA-0001Ml-00
	for <gcsg-supervision@gmane.org>; Thu, 23 Sep 2004 10:48:28 +0200
Original-Received: (qmail 22994 invoked by uid 76); 23 Sep 2004 08:48:49 -0000
Mailing-List: contact supervision-help@list.skarnet.org; run by ezmlm
List-Post: <mailto:supervision@list.skarnet.org>
List-Help: <mailto:supervision-help@list.skarnet.org>
List-Unsubscribe: <mailto:supervision-unsubscribe@list.skarnet.org>
List-Subscribe: <mailto:supervision-subscribe@list.skarnet.org>
List-Archive: <http://www.skarnet.org/lists/>
Original-Received: (qmail 22988 invoked from network); 23 Sep 2004 08:48:48 -0000
Original-To: supervision@list.skarnet.org
User-Agent: Internet Messaging Program (IMP) 3.2.5-cvs
X-Originating-IP: 194.119.125.25
Xref: main.gmane.org gmane.comp.sysutils.supervision.general:584
X-Report-Spam: http://spam.gmane.org/gmane.comp.sysutils.supervision.general:584

Hi everyone,

I've worked on a tool to log everything in mysql or pgsql database.
It may be used instead of/with a multilog/svlogd process on the main
svcan/runsvdir process. (think about replacing the readproctitle...)

I convert the taia64 date format into the sql equivalent.

I wanted to have it launched at the system boot, but I still wanted it to be
supervised. So I fell back on using a fifo and opening it RDWR on Linux to no
block the main process (writing to a pipe not opened RDWR when the reader isn't
started blocks...).

You can find more about it on http://rolphin.expert-gamers.com/notify.html,
(for now the page is in french, if anyone is interested I will be pleased to
rewrite it english).

So tell me about this idea, what do you think about it, and what could be wrong
with it...

PS: if you use the download link you may not be able to compile the tool as is,
since I may have forget to include some libowfat function of mine ... But I
will correct this as soon as I get feedback ;p

See ya.