You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by khozaima shakir <sk...@hotmail.com> on 2002/08/09 22:43:38 UTC
JDBC Realm - Can't start TC4.0.4 !!
I am trying to configure JDBCRealm. I can't understand the error, since the
same username and password was successfully used to access the database
using servlet-jdbc in my webapp, without configuring JDBCrealm. Can anyone
please advise?
Thanks,
skhuzema
I have edited server.xml realm as under:
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="org.gjt.mm.mysql.Driver"
connectionURL="jdbc:mysql://myql.wpi.edu/dbaseName?user=skhuzema;dbpasswd=dbpasswd"
userTable="users" userNameCol="user_name" userCredCol="user_pass"
userRoleTable="user_roles" roleNameCol="role_name" />
-->> Names of columns same as above in database
(I have installed tomcat on mapped drive on windowsNT)
Error Message on tomcat startup:
Starting service Tomcat-Standalone
Apache Tomcat/4.0.4
Catalina.start: LifecycleException: Exception opening database connection:
java.sql.SQLException: Invalid authorization specification: Access denied
for user:
'skhuzema;password@fla22-1.cs.WPI.EDU' (Using password: NO)
LifecycleException: Exception opening database connection:
java.sql.SQLException: Invalid authorization specification: Access denied
for user: 'skhuzema;password@fla22-1.cs.WPI.EDU' (Using password: NO)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:506
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
----- Root Cause -----
java.sql.SQLException: Invalid authorization specification: Access denied
for user: 'skhuzema;password@fla22-1.cs.WPI.EDU' (Using password: NO)
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:278)
at org.gjt.mm.mysql.Connection.<init>(Connection.java:230)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:506
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
_________________________________________________________________
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>