Return-Path: 
 <tomcat-user-return-125432-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 12709 invoked from network); 22 Apr 2005 19:56:29 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 22 Apr 2005 19:56:29 -0000
Received: (qmail 74576 invoked by uid 500); 22 Apr 2005 19:56:33 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 74545 invoked by uid 500); 22 Apr 2005 19:56:32 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 74531 invoked by uid 99); 22 Apr 2005 19:56:32 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from sccrmhc11.comcast.net (HELO sccrmhc11.comcast.net)
 (204.127.202.55)
  by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 22 Apr 2005 12:56:32 -0700
Received: from akumac (pcp0010700939pcs.manass01.va.comcast.net[69.243.19.26])
          by comcast.net (sccrmhc11) with SMTP
          id <200504221956020110081veee>; Fri, 22 Apr 2005 19:56:03 +0000
Message-ID: <011a01c54775$5ae06bd0$6601a8c0@akumac>
From: "joelsherriff" <joelsherriff@comcast.net>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
References: <072801c5316b$21557ec0$6701a8c0@akumac>
 <d22f2r$326$1@sea.gmane.org> <005f01c531a6$88850bc0$6701a8c0@akumac>
 <d22jt1$ce7$1@sea.gmane.org> <003d01c53220$4b4a4cf0$6701a8c0@akumac>
 <008001c5323b$83ee29d0$6701a8c0@akumac> <d24nk1$t5s$1@sea.gmane.org>
 <00ae01c53271$c419de10$6701a8c0@akumac>
 <012901c53306$18b62de0$6701a8c0@akumac>
Subject: Help with JDBCRealm config on Tomcat 4.1
Date: Fri, 22 Apr 2005 15:56:20 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hope someone can help me - I'm still a relative newbie to tomcat, am baffled
at this point and I can't even get it configured so that I
can get debug info to find out what's wrong.

I've added a context to my server.xml for the webapp I'm trying to set up
JDBCRealm authentication for:

      <Context path="/blojsom" docBase="blojsom" debug="99" >
            <Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_blojsom_log." suffix=".txt" timestamp="true" />
            <Realm  className="org.apache.catalina.realm.JDBCRealm"
debug="99" driverName="org.gjt.mm.mysql.Driver"

connectionURL="jdbc:mysql://localhost/mydatabase?user=xxxxxx;password=xxxxxx
"
                connectionName="xxxxxx" connectionPassword="xxxxxx"
digest="MD5"
                userTable="users" userNameCol="userid"
userCredCol="md5password"
                userRoleTable="user_roles" roleNameCol="role_name" />
      </Context>

And, of course, added the supporting tables and roles to my database.  When
I attempt to access a page from the webapp,
my login.jsp page is displayed, and when I attempt to login, my error.jsp
page is displayed.   I didn't expect this to work
correctly the first time I configured it,  and it's not, but my problem is
that I can't figure out how to debug it at all.  The
Logger I have configured in the webapp's Context does nothing - doesn't
create the log file and nothing is logged
anywhere else either.   How can I further debug it?

Now, if I take the Realm out of the Context (applying it to the entire
server), I get an exception in my catalina_log:

2005-04-22 15:26:10 JDBCRealm[Standalone]: Exception performing
authentication
java.sql.SQLException: org.gjt.mm.mysql.Driver
 at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:588)
 at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:343)

Though it doesn't say it precisely, I think this implies that it's not
connecting to the DB, but the db, user and password values are all correct.

Basically, I have three problems:  why can't I get logging to work from
within a specific context,  am I doing something wrong in my attempt
to get JDBCRealm authentication to work, and what is the right way to debug
the problem further, if the solution isn't obvious?

Also, I've added to my webapp's web.xml file:

<security-constraint>
<web-resource-collection>
<web-resource-name>Entire Application</web-resource-name>
<url-pattern>/*</url-pattern>
</web-resource-collection>
<auth-constraint>
<role-name>users</role-name>
</auth-constraint>
</security-constraint>

<login-config>
<auth-method>FORM</auth-method>
<realm-name>Users</realm-name>
<form-login-config>
<form-login-page>/login.jsp</form-login-page>
<form-error-page>/error.jsp</form-error-page>
</form-login-config>
</login-config>

<security-role>
<description>
Some Stuff
</description>
<role-name>users</role-name>
</security-role>





---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org