how do I disable LDAP Auth without GUI access

[tjyang]

My ldap auth configuration stop working(due to bind account password expiration ? ).


In R1, we can reset the local Admin password using sql statement.
But I need to disable LDAP Auth configuration to go back to R1 case.
Is there sql statements to disable ldap auth ?

R1: https://www.zabbix.com/forum/zabbix-...out-gui-access
R2: Zabbix server 4.4.5 using timescaledb.

[tim.mooney]

There are a bunch of LDAP-related columns in the 'config' table of the Zabbix database. There's also the "authentication_type" column, which probably has different integer values depending on which authentication type has been configured.

[sancho]

Hi tjyang

Look at this post: https://www.zabbix.com/forum/zabbix-...760#post244760