Re: Problem with JDBCAppender and mySQL

2005-04-27 Thread Hakan Koseoglu
> - Sorry everyone. It was my fault. The database specified below > is a new database that I didn't specifically add my couser to. This is > the reason why it wasn't connecting. I'm not sure what the whole '%' > thing was though. Now it's working and should work fine on my production > host.

Re: Problem with JDBCAppender and mySQL

2005-04-27 Thread Dave Pawson
On Wed, 2005-04-27 at 07:07 +1200, [EMAIL PROTECTED] wrote: > Thanks Dave. I thought it was interesting as well... I just tried using > 'root' and the password for the root user in mySQL and it works. I'm not > going to have access to the root user on my production host, so how can I > get aroun

Re: Problem with JDBCAppender and mySQL

2005-04-26 Thread mymail
Thanks Dave. I thought it was interesting as well... I just tried using 'root' and the password for the root user in mySQL and it works. I'm not going to have access to the root user on my production host, so how can I get around this? Both the Tomcat server and the mySQL server are on the same

Re: Problem with JDBCAppender and mySQL

2005-04-26 Thread Dave Pawson
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â) > [t

Problem with JDBCAppender and mySQL

2005-04-26 Thread mymail
Hello. I’m a fairly new user and have over the last 6 months been using a RollingFileAppender. Works fine but I’ve run across some problems with having a version of the log4j.properties file on my development system (Windows) and one on the production (Linux). Anyway, I’m trying to eliminate tho