[Basicportal-maillist] Setup: Poolman, Realms, Postgres
Brought to you by:
basebeans
|
From: John M. <jo...@ea...> - 2002-07-25 23:56:45
|
Hi,
I realize this is not a portal question specifically but I hope somebody may
have a sample setup for me to look at????
The problem occurs when I try to start Apache with my new Realm and get
Catalina.start: LifecycleException: Exception opening database connection:
jav
a.sql.SQLException: org.postgresql.Driver
LifecycleException: Exception opening database connection:
java.sql.SQLExcepti
on: org.postgresql.Driver
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
)
My realm is configured as follows in the server.xml (my database name is
test on the computer named remote)
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql://remote:5432/test"
connectionName="postgres"
connectionPassword="postgres"
userTable="base_users"
userNameCol="email_id"
userCredCol="password"
userRoleTable="base_users"
roleNameCol="role_code"/>
Poolman is configured as follows:
<datasource>
<!-- ============================== -->
<!-- Physical Connection Attributes -->
<!-- ============================== -->
<!-- Standard JDBC Driver info -->
<dbname>testdb</dbname>
<jndiName>jndi-testdb</jndiName>
<driver>org.postgresql.Driver</driver>
<url>jdbc:postgresql://remote:5432/test</url>
<username>postgres</username>
<password/>
I setup poolman and got the initial pages running but I run into a problem
when I try to add something. I figured it was the Realm setup. I tried
adding the Realm, but now Tomcat will not start.
I am using the pgjdbc2.jar driver for PostgreSQL. and have placed it in the
common\lib folder
Is anyone using Postgres with Poolman and could they show me their Realm
entry?
|