RE: Can I set up 2 realms for the same server so I can access 2 databases

[Angus Mezick]

According to the spec, you can have 0 or 1 realms configured.  Now, if
you want to rewrite the code that uses the realms for logging people in
I think you can use 2 DB's.

> -----Original Message-----
> From: Val T. [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, June 18, 2003 2:40 PM
> To: Tomcat Users List
> Subject: Can I set up 2 realms for the same server so I can 
> access 2 databases
> 
> 
> Hi,
> 
> I've got two sites set up on one server, and I am trying to 
> set up security
> for each of them.  They use 2 different databases.  Is it 
> possible to set
> things up in the server.xml the way I have below, or do I 
> have to put all
> users in the same database?  I can't find anything on the Web 
> that deals
> with this issue.
> 
> <Realm roleNameCol="RoleID" userCredCol="Password"
> className="org.apache.catalina.realm.JDBCRealm"
>               userTable="tblUSERS" debug="99"
>           userRoleTable="tblUSERROLES" userNameCol="Username"
> 
> connectionURL="jdbc:mysql://localhost/DB1?user=MyName&amp;pass
> word=MyPW"
>              driverName="com.mysql.jdbc.Driver" />
> 
>   <Realm roleNameCol="RoleID" userCredCol="Password"
> className="org.apache.catalina.realm.JDBCRealm"
>               userTable="tblUSERS" debug="99"
>           userRoleTable="tblUSERROLES" userNameCol="Username"
> 
> connectionURL="jdbc:mysql://localhost/DB2?user=MyName&amp;pass
> word=MyPW"
>              driverName="com.mysql.jdbc.Driver" />
> 
> Thank you for any help.
> 
> Val
> 
> 
> ---------------------------------------------------------------------
> 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]