Skip to Content.
Sympa Menu

freetds - can't get JCBC realms to work with freetds/JDBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Jason" <jcowley AT cenquest.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: can't get JCBC realms to work with freetds/JDBC
  • Date: Mon, 13 May 2002 19:56:52 -0400


I cannot seem to get JDBC realm working with the freetds driver. When I go
to a page in the protected area, I get in without being prompted for a
password but only see a blank page. I'm pretty sure my configuration is
correct, I've tested it with a mySQL database and driver.

I've been struggling with this for two days now. Does anyone have any
advice?

I'm using tomcat 4.0.3 on a Linux system (RH 7.2) and SQL Server 7.0.

I have configured my Realm in the tomcat server.xml file like this:

<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="com.internetcds.jdbc.tds.Driver"
connectionName="test" connectionPassword="password"
connectionURL="jdbc:freetds:sqlserver://ONYX/Web_Onyx_test;TDS=7.0"
userTable="Users"
userNameCol="Login"
userCredCol="Password"
userRoleTable="User_Roles"
roleNameCol="Role" />

And my web.xml file like this:

<web-app>
<security-constraint>
<display-name>Test Realm</display-name>
<web-resource-collection>
<web-resource-name>Protected Area</web-resource-name>
<url-pattern>/*</url-pattern>
<http-method>DELETE</http-method>
<http-method>GET</http-method>
<http-method>POST</http-method>
<http-method>PUT</http-method>
</web-resource-collection>
<auth-constraint>
<role-name>testRole</role-name>
</auth-constraint>
</security-constraint>
<login-config>
<auth-method>BASIC</auth-method>
<realm-name>Test</realm-name>
</login-config>
</web-app>


Thanks!






  • can't get JCBC realms to work with freetds/JDBC, Jason, 05/13/2002

Archive powered by MHonArc 2.6.24.

Top of Page