Postgres JDBCRealms : Tomcat-4.0.1

2002-05-09 Thread Grant Edwards

Hi,

I am having a bit of trouble getting my Postgres JDBCRealm correctly 
configured.
If I start up my combined JBoss-2.4.4_Tomcat-4.0.1 stack, I am able to get a 
connection to the DB and all is ok. Running the following command also works 
fine : /usr/local/pgsql/bin/psql -h localhost -U userName -W testDB.


The exception (see below) occurs when I try and run Tomcat by itself.

Does the config for the JDBCRealm look correct ?

Realm  className=org.apache.catalina.realm.JDBCRealm debug=99
driverName=org.postgresql.Driver

connectionURL=jdbc:postgresql://localhost.localdomain:5432/testDB
connectionName=userName
connectionPassword=password
userTable=users
userNameCol=user_name
userCredCol=user_pass
userRoleTable=user_roles
roleNameCol=role_name /


[gedwards@localhost bin]$ ./catalina.sh run -security
Guessing CATALINA_HOME from catalina.sh to ./..
Setting CATALINA_HOME to ./..
./../bin/bootstrap.jar
Using CLASSPATH: 
./../bin/bootstrap.jar:/home/gedwards/usr/local/postgresql-7.2/src/interfaces/jdbc/jars/postgresql.jar:/home/gedwards/usr/local/jdk1.3.1_01/lib/tools.jar
Using CATALINA_BASE: ./..
Using CATALINA_HOME: ./..
Using JAVA_HOME: /home/gedwards/usr/local/jdk1.3.1_01
Using Security Manager
Starting service Tomcat-Standalone
Apache Tomcat/4.0.1
Catalina.start: LifecycleException:  Exception opening database connection:  
Something unusual has occured to cause the driver to fail. Please report 
this exception: Exception: java.security.AccessControlException: access 
denied (java.net.SocketPermission localhost.localdomain resolve)
Stack Trace:

java.security.AccessControlException: access denied 
(java.net.SocketPermission localhost.localdomain resolve)
at 
java.security.AccessControlContext.checkPermission(AccessControlContext.java:272)
at 
java.security.AccessController.checkPermission(AccessController.java:399)
at 
java.lang.SecurityManager.checkPermission(SecurityManager.java:545)
at java.lang.SecurityManager.checkConnect(SecurityManager.java:1042)
at java.net.InetAddress.getAllByName0(InetAddress.java:559)
at java.net.InetAddress.getAllByName0(InetAddress.java:540)
at java.net.InetAddress.getByName(InetAddress.java:449)
at java.net.Socket.init(Socket.java:100)
at org.postgresql.PG_Stream.init(Unknown Source)
at org.postgresql.Connection.openConnection(Unknown Source)
at org.postgresql.Driver.connect(Unknown Source)
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613)
at 
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
at 
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307)
at 
org.apache.catalina.core.StandardService.start(StandardService.java:388)
at 
org.apache.catalina.core.StandardServer.start(StandardServer.java:505)
at org.apache.catalina.startup.Catalina.start(Catalina.java:776)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
End of Stack Trace



Many thanks

Regards

Grant E

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


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




Re: Postgres JDBCRealms : Tomcat-4.0.1

2002-05-09 Thread James Williamson

Grant,

The stack trace tells you exactly what's going wrong,
you need to relax the security regarding opening sockets.
Modify the catalina.policy file in your conf directory.

Regards,

James Williamson
www.nameonthe.net
UK Tomcat Hosting

- Original Message -
From: Grant Edwards [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 10:09 PM
Subject: Postgres JDBCRealms : Tomcat-4.0.1


 Hi,

 I am having a bit of trouble getting my Postgres JDBCRealm correctly
 configured.
 If I start up my combined JBoss-2.4.4_Tomcat-4.0.1 stack, I am able to get
a
 connection to the DB and all is ok. Running the following command also
works
 fine : /usr/local/pgsql/bin/psql -h localhost -U userName -W testDB.


 The exception (see below) occurs when I try and run Tomcat by itself.

 Does the config for the JDBCRealm look correct ?

 Realm  className=org.apache.catalina.realm.JDBCRealm debug=99
 driverName=org.postgresql.Driver

 connectionURL=jdbc:postgresql://localhost.localdomain:5432/testDB
 connectionName=userName
 connectionPassword=password
 userTable=users
 userNameCol=user_name
 userCredCol=user_pass
 userRoleTable=user_roles
 roleNameCol=role_name /


 [gedwards@localhost bin]$ ./catalina.sh run -security
 Guessing CATALINA_HOME from catalina.sh to ./..
 Setting CATALINA_HOME to ./..
 ./../bin/bootstrap.jar
 Using CLASSPATH:

./../bin/bootstrap.jar:/home/gedwards/usr/local/postgresql-7.2/src/interface
s/jdbc/jars/postgresql.jar:/home/gedwards/usr/local/jdk1.3.1_01/lib/tools.ja
r
 Using CATALINA_BASE: ./..
 Using CATALINA_HOME: ./..
 Using JAVA_HOME: /home/gedwards/usr/local/jdk1.3.1_01
 Using Security Manager
 Starting service Tomcat-Standalone
 Apache Tomcat/4.0.1
 Catalina.start: LifecycleException:  Exception opening database
connection:
 Something unusual has occured to cause the driver to fail. Please report
 this exception: Exception: java.security.AccessControlException: access
 denied (java.net.SocketPermission localhost.localdomain resolve)
 Stack Trace:

 java.security.AccessControlException: access denied
 (java.net.SocketPermission localhost.localdomain resolve)
 at

java.security.AccessControlContext.checkPermission(AccessControlContext.java
:272)
 at
 java.security.AccessController.checkPermission(AccessController.java:399)
 at
 java.lang.SecurityManager.checkPermission(SecurityManager.java:545)
 at
java.lang.SecurityManager.checkConnect(SecurityManager.java:1042)
 at java.net.InetAddress.getAllByName0(InetAddress.java:559)
 at java.net.InetAddress.getAllByName0(InetAddress.java:540)
 at java.net.InetAddress.getByName(InetAddress.java:449)
 at java.net.Socket.init(Socket.java:100)
 at org.postgresql.PG_Stream.init(Unknown Source)
 at org.postgresql.Connection.openConnection(Unknown Source)
 at org.postgresql.Driver.connect(Unknown Source)
 at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548)
 at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613)
 at
 org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
 at
 org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307)
 at
 org.apache.catalina.core.StandardService.start(StandardService.java:388)
 at
 org.apache.catalina.core.StandardServer.start(StandardServer.java:505)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:776)
 at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
 at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
 at java.lang.reflect.Method.invoke(Native Method)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
 End of Stack Trace



 Many thanks

 Regards

 Grant E

 _
 Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp.


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



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




Re: Interbase/Interclient JDBCRealms in Tomcat 4.0.1?

2001-11-12 Thread raj

I am using Interbase with apache 4.0.1 and Interclient (the Java JDBC 
driver) and it all works very well with FORM based authentication on a 
LINUX box.

