ZABBIX 1.8.4: MySQL Error.

[H2O1h]

Greetings from Venezuela.


I've compiled n' configured Zabbix 1.8.4, created Zabbix database and populated it with data.sql and mysql.sql, inserted images_mysql.sql on it and finally instaled the frontend succesfully.


but...

THIS IS WHAT HAPPENS WHEN FRONTEND IS OPENED:

* Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=2 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Unknown column 'r.type' in 'on clause']
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:411]
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:411]
* Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=2 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Unknown column 'r.type' in 'on clause']
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:411]
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:411]
* Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=2 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Unknown column 'r.type' in 'on clause']
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:411]
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:411]
* Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=2 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Unknown column 'r.type' in 'on clause']
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:411]
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:411]
* Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=2 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Unknown column 'r.type' in 'on clause']
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:411]
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/share/zabbix/include/db.inc.php:411]

Could anysoul help me please...!?



Thanks...!

[richlv]

hmm... i sense a bit of formatting overuse

but this looks awfully like zabbix 1.4 frontend against a recent version database

[H2O1h]

What do u mean? I can't get your point...

[H2O1h]

Hello richlv, I've solved the problem by compiling zabbix 1.4. and now it's working right using SNMP V2. I didn't realized that zabbix 1.8 came with 1.4 frontend.





Now, could you help me with some traffic OID's...?


Thank you very much for your help.

[Colttt]

which distribution do oyu use?!

do you install the php-mysql-modul for apache

[H2O1h]

Hi Shad0w, i'm running Debian Lenny...


Yes, I did install php-mysql.

[Colttt]

Hi Shad0w, i'm running Debian Lenny...

yehhaarr.. the best distri..

ehm, why you don´t use tha backports??

there ist zabbix in version 1.8.2 and its works fine..

btw:
in few days Debian Squeeze will be stable..

http://lists.debian.org/debian-devel-announce/2011/01/msg00003.html