ldap认证失败_ldap认证_ldap服务器(4)

#查询用户和权限组对应关系
mysql> select * from users_groups ;
+----+----------+--------+
| id | usrgrpid | userid |
+----+----------+--------+
|  4 |        7 |      1 |
|  2 |        8 |      2 |
|  5 |        7 |      3 |
|  6 |        7 |      4 |
|  7 |        7 |      5 |
| 12 |       14 |      6 |
| 11 |       13 |      8 |
+----+----------+--------+
7 rows in set (0.00 sec)
#修改用户所在权限组
mysql>  update users_group set usrgrpid='1' where userid=3;
ERROR 1146 (42S02): Table 'zabbix.users_group' doesn't exist
mysql>  update users_groups set usrgrpid='1' where userid=3;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

更改LDAP主机或者BIND DN:

mysql> update config set ldap_host='xxx.xxx.xxx.xxx' ldap_base_dn='cn=ldap_search,ou=example,dc=com' ldap_bind_password='passwd';

有了上面这些操作，不论是用户误删除且密码忘记，还是LDAP挂掉，都可以随心所欲的更改认证了。

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/jisuanjixue/article-33385-4.html