zabbix ldap 설정 오류로 로컬 인증, ldap 인증 모두 실패 - WebUI 접속 불가
DB 설정값 변경으로 ldap -> 로컬 인증으로 변경
- authentication_type
- 로컬인증: 0
- ldap 인증: 1
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 138280
Server version: 8.0.33-0ubuntu0.20.04.2 (Ubuntu)
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use zabbix;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select authentication_type from config;
+---------------------+
| authentication_type |
+---------------------+
| 1 |
+---------------------+
1 row in set (0.00 sec)
mysql> update config set authentication_type=0;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select authentication_type from config;
+---------------------+
| authentication_type |
+---------------------+
| 0 |
+---------------------+
1 row in set (0.00 sec)