i'm trying to use MSSQL server as Identity store.
I use ubuntu linux, tomcat 6 and jdk 1.6
I used maven to produce CAS 3.4.2 war and it works.
now, changed auth adaptor in
<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 imported common-dbcp 1.4.jar and used jtds driver, putting jtds-1.2.5.jar in WEB-INF/lib and as datasource:
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"><value>oracle.jdbc.driver.OracleDriver</value></property>
<property name="url"><value>jdbc:jtds:sqlserver://database-server/dbname</value></property>
<property name="username"><value>admusr</value></property>
<property name="password"><value>admpwd</value></property>
</bean>
in catalina.out i cet no errors, put on interface i get "CAS unavailable, contact admin" message
after that i tryied microsoft dirvers, but without success
Can you help me to debug finding where is misonfiguration?
-------------------------------------------------------------------------------
Valore legale alle tue mail
InterfreePEC - la tua Posta Elettronica Certificata
http://pec.interfree.it
-------------------------------------------------------------------------------
--
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-dev
