Subject: Re: JDBCRealm & Debug Logging From: Vic Cekvenich <[EMAIL PROTECTED]> === One would assume that you tested connecting to the JDBC outside of Tomcat and have the JARs in lib.
Eric Grace wrote: > Hello, > > I'm getting an extremely general SQLException on startup and am > wondering if there is a way to get better debugging info that will > illuminate the real problem ( changing the debug level on the realm does > not seem to have any effect ). It would be nice to not have to edit the > sourcecode, though it's not out of the question. Could someone give a > bit of direction on what I might be missing here to get a JDBCRealm up > and running? Thanks in advance. > > I have the following Realm definition in server.xml.. > <Realm > className="org.apache.catalina.realm.JDBCRealm" > debug="5" > driverName="org.gjt.mm.mysql.Driver" > connectionName="conname" > connectionPassword="conpass" > connectionURL="jdbc:mysql://localhost:3306/tomcatusers" > userTable="users" > userNameCol="login" > userCredCol="password" > userRoleTable="user_roles" > roleNameCol="role_name"/> > > permissions on the data files..666 ( not for the rest of the path ) > > > The following occurs at startup..and is dumped to catalina.out > Starting service Tomcat-Standalone > Apache Tomcat/4.0.1 > Catalina.start: LifecycleException: Exception opening database > connection: java.sql.SQLException: org.gjt.mm.mysql.Driver > LifecycleException: Exception opening database connection: > java.sql.SQLException: org.gjt.mm.mysql.Driver > 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.StandardContext.start(StandardContext.java:3334 > ) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) > at > org.apache.catalina.core.StandardHost.start(StandardHost.java:612) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) > at > org.apache.catalina.core.StandardService.start(StandardService.java:388) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:505) > at org.apache.catalina.startup.Catalina.start(Catalina.java:776) > 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: org.gjt.mm.mysql.Driver > at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538) > 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.StandardContext.start(StandardContext.java:3334 > ) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) > at > org.apache.catalina.core.StandardHost.start(StandardHost.java:612) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) > at > org.apache.catalina.core.StandardService.start(StandardService.java:388) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:505) > at org.apache.catalina.startup.Catalina.start(Catalina.java:776) > 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) > > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
