> I have added the following in the deployerConfigContext.xml > > <bean id="SearchModeSearchDatabaseAuthenticationHandler" > > class="org.jasig.cas.adaptors.jdbc.SearchModeSearchDatabaseAuthenticationHandler"> > <property name="tableUsers"> > <value>USERS</value> > </property> > <property name="fieldUser"> > <value>USERNAME</value> > </property> > <property name="fieldPassword"> > <value>PASSWORD</value> > </property> > <property name="dataSource" ref="dataSource" /> > </bean> > > <bean class="org.jasig.cas.adaptors.jdbc.QueryDatabaseAuthenticationHandler"> > <property name="dataSource" ref="dataSource" /> > <property name="sql" value="select password from some_table where > lower(username) = lower(?)" /> > </bean>
I recommend you study http://www.ja-sig.org/wiki/display/CASUM/Using+JDBC+for+Authentication. It indicates you should define one or the other of the handlers above but not both. The cas log you attached is complaining about SQL, so I'm fairly certain this is a configuration problem related to defining both types of JDBC auth handlers. M -- 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
