-
Documentation task
-
Resolution: Unresolved
-
Major
-
7.0.5
-
None
-
AlmaLinux8
Zabbix 7.0.5
MariaDB 10.5.1
-
Documentation backlog
-
0.1
On Zabbix 7.0 documentation, MariaDB 10.5.00-11.5.X are supported, but an issue below occurs at least on 10.5.1.
Steps to reproduce:
- Create user and apply the settings below
- On "User roles" page, set the "User type" to Admin or User, and uncheck "Dashboards" of "Access to UI elements".
- On "User groups" page, add any host groups to "Host permissions".
- Login to Zabbix web frontend with the user configured above.
Result:
Zabbix shows Monitoring>Problems page with an error message "System error occurred. Please contact Zabbix administrator."
Query error is also output on error_log of HTTPD.
[Fri Dec 13 06:30:03.906245 2024] [proxy_fcgi:error] [pid 3531:tid 140232049501952] [client 192.168.10.155:51139] AH01071: Got error 'PHP message: PHP Warning: Error in query [SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity,p.cause_eventid FROM problem p,functions f,items i,host_hgset hh,permission pp WHERE p.source=0 AND p.object=0 AND p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hh.hostid AND hh.hgsetid=pp.hgsetid AND pp.ugsetid=2 AND NOT EXISTS (SELECT NULL FROM functions f1 JOIN items i1 ON f1.itemid=i1.itemid JOIN host_hgset hh1 ON i1.hostid=hh1.hostid LEFT JOIN permission pp1 ON hh1.hgsetid=pp1.hgsetid AND pp1.ugsetid=pp.ugsetid WHERE p.objectid=f1.triggerid AND pp1.permission IS NULL) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND p.cause_eventid IS NULL AND (p.r_eventid IS NULL OR p.r_clock>1734071103) ORDER BY p.eventid DESC LIMIT 1001] [Unknown column 'pp.ugsetid' in 'on clause'] in /usr/share/zabbix/include/db.inc.php on line 243', referer: http://192.168.11.212/zabbix/zabbix.php?show=1&name=&acknowledgement_status=0&inventory%5B0%5D%5Bfield%5D=type&inventory%5B0%5D%5Bvalue%5D=&evaltype=0&tags%5B0%5D%5Btag%5D=&tags%5B0%5D%5Boperator%5D=0&tags%5B0%5D%5Bvalue%5D=&show_tags=3&tag_name_format=0&tag_priority=&show_opdata=0&show_timeline=1&filter_name=&filter_show_counter=0&filter_custom_time=0&sort=clock&sortorder=DESC&age_state=0&show_symptoms=0&show_suppressed=0&acknowledged_by_me=0&compact_view=0&details=0&highlight_row=0&action=problem.view
After upgrading to MariaDB 10.5.27, the error does not appear.
- mentioned in
-
Page Loading...