JDBC Realm Authentication Problem

[Geoff Peters]

A small problem here, can't seem to figure out why. 

In the following server.xml, if I remove the context level realm, the authentication 
fails against the database (I can connect on startup, but I cannot authenticate to 
access the manager or admin applications). However, if I put the context level JDBC 
realm back in (exactly the same as the top level realm)

Removing the top level realm makes no difference on startup or authentication. 
Shouldn't I be able to authenticate for the manager and admin outside of a contect 
level database?


Thanks!!

Geoff


SERVER.XML:

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

  <Service name="Tomcat-Standalone">

   

    <Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
        port="80" minProcessors="5" maxProcessors="75"
               enableLookups="true" redirectPort="8443"
               acceptCount="100" debug="0" connectionTimeout="20000"
               useURIValidationHack="false" disableUploadTimeout="true" />

 
    <Engine name="Standalone" defaultHost="localhost" debug="0">


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

                  
     <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
                  driverName="org.gjt.mm.mysql.Driver"
               connectionURL="jdbc:mysql://somewhere.com/MailAdmn"
          connectionName="user" connectionPassword="password"
            userTable="tblUsers" userNameCol="user_name" userCredCol="user_pass"
          userRoleTable="tblUser_Role" roleNameCol="role_name" digest = "md5"/>
      
  
  <Host name="localhost" debug="0" appBase="webapps" unpackWARs="true" 
autoDeploy="true">

       
       <Valve className="org.apache.catalina.valves.AccessLogValve"
                 directory="logs"  prefix="gpeters_access_log." suffix=".txt"
                 pattern="common" resolveHosts="false"/>
        
        <Logger className="org.apache.catalina.logger.FileLogger"
                 directory="logs"  prefix="gpeters_log." suffix=".txt"
                timestamp="true"/>
     
          <Context path="" docBase="ROOT" debug="99"/>
      
      
                <Context path="/Mail" docBase="Mail" debug="99"
                  reloadable="true" crossContext="true" />
                  
                <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
                 driverName="org.gjt.mm.mysql.Driver"
                        connectionURL="jdbc:mysql://somewhere.com/MailAdmn"
                connectionName="user" connectionPassword="password"  
userTable="tblUsers" userNameCol="user_name"                       
userCredCol="user_pass"
                        userRoleTable="tblUser_Role" roleNameCol="role_name" digest = 
"md5"/>
     
                  
                 <Logger className="org.apache.catalina.logger.FileLogger"
                  prefix="tomcat_MailApp_log." suffix=".txt" timestamp="true" /> 


      </Host>

    </Engine>

  </Service>

</Server>


Geoff Peters, BScFE, AIT      Phone  : (441) 296-9640
Applications Developer        Fax    : (441) 292-1509
Logic Communications          E-mail : [EMAIL PROTECTED]
12 Par-La-Ville Road          WWW    : http://www.logic.bm
Hamilton, Bermuda  HM JX


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]