Hi Guys,
Fist off I would like to say sorry if this is documented somewhere. I
am having problems configuring CAS to query a MS SQL Server for credential
authentication. Is there documentation online that goes through the setup
process?
I added this authentication handler:
<bean
class="org.jasig.cas.adaptors.jdbc.QueryDatabaseAuthenticationHandler">
<property name="dataSource" ref="dataSource" />
<property name="sql" value="select password from users where lower(username)
= lower?" />
</bean>
And this bean:
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>
</property>
<property name="url">
<value>jdbc:sqlserver://sql2008beta;databaseName=XXX_Portal-alpha;</value>
</property>
<property name="username">
<value>XXXX-Portal</value>
</property>
<property name="password">
<value>XXXXXXX</value>
</property>
</bean>
But I don't seem to be getting anywhere. Everytime I start Tomcat and try
to access the CAS page I get a HTTP Status 404 error, so I know I messed up
something in my config. This is Tomcat 6.0.24 on Server 2003 using CAS
3.3.5 Final. Any help would be appreciated.
Thanks,
Sean
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
