Stable 1.4.2 has broken permission on events viewer (anon user can browse zabbix events) and seems this not only mine problem. Thread http://www.zabbix.com/forum/showthread.php?t=7853 suggests it can be fixed in svn tree so I'm start testing patch from 1.4 branch.
Seems now is partially better than before .. partially because anon user can't browse events but also anyone other can't do this too.
On enter to monitoring -> events I see now bunch of errors:
* pg_query() [function.pg-query]: Query failed: ERROR: column t.type does not exist LINE 1: ...erid,t.priority,t.description,t.expression,h.ho st,t.type FR... ^[/srv/httpd/apps/zabbix/include/db.inc.php:293]
* Error in query [SELECT DISTINCT t.triggerid,t.priority,t.description,t.expression, h.host,t.type FROM triggers t, functions f, items i, hosts h , hosts_groups hg WHERE (t.triggerid/100000000000000) in (0) AND t.triggerid=f.triggerid and f.itemid=i.itemid AND i.hostid=h.hostid and h.hostid in (-1) and h.status=0] [ERROR: column t.type does not exist LINE 1: ...erid,t.priority,t.description,t.expression,h.ho st,t.type FR... ^]
* pg_fetch_array() expects parameter 1 to be resource, boolean given[/srv/httpd/apps/zabbix/include/db.inc.php:414]
* pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near ")" LINE 1: ...e WHERE MOD(e.object,1000)=0 AND e.objectid IN () AND e.va... ^[/srv/httpd/apps/zabbix/include/db.inc.php:293]
* Error in query [SELECT e.eventid, e.objectid as triggerid,e.clock,e.value FROM events e WHERE MOD(e.object,1000)=0 AND e.objectid IN () AND e.value<>2 ORDER BY e.eventid DESC limit 1000] [ERROR: syntax error at or near ")" LINE 1: ...e WHERE MOD(e.object,1000)=0 AND e.objectid IN () AND e.va... ^]
* pg_fetch_array() expects parameter 1 to be resource, boolean given[/srv/httpd/apps/zabbix/include/db.inc.php:414]
Seems now is partially better than before .. partially because anon user can't browse events but also anyone other can't do this too.
On enter to monitoring -> events I see now bunch of errors:
* pg_query() [function.pg-query]: Query failed: ERROR: column t.type does not exist LINE 1: ...erid,t.priority,t.description,t.expression,h.ho st,t.type FR... ^[/srv/httpd/apps/zabbix/include/db.inc.php:293]
* Error in query [SELECT DISTINCT t.triggerid,t.priority,t.description,t.expression, h.host,t.type FROM triggers t, functions f, items i, hosts h , hosts_groups hg WHERE (t.triggerid/100000000000000) in (0) AND t.triggerid=f.triggerid and f.itemid=i.itemid AND i.hostid=h.hostid and h.hostid in (-1) and h.status=0] [ERROR: column t.type does not exist LINE 1: ...erid,t.priority,t.description,t.expression,h.ho st,t.type FR... ^]
* pg_fetch_array() expects parameter 1 to be resource, boolean given[/srv/httpd/apps/zabbix/include/db.inc.php:414]
* pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near ")" LINE 1: ...e WHERE MOD(e.object,1000)=0 AND e.objectid IN () AND e.va... ^[/srv/httpd/apps/zabbix/include/db.inc.php:293]
* Error in query [SELECT e.eventid, e.objectid as triggerid,e.clock,e.value FROM events e WHERE MOD(e.object,1000)=0 AND e.objectid IN () AND e.value<>2 ORDER BY e.eventid DESC limit 1000] [ERROR: syntax error at or near ")" LINE 1: ...e WHERE MOD(e.object,1000)=0 AND e.objectid IN () AND e.va... ^]
* pg_fetch_array() expects parameter 1 to be resource, boolean given[/srv/httpd/apps/zabbix/include/db.inc.php:414]
Comment