Cas服务端5.3 基于MySQL8数据库，实现用户认证

た入场券 2023-10-18 18:09 116阅读 0赞

第一步：Cas 服务端添加数据库认证依赖jar 文件：

找到下图所示代码端：

![20190506104457196.png][]

添加如下依赖jar包：

<dependency>
    				<groupId>org.apereo.cas</groupId>
    				<artifactId>cas-server-support-jdbc</artifactId>
    				<version>${cas.version}</version>
    			</dependency>
    			<dependency>
    				<groupId>org.apereo.cas</groupId>
    				<artifactId>cas-server-support-jdbc-drivers</artifactId>
    				<version>${cas.version}</version>
    			</dependency>
    			<dependency>
    				<groupId>mysql</groupId>
    				<artifactId>mysql-connector-java</artifactId>
    				<version>${mysql.driver.version}</version>
    			</dependency>

继续找到下段代码，如下图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70][]

在<properties>和</properties>中加入mysql 版本信息：

<mysql.driver.version>8.0.13</mysql.driver.version>

第二步：重新编译Cas服务端代码

window CMD窗口指令切换至cas5.3.zip 解压文件目录，执行如下指令：mvn install

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 1][]

第三步：cas 用户认证配置和mysql 相关文件

3.1 创建用户表，并初始化用户信息：

DROP TABLE IF EXISTS `u_user`;
    CREATE TABLE `u_user`  (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `nickname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户昵称',
      `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱|登录帐号',
      `pswd` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
      `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
      `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间',
      `status` bigint(1) NULL DEFAULT 1 COMMENT '1:有效，0:禁止登录',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of u_user
    -- ----------------------------
    INSERT INTO `u_user` VALUES (1, 'admin', 'admin@163.com', '1', '2019-04-27 22:44:44', NULL, 1);

3.2 切换至C:\\tomcat\\apache-tomcat-8.0.47\\webapps\\cas\\WEB-INF\\classes目录的application.properties将用户认证配置cas.authn.accept.users=casuser::Mellon注释掉，再加入以下内容

##
    # CAS Authentication Credentials
    #
    cas.authn.jdbc.query[0].url=jdbc:mysql://192.168.1.73:3306/boot-security?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true     
    cas.authn.jdbc.query[0].user=root
    cas.authn.jdbc.query[0].password=digipower
    cas.authn.jdbc.query[0].sql=select * from u_user where nickname = ?
    cas.authn.jdbc.query[0].fieldPassword=pswd
    cas.authn.jdbc.query[0].driverClass=com.mysql.jdbc.Driver

第四步：访问http://localhost:9100/cas/index,跳转至CAS 服务端登入界面，输入正确用户名和密码，返回相关数据结果：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 2][]

[20190506104457196.png]: https://img-blog.csdnimg.cn/20190506104457196.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190506104816185.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190506105429706.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20190506105957671.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70