Enable Admin

[wojciechiwanski]

Hello all,
I had issue that our ldap host and domain controller failed to no recovery point.
I have disabled all local accounts in zabbix.
Now the problem is I cannot log into zabbix frontend to change anything.

How can I enable again Admin account to be able to login zabbix front end?
I don't know what user settings need to be changed in mysql to allow Admin to log in again.

[BDiE8VNy]

Not tested but I can imaging that all you need to do is to updated the password field from the user of your choice and make sure that it is in a group having internal GUI access:

zabbix=# SELECT userid, alias, name, surname, passwd, type FROM users WHERE alias = 'foobar';
 userid | alias  | name | surname |              passwd              | type
--------+--------+------+---------+----------------------------------+------
    155 | foobar | foo  | bar     | 5fce1b3e34b520afeffb37ce08c7cd66 |    3
(1 row)

zabbix=# SELECT * FROM users_groups WHERE userid = 155;
 id  | usrgrpid | userid
-----+----------+--------
 392 |       56 |    155
(1 row)

zabbix=# SELECT * FROM usrgrp WHERE usrgrpid = 56;
 usrgrpid |              name               | gui_access | users_status | debug_mode
----------+---------------------------------+------------+--------------+------------
       56 | ZBX :: Internal frontend access |          1 |            0 |          0
(1 row)

zabbix=#

passwd=5fce1b3e34b520afeffb37ce08c7cd66 -> zabbix
type=3 -> Zabbix Super Admin
gui_access=1 -> Internal

[wojciechiwanski]

Thanks a lot, I had gui_access = 0 for this user, changed it and logged to frondend.