Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org Received: (qmail 12400 invoked by uid 500); 17 Apr 2001 17:08:10 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk Reply-To: tomcat-user@jakarta.apache.org list-help: list-unsubscribe: list-post: Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 12203 invoked from network); 17 Apr 2001 17:08:04 -0000 Received: from f56.law8.hotmail.com (HELO hotmail.com) (216.33.241.56) by h31.sny.collab.net with SMTP; 17 Apr 2001 17:08:04 -0000 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 17 Apr 2001 10:07:40 -0700 Received: from 151.209.112.132 by lw8fd.law8.hotmail.msn.com with HTTP; Tue, 17 Apr 2001 17:07:40 GMT X-Originating-IP: [151.209.112.132] From: "eric chacon" To: tomcat-user@jakarta.apache.org Subject: Re: JDBC Realm Question Date: Tue, 17 Apr 2001 13:07:40 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 17 Apr 2001 17:07:40.0426 (UTC) FILETIME=[E8E196A0:01C0C760] X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N That seems to have done it... thanks, Eric >From: Stefan Meisner Larsen >Reply-To: tomcat-user@jakarta.apache.org >To: tomcat-user@jakarta.apache.org >Subject: Re: JDBC Realm Question >Date: Tue, 17 Apr 2001 14:55:21 +0200 > >Hi Eric > >You seems to be missing: > connectionName="some_name" > connectionPassword="some_password" > >in your RequestInterceptor setup > >Under normal conditions it is the unix user/password you used when the db >was >created > >Stefan > > >On Tuesday 17 April 2001 14:07, you wrote: > > 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 > > > > > 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 _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com