I've just upgraded my Ubuntu install from 12.04 to 12.10. This upgraded zabbix from 1.8.11 to 2.0.2.
The first time I tried to access it after the upgrade, I was given the install dialogue, which I followed through. I had to download and copy the zabbix.conf.php file to the zabbix conf directory (/etc/zabbix), and give www-data permissions for it.
Now when I browse to it, I get what looks like the old interface but with lots of parts of it replaced by php error messages, all of which are along the lines of:
(lines like that first line appear a LOT, but the forum is preventing me from posting them since I guess the square brackets make it think I'm spamming)
Is this because I didn't upgrade the database? If so, how do I do that? The upgrade script files mentioned in the zabbix documentation don't seem to exist in an Ubuntu install. Where can I find them?
The first time I tried to access it after the upgrade, I was given the install dialogue, which I followed through. I had to download and copy the zabbix.conf.php file to the zabbix conf directory (/etc/zabbix), and give www-data permissions for it.
Now when I browse to it, I get what looks like the old interface but with lots of parts of it replaced by php error messages, all of which are along the lines of:
Code:
Undefined index: severity_name_5 [include/triggers.inc.php:250]
Error in query [SELECT DISTINCT t.*,hg.groupid FROM triggers t,functions f,items i,hosts_groups hg WHERE hg.hostid=i.hostid AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND (hg.groupid IN ('4','2')) AND NOT EXISTS ( SELECT ff.functionid FROM functions ff WHERE ff.triggerid=t.triggerid AND EXISTS ( SELECT ii.itemid FROM items ii,hosts hh WHERE ff.itemid=ii.itemid AND hh.hostid=ii.hostid AND ( ii.status<>0 OR hh.status<>0 ) ) ) AND t.status=0 AND ( (t.value IN ('1')) AND (t.flags IN ('0','4')) ) ORDER BY lastchange DESC,t.lastchange DESC] [Unknown column 't.flags' in 'where clause']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:569]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:570]
Error in query [SELECT DISTINCT h.hostid,h.name,f.triggerid FROM hosts h,functions f,items i WHERE 1=0 AND h.hostid=i.hostid AND f.itemid=i.itemid AND h.status IN (0,1,3)] [Unknown column 'h.name' in 'field list']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:569]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:570]
Is this because I didn't upgrade the database? If so, how do I do that? The upgrade script files mentioned in the zabbix documentation don't seem to exist in an Ubuntu install. Where can I find them?