Return-Path: 
 <tomcat-user-return-68381-qmlist-jakarta-archive-tomcat-user=nagoya.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org
Received: (qmail 88241 invoked from network); 18 Jun 2003 18:48:46 -0000
Received: from exchange.sun.com (192.18.33.10)
  by daedalus.apache.org with SMTP; 18 Jun 2003 18:48:46 -0000
Received: (qmail 28359 invoked by uid 97); 18 Jun 2003 18:51:09 -0000
Delivered-To: qmlist-jakarta-archive-tomcat-user@nagoya.betaversion.org
Received: (qmail 28352 invoked from network); 18 Jun 2003 18:51:09 -0000
Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12)
  by nagoya.betaversion.org with SMTP; 18 Jun 2003 18:51:09 -0000
Received: (qmail 86843 invoked by uid 500); 18 Jun 2003 18:48:30 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 86823 invoked from network); 18 Jun 2003 18:48:29 -0000
Received: from unknown (HELO wbmail.guidestar.org) (209.96.199.2)
  by daedalus.apache.org with SMTP; 18 Jun 2003 18:48:29 -0000
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0
Subject: RE: Can I set up 2 realms for the same server so I can access 2
 databases
Date: Wed, 18 Jun 2003 14:48:33 -0400
Message-ID: <24A8596C44DF4F4DA442CBE269C351BDBADFF4@wbmail.guidestar.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Can I set up 2 realms for the same server so I can access 2
 databases
Thread-Index: AcM1yR0n2m4T87R+SoOi0uHemBm6nwAAPsNg
From: "Angus Mezick" <amezick@guidestar.org>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

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]=20
> 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=20
> access 2 databases
>=20
>=20
> Hi,
>=20
> I've got two sites set up on one server, and I am trying to=20
> set up security
> for each of them.  They use 2 different databases.  Is it=20
> possible to set
> things up in the server.xml the way I have below, or do I=20
> have to put all
> users in the same database?  I can't find anything on the Web=20
> that deals
> with this issue.
>=20
> <Realm roleNameCol=3D"RoleID" userCredCol=3D"Password"
> className=3D"org.apache.catalina.realm.JDBCRealm"
>               userTable=3D"tblUSERS" debug=3D"99"
>           userRoleTable=3D"tblUSERROLES" userNameCol=3D"Username"
>=20
> connectionURL=3D"jdbc:mysql://localhost/DB1?user=3DMyName&amp;pass
> word=3DMyPW"
>              driverName=3D"com.mysql.jdbc.Driver" />
>=20
>   <Realm roleNameCol=3D"RoleID" userCredCol=3D"Password"
> className=3D"org.apache.catalina.realm.JDBCRealm"
>               userTable=3D"tblUSERS" debug=3D"99"
>           userRoleTable=3D"tblUSERROLES" userNameCol=3D"Username"
>=20
> connectionURL=3D"jdbc:mysql://localhost/DB2?user=3DMyName&amp;pass
> word=3DMyPW"
>              driverName=3D"com.mysql.jdbc.Driver" />
>=20
> Thank you for any help.
>=20
> Val
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>=20
>=20

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