Hi,
I am trying to set up a JDBCRealm in Catalina's server.xml
After starting I find a message in the logs stating a connection could not be
established because access was denied.
What I don't understand is that MySQL states no password has been supplied and
the user trying to connect is named 'root;password@localhost' where it should be
'root@localhost'.
Changing the semicolon in the connectionURL to an ampersand (= correct
org.gjt.mm.mysql syntax) was refused by the SAX parser?
Am I overlooking something? I am using Tomcat4-4.0-b1.1
Regards,
Wilko
--- catalina_log.2001-01-31.txt ------
2001-01-31 11:16:09 JDBCRealm[Standalone]: The database connection is null or
was found to be closed. Trying to re-open it.
2001-01-31 11:16:09 JDBCRealm[Standalone]: Cannot find message associated with
key 'jdbcRealm.checkConnectionSQLException'
java.sql.SQLException: Invalid authorization specification: Access denied for
user: 'root;password@localhost' (Using password: NO)
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
at org.gjt.mm.mysql.Driver.connect(Driver.java)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:199)
at
org.apache.catalina.realm.JDBCRealm.checkConnection(JDBCRealm.java:614)
etcetera
--- server.xml -------------------------
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="org.gjt.mm.mysql.Driver"
connectionURL="jdbc:mysql://localhost/authority?user=root;password=apassword"
userTable="User" userNameCol="uname" userCredCol="password"
userRoleTable="UserRoles" roleNameCol="rname" />
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
