tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Angus Mezick" <amez...@guidestar.org>
Subject RE: Can I set up 2 realms for the same server so I can access 2 databases
Date Wed, 18 Jun 2003 18:48:33 GMT
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:vtobin@realityclick.com] 
> 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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message