I am trying to set up a JDBC Realm on tomcat 3.2.1
(Also, Linux, Postgres 7.0 something, Apache using mod_jk...)
Here is my entry in the server.xml file
<RequestInterceptor
className="org.apache.tomcat.request.JDBCRealm"
debug="99"
driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql://localhost:5432/mysite_userdb"
userTable="users"
userNameCol="user_name"
userCredCol="user_pass"
userRoleTable="user_roles"
roleNameCol="role_name" />
Here is the error I get
FATAL:java.lang.RuntimeException: JDBCRealm.start.readXml: The user property
is
missing. It is mandatory.
java.lang.RuntimeException: JDBCRealm.start.readXml: The user property is
missing. It is mandatory.
at org.apache.tomcat.request.JDBCRealm.contextInit(JDBCRealm.java,
Compiled Code)
at
org.apache.tomcat.core.ContextManager.initContext(ContextManager.java,
Compiled Code)
at org.apache.tomcat.core.ContextManager.init(ContextManager.java,
Compiled Code)
at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java, Compiled
Code)
at org.apache.tomcat.startup.Tomcat.main(Tomcat.java, Compiled Code)
I have all the necessary databases set up, I can connect to postgres from
stand-alone programs. I have the JDBC drivers in the classpath and in the
tomcat/lib directory.
If I remove the connectionURL line or the driverName line, I get appropriate
error messages telling me that these attributes are required.
I'm not sure what a user property is...
Cheers, and thanks,
Eric
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com