Re: Difficulties getting JDBCRealm to work with MySQL driver

[Craig R. McClanahan]

[EMAIL PROTECTED] wrote:

> Thanks Ignacio!
>
> The realm specification in server.xml now reads:
>
> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
>              driverName="org.gjt.mm.mysql.Driver"
>           connectionURL="jdbc:mysql://localhost/authority?user=root&amp;
> password=apassword"
>               userTable="User" userNameCol="uname" userCredCol="password"
>           userRoleTable="UserRoles" roleNameCol="rname" />
>
> and it works.
>
> However the main reason for me to migrate to tomcat4 at this moment is the
> ability to specify a JDBC realm per webapp.
> I tried to move the Realm tag above to a web.xml file but got the following
> error:
>
> org.xml.sax.SAXParseException: Element "web-app" does not allow "Realm" here.
>

The <Realm> element goes in server.xml, not in web.xml.  You need to
nest it inside
a <Context> element for your webapp:

    <Context path="/myapp" docBase="..." ...>
        <Realm .../>
    </Context>

>
> I checked $TOMCAT/conf/web_23.dtd and there is no mention of a realm tag indeed.
>
> Do you have a suggestion on how to proceed?
>
> Thanks,
>
> Wilko
>

Craig McClanahan

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