Configuration of mysql is ok. I can connect in Netbeans IDE with a String like jdbc:mysql://localhost:3306/tomcatsessions?user=username&password=password but
Here I use "&" instead of ";" in the IDE. That works fine. But when I am using this String in server.xml I get parsing errors because of the "&". So I tried also "&". I get the same error in all cases: During init of JDBCStore there is following error: JDBCStore[]: The database connetion is null or was found to be closed. Trying to reopen it. On any action with jsp I get: JDBCStore[]: SQL Error java.sql.SQLException: General Error: Access denied dor user: '@localhost' to database 'tomcatsessions' I had the same errors with ";" in <Realm> configuration. So I use there connectionName and connectionPassword and <Realm> works! I need some further hints to solve this problem. Still: Why are org.apache.catalina.JDBCStore and org.apache.calalina.JDBCRealm using different connection attributes? Thanks- Yves Brad Plies wrote: > > Sounds like a mysql config error. > try a: GRANT ALL ON <dbname> TO <username>@localhost > GRANT ALL ON <dbname> TO <username>@'%' > > Make sure the password you're using for the Connection > is correct too. Restart MySQL to flush the > priveleges. > > That's my best recommendation, hope it helps! > > --- Yves Sablonier <[EMAIL PROTECTED]> wrote: > > Need some help. > > > > I am trying to use > > <Store > > className="org.apache.catalina.session.JDBCStore" > > driverName="com.mysql.jdbc.Driver" > > > >connectionURL="jdbc:mysql://localhost:3306/tomcatsessions?user=username;password=password" > > > > > > etc. in my <Context> of a WebApp under Tomcat 4.0.1 > > > > JDBCStore can not connect to my MySQL-Database with > > this connectionUrl. > > I get '@localhost' access denied. It seems like the > > URL above will not > > work with user/password. I had the same Problem with > > <Realm> but there > > is a "ConnectionName" and "ConnectionPassword". This > > works fine with > > <Realm>. Why is the usage of the connnection > > attributes different in <Store>? > > > > Does anybody know why this URL is not working? > > > > Thanks, Yves > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > __________________________________________________ > Do you Yahoo!? > New DSL Internet Access from SBC & Yahoo! > http://sbc.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
