Unable to login to Zabbix 2.2.1

[mall]

Hi there,

I am working in a company that uses Zabbix. The previous Sys Admin has left the company and now I need to reset his pass.
I have logined in mysql, went to table 'users' and altered the md5 pass to the new one. However I cannot authenticate in the browser.
What am I missing?
This is very urgent...I don´t know what to do...

Thank you in advance

[tchjts1]

Have you tried doing it through the Zabbix GUI using the default Admin account?

username: Admin (Capital A)
password: zabbix (All lower case)

[mall]

Have you tried doing it through the Zabbix GUI using the default Admin account?

username: Admin (Capital A)
password: zabbix (All lower case)

Yes! I had tried that...with no luck...

But I have found the root of the problem and I am posting it here for info purposes:

The user was disalowed in the gui access. There is a table "usrgrp" wich have a "gui_access". It's value was 0, and thats why I cannot login.

Thanks

[aib]

Did you do everything like it has showed here?

https://www.youtube.com/watch?v=aooRNtIaEjk

[aib]

BTW, your assuming about "usrgrp" is not correct.
My userid=3, I'm in group "Zabbix administrators" which also has "0" in column "gui_access"
I'm working in GUI every day.

mysql> select * from users_groups where userid=3;
+----+----------+--------+
| id | usrgrpid | userid |
+----+----------+--------+
| 16 |        7 |      3 |
+----+----------+--------+
1 row in set (0.00 sec)

mysql> select * from usrgrp where usrgrpid=7;
+----------+-----------------------+------------+--------------+------------+
| usrgrpid | name                  | gui_access | users_status | debug_mode |
+----------+-----------------------+------------+--------------+------------+
|        7 | Zabbix administrators |          0 |            0 |          1 |
+----------+-----------------------+------------+--------------+------------+
1 row in set (0.00 sec)

mysql>

[mall]

in my case, it had solved my issue...