logging-log4j-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "CHANG Shuh" <shuh.ch...@gemalto.com>
Subject RE: is the org.apache.log4j.jdbc.JDBCAppender removed yet?
Date Wed, 28 Nov 2007 15:48:30 GMT
There are a few areas that you might want to look into:

1. Double check the values that you enter for those parameters. For
example, did you have a typo in your user name?
      log4j.appender.db.user=uesr

2. Try removing the port number and using the default port, and see if
it works better:
      log4j.appender.db.URL=jdbc:mysql://172.16.100.103/p2pdb

3. Try it locally (local to your MySQL server) first so that there is no
remote login issue for the MySQL:
      log4j.appender.db.URL=jdbc:mysql://localhost:3306/p2pdb

If the third option works, then it means that your MySQL server only
allows local login, not remote access. Fix your MySQL server settings in
that case then.

Good luck.

Best Regards,
Shuh Chang
Senior Systems Architect
Security, Network Identity
Gemalto
Tel: +1 512-257-3859
Fax: +1 512-257-3904
9442 Capital of Texas Highway North
Arboretum Plaza II, Suite 400
Austin, Texas 78759
Shuh dot chang at gemalto.com
www.gemalto.com


 

> -----Original Message-----
> From: James A. N. Stauffer [mailto:stauffer.james@gmail.com] 
> Sent: Wednesday, November 28, 2007 9:20 AM
> To: Log4J Users List; shaoning.zeng@163.com
> Subject: Re: is the org.apache.log4j.jdbc.JDBCAppender removed yet?
> 
> Try turning on log4j debugging.
> 
> On Nov 28, 2007 1:40 AM, Fancing <xiaoning.zeng@gmail.com> wrote:
> 
> > i configure my log4j.properties like the following:
> >
> > log4j.appender.db=org.apache.log4j.jdbc.JDBCAppender
> > log4j.appender.db.URL=jdbc:mysql://172.16.100.103:3306/p2pdb
> > log4j.appender.db.user=uesr
> > log4j.appender.db.password=password
> > log4j.appender.db.sql=INSERT INTO log
> > VALUES(LAST_INSERT_ID(),%d,'%c','%p','%m')
> >
> > And it doesn't work! nothing logged into the database but 
> no error or 
> > exception thrown ...
> >
> > does Log4j support logging into database yet? how?
> > Thanks for reply!
> >
> > 
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
> > For additional commands, e-mail: log4j-user-help@logging.apache.org
> >
> >
> 
> 
> -- 
> James A. N. Stauffer        http://www.geocities.com/stauffer_james/
> Are you good? Take the test at http://www.livingwaters.com/good/
> 

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


Mime
View raw message