logging-log4j-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rally, Varun" <varun.ra...@fiserv.com>
Subject RE: Question for CustomSQLDBReceiver
Date Thu, 03 Jul 2008 19:44:22 GMT
I created a table with the following statement.

 

1) CREATE TABLE  `userdb`.`sys_log` (

 

  `log_id` int(10) unsigned NOT NULL auto_increment,

 

  `log_date` timestamp NOT NULL default CURRENT_TIMESTAMP,

 

  `sys_name` varchar(45) NOT NULL,

 

  `machine_name` varchar(45) NOT NULL,

 

  `class_name` varchar(45) NOT NULL,

 

  `priority` varchar(45) NOT NULL,

 

  `message` varchar(45) default NULL,

 

  `extended_message` varchar(45) default NULL,

 

  `user_id` int(10) unsigned NOT NULL,

 

  `method_name` varchar(45) NOT NULL,

 

  PRIMARY KEY  (`log_id`)

 

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

 

 

My config file is like this...

 

2) <?xml version="1.0" encoding="UTF-8" ?>

 

<!DOCTYPE log4j:configuration >

 

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"

debug="true">

 

   <appender name="A2" class="org.apache.log4j.ConsoleAppender">

 

      <layout class="org.apache.log4j.SimpleLayout"/>

 

   </appender>

 

  <plugin name="CustomDBReceiver"

class="org.apache.log4j.db.CustomSQLDBReceiver">

 

      <connectionSource

class="org.apache.log4j.db.DriverManagerConnectionSource">

 

        <param name="password" value="admin"/>

 

        <param name="user" value="root"/>

 

        <param name="driverClass" value="org.gjt.mm.mysql.Driver"/>

 

        <param name="url" value="jdbc:mysql://127.0.0.1/user_db"/>

 

              </connectionSource>

 

      <param name="refreshMillis" value="5000"/>

 

      <param name="sql" value='select logger as LOGGER, log_date as

TIMESTAMP, priority as LEVEL, message as MESSAGE, class_name as CLASS,

method_name as METHOD,

concat("{{application,databaselogs,hostname,mymachine,log4jid,",

COUNTER, "}}") as PROPERTIES, "" as EXCEPTION from sys_log'/>

 

      THREAD,  NDC, MDC, FILE, LINE, PROPERTIES, THROWABLE

 

      <param name="IDField" value="log_id"/>

 

   </plugin>

 

   <root>

 

      <level value="debug"/>

 

   </root>

 

</log4j:configuration>

 

 

I also setup automatic configuration script to point to my config file

in chainsaw. But when I open chainsaw, nothing happens. I have also put
the MySQL driver .jar file in .chainsaw/plugins directory.

 

Please let me know what I am missing.

 

 

Regards,

Varun Rally

---------------------------------------------------

Fiserv, A-94/8, SECTOR 58 NOIDA UP INDIA 201301

Phone- 91-120-4023000  extn. 3268 Cell- 91-98990-37800

VOIP - 434-509-0698 Extn. 121

US Phone- 001-303-293-2223 Extn. 22814

 

 

-----Original Message-----
From: Scott Deboy [mailto:sdeboy@comotivsystems.com] 
Sent: Thursday, July 03, 2008 10:29 AM
To: Log4J Users List
Subject: RE: Question for CustomSQLDBReceiver

 

http://logging.apache.org/log4j/companions/receivers/apidocs/org/apache/
log4j/db/CustomSQLDBReceiver.html

 

Add your jdbc jar to the $userhome/.chainsaw/plugins folder and update
your chainsaw xml config file to use the receiver (see the Welcome tab -
there's a 'view example receiver configuration' button on that tab which
contains an example configuration file.

 

The receiver essentially requires you to define aliases from your
columns to fixed columns the receiver is going to use to run the query.
It also supports an IDField param, which is assumed to be an
auto-incrementing int, which will allow you to 'tail' the events from
the database when running the query multiple times (if the refreshMillis
param is defined).

 

 

Scott Deboy

COMOTIV SYSTEMS

111 SW Columbia Street Ste. 950

Portland, OR  97201

 

Telephone:      503.224.7496

Cell:           503.997.1367

Fax:            503.222.0185

 

sdeboy@comotivsystems.com

 

www.comotivsystems.com

 

 

 

-----Original Message-----

From: Rally, Varun [mailto:varun.rally@fiserv.com]

Sent: Thu 7/3/2008 9:12 AM

To: log4j-user@logging.apache.org

Subject: Question for CustomSQLDBReceiver

 

Hello All,

 

 

 

I am new to Chainsaw and want to use CustomSQLDBReceiver. Though I have

got an idea of what it is, I am not able to get it running. Please

provide me an internet link or URL that explains the steps to use a

CustomSQLDBReceiver.

 

 

 

Thanks in anticipation.

 

 

 

Regards,

Varun 

 

 

 

 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message