JDBCRealm and authentication - interesting problem!?

[Cross Fire Labs B.A. Lambrechts]

Here's an intersting one: Have followed all docs and advice from this list 
and still can't get dialog box to pop for username/password.  No errors 
anywhere and debug says that BASIC authentication has been configured.

Server.xml looks like this:

<Server port="8008" shutdown="SHUTDOWN" debug="0">

<!-- Define an Apache-Connector Service -->
<Service name="Tomcat-Apache">

  <Connector className="org.apache.catalina.connector.warp.WarpConnector"
   port="8008" minProcessors="5" maxProcessors="75"
   enableLookups="true"
   acceptCount="10" debug="0"/>

  <Engine className="org.apache.catalina.connector.warp.WarpEngine"
   name="Apache" debug="0" appBase="webapps">


      <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="0"
           driverName="org.gjt.mm.mysql.Driver"
        connectionURL="jdbc:mysql://localhost/BMI"
connectionName="bmi"
connectionPassword="bmi4now"
            userTable="LOGIN" userNameCol="USERNAME"
userCredCol="PASSWORD"
        userRoleTable="LOGIN_ROLE" roleNameCol="ROLENAME" />



    <Host name="0.0.0.0" debug="0" appBase="webapps" unpackWARs="true">

      <!-- BMI IMPLEMENTATION -->

      <Context path="/bmi" docBase="bmi" debug="0"
               reloadable="true">

      <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="0"
           driverName="org.gjt.mm.mysql.Driver"
        connectionURL="jdbc:mysql://localhost/BMI"
connectionName="bmi"
connectionPassword="ow"
            userTable="LOGIN" userNameCol="USERNAME"
userCredCol="PASSWORD"
        userRoleTable="LOGIN_ROLE" roleNameCol="ROLENAME" />


        <Logger className="org.apache.catalina.logger.FileLogger"
                   prefix="localhost_bmi_log." suffix=".txt"
        timestamp="true"/>

</Context>


<!-- END OF BMI IMPLEMENTATION -->
    </Host>

    <!-- Global logger unless overridden at lower levels -->
    <Logger className="org.apache.catalina.logger.FileLogger"
            prefix="apache_log." suffix=".txt"
            timestamp="true"/>

  </Engine>

</Service>

</Server>

and have web.xml in bmi webapp configured like this:

<security-constraint>
    <display-name>Bandwidth Management Interface</display-name>
    <web-resource-collection>
       <web-resource-name>Bandwidth Manager</web-resource-name>
<!-- Define the context-relative URL(s) to be protected -->
       <url-pattern>/*</url-pattern>
<!-- If you list http methods, only those methods are protected
<http-method>DELETE</http-method>
       <http-method>GET</http-method>
       <http-method>POST</http-method>
<http-method>PUT</http-method>
-->
    </web-resource-collection>
    <auth-constraint>
       <!-- Anyone with one of the listed roles may access this area -->
       <role-name>SU</role-name>
<role-name>R</role-name>
<role-name>RW</role-name>
    </auth-constraint>
  </security-constraint>


Beth Anne Lambrechts
Cross Fire Labs, Inc.
e-mail: [EMAIL PROTECTED]
Phone/Fax: 703-724-9210


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>