Hi, I'm having problems connecting to mysql from tomcat when (only when) going via the warp connector. (with roller in this example - I'm assuming it's not app specific) I point a browser to http://localhost:8080/roller/ and everything works - db access no problem. I point a browser to http://localhost/roller/ and I see the webapp html no problem, but I get the exception below whenever it tries to hit mysql. thanks in advance for any help on this (chunks of httpd.conf/server.xml & versions at the bottom if they can aid diagnosis) rob.
Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException LifecycleException: Exception opening database connection: java.sql.SQLException 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:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2185) at org.apache.catalina.startup.Catalina.start(Catalina.java:510) 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(NativeMethodAccessorImpl.java:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) ----- Root Cause ----- java.sql.SQLException at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:606) 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:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2185) at org.apache.catalina.startup.Catalina.start(Catalina.java:510) 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(NativeMethodAccessorImpl.java:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) Stopping service Tomcat-Standalone Stopping service Tomcat-Apache Catalina.stop: LifecycleException: Not started LifecycleException: Not started at org.apache.catalina.connector.warp.WarpConnector.stop(Unknown Source) at org.apache.catalina.core.StandardService.stop(StandardService.java:546) at org.apache.catalina.core.StandardServer.stop(StandardServer.java:2220) at org.apache.catalina.startup.Catalina.start(Catalina.java:541) 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(NativeMethodAccessorImpl.java:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) HTTPD.CONF ---------------- <VirtualHost *> ServerName www.whatever.... DocumentRoot /home/www/public_html WebAppConnection conn warp localhost:8008 WebAppDeploy roller conn /roller WebAppInfo /webapp-info </VirtualHost> SERVER.XML ---------------- <Service name="Tomcat-Apache"> <Connector className="org.apache.catalina.connector.warp.WarpConnector" port="8008" minProcessors="5" maxProcessors="75" enableLookups="true" appBase="webapps" acceptCount="10" debug="0"/> <Engine className="org.apache.catalina.connector.warp.WarpEngine" name="Apache" debug="0"> <Logger className="org.apache.catalina.logger.FileLogger" prefix="apache_log." suffix=".txt" timestamp="true"/> <Realm className="org.apache.catalina.realm.MemoryRealm" /> </Engine> </Service> VERSIONS -------------- tomcat 4.1.7 (also tried 4.0.4) mysql-3.23.51 Apache/1.3.26 mm.mysql-2.0.14 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>