logging-log4j-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fancing <xiaoning.z...@gmail.com>
Subject Re: is the org.apache.log4j.jdbc.JDBCAppender removed yet?
Date Thu, 29 Nov 2007 06:32:19 GMT
It works, after i add:
log4j.appender.db.driver=com.mysql.jdbc.Driver

thanks!

2007/11/28, CHANG Shuh <shuh.chang@gemalto.com>:
> 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
>
>

---------------------------------------------------------------------
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