It works, after i add: log4j.appender.db.driver=com.mysql.jdbc.Driver thanks!
2007/11/28, CHANG Shuh <[EMAIL PROTECTED]>: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
