Try using an & in place of the ; in your connectionURL: connectionURL="jdbc:mysql://javadev.logic.bm/steve?user=user&password=pa ssword"
> -----Original Message----- > From: Geoff Peters [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 31, 2003 11:08 AM > To: [EMAIL PROTECTED] > Subject: MySQL/Tomcat startup problem > > > Hello again - I have spent most of the day on this and don't > seem to be getting anywhere, searched the archives here and > the java.sun.com forums to no avail. Running Tomcat 4.1.18 on > my dev box Win2K Server, running MySQL 3.23.49 on the same > network on a Redhat 7.3 install. I am simply trying to make > a database connection, have 2 tables created with usernames > and roles, usernames and passwords, and set the mysqladmin > password to connect through the string. The systems guy sees > my packets hitting the box, so it doesn't seem to be a > network / firewall problem. > > Here is the realm tag (commented out the memory realm): > > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > driverName="org.gjt.mm.mysql.Driver" > > connectionURL="jdbc:mysql://javadev.logic.bm/steve?user=user;p > assword=password" > > userTable="tblUsers" userNameCol="user_name" > userCredCol="user_pass" > userRoleTable="tblUser_Role" roleNameCol="role_name" /> > > Here is the output (no matter what I change the username / > password to): > > > > Catalina.start: LifecycleException: Exception opening > database connection: jav > a.sql.SQLException: Communication link failure: java.io.IOException > LifecycleException: Exception opening database connection: > java.sql.SQLExcepti > on: Communication link failure: java.io.IOException > at > org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:681) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1173) > > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347 > ) > at > org.apache.catalina.core.StandardService.start(StandardService.java:4 > 97) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:218 > 9) > at > org.apache.catalina.startup.Catalina.start(Catalina.java:512) > at > org.apache.catalina.startup.Catalina.execute(Catalina.java:400) > at > org.apache.catalina.startup.Catalina.process(Catalina.java:180) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) > ----- Root Cause ----- > java.sql.SQLException: Communication link failure: java.io.IOException > at com.mysql.jdbc.MysqlIO.init(Unknown Source) > at com.mysql.jdbc.Connection.connectionInit(Unknown Source) > at > com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source) > at com.mysql.jdbc.Driver.connect(Unknown Source) > at > org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:616) > at > org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:679) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1173) > > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347 > ) > at > org.apache.catalina.core.StandardService.start(StandardService.java:4 > 97) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:218 > 9) > at > org.apache.catalina.startup.Catalina.start(Catalina.java:512) > at > org.apache.catalina.startup.Catalina.execute(Catalina.java:400) > at > org.apache.catalina.startup.Catalina.process(Catalina.java:180) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) > Stopping service Tomcat-Standalone > Catalina.stop: LifecycleException: Coyote connector has not > been started > LifecycleException: Coyote connector has not been started > at > org.apache.coyote.tomcat4.CoyoteConnector.stop(CoyoteConnector.java:1 > 075) > at > org.apache.catalina.core.StandardService.stop(StandardService.java:54 > 6) > at > org.apache.catalina.core.StandardServer.stop(StandardServer.java:2224 > ) > at > org.apache.catalina.startup.Catalina.start(Catalina.java:543) > at > org.apache.catalina.startup.Catalina.execute(Catalina.java:400) > at > org.apache.catalina.startup.Catalina.process(Catalina.java:180) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) > > > Communication link failure seems a little vague, anyone point > me in the right direction? > > Thanks!!! > > Geoff > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