This is from my posting on the news group 
borland.public.interbase.general to a post headed Interclient JDK1.3:

--start-
nicolaas [EMAIL PROTECTED] wrote in message 
news:3be7b882_2@dnews...
  i can't get a connection to my database using Interclient in a JDK 1.3
  envirnment, what is the problem, please help
 
  regards
  nic

If your server is 6.0.1 then you must use a JDK1.3 compiled version of
InterClient.

If not then, visit http://www.ibphoenix.com/ibp_interbase_download.html
to download (uncertified version of ) InterBase V6.01 Release (for
your platform)

The best way to secure a jdk1.3 compliant InterClient is to register
with Borland, complete the survey etc,
and download the distributions (you get a SOLARIS, LINUX and WINDOWS
tar.gz/zip file(s)).
For this visit http://www.borland.com/interbase/downloads/

These distributions has a version of InterClient which is jdk 1.3
compliant and it works!!.

Unfortunately the server (certified) v6.0.1 that comes for LINUX with
this Borland download is corrupt
(no licence file found etc are some of the errors), hence the pointer
to the above uncertified version.
end---


Hope this helps.

Cheers
-raj


--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]




RE: Using JDBCRealms

2001-05-29 Thread Ben Sifuentes

I'm trying to utilize teh JDBCRealm also. I see you are trying to get some
of the same information I am. Did you get a response for your previos e-mail

-Ben

-Original Message-
From: William Kaufman [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 8:05 PM
To: Tomcat Users (E-mail)
Subject: Using JDBCRealms


(Tomcat version 3.2.1.)

I'm trying to use JDBCRealm to manage access to some static files.  Is there
any documentation for that?

I've successfully configured authorization in web.xml (though it only seems
to work if the files are under webapps/ROOT--that's OK for what I'm doing,
but I am curious about why that is).

But I can't seem to get JDBCRealm (or my own subclass of that) to get
called.  I've added,

RequestInterceptor
className=org.apache.tomcat.request.JDBCRealm
debug=99
driverName=oracle.jdbc.driver.OracleDriver
connectionURL=jdbc:oracle:thin:@localhost:1521:adb
connectionName=metax
connectionPassword=tiger
userTable=contacts
userNameCol=username
userCredCol=password
userRoleTable=user_roles
roleNameCol=role /

to my conf\server.xml, and commented out the SimpleRealm interceptor.
JDBCRealm is on my classpath--javap can print it.  And that JDBC
connection works fine outside of JDBCRealms, so it's not a JDBC issue.

Near as I can figure, Tomcat isn't even loading the class.  Is there some
debugging I can turn on in Tomcat to see what's going wrong?

-- Bill K.




RE: Using JDBCRealms

2001-05-29 Thread William Kaufman

It turned out I was being an idiot: I modified tomcat/conf/server.xml, where
our batch file was actually executing Tomcat with -f
/some/where/else/server.xml.  Once I put it in the right file, everything
worked fine, so I don't know how much help my responses would be.  (You
could look through the archives at one of,

http://tomcat.mslinn.com/
http://marc.theaimsgroup.com/?l=tomcat-userr=1w=2

Maybe you should post the problem(s) you're having, and whatever debug info
you're getting,...

-- Bill K.


 -Original Message-
 From: Ben Sifuentes [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, May 29, 2001 7:49 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Using JDBCRealms
 
 
 I'm trying to utilize teh JDBCRealm also. I see you are 
 trying to get some
 of the same information I am. Did you get a response for your 
 previos e-mail
 
 -Ben
 
 -Original Message-
 From: William Kaufman [mailto:[EMAIL PROTECTED]]
 Sent: Friday, March 16, 2001 8:05 PM
 To: Tomcat Users (E-mail)
 Subject: Using JDBCRealms
 
 
 (Tomcat version 3.2.1.)
 
 I'm trying to use JDBCRealm to manage access to some static 
 files.  Is there
 any documentation for that?
 
 I've successfully configured authorization in web.xml (though 
 it only seems
 to work if the files are under webapps/ROOT--that's OK for 
 what I'm doing,
 but I am curious about why that is).
 
 But I can't seem to get JDBCRealm (or my own subclass of that) to get
 called.  I've added,
 
 RequestInterceptor
 className=org.apache.tomcat.request.JDBCRealm
 debug=99
 driverName=oracle.jdbc.driver.OracleDriver
 connectionURL=jdbc:oracle:thin:@localhost:1521:adb
 connectionName=metax
 connectionPassword=tiger
 userTable=contacts
 userNameCol=username
 userCredCol=password
 userRoleTable=user_roles
 roleNameCol=role /
 
 to my conf\server.xml, and commented out the SimpleRealm interceptor.
 JDBCRealm is on my classpath--javap can print it.  And that JDBC
 connection works fine outside of JDBCRealms, so it's not a JDBC issue.
 
 Near as I can figure, Tomcat isn't even loading the class.  
 Is there some
 debugging I can turn on in Tomcat to see what's going wrong?
 
 -- Bill K.
 



JDBCRealms Question

2001-05-08 Thread Darin Wilcox

I know it is possible to authenticate users using JDBCRealms.  However, is it possible 
to use the information from the login page in the succeeding pages?  For instance, 
only certain information is available to those with the status of user... and certain 
information is available to those with the status of administrator?

I thought of using the http headers, but it pulls from the requesting page and not 
from the login page.  Any ideas?

Thanks,
- D

-
Darin Wilcox
Web Engineer
College of Nursing
University of Utah
585-7332




Re: JDBCRealms Question

2001-05-08 Thread Jeff Kilbride

If you are trying to get the user's login info, you should look at the
following methods of the request object:

getRemoteUser()
getUserPrincipal()
isUserInRole()

--jeff

