Hi,
I am having a bit of trouble getting my Postgres JDBCRealm correctly
configured.
If I start up my combined JBoss-2.4.4_Tomcat-4.0.1 stack, I am able to get a
connection to the DB and all is ok. Running the following command also works
fine : /usr/local/pgsql/bin/psql -h localhost -U userName -W testDB.
The exception (see below) occurs when I try and run Tomcat by itself.
Does the config for the JDBCRealm look correct ?
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql://localhost.localdomain:5432/testDB"
connectionName="userName"
connectionPassword="password"
userTable="users"
userNameCol="user_name"
userCredCol="user_pass"
userRoleTable="user_roles"
roleNameCol="role_name" />
[gedwards@localhost bin]$ ./catalina.sh run -security
Guessing CATALINA_HOME from catalina.sh to ./..
Setting CATALINA_HOME to ./..
./../bin/bootstrap.jar
Using CLASSPATH:
./../bin/bootstrap.jar:/home/gedwards/usr/local/postgresql-7.2/src/interfaces/jdbc/jars/postgresql.jar:/home/gedwards/usr/local/jdk1.3.1_01/lib/tools.jar
Using CATALINA_BASE: ./..
Using CATALINA_HOME: ./..
Using JAVA_HOME: /home/gedwards/usr/local/jdk1.3.1_01
Using Security Manager
Starting service Tomcat-Standalone
Apache Tomcat/4.0.1
Catalina.start: LifecycleException: Exception opening database connection:
Something unusual has occured to cause the driver to fail. Please report
this exception: Exception: java.security.AccessControlException: access
denied (java.net.SocketPermission localhost.localdomain resolve)
Stack Trace:
java.security.AccessControlException: access denied
(java.net.SocketPermission localhost.localdomain resolve)
at
java.security.AccessControlContext.checkPermission(AccessControlContext.java:272)
at
java.security.AccessController.checkPermission(AccessController.java:399)
at
java.lang.SecurityManager.checkPermission(SecurityManager.java:545)
at java.lang.SecurityManager.checkConnect(SecurityManager.java:1042)
at java.net.InetAddress.getAllByName0(InetAddress.java:559)
at java.net.InetAddress.getAllByName0(InetAddress.java:540)
at java.net.InetAddress.getByName(InetAddress.java:449)
at java.net.Socket.<init>(Socket.java:100)
at org.postgresql.PG_Stream.<init>(Unknown Source)
at org.postgresql.Connection.openConnection(Unknown Source)
at org.postgresql.Driver.connect(Unknown Source)
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548)
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.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)
End of Stack Trace
Many thanks
Regards
Grant E
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
