Mailing-List: contact log4j-user-help@logging.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Log4J Users List" <log4j-user@logging.apache.org>
Received-SPF: pass (athena.apache.org: domain of jlar310@gmail.com designates
 209.85.198.251 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=PNfxVbArdv7craCEizBmtYYsBapxicZhuk1/0ppMPHklGlfF3oE+U+3/3BVib2tBRJ
         y29h1catBJLXWaDa5ugi5L5jqpSeaAfRrFsIMfAOLpIPvORH+a2L2ul4ysu2q45fWJBp
         Vl6uldhFY5pnrVB0MnWp3P3AeVWA+P5C6THeU=
Message-ID: <d1f9b6f00808071642u15b47bd9n638df1afc48b30c8@mail.gmail.com>
Date: Thu, 7 Aug 2008 18:42:20 -0500
From: Jeff <jlar310@gmail.com>
To: "Log4J Users List" <log4j-user@logging.apache.org>
Subject: Re: Distributed Logging Problem (log to remote database possible?)
In-Reply-To: <18879250.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <18879250.post@talk.nabble.com>

On Thu, Aug 7, 2008 at 3:42 PM, CheapLisa <lisa@purpleblade.net> wrote:
>
> We have six machines involved in a transaction (Identity Provisioning /
> Identity Integration).  In this scenario ata is sent from a hub out to six
> machines.
>
> I want to log information on the hub and the six machines in one place (a
> database residing on yet another machine).
>
> Is this possible to do?  I suppose the only thing really needed to do this
> is the ability for Log4J to log a message to a remote database.  Each
> machine would be logging messages with a message_id unique to that
> transaction so I could write a query to show me all messages for that
> transaction alone.
>
> I need the ability to log to all of the following databases: Oracle,
> PostgreSQL, Derby, MySQL
>

org.apache.log4j.jdbc.JDBCAppender seems to be the place to start.

Or SyslogAppender, with a centralized syslog server writing to a
database, but support for a good syslog/database bridge is somewhat
lacking. The specs for the relatively new rsyslog say it supports a
database backend, but some accounts I've read say that the rsyslog
system as a whole is still a bit raw. I have not used it myself. Not
log4j related, but I use syslog-ng with a mysql backend, but I have
not been pleased with the un-refined method used to get syslog records
into the database.

-- 
Jeff

---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-user-help@logging.apache.org