Auto discovery and graphs

[krims0n]

Hello,

First of all, nice work. Zabbix is looking very promising. While testing I ran into a bug (I think).

We auto-link a template to a host that is discovered using auto-discovery. This template has 4 graphs attached to it. However, when a new host is discovered, only 1 graph is available. Everything else seems to be fine. When manually adding a host and binding it to this template, all graphs are there.

Zabbix 1.4.2, with mysql backend.

[krims0n]

Just bumped into an SQL error that might be related. This occurs when I go to Configuration->Graphs and then select Group all and Host all.

* Error in query [select distinct g.* from graphs g left join graphs_items gi on g.graphid=gi.graphid left join items i on gi.itemid=i.itemid while (g.graphid div 100000000000000) in (0) and ( i.hostid not in (-1) OR i.hostid is NULL ) order by g.name, g.graphid] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'while (g.graphid div 100000000000000) in (0) and ( i.hostid not in (-1) OR i.' at line 1]
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/data/nagios/zabbix/www/include/db.inc.php:411]

[Aly]

Try checking this threat link

[krims0n]

Thanks, that fixed the SQL error.

It didn't fix the problem with the graphs & autodiscovery though. Alexei, is this a known issue or should I report it as a bug ?

[Alexei]

Thanks, that fixed the SQL error.

It didn't fix the problem with the graphs & autodiscovery though. Alexei, is this a known issue or should I report it as a bug ?

Please try the latest 1.4.x from www.zabbix.com/developers.php. I believe this already fixed there as well.

[krims0n]

I downloaded pre-1.4.2, but can't get zabbix server to run:

./zabbix_server -c ../etc/zabbix_server.conf

then it just dies:

16798:20070903:101753 Starting zabbix_server. ZABBIX 1.4.3.
16798:20070903:101753 In ip_in_list(list:10.0.0.1-255,ip:10.0.0.30)
16798:20070903:101753 End ip_in_list(ret:SUCCEED)
16798:20070903:101753 In ip_in_list(list:192.168.0.1-255,192.168.1.1-255,ip:192.168.2.201)
16798:20070903:101753 End ip_in_list(ret:FAIL)
16798:20070903:101753 In ip_in_list(list:172.16.0.0,172.16.0.1,172.16.0.2-200,172.16.0.201,ip:172.16.0.201)
16798:20070903:101753 End ip_in_list(ret:SUCCEED)
16798:20070903:101753 In ip_in_list(list:172.31.255.1-255,ip:172.31.255.43)
16798:20070903:101753 End ip_in_list(ret:SUCCEED)
16798:20070903:101753 In ip_in_list(list:86.57.15.94,ip:86.57.15.95)
16798:20070903:101753 End ip_in_list(ret:FAIL)
16798:20070903:101753 In ip_in_list(list:86.57.15.94,ip:86.57.15.94)
16798:20070903:101753 End ip_in_list(ret:SUCCEED)
16798:20070903:101755 ZABBIX Server stopped

[Alexei]

Please try now. The files were updated.

[krims0n]

Thanks. Tried again, the problem is still there though, I still see only one graph instead of 3 on an auto-discovered host.

I tested this by removing all hosts and having autodiscovery re-add them.

[Alexei]

I will do more research...

[krims0n]

Just checking back in, did you find a fix for this issue ?