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:[EMAIL PROTECTED]
> Sent: Wednesday, November 28, 2007 9:20 AM
> To: Log4J Users List; [EMAIL PROTECTED]
> Subject: Re: is the org.apache.log4j.jdbc.JDBCAppender removed yet?
>
> Try turning on log4j debugging.
>
> On Nov 28, 2007 1:40 AM, Fancing <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> --
> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
