Zabbix disable ldap-auth without webui

From Bitbull Wiki
Jump to navigation Jump to search
MariaDB [zabbix]> select authentication_type from config;
+---------------------+
| authentication_type |
+---------------------+
|                   1 |
+---------------------+
1 row in set (0.001 sec)

MariaDB [zabbix]> update config set authentication_type=0;
Query OK, 1 row affected (0.012 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [zabbix]> select authentication_type from config;
+---------------------+
| authentication_type |
+---------------------+
|                   0 |
+---------------------+
1 row in set (0.000 sec)

MariaDB [zabbix]> select * from users;
+--------+----------+-------------+---------------+--------------------------------------------------------------+-----+-----------+------------+---------+---------+---------+----------------+---------------+---------------+---------------+----------+--------+
| userid | username | name        | surname       | passwd                                                       | url | autologin | autologout | lang    | refresh | theme   | attempt_failed | attempt_ip    | attempt_clock | rows_per_page | timezone | roleid |
+--------+----------+-------------+---------------+--------------------------------------------------------------+-----+-----------+------------+---------+---------+---------+----------------+---------------+---------------+---------------+----------+--------+
|      1 | thomas   | Zabbix      | Administrator | $...                                                         |     |         1 | 0          | en_US   | 30s     | default |              0 | 192.168.1.1   |    1663939095 |           500 | default  |      3 |
|      2 | guest    |             |               |                                                              |     |         0 | 15m        | default | 30s     | default |              0 |               |             0 |            50 | default  |      1 |
|      6 | adm      | Local Admin |               | $...                                                         |     |         1 | 0          | default | 30s     | default |              0 | 192.168.1.1   |    1649097750 |            50 | default  |      3 |
+--------+----------+-------------+---------------+--------------------------------------------------------------+-----+-----------+------------+---------+---------+---------+----------------+---------------+---------------+---------------+----------+--------+
3 rows in set (0.000 sec)