AD域同步报错

LDAP配置截图看下

配置信息如下

s3存储配置下

已配置S3 报错如下

LDAP同步失败: ### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'name' at row 1 ### The error may exist in xyz/playedu/common/mapper/UserMapper.java (best guess) ### The error may involve xyz.playedu.common.mapper.UserMapper.insert-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO users ( email, name, avatar, password, salt, id_card, credit1, create_ip, create_city, is_active, is_lock, is_set_password, created_at, updated_at ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'name' at row 1 ; Data truncation: Data too long for column 'name' at row 1

ad域中用户名超出长度了，默认就24个字符长度，需要你手动进入数据库修改下users表的name字段长度了

显示同步失败 只同步了部分数据

错误code=49 这个错误一般是用于配置的ad账号和密码有误

1.检查账号和密码是否输入错误 2.检查次账号是否具有权限