On Wed, 2005-04-27 at 06:06 +1200, [EMAIL PROTECTED] wrote: > Log4j.appender.orgco.URL=jdbc:mysql://localhost:3306/logs?autoReconnect=true
> Log4j.appender.orgco.User=couser > Log4j.appender.orgco.Password=password > Log4j.appender.orgco.Sql=INSERT INTO mylog (level) VALUES (â%5pâ) > [this will change, of course :)] > > Log4j.appender.orgco.layout=org.apache.log4j.PatternLayout > > # --------------- END ------------------ > > The following is the error I get: > > Log4j: ERROR Failed to excute sql > Java.sql.SQLException: Server connection failure during transaction. Due > to underlying exception: âjava.sql.SQLException: Access denied for user > [EMAIL PROTECTED] to database âlogsâ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > Then it goes on to show the dump. That (marked) seems the odd bit to me. [EMAIL PROTECTED] is normal (from what little I know of mySQL) I have same environment, mysql on win32 test environment, then production on Redhat Linux box. Assuming mySQL is on the same box as the logger application, I recall creating the 'couser' @localhost which seemed to work OK (and still is). Also, the password is encrypted prior to sending. HTH DaveP --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