- Original Message -
From: Darin Wilcox [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 08, 2001 5:05 AM
Subject: JDBCRealms Question


 I know it is possible to authenticate users using JDBCRealms.  However, is
it possible to use the information from the login page in the succeeding
pages?  For instance, only certain information is available to those with
the status of user... and certain information is available to those with the
status of administrator?

 I thought of using the http headers, but it pulls from the requesting page
and not from the login page.  Any ideas?

 Thanks,
 - D

 -
 Darin Wilcox
 Web Engineer
 College of Nursing
 University of Utah
 585-7332





Multiple JDBCRealms

2001-05-04 Thread Nathan Coast

(sorry if this is a repost, mail is playing up)

Hi,

I've got two contexts within my tomcat install.  I want the login for each 
context to go to different databases / tables for authentication.  Is it 
possible to configure different contexts to send authentication requests to 
different places?  Is this done by having multiple ContextManager elements 
defined in server.xml?

Cheers
Nathan




Authentication with JDBC but without JDBCRealms

2001-04-17 Thread João Folha



Hi there, i need some inspiration 
here.
I want my application to be independent of 
JDBCRealms, any example.

I don´t know how to protect the resources from de 
web.xml file.

HELP


Re: Authentication with JDBC but without JDBCRealms

2001-04-17 Thread Torgeir Veimo

Joo Folha wrote:
 
 Hi there, i need some inspiration here.
 I want my application to be independent of JDBCRealms, any example.
 
 I dont know how to protect the resources from de web.xml file.

You mean you want to use container based authentication, ie. a *Realm,
but to specify the details in the web.xml file?

This is not supported, the Realm can only specified in the server.xml
file, and be shared among all Context's.

-- 
- Torgeir



Re: Authentication with JDBC but without JDBCRealms

2001-04-17 Thread João Folha

Thanks for your anwer.

I know that, but The security constrains on the web.xml, will make some
diference on the behaviour of the *Realm.

But what i really want is new "Realm" made by myself so my application
doenst be tomcat dependent

- Original Message -
From: "Torgeir Veimo" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 5:30 PM
Subject: Re: Authentication with JDBC but without JDBCRealms


 Joo Folha wrote:
 
  Hi there, i need some inspiration here.
  I want my application to be independent of JDBCRealms, any example.
 
  I dont know how to protect the resources from de web.xml file.

 You mean you want to use container based authentication, ie. a *Realm,
 but to specify the details in the web.xml file?

 This is not supported, the Realm can only specified in the server.xml
 file, and be shared among all Context's.

 --
 - Torgeir



JDBCRealms

2001-04-12 Thread Leon Palermo

Hello,

I have set up my database tables and the appropriate RequestInterceptor in
my server.xml file.  Can someone show me an example of what should be in the
web.xml file (including roles) to utilize the JDBCRealm?  Thanks in advance!

Leon Palermo




JDBCRealms

2001-04-12 Thread Leon Palermo

Hello,

I have set up my database tables and the appropriate RequestInterceptor in
my server.xml file.  Can someone show me an example of what should be in the
web.xml file (including roles) to utilize the JDBCRealm?  Thanks in advance!

Leon Palermo





RE: JDBCRealms

2001-04-12 Thread Ricardo Gladwell

To secure you web application you need to add the following sequence to the
web.xml file for the web application you want to secure, amended for your
own needs:

security-constraint

web-resource-collection
web-resource-nameIntranet/web-resource-name
url-pattern/*/url-pattern
/web-resource-collection

auth-constraint
role-nameIntranetUser/role-name
/auth-constraint

/security-constraint

login-config
auth-methodBASIC/auth-method
realm-nameUBQT Media Intranet/realm-name
/login-config

The web-resource-collection details the areas and access points of your
application you wish to secure. The web-resource-name *appears* to be just
an identifier for the particular web-resource, but with documentation for
this feature being very thin on the ground it's dificult to say for sure.
The url-pattern tag allows you to specify wildcard filters to determine
which files are to be secured. For example,
url-pattern/*.jsp/url-pattern will only ask for authentication for your
JSP files. You may also add http-method tags to limit authentication to
specific HTTP methods, such as GET or POST. By default all HTTP methods will
be authenticated.

The auth-constraint specifies the authentication constraints on users. For
example, the role-name tags allows you to specify that only users that
members of certain roles have access.

Finally, the login-config group allows you specify the authentication
method (which must be either BASIC or FORM). The realm-name tag allows you
specify the domain/realm name that will appear in the password dialog for
the client.

Hope that was helpful, yours...

--
Ricardo Gladwell
UBQT Media PLC, Windsor
Mobile: (07779) 841 444

 -Original Message-
 From: Leon Palermo [mailto:[EMAIL PROTECTED]]
 Sent: 12 April 2001 15:00
 To: [EMAIL PROTECTED]
 Subject: JDBCRealms


 Hello,

 I have set up my database tables and the appropriate RequestInterceptor in
 my server.xml file.  Can someone show me an example of what
 should be in the
 web.xml file (including roles) to utilize the JDBCRealm?  Thanks
 in advance!

 Leon Palermo





JDBCRealms

2001-03-29 Thread Darin Wilcox

Can anyone give me a descriptive explanation of what JDBCRealms?  I think it is what I 
want to use, but I haven't yet figured out if it is correct.

Thanks.

-
Darin Wilcox
Web Engineer
College of Nursing
University of Utah
585-7332




RE: JDBCRealms

2001-03-29 Thread William Kaufman

http://jakarta.apache.org/tomcat/jakarta-tomcat/src/doc/JDBCRealm.howto

Is there something you want to know that isn't in there?


-- Bill K.


 -Original Message-
 From: Darin Wilcox [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, March 29, 2001 3:54 PM
 To: [EMAIL PROTECTED]
 Subject: JDBCRealms
 
 
 Can anyone give me a descriptive explanation of what 
 JDBCRealms?  I think it is what I want to use, but I haven't 
 yet figured out if it is correct.
 
 Thanks.
 
 -
 Darin Wilcox
 Web Engineer
 College of Nursing
 University of Utah
 585-7332
 



Re: JDBCRealms

2001-03-29 Thread Jeff Kilbride

It's a way to authenticate users and roles via JDBC by configuring your
server.xml file.

Check this out:

http://jakarta.apache.org/tomcat/jakarta-tomcat/src/doc/JDBCRealm.howto

--jeff

- Original Message -
From: "Darin Wilcox" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 29, 2001 3:53 PM
Subject: JDBCRealms


 Can anyone give me a descriptive explanation of what JDBCRealms?  I think
it is what I want to use, but I haven't yet figured out if it is correct.

 Thanks.

 -
 Darin Wilcox
 Web Engineer
 College of Nursing
 University of Utah
 585-7332





RE: Using JDBCRealms

2001-03-20 Thread Ignacio J. Ortega

Do you have any logs?

Which URL are trying?

Which is your context directoy struct ?

TIA

Saludos ,
Ignacio J. Ortega


 -Mensaje original-
 De: William Kaufman [mailto:[EMAIL PROTECTED]]
 Enviado el: martes 20 de marzo de 2001 1:11
 Para: '[EMAIL PROTECTED]'
 Asunto: Using JDBCRealms
 
 
 (I posted this before, but I haven't seen any responses.  
 I've added some
 more information.)
 
 (Tomcat version 3.2.1.)
 
 I'm trying to use JDBCRealm to manage access to some static files.  Is
 there any documentation for that?
 
 I've successfully configured authorization in web.xml:
 
 security-constraint
   web-resource-collection
 web-resource-nameProtected Area/web-resource-name
 url-pattern/help/*/url-pattern
   user-data-constraint
 transport-guaranteeNONE/transport-guarantee
   /user-data-constraint
 http-methodGET/http-method
 http-methodPUT/http-method
 http-methodPOST/http-method
 http-methodDELETE/http-method
   /web-resource-collection
   auth-constraint
 role-nameViquityUser/role-name
   /auth-constraint
 /security-constraint
 login-config
   auth-methodBASIC/auth-method
   realm-nameViquity/realm-name
 /login-config
 
 But I can't seem to get JDBCRealm (or my own subclass of that) to get
 called.  I've added,
 
 RequestInterceptor 
 className="org.apache.tomcat.request.JDBCRealm" 
 debug="99" 
 driverName="oracle.jdbc.driver.OracleDriver"
 connectionURL="jdbc:oracle:thin:@localhost:1521:adb"
 connectionName="metax"
 connectionPassword="tiger"
 userTable="contacts" 
 userNameCol="username" 
 userCredCol="password" 
 userRoleTable="user_roles" 
 roleNameCol="role" /
 
 to my conf\server.xml, and commented out the SimpleRealm interceptor.
 JDBCRealm is on my classpath--"javap" can print it.  And that JDBC
 connection works fine outside of Tomcat, so it's not a JDBC issue.
 
 Near as I can figure, Tomcat isn't even loading the class.  Is there
 some debugging I can turn on in Tomcat to see what's going wrong?
 
 -- Bill K.
 



RE: Using JDBCRealms

2001-03-20 Thread William Kaufman

 Do you have any logs?

Nothing useful.  Is there some debugging flag(s) I can turn on for this?

 Which URL are trying?

On my local machine: http://localhost:8089/help/AboutVqt.htm .  The password
dialog does come up, but it only tests the tomcat-users.xml file, not the
JDBCRealm database table.

 Which is your context directoy struct ?

...\tomcat\webapps\ROOT\
WEB-INF\
web.xml
help\
AboutVqt.htm

plus the usual Tomcat demo stuff.
-- Bill K.


 -Original Message-
 From: Ignacio J. Ortega [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, March 20, 2001 3:11 AM
 To: '[EMAIL PROTECTED]'
 Subject: RE: Using JDBCRealms
 
 
 Do you have any logs?
 
 Which URL are trying?
 
 Which is your context directoy struct ?
 
 TIA
 
 Saludos ,
 Ignacio J. Ortega
 
 
  -Mensaje original-
  De: William Kaufman [mailto:[EMAIL PROTECTED]]
  Enviado el: martes 20 de marzo de 2001 1:11
  Para: '[EMAIL PROTECTED]'
  Asunto: Using JDBCRealms
  
  
  (I posted this before, but I haven't seen any responses.  
  I've added some
  more information.)
  
  (Tomcat version 3.2.1.)
  
  I'm trying to use JDBCRealm to manage access to some static 
 files.  Is
  there any documentation for that?
  
  I've successfully configured authorization in web.xml:
  
  security-constraint
web-resource-collection
  web-resource-nameProtected Area/web-resource-name
  url-pattern/help/*/url-pattern
user-data-constraint
  transport-guaranteeNONE/transport-guarantee
/user-data-constraint
  http-methodGET/http-method
  http-methodPUT/http-method
  http-methodPOST/http-method
  http-methodDELETE/http-method
/web-resource-collection
auth-constraint
  role-nameViquityUser/role-name
/auth-constraint
  /security-constraint
  login-config
auth-methodBASIC/auth-method
realm-nameViquity/realm-name
  /login-config
  
  But I can't seem to get JDBCRealm (or my own subclass of 
 that) to get
  called.  I've added,
  
  RequestInterceptor 
  className="org.apache.tomcat.request.JDBCRealm" 
  debug="99" 
  driverName="oracle.jdbc.driver.OracleDriver"
  connectionURL="jdbc:oracle:thin:@localhost:1521:adb"
  connectionName="metax"
  connectionPassword="tiger"
  userTable="contacts" 
  userNameCol="username" 
  userCredCol="password" 
  userRoleTable="user_roles" 
  roleNameCol="role" /
  
  to my conf\server.xml, and commented out the SimpleRealm 
 interceptor.
  JDBCRealm is on my classpath--"javap" can print it.  And that JDBC
  connection works fine outside of Tomcat, so it's not a JDBC issue.
  
  Near as I can figure, Tomcat isn't even loading the class.  Is there
  some debugging I can turn on in Tomcat to see what's going wrong?
  
  
 -- Bill K.
  
 



RE: Using JDBCRealms

2001-03-20 Thread Ignacio J. Ortega

Did you delete or comment the SimpleRealm Interceptor?

If not this can be the problem..

Saludos ,
Ignacio J. Ortega


 -Mensaje original-
 De: William Kaufman [mailto:[EMAIL PROTECTED]]
 Enviado el: martes 20 de marzo de 2001 19:46
 Para: '[EMAIL PROTECTED]'
 Asunto: RE: Using JDBCRealms
 
 
  Do you have any logs?
 
 Nothing useful.  Is there some debugging flag(s) I can turn 
 on for this?
 
  Which URL are trying?
 
 On my local machine: http://localhost:8089/help/AboutVqt.htm 
 .  The password
 dialog does come up, but it only tests the tomcat-users.xml 
 file, not the
 JDBCRealm database table.
 
  Which is your context directoy struct ?
 
 ...\tomcat\webapps\ROOT\
 WEB-INF\
 web.xml
 help\
 AboutVqt.htm
 
 plus the usual Tomcat demo stuff.
 -- Bill K.
 
 
  -Original Message-
  From: Ignacio J. Ortega [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, March 20, 2001 3:11 AM
  To: '[EMAIL PROTECTED]'
  Subject: RE: Using JDBCRealms
  
  
  Do you have any logs?
  
  Which URL are trying?
  
  Which is your context directoy struct ?
  
  TIA
  
  Saludos ,
  Ignacio J. Ortega
  
  
   -Mensaje original-
   De: William Kaufman [mailto:[EMAIL PROTECTED]]
   Enviado el: martes 20 de marzo de 2001 1:11
   Para: '[EMAIL PROTECTED]'
   Asunto: Using JDBCRealms
   
   
   (I posted this before, but I haven't seen any responses.  
   I've added some
   more information.)
   
   (Tomcat version 3.2.1.)
   
   I'm trying to use JDBCRealm to manage access to some static 
  files.  Is
   there any documentation for that?
   
   I've successfully configured authorization in web.xml:
   
   security-constraint
 web-resource-collection
   web-resource-nameProtected Area/web-resource-name
   url-pattern/help/*/url-pattern
 user-data-constraint
   transport-guaranteeNONE/transport-guarantee
 /user-data-constraint
   http-methodGET/http-method
   http-methodPUT/http-method
   http-methodPOST/http-method
   http-methodDELETE/http-method
 /web-resource-collection
 auth-constraint
   role-nameViquityUser/role-name
 /auth-constraint
   /security-constraint
   login-config
 auth-methodBASIC/auth-method
 realm-nameViquity/realm-name
   /login-config
   
   But I can't seem to get JDBCRealm (or my own subclass of 
  that) to get
   called.  I've added,
   
   RequestInterceptor 
   className="org.apache.tomcat.request.JDBCRealm" 
   debug="99" 
   driverName="oracle.jdbc.driver.OracleDriver"
   connectionURL="jdbc:oracle:thin:@localhost:1521:adb"
   connectionName="metax"
   connectionPassword="tiger"
   userTable="contacts" 
   userNameCol="username" 
   userCredCol="password" 
   userRoleTable="user_roles" 
   roleNameCol="role" /
   
   to my conf\server.xml, and commented out the SimpleRealm 
  interceptor.
   JDBCRealm is on my classpath--"javap" can print it.  And that JDBC
   connection works fine outside of Tomcat, so it's not a JDBC issue.
   
   Near as I can figure, Tomcat isn't even loading the 
 class.  Is there
   some debugging I can turn on in Tomcat to see what's going wrong?
   
   
  -- Bill K.
   
  
 



Using JDBCRealms

2001-03-19 Thread William Kaufman

(I posted this before, but I haven't seen any responses.  I've added some
more information.)

(Tomcat version 3.2.1.)

I'm trying to use JDBCRealm to manage access to some static files.  Is
there any documentation for that?

I've successfully configured authorization in web.xml:

security-constraint
  web-resource-collection
web-resource-nameProtected Area/web-resource-name
url-pattern/help/*/url-pattern
  user-data-constraint
transport-guaranteeNONE/transport-guarantee
  /user-data-constraint
http-methodGET/http-method
http-methodPUT/http-method
http-methodPOST/http-method
http-methodDELETE/http-method
  /web-resource-collection
  auth-constraint
role-nameViquityUser/role-name
  /auth-constraint
/security-constraint
login-config
  auth-methodBASIC/auth-method
  realm-nameViquity/realm-name
/login-config

But I can't seem to get JDBCRealm (or my own subclass of that) to get
called.  I've added,

RequestInterceptor 
className="org.apache.tomcat.request.JDBCRealm" 
debug="99" 
driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@localhost:1521:adb"
connectionName="metax"
connectionPassword="tiger"
userTable="contacts" 
userNameCol="username" 
userCredCol="password" 
userRoleTable="user_roles" 
roleNameCol="role" /

to my conf\server.xml, and commented out the SimpleRealm interceptor.
JDBCRealm is on my classpath--"javap" can print it.  And that JDBC
connection works fine outside of Tomcat, so it's not a JDBC issue.

Near as I can figure, Tomcat isn't even loading the class.  Is there
some debugging I can turn on in Tomcat to see what's going wrong?

-- Bill K.



Using JDBCRealms

2001-03-16 Thread William Kaufman

(Tomcat version 3.2.1.)

I'm trying to use JDBCRealm to manage access to some static files.  Is there
any documentation for that?

I've successfully configured authorization in web.xml (though it only seems
to work if the files are under webapps/ROOT--that's OK for what I'm doing,
but I am curious about why that is).

But I can't seem to get JDBCRealm (or my own subclass of that) to get
called.  I've added,

RequestInterceptor 
className="org.apache.tomcat.request.JDBCRealm" 
debug="99" 
driverName="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@localhost:1521:adb"
connectionName="metax"
connectionPassword="tiger"
userTable="contacts" 
userNameCol="username" 
userCredCol="password" 
userRoleTable="user_roles" 
roleNameCol="role" /

to my conf\server.xml, and commented out the SimpleRealm interceptor.
JDBCRealm is on my classpath--"javap" can print it.  And that JDBC
connection works fine outside of JDBCRealms, so it's not a JDBC issue.

Near as I can figure, Tomcat isn't even loading the class.  Is there some
debugging I can turn on in Tomcat to see what's going wrong?

-- Bill K.



administrative webapp breaks JDBCRealms

2001-01-30 Thread Ingo Luetkebohle

Hi,

on Tomcat 3.2.1 (Linux 2.2, IBM JDK 1.3), I experience the problem
that removing an application through the administrative webapp breaks
database connections for JDBCRealms (which are not subsequently
reestablished, unfortunately).

Is this a bug or am I doing something wrong and this shouldn't happen?

-- 
Ingo Luetkebohle / [EMAIL PROTECTED] / 95428014
/
| Student of Computational Linguistics  Computer Science;
| Fargonauten.DE sysadmin; Gimp Registry maintainer;
| FP: 3187 4DEC 47E6 1B1E 6F4F  57D4 CD90 C164 34AD CE5B

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




RE: Pointers on JDBCRealms

2001-01-19 Thread Charles Sabourdin

JDBCRealm.howto
is in the documentation in tomcat
but I perssonnaly never manage to make it works until
the tomcat 3.2.1
secondly, you un comment the 

!-- UnComment the following and comment out the
above to get a JDBC realm.
Other options for driverName: 
 
driverName="oracle.jdbc.driver.OracleDriver"
 
connectionURL="jdbc:oracle:thin:@ntserver:1521:ORCL"
  connectionName="scott"
  connectionPassword="tiger"

  driverName="org.gjt.mm.mysql.Driver"
 
connectionURL="jdbc:mysql://localhost/authority"
  connectionName="test"
  connectionPassword="test"

!--"connectionName" and
"connectionPassword" are optional. --

and comment the 
!-- Check permissions using the simple xml file. You
can 
 plug more advanced authentication
modules.
  
RequestInterceptor 
   
className="org.apache.tomcat.request.SimpleRealm" 
debug="0" / --
othwise the simpleRealm overload teh JDBC
And don't forget the driver into \lib

@++


--- Vijay Prabhakar [EMAIL PROTECTED]
wrote:
 My apologies...I didn't do that cut and paste quite
 the way I meant to
 :)  
 
 
 -Original Message-
 From: Vijay Prabhakar 
 Sent: Thursday, January 18, 2001 5:39 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Pointers on JDBCRealms
 
 
 If you get such a document, could you pass it my
 way?  I'm interested in
 that as well.  Thanks! 
 -Vijay 
 -Original Message- 
 From: Peter Giannopoulos
 [mailto:[EMAIL PROTECTED]] 
 Sent: Thursday, January 18, 2001 5:31 PM 
 To: [EMAIL PROTECTED] 
 Subject: Pointers on JDBCRealms 
 
 
 Hello all, 
 can anyone give me some pointers on documentation or
 even examples that
 make 
 use of JDBCRealms in a clear and concise manner? 
 
 
 Thanks in advance. 
 
 

--
 
  Peter Giannopoulos,Software Developer 
  Gemplus Software,  Advanced Projects
 Group 
  Phone: +15147322434 
  Fax:   +15147322401 
  Gemplus Card International,
 Http://www.gemplus.fr 

---
 
 


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

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




RE: Pointers on JDBCRealms

2001-01-19 Thread David Svensson
Title: RE: Pointers on JDBCRealms





Related Question


I already have my own authentication/authorization scheme. I would like to be able to fetch my user-object which holds the authorization info by using:

User user = (User)request.getUserPrincipal();


What interface or which class should be overriden to let my authentication class be used by tomcat directly. ie How do I make a acceptable RequestInterceptor.

(On JRun this can be done overriding allaire.jrun.security.AuthenticationPrincipal, for full explanation see the article JRun Authentication by Karl Moss, www.allaire.com) 

/David Svensson


 JDBCRealm.howto
 is in the documentation in tomcat
 but I perssonnaly never manage to make it works until
 the tomcat 3.2.1
 secondly, you un comment the 
 
 !-- UnComment the following and comment out the
 above to get a JDBC realm.
 Other options for driverName: 
 
 driverName=oracle.jdbc.driver.OracleDriver
 
 connectionURL=jdbc:oracle:thin:@ntserver:1521:ORCL
 connectionName=scott
 connectionPassword=tiger
 
 driverName=org.gjt.mm.mysql.Driver
 
 connectionURL=jdbc:mysql://localhost/authority
 connectionName=test
 connectionPassword=test
 
 !-- connectionName and
 connectionPassword are optional. --
 
 and comment the 
 !-- Check permissions using the simple xml file. You
 can 
 plug more advanced authentication
 modules.
 
 RequestInterceptor 
 
 className=org.apache.tomcat.request.SimpleRealm 
 debug=0 / --
 othwise the simpleRealm overload teh JDBC
 And don't forget the driver into \lib
 
 @++
 
 
 --- Vijay Prabhakar [EMAIL PROTECTED]
 wrote:
  My apologies...I didn't do that cut and paste quite
  the way I meant to
  :) 
  
  
  -Original Message-
  From: Vijay Prabhakar 
  Sent: Thursday, January 18, 2001 5:39 PM
  To: [EMAIL PROTECTED]
  Subject: RE: Pointers on JDBCRealms
  
  
  If you get such a document, could you pass it my
  way? I'm interested in
  that as well. Thanks! 
  -Vijay 
  -Original Message- 
  From: Peter Giannopoulos
  [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, January 18, 2001 5:31 PM 
  To: [EMAIL PROTECTED] 
  Subject: Pointers on JDBCRealms 
  
  
  Hello all, 
  can anyone give me some pointers on documentation or
  even examples that
  make 
  use of JDBCRealms in a clear and concise manner? 
  
  
  Thanks in advance. 
  
  
 
 --
  
  Peter Giannopoulos, Software Developer 
  Gemplus Software, Advanced Projects
  Group 
  Phone: +15147322434 
  Fax: +15147322401 
  Gemplus Card International, 
  Http://www.gemplus.fr 
 
 ---
  
  
 
 
 __
 Do You Yahoo!?
 Get email at your own domain with Yahoo! Mail. 
 http://personal.mail.yahoo.com/
 
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, email: [EMAIL PROTECTED]
 





RE: Pointers on JDBCRealms

2001-01-19 Thread Peter Giannopoulos


Thanks. I have tried this, but unfortunately I can't help but feel that I
REALLY have a week grasp on the concept of JDBCRealms and how I can get the
MOST use out of them.



--
 Peter Giannopoulos,Software Developer
 Gemplus Software,  Advanced Projects Group

 Phone: +15147322434
 Fax:   +15147322401
 Gemplus Card International, Http://www.gemplus.fr
---

-Original Message-
From: Charles Sabourdin [mailto:[EMAIL PROTECTED]]
Sent: January 19, 2001 5:33 AM
To: [EMAIL PROTECTED]
Subject: RE: Pointers on JDBCRealms


JDBCRealm.howto
is in the documentation in tomcat
but I perssonnaly never manage to make it works until
the tomcat 3.2.1
secondly, you un comment the

!-- UnComment the following and comment out the
above to get a JDBC realm.
Other options for driverName:

driverName="oracle.jdbc.driver.OracleDriver"

connectionURL="jdbc:oracle:thin:@ntserver:1521:ORCL"
  connectionName="scott"
  connectionPassword="tiger"

  driverName="org.gjt.mm.mysql.Driver"

connectionURL="jdbc:mysql://localhost/authority"
  connectionName="test"
  connectionPassword="test"

!--"connectionName" and
"connectionPassword" are optional. --

and comment the
!-- Check permissions using the simple xml file. You
can
 plug more advanced authentication
modules.

RequestInterceptor

className="org.apache.tomcat.request.SimpleRealm"
debug="0" / --
othwise the simpleRealm overload teh JDBC
And don't forget the driver into \lib

@++


--- Vijay Prabhakar [EMAIL PROTECTED]
wrote:
 My apologies...I didn't do that cut and paste quite
 the way I meant to
 :)


 -Original Message-
 From: Vijay Prabhakar
 Sent: Thursday, January 18, 2001 5:39 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Pointers on JDBCRealms


 If you get such a document, could you pass it my
 way?  I'm interested in
 that as well.  Thanks!
 -Vijay
 -Original Message-
 From: Peter Giannopoulos
 [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 18, 2001 5:31 PM
 To: [EMAIL PROTECTED]
 Subject: Pointers on JDBCRealms


 Hello all,
 can anyone give me some pointers on documentation or
 even examples that
 make
 use of JDBCRealms in a clear and concise manner?


 Thanks in advance.



--

  Peter Giannopoulos,Software Developer
  Gemplus Software,  Advanced Projects
 Group
  Phone: +15147322434
  Fax:   +15147322401
  Gemplus Card International,
 Http://www.gemplus.fr

---




__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

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



BEGIN:VCARD
VERSION:2.1
N:Giannopoulos;Peter
FN:Peter Giannopoulos
ORG:Gemplus Canada inc.;CTO Group
TITLE:Software Developer
NOTE;ENCODING=QUOTED-PRINTABLE:=0D=0A--- Codito, ergo sum - "I code, therefore I am" ---
TEL;WORK;VOICE:514-732-2434
TEL;HOME;VOICE:N/A
TEL;CELL;VOICE:N/A
TEL;PAGER;VOICE:N/A
TEL;WORK;FAX:514-732-2301
ADR;POSTAL:;;3 Place du Commerce;Ile des soeurs;Quebec;H3E 1H7;Canada
LABEL;POSTAL;ENCODING=QUOTED-PRINTABLE:3 Place du Commerce=0D=0AIle des soeurs, Quebec H3E 1H7=0D=0ACanada
URL:http://www.gemplus.com
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:2926T190330Z
END:VCARD



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


RE: Pointers on JDBCRealms

2001-01-19 Thread Ignacio J. Ortega

Which is your problem with JDBCRealm?
Post an excertp of your server.xml file to help you isolate problems...

Saludos ,
Ignacio J. Ortega


 -Mensaje original-
 De: Peter Giannopoulos [mailto:[EMAIL PROTECTED]]
 Enviado el: viernes 19 de enero de 2001 15:36
 Para: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Asunto: RE: Pointers on JDBCRealms
 
 
 
 Thanks. I have tried this, but unfortunately I can't help but 
 feel that I
 REALLY have a week grasp on the concept of JDBCRealms and how 
 I can get the
 MOST use out of them.
 
 
 
 --
  Peter Giannopoulos,Software Developer
  Gemplus Software,  Advanced Projects Group
 
  Phone: +15147322434
  Fax:   +15147322401
  Gemplus Card International, Http://www.gemplus.fr
 ---
 
 -Original Message-
 From: Charles Sabourdin [mailto:[EMAIL PROTECTED]]
 Sent: January 19, 2001 5:33 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Pointers on JDBCRealms
 
 
 JDBCRealm.howto
 is in the documentation in tomcat
 but I perssonnaly never manage to make it works until
 the tomcat 3.2.1
 secondly, you un comment the
 
 !-- UnComment the following and comment out the
 above to get a JDBC realm.
 Other options for driverName:
 
 driverName="oracle.jdbc.driver.OracleDriver"
 
 connectionURL="jdbc:oracle:thin:@ntserver:1521:ORCL"
   connectionName="scott"
   connectionPassword="tiger"
 
   driverName="org.gjt.mm.mysql.Driver"
 
 connectionURL="jdbc:mysql://localhost/authority"
   connectionName="test"
   connectionPassword="test"
 
 !--"connectionName" and
 "connectionPassword" are optional. --
 
 and comment the
 !-- Check permissions using the simple xml file. You
 can
  plug more advanced authentication
 modules.
 
 RequestInterceptor
 
 className="org.apache.tomcat.request.SimpleRealm"
 debug="0" / --
 othwise the simpleRealm overload teh JDBC
 And don't forget the driver into \lib
 
 @++
 
 
 --- Vijay Prabhakar [EMAIL PROTECTED]
 wrote:
  My apologies...I didn't do that cut and paste quite
  the way I meant to
  :)
 
 
  -Original Message-
  From: Vijay Prabhakar
  Sent: Thursday, January 18, 2001 5:39 PM
  To: [EMAIL PROTECTED]
  Subject: RE: Pointers on JDBCRealms
 
 
  If you get such a document, could you pass it my
  way?  I'm interested in
  that as well.  Thanks!
  -Vijay
  -Original Message-
  From: Peter Giannopoulos
  [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, January 18, 2001 5:31 PM
  To: [EMAIL PROTECTED]
  Subject: Pointers on JDBCRealms
 
 
  Hello all,
  can anyone give me some pointers on documentation or
  even examples that
  make
  use of JDBCRealms in a clear and concise manner?
 
 
  Thanks in advance.
 
 
 
 --
 
   Peter Giannopoulos,Software Developer
   Gemplus Software,  Advanced Projects
  Group
   Phone: +15147322434
   Fax:   +15147322401
   Gemplus Card International,
  Http://www.gemplus.fr
 
 ---
 
 
 
 
 __
 Do You Yahoo!?
 Get email at your own domain with Yahoo! Mail.
 http://personal.mail.yahoo.com/
 
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, email: [EMAIL PROTECTED]
 
 

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




RE: Pointers on JDBCRealms

2001-01-19 Thread Charles Sabourdin

I forget to add that you should add into your web.xml
(in the webapps) the security set to avoid anonymous
login.

security-constraint
  web-resource-collection
  web-resource-nameProtected
Area/web-resource-name
 !-- 
   Define the context-relative URL(s) to
be protected 
   --
   url-pattern/protected/*/url-pattern
   !--
   If you list http methods, only those
methods are protected 
   --
 http-methodDELETE/http-method
   http-methodGET/http-method
   http-methodPOST/http-method
   http-methodPUT/http-method
  /web-resource-collection
auth-constraint
!-- Anyone with one of the listed roles may
access this area --
  !-- ce rappeller qu'il faut editer le fichier
tomcat-users.xml 
dans le repertoire conf de
tomcat/conf/tomcat-users.xml --
role-nametheRoleAccepted1/role-name
role-nametheRoleAccepted2/role-name
 /auth-constraint
/security-constraint
!-- 
Default login configuration uses BASIC
authentication 
--
!--
login-config
  auth-methodBASIC/auth-method
  realm-nameExample Basic Authentication
Area/realm-name
/login-config
--

 !--
  Form-based login is enabled by default.  If you
wish to
 try Basic authentication, comment out the
login-config
 section below and uncomment the one above. 
 --
 login-config
  auth-methodFORM/auth-method
   realm-namePlease identify
yourself/realm-name
   form-login-config
   
form-login-page/security/login/login.jsp/form-login-page
   
form-error-page/security/login/error.jsp/form-error-page
   /form-login-config
/login-config

--- Peter Giannopoulos
[EMAIL PROTECTED] wrote:
 
 Thanks. I have tried this, but unfortunately I can't
 help but feel that I
 REALLY have a week grasp on the concept of
 JDBCRealms and how I can get the
 MOST use out of them.
 
 
 

--
  Peter Giannopoulos,Software Developer
  Gemplus Software,  Advanced Projects
 Group
 
  Phone: +15147322434
  Fax:   +15147322401
  Gemplus Card International,
 Http://www.gemplus.fr

---
 
 -Original Message-
 From: Charles Sabourdin [mailto:[EMAIL PROTECTED]]
 Sent: January 19, 2001 5:33 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Pointers on JDBCRealms
 
 
 JDBCRealm.howto
 is in the documentation in tomcat
 but I perssonnaly never manage to make it works
 until
 the tomcat 3.2.1
 secondly, you un comment the
 
 !-- UnComment the following and comment out the
 above to get a JDBC realm.
 Other options for driverName:
 
 driverName="oracle.jdbc.driver.OracleDriver"
 
 connectionURL="jdbc:oracle:thin:@ntserver:1521:ORCL"
   connectionName="scott"
   connectionPassword="tiger"
 
   driverName="org.gjt.mm.mysql.Driver"
 
 connectionURL="jdbc:mysql://localhost/authority"
   connectionName="test"
   connectionPassword="test"
 
 !--"connectionName" and
 "connectionPassword" are optional. --
 
 and comment the
 !-- Check permissions using the simple xml file.
 You
 can
  plug more advanced authentication
 modules.
 
 RequestInterceptor
 
 className="org.apache.tomcat.request.SimpleRealm"
 debug="0" / --
 othwise the simpleRealm overload teh JDBC
 And don't forget the driver into \lib
 
 @++
 
 
 --- Vijay Prabhakar [EMAIL PROTECTED]
 wrote:
  My apologies...I didn't do that cut and paste
 quite
  the way I meant to
  :)
 
 
  -Original Message-
  From: Vijay Prabhakar
  Sent: Thursday, January 18, 2001 5:39 PM
  To: [EMAIL PROTECTED]
  Subject: RE: Pointers on JDBCRealms
 
 
  If you get such a document, could you pass it my
  way?  I'm interested in
  that as well.  Thanks!
  -Vijay
  -Original Message-
  From: Peter Giannopoulos
  [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, January 18, 2001 5:31 PM
  To: [EMAIL PROTECTED]
  Subject: Pointers on JDBCRealms
 
 
  Hello all,
  can anyone give me some pointers on documentation
 or
  even examples that
  make
  use of JDBCRealms in a clear and concise manner?
 
 
  Thanks in advance.
 
 
 

--
 
   Peter Giannopoulos,Software Developer
   Gemplus Software,  Advanced Projects
  Group
   Phone: +15147322434
   Fax:   +15147322401
   Gemplus Card International,
  Http://www.gemplus.fr
 

-

RE: Pointers on JDBCRealms

2001-01-19 Thread Peter Giannopoulos


Thanks. I appreciate all the help.





--
 Peter Giannopoulos,Software Developer
 Gemplus Software,  Advanced Projects Group
 
 Phone: +15147322434
 Fax:   +15147322401
 Gemplus Card International, Http://www.gemplus.fr
---

-Original Message-
From: Charles Sabourdin [mailto:[EMAIL PROTECTED]]
Sent: January 19, 2001 10:18 AM
To: [EMAIL PROTECTED]
Subject: RE: Pointers on JDBCRealms


I forget to add that you should add into your web.xml
(in the webapps) the security set to avoid anonymous
login.

security-constraint
  web-resource-collection
  web-resource-nameProtected
Area/web-resource-name
 !-- 
   Define the context-relative URL(s) to
be protected 
   --
   url-pattern/protected/*/url-pattern
   !--
   If you list http methods, only those
methods are protected 
   --
 http-methodDELETE/http-method
   http-methodGET/http-method
   http-methodPOST/http-method
   http-methodPUT/http-method
  /web-resource-collection
auth-constraint
!-- Anyone with one of the listed roles may
access this area --
  !-- ce rappeller qu'il faut editer le fichier
tomcat-users.xml 
dans le repertoire conf de
tomcat/conf/tomcat-users.xml --
role-nametheRoleAccepted1/role-name
role-nametheRoleAccepted2/role-name
 /auth-constraint
/security-constraint
!-- 
Default login configuration uses BASIC
authentication 
--
!--
login-config
  auth-methodBASIC/auth-method
  realm-nameExample Basic Authentication
Area/realm-name
/login-config
--

 !--
  Form-based login is enabled by default.  If you
wish to
 try Basic authentication, comment out the
login-config
 section below and uncomment the one above. 
 --
 login-config
  auth-methodFORM/auth-method
   realm-namePlease identify
yourself/realm-name
   form-login-config
   
form-login-page/security/login/login.jsp/form-login-page
   
form-error-page/security/login/error.jsp/form-error-page
   /form-login-config
/login-config

--- Peter Giannopoulos
[EMAIL PROTECTED] wrote:
 
 Thanks. I have tried this, but unfortunately I can't
 help but feel that I
 REALLY have a week grasp on the concept of
 JDBCRealms and how I can get the
 MOST use out of them.
 
 
 

--
  Peter Giannopoulos,Software Developer
  Gemplus Software,  Advanced Projects
 Group
 
  Phone: +15147322434
  Fax:   +15147322401
  Gemplus Card International,
 Http://www.gemplus.fr

---
 
 -Original Message-
 From: Charles Sabourdin [mailto:[EMAIL PROTECTED]]
 Sent: January 19, 2001 5:33 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Pointers on JDBCRealms
 
 
 JDBCRealm.howto
 is in the documentation in tomcat
 but I perssonnaly never manage to make it works
 until
 the tomcat 3.2.1
 secondly, you un comment the
 
 !-- UnComment the following and comment out the
 above to get a JDBC realm.
 Other options for driverName:
 
 driverName="oracle.jdbc.driver.OracleDriver"
 
 connectionURL="jdbc:oracle:thin:@ntserver:1521:ORCL"
   connectionName="scott"
   connectionPassword="tiger"
 
   driverName="org.gjt.mm.mysql.Driver"
 
 connectionURL="jdbc:mysql://localhost/authority"
   connectionName="test"
   connectionPassword="test"
 
 !--"connectionName" and
 "connectionPassword" are optional. --
 
 and comment the
 !-- Check permissions using the simple xml file.
 You
 can
  plug more advanced authentication
 modules.
 
 RequestInterceptor
 
 className="org.apache.tomcat.request.SimpleRealm"
 debug="0" / --
 othwise the simpleRealm overload teh JDBC
 And don't forget the driver into \lib
 
 @++
 
 
 --- Vijay Prabhakar [EMAIL PROTECTED]
 wrote:
  My apologies...I didn't do that cut and paste
 quite
  the way I meant to
  :)
 
 
  -Original Message-
  From: Vijay Prabhakar
  Sent: Thursday, January 18, 2001 5:39 PM
  To: [EMAIL PROTECTED]
  Subject: RE: Pointers on JDBCRealms
 
 
  If you get such a document, could you pass it my
  way?  I'm interested in
  that as well.  Thanks!
  -Vijay
  -Original Message-
  From: Peter Giannopoulos
  [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, January 18, 20

RE: Pointers on JDBCRealms

2001-01-19 Thread Charles Sabourdin


--- Peter Giannopoulos
[EMAIL PROTECTED] wrote:
 
 Thanks. I appreciate all the help.
 
 De nada, I only want to insiste on the fact that it
work only since the 3.2.1

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

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




Pointers on JDBCRealms

2001-01-18 Thread Peter Giannopoulos

Hello all,

can anyone give me some pointers on documentation or even examples that make
use of JDBCRealms in a clear and concise manner?


Thanks in advance.


--
 Peter Giannopoulos,Software Developer
 Gemplus Software,  Advanced Projects Group

 Phone: +15147322434
 Fax:   +15147322401
 Gemplus Card International, Http://www.gemplus.fr
---


BEGIN:VCARD
VERSION:2.1
N:Giannopoulos;Peter
FN:Peter Giannopoulos
ORG:Gemplus Canada inc.;CTO Group
TITLE:Software Developer
NOTE;ENCODING=QUOTED-PRINTABLE:=0D=0A--- Codito, ergo sum - "I code, therefore I am" ---
TEL;WORK;VOICE:514-732-2434
TEL;HOME;VOICE:N/A
TEL;CELL;VOICE:N/A
TEL;PAGER;VOICE:N/A
TEL;WORK;FAX:514-732-2301
ADR;POSTAL:;;3 Place du Commerce;Ile des soeurs;Quebec;H3E 1H7;Canada
LABEL;POSTAL;ENCODING=QUOTED-PRINTABLE:3 Place du Commerce=0D=0AIle des soeurs, Quebec H3E 1H7=0D=0ACanada
URL:http://www.gemplus.com
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:2926T190330Z
END:VCARD



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


RE: Pointers on JDBCRealms

2001-01-18 Thread Vijay Prabhakar
Title: RE: Pointers on JDBCRealms






My apologies...I didn't do that cut and paste quite the way I meant to :) 



-Original Message-

From: Vijay Prabhakar 

Sent: Thursday, January 18, 2001 5:39 PM

To: [EMAIL PROTECTED]

Subject: RE: Pointers on JDBCRealms



If you get such a document, could you pass it my way? I'm interested in that as well. Thanks! 

-Vijay 

-Original Message- 

From: Peter Giannopoulos [mailto:[EMAIL PROTECTED]] 

Sent: Thursday, January 18, 2001 5:31 PM 

To: [EMAIL PROTECTED] 

Subject: Pointers on JDBCRealms 



Hello all, 

can anyone give me some pointers on documentation or even examples that make 

use of JDBCRealms in a clear and concise manner? 



Thanks in advance. 



-- 

Peter Giannopoulos, Software Developer 

Gemplus Software, Advanced Projects Group 

Phone: +15147322434 

Fax: +15147322401 

Gemplus Card International, Http://www.gemplus.fr 

---