RE: Chainsaw V2 config file for DBAppender

[Scott Deboy]

URLConnectionSource is in the sandbox - it's not a part of log4j 1.3 alpha. 

Here's a config file that should work.  Save off the XML below and use it as 
your Chainsaw config after updating the settings specific to your database (in 
all-caps in the XML).  I removed the xml declaration and set up the single db 
receiver to use DriverManagerConnectionSource:

----------------------
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/";>
   <plugin name="MyDBReceiver" class="org.apache.log4j.db.DBReceiver">
      <connectionSource 
class="org.apache.log4j.db.DriverManagerConnectionSource">
        <param name="password" value="MYPASSWORD"/>
        <param name="user" value="MYUSER"/>
        <param name="driverClass" value="MYDRIVER"/>
        <param name="url" value="MYJDBCURL"/>
      </connectionSource>
    </plugin>

   <root>
      <level value="debug"/>
   </root>
</log4j:configuration>
------------------------



-----Original Message-----
From:   Darren Hartford [mailto:[EMAIL PROTECTED]
Sent:   Thu 4/21/2005 7:53 AM
To:     Log4J Users List
Cc:     
Subject:        RE: Chainsaw V2 config file for DBAppender
Thanks for taking a look Scott, here it is:
======================
<?xml version="1.0" encoding="UTF-8" ?>
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/";
debug="false">

 <plugin name="DBReceiver1" class="org.apache.log4j.db.DBReceiver">
       <connectionSource
class="org.apache.log4j.db.DriverManagerConnectionSource">
         <param name="driverClass" value="com.mysql.jdbc.Driver"/>
         <param name="url" value="jdbc:mysql://<server>/<db>"/>
         <param name="user" value="<snip>"/>
       </connectionSource>
  </plugin>

 <plugin name="DBReceiver2" class="org.apache.log4j.db.DBReceiver">
       <connectionSource
class="org.apache.log4j.db.UrlConnectionSource">
         <param name="driverClass" value="com.mysql.jdbc.Driver"/>
         <param name="url" value="jdbc:mysql://<server>/<db>"/>
         <param name="user" value="<snip>"/>       
</connectionSource>
  </plugin>

   <plugin name="MyDBReceiver"
class="org.apache.log4j.db.CustomSQLDBReceiver">
      <param name="sql" value="SELECT logger AS 'LOGGER', event_time AS
'TIMESTAMP', log_level AS 'LEVEL', thread AS 'THREAD', message AS
'MESSAGE', '' AS 'NDC', '' AS 'MDC', 'class_name' AS 'CLASS', method AS
'METHOD', file_name AS 'FILE', line AS 'LINE', '{{application,' +
app_name + ',hostname,' + machine_name + ',log4jid,' + CAST(counter AS
varchar(255)) + '}}' AS 'PROPERTIES', '' AS 'EXCEPTION' FROM
log_event"/>
      <connectionSource
class="org.apache.log4j.db.DriverManagerConnectionSource">
        <param name="password" value="XXXXX"/>
        <param name="user" value="YYYYY"/>
        <param name="driverClass" value="com.mysql.jdbc.Driver"/>
         <param name="url" value="jdbc:mysql://<server>/<db>"/>
      </connectionSource>
      <param name="IDField" value="counter"/>
      <param name="refreshMillis" value="3000"/>
    </plugin>

    <root>
      <level value="debug"/>
   </root>

</log4j:configuration>
======================

 

> -----Original Message-----
> From: Scott Deboy [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, April 21, 2005 10:33 AM
> To: Log4J Users List
> Subject: RE: Chainsaw V2 config file for DBAppender
> 
> Can you email the contents of your config file?
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]






---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]