CAS配置数据源

1.修改cas服务端中WEB-INF下deployerConfigContext.xml ，添加如下配置 连接宿主机mysql 此过程需要关闭宿主机防火墙

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"  
			  p:driverClass="com.mysql.jdbc.Driver"  
			  p:jdbcUrl="jdbc:mysql://192.168.188.1:3306/testdb?characterEncoding=utf8"  
			  p:user="root"  
			  p:password="123456" /> 
<bean id="passwordEncoder" 
class="org.jasig.cas.authentication.handler.DefaultPasswordEncoder"  
		c:encodingAlgorithm="MD5"  
		p:characterEncoding="UTF-8" />  
<bean id="dbAuthHandler"  
		  class="org.jasig.cas.adaptors.jdbc.QueryDatabaseAuthenticationHandler"  
		  p:dataSource-ref="dataSource"  
		  p:sql="select password from tb_user where username = ?"  
		  p:passwordEncoder-ref="passwordEncoder"/>  

注意数据库，root账号是否允许远程连接。

2.在配置文件靠前找到如下信息

 <bean id="authenticationManager" class="org.jasig.cas.authentication.PolicyBasedAuthenticationManager">
        <constructor-arg>
            <map>               
                <entry key-ref="proxyAuthenticationHandler" value-ref="proxyPrincipalResolver" />
                <entry key-ref="primaryAuthenticationHandler" value-ref="primaryPrincipalResolver" />
            </map>
        </constructor-arg>      
        <property name="authenticationPolicy">
            <bean class="org.jasig.cas.authentication.AnyAuthenticationPolicy" />
        </property>
</bean>

将<entry key-ref="primaryAuthenticationHandler" value-ref="primaryPrincipalResolver" />注释
在注释下面添加

<entry key-ref="dbAuthHandler" value-ref="primaryPrincipalResolver"/>

3.将jar包放入webapps\cas\WEB-INF\lib下

4.在linux服务器安装mysql客户端，测试和数据库连接是否正常(若前三步成功可取消第四步)

yum install mysql -y
mysql -uroot -p  -h 192.168.188.1