tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From colin.mad...@ieminc.com
Subject [nbusers] Tomcat 3.3.1 and JDBC Realms - no luck
Date Mon, 22 Apr 2002 17:08:04 GMT

> I'm trying to do the basic setup of this and failing.  I had this working
> under Tomcat 3.2 a year ago or so and don't know what I'm missing this
> time.
> 
> OS: WinNT
> Tomcat: 3.3.1 (also tried 3.3a prior to upgrading)
> DB: SQLServer
> 
> I'm doing the simple one in "server.xml" (not the context one) and
> followed all the directions and even used my old 'web.xml' security
> configuration to be sure I was doing it right.  Problem is, I never see
> the "JDBCRealm connected" like I used to 3.2 when Tomcat starts, NOR
> anything related when the page is accessed, nor am I prompted for
> authentication.  Basically it looks like Tomcat is ignoring all my
> settings with respect to JDBCRealms.
> 
> When setting the debug lvl to "10", I do get this upon startup:
> 
> 2002-04-17 17:02:47 - LogEvents: addInterceptor
> org.apache.tomcat.modules.aaa.JDBCRealm@3ca5f1
> 
> but nothing when the page is accessed.
> 
> Here are the relevent sections of my server.xml and web.xml, respectively:
> 
> (server.xml)
> 
> <JDBCRealm
> 	debug="99"
> 	driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver" 
> 	
> connectionURL="jdbc:microsoft:sqlserver://DBServer:1433;user=bob;password=
> thing;database=WebLogin;SelectMethod=cursor"
> 	userTable="users" 
> 	userNameCol="username" 	
> 	userCredCol="userpass" 
> 	userRoleTable="userroles" 
> 	roleNameCol="rolename" />
> 
> (web.xml)
> 
> 	<security-constraint>
> 		<web-resource-collection>
> 			<web-resource-name>Resume System</web-resource-name>
> 			<url-pattern>/ResumeSystem/*</url-pattern>
> 		</web-resource-collection>
> 		<auth-constraint>
> 			<role-name>employee</role-name>
> 		</auth-constraint>
> 	</security-constraint>
> 
> 	<login-config>
> 		<auth-method>BASIC</auth-method>
> 		<realm-name>Basic Authentication Area</realm-name>
> 	</login-config>
> 
> (also tried these web.xml entries)
> 
>     <security-constraint>
>         <web-resource-collection>
>             <web-resource-name>ResumeSystem</web-resource-name>
>             <url-pattern>/ResumeSystem/*</url-pattern>
>             <http-method>GET</http-method>
>             <http-method>POST</http-method>
>         </web-resource-collection>
>         <auth-constraint>
>             <role-name>employee</role-name>
>         </auth-constraint>
>         <user-data-constraint>
>             <transport-guarantee>NONE</transport-guarantee>
>         </user-data-constraint>
>     </security-constraint>
>     
>     <login-config>
>         <auth-method>BASIC</auth-method>
>         <realm-name>IEM Web</realm-name>
>     </login-config>
>     
>     <security-role>
>         <role-name>employee</role-name>
>     </security-role>
> 
> NOTE:
> Servlets work, JDBC connection works
> 
> Searched the archives but nothing helped.
> 
> Colin Madere
> 
> P.S. I apologize for any formatting madness, Outlook hid my "Plain Text"
> option and company policy dictates email client :(
> 
> 

--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message