Remove LDAP attribute from Admin account.

[Kwekkel]

Hi,
I made a mistake by activating LDAP for the Admin account while LDAP is not working yet so I locked myself out.
Is there a way to remove the LDAP attribute from the cmd line?

[niveastn]

Hi!

You are going to do it via you zbx database!
> Access your zabbix database (with admin user)
> execute

select authentication_type from config;

what value do you get? if its not 0, execute

update config set authentication_type=0;

let us know if you could access after that!

[Kwekkel]

Hello,

I get this response:
MariaDB [zabbix]> select authentication_type from config;
+---------------------+
| authentication_type |
+---------------------+
| 0 |
+---------------------+
1 row in set (0.00 sec)

This looks for me a generic setting for all users. I guess I need to alter a setting on user level for user Admin.
Alternatively, adding another superuser via the cmd line or directly in the database might help as well.