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:52:56 GMT
Yup, as I read further, it looks like you would need to write your own
realm class that will talk to both DB's for you.  Sounds like a mess.
--Angus

> -----Original Message-----
> From: Angus Mezick 
> Sent: Wednesday, June 18, 2003 2:49 PM
> To: Tomcat Users List
> Subject: RE: Can I set up 2 realms for the same server so I 
> can access 2 databases
> 
> 
> 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
> 
> 

---------------------------------------------------------------------
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