Locked out of UI with LDAP authentication

[markfree]

I've managed to lock myself out of Zabbix 6 while configuring a new installment.
I've configured LDAP login, then changed the default login type to it, but forgot to create a new user with admin privileges.


After that, "Admin" account could not login anymore and I can't access Zabbix UI anymore.

Any idea how to change back the default login to "internal"?

[markfree]

Great Markku !
That did it.
I've changed authentication_type from config table and now I'm able to login.

mysql> update config set authentication_type=0;
Query OK, 1 row affected (0.00 sec)
mysql> select authentication_type from config limit 10;
+---------------------+
| authentication_type |
+---------------------+
| 0 |
+---------------------+

Thanks a lot.

[Markku]

Does this help you: https://www.zabbix.com/forum/zabbix-...ied#post244760

Markku

[markfree]

Great Markku !
That did it.
I've changed authentication_type from config table and now I'm able to login.

mysql> update config set authentication_type=0;
Query OK, 1 row affected (0.00 sec)
mysql> select authentication_type from config limit 10;
+---------------------+
| authentication_type |
+---------------------+
| 0 |
+---------------------+

Thanks a lot.