Sean - I didn't omit anything in my post - the serverl.xml is as it is in my app. I 
think you might have inadvertently answered my question, does my context level realm 
physically have to reside inside the context tag? (do I have to put a </context> on 
after the realm)? I manager to get everything working, it is authenticating the 
manager app against the database fine now, and the lower level authentication works as 
well, I am not sure which realm is being used where, I am going to create a new 
database and see that it is working right.


Thanks for the reply!!

Geoff

-----Original Message-----
From: Sean Dockery [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 8:34 PM
To: Tomcat Users List
Subject: Re: JDBC Realm Authentication Problem


Where I wrote "did you remove," I meant to write "did you omit."  Basically 
I want to know exactly what you edited out of the server.xml file that you 
put in your message because you didn't think it was relevant.

Basically, I suspect that if you left the memory realm at the engine level 
that authentication is failing against the memory realm (so it doesn't 
bother checking your JDBC realm at the engine level).

At 17:27 2003-02-06 -0700, you wrote:
>Um.  I don't see a context-level realm in there.  There is a host-level 
>realm, however.  :-)
>
>Did you remove anything at all (such as other Realms) from the server.xml 
>file that you presented?
>
>At 13:29 2003-02-06 -0400, you wrote:
>>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]
>
>Sean Dockery
>[EMAIL PROTECTED]
>Certified Java Web Component Developer
>Certified Delphi Programmer
>SBD Consultants
>http://www.sbdconsultants.com
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]

Sean Dockery
[EMAIL PROTECTED]
Certified Java Web Component Developer
Certified Delphi Programmer
SBD Consultants
http://www.sbdconsultants.com



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


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

Reply via email to