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 world’s 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>