Zabbix disable ldap-auth without webui

From Bitbull Wiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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)