Try looking at your Postgres logs for more information. Edit your
postgresql.conf file by setting 'syslog' to 1 or 2. Then check your system
logs after you try to start up Tomcat. Other options to consider in your
postgresql.conf file:
log_connections = true
debug_level = 4
debug_pring_query = true
--
Robert Abernethy IV
Dynamic Edge, Inc.
734.975.0460
> Hello,
>
> I've had a hard time setting up a JDBCRealm in Tomcat 4.1.18 Win2k
> connecting to a postgresql 7.2.1 server on a seperate machine.
> I've set up the server.xml following the directions to a tee:
>
> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
> driver="org.postgresql.Driver"
> connectionURL="jdbc:postgresql://my.database.com/dbname"
> connectionName="username"
> connectionPassword="password"
> digest="MD5"
> userTable="users" userNameCol="username" userCredCol="password"
> userRoleTable="user_roles" roleNameCol="role_name" />
>
> I have copied pg73jdbc2.jar (I've also tried pg73jdbc3.jar) to the
> common/lib directory
> I can connect to postgresql through jsp just fine, through simple
> jdbc just fine.
>
> I have searched the mailing list archives and groups.google.com none
> of the answers seem to apply. I originally had the problem with tomcat
> 4.1.3 and I upgraded but to no avail. Please help.
>
> I get this error message when I start up tomcat with this realm config:
>
> Bootstrap: Create Catalina server
> Bootstrap: Starting service
> Starting service Tomcat-Standalone
> Apache Tomcat/4.1.18
> 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:2189) at
org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:273)
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.BootstrapService.start
(BootstrapService.java:245) at
org.apache.catalina.startup.BootstrapService.main(BootstrapService.java:307)
> ----- 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:2189) at
org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:273)
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.BootstrapService.start
(BootstrapService.java:245) at
org.apache.catalina.startup.BootstrapService.main(BootstrapService.java:307)
Bootstrap: Service started
>
> --
> To unsubscribe, e-mail: <mailto:tomcat-user-
[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:tomcat-user-
[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
