good morning everyone.
I am running zabbix 4.1 over mysql database, the frontend is hosted on the same device.
after creating hosts, triggers, items etc, and maybe after someone of my company did something wrong on the GUI, I lost access to data, dashboard, hosts etc on the GUI.
meaning I am able to login but cannot edit anydashboard ( can only see the global view one), don't have anymore configuration neither administration option in the menu.
of course I have the same issue with my only 2 superadmin users.
I can see all data are there when querying sql, so I strongly suspect something is wrong on the permissions level.
here is the output of users, usrgrp and users_groups and rights table in my sql database.
If anyone can point out what I should change on the database in order to, at least, recover a default Admin user access level, that would be great.
MariaDB [zabbix]> select * from users;
+--------+------------+------------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+---------+----------------+------------+---------------+---------------+
| userid | alias | name | surname | passwd | url | autologin | autologout | lang | refresh | type | theme | attempt_failed | attempt_ip | attempt_clock | rows_per_page |
+--------+------------+------------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+---------+----------------+------------+---------------+---------------+
| 1 | Admin | Zabbix | Administrator | ******* | | 1 | 0 | en_GB | 30s | 3 | default | 0 | **** | 1562705234 | 50 |
| 2 | guest | | | ****** | | 0 | 15m | en_GB | 30s | 1 | default | 0 | | 0 | 50 |
| 3 | admin2 | admin2 | yachtadmin | ****** | | 0 | 0 | en_GB | 30s | 1 | default | 0 | | 0 | 50 |
+--------+------------+------------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+---------+----------------+------------+---------------+---------------+
3 rows in set (0.00 sec)
MariaDB [zabbix]> select * from usrgrp;
+----------+---------------------------+------------+--------------+------------+
| usrgrpid | name | gui_access | users_status | debug_mode |
+----------+---------------------------+------------+--------------+------------+
| 7 | Zabbix administrators | 0 | 0 | 0 |
| 8 | Guests | 1 | 0 | 0 |
| 9 | Disabled | 0 | 1 | 0 |
| 11 | Enabled debug mode | 0 | 0 | 1 |
| 12 | No access to the frontend | 3 | 0 | 0 |
| 13 | standard users | 0 | 0 | 0 |
+----------+---------------------------+------------+--------------+------------+
6 rows in set (0.01 sec)
MariaDB [zabbix]> select * from users_groups;
+----+----------+--------+
| id | usrgrpid | userid |
+----+----------+--------+
| 4 | 7 | 1 |
| 2 | 8 | 2 |
| 5 | 13 | 3 |
+----+----------+--------+
3 rows in set (0.01 sec)
MariaDB [zabbix]> select * from rights;
+---------+---------+------------+----+
| rightid | groupid | permission | id |
+---------+---------+------------+----+
| 1 | 13 | 2 | 21 |
| 2 | 13 | 2 | 29 |
| 3 | 13 | 2 | 7 |
| 4 | 13 | 2 | 2 |
| 5 | 13 | 2 | 17 |
| 6 | 13 | 2 | 19 |
| 7 | 13 | 2 | 18 |
| 8 | 13 | 2 | 20 |
| 9 | 13 | 2 | 23 |
| 10 | 13 | 2 | 22 |
| 11 | 13 | 2 | 27 |
| 12 | 13 | 2 | 24 |
| 13 | 13 | 2 | 16 |
| 14 | 13 | 2 | 25 |
| 15 | 13 | 2 | 6 |
| 16 | 13 | 2 | 15 |
| 17 | 13 | 2 | 4 |
+---------+---------+------------+----+
17 rows in set (0.00 sec)
MariaDB [zabbix]>
I am running zabbix 4.1 over mysql database, the frontend is hosted on the same device.
after creating hosts, triggers, items etc, and maybe after someone of my company did something wrong on the GUI, I lost access to data, dashboard, hosts etc on the GUI.
meaning I am able to login but cannot edit anydashboard ( can only see the global view one), don't have anymore configuration neither administration option in the menu.
of course I have the same issue with my only 2 superadmin users.
I can see all data are there when querying sql, so I strongly suspect something is wrong on the permissions level.
here is the output of users, usrgrp and users_groups and rights table in my sql database.
If anyone can point out what I should change on the database in order to, at least, recover a default Admin user access level, that would be great.
MariaDB [zabbix]> select * from users;
+--------+------------+------------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+---------+----------------+------------+---------------+---------------+
| userid | alias | name | surname | passwd | url | autologin | autologout | lang | refresh | type | theme | attempt_failed | attempt_ip | attempt_clock | rows_per_page |
+--------+------------+------------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+---------+----------------+------------+---------------+---------------+
| 1 | Admin | Zabbix | Administrator | ******* | | 1 | 0 | en_GB | 30s | 3 | default | 0 | **** | 1562705234 | 50 |
| 2 | guest | | | ****** | | 0 | 15m | en_GB | 30s | 1 | default | 0 | | 0 | 50 |
| 3 | admin2 | admin2 | yachtadmin | ****** | | 0 | 0 | en_GB | 30s | 1 | default | 0 | | 0 | 50 |
+--------+------------+------------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+---------+----------------+------------+---------------+---------------+
3 rows in set (0.00 sec)
MariaDB [zabbix]> select * from usrgrp;
+----------+---------------------------+------------+--------------+------------+
| usrgrpid | name | gui_access | users_status | debug_mode |
+----------+---------------------------+------------+--------------+------------+
| 7 | Zabbix administrators | 0 | 0 | 0 |
| 8 | Guests | 1 | 0 | 0 |
| 9 | Disabled | 0 | 1 | 0 |
| 11 | Enabled debug mode | 0 | 0 | 1 |
| 12 | No access to the frontend | 3 | 0 | 0 |
| 13 | standard users | 0 | 0 | 0 |
+----------+---------------------------+------------+--------------+------------+
6 rows in set (0.01 sec)
MariaDB [zabbix]> select * from users_groups;
+----+----------+--------+
| id | usrgrpid | userid |
+----+----------+--------+
| 4 | 7 | 1 |
| 2 | 8 | 2 |
| 5 | 13 | 3 |
+----+----------+--------+
3 rows in set (0.01 sec)
MariaDB [zabbix]> select * from rights;
+---------+---------+------------+----+
| rightid | groupid | permission | id |
+---------+---------+------------+----+
| 1 | 13 | 2 | 21 |
| 2 | 13 | 2 | 29 |
| 3 | 13 | 2 | 7 |
| 4 | 13 | 2 | 2 |
| 5 | 13 | 2 | 17 |
| 6 | 13 | 2 | 19 |
| 7 | 13 | 2 | 18 |
| 8 | 13 | 2 | 20 |
| 9 | 13 | 2 | 23 |
| 10 | 13 | 2 | 22 |
| 11 | 13 | 2 | 27 |
| 12 | 13 | 2 | 24 |
| 13 | 13 | 2 | 16 |
| 14 | 13 | 2 | 25 |
| 15 | 13 | 2 | 6 |
| 16 | 13 | 2 | 15 |
| 17 | 13 | 2 | 4 |
+---------+---------+------------+----+
17 rows in set (0.00 sec)
MariaDB [zabbix]>