I have a weird problem. When I converted my zabbix installation over to DM, none of the hosts are validating anymore. I did the database conversion and the hostid's were updated ( adding 11 infront ). Now any checker looking up hosts or groups are not adding the 11 in the front thus not working.
agentd log
... No active checks on server: host [Wazoo] not found
server log
... Sending list of active checks to [---] failed: host [Wazoo] not found
mysql> select hostid,status,proxy_hostid from hosts where host='Wazoo';
+------------------+--------+--------------+
| hostid | status | proxy_hostid |
+------------------+--------+--------------+
| 1101100000010047 | 0 | 0 |
+------------------+--------+--------------+
1 row in set (0.00 sec)
Here is where it is failing. The above query is only part of what is checked when the host asks for active checks.
select hostid,status from hosts where host='Wazoo' and status in (0,1) and proxy_hostid=0 and hostid between 000000000000000 and 099999999999999;
Notice the hostid?
000000000000000 << Range Low
099999999999999 << Range High
1101100000010047 << hostid with node 11
It would appear the nodeID is not being taken into account. Is there something I missed when setting this server as node 11? It shows as nodeid 11 in the database.
mysql> select * from nodes;
+--------+---------------+----------+--------------+-------+---------------+--------------+----------+----------+
| nodeid | name | timezone | ip | port | slave_history | slave_trends | nodetype | masterid |
+--------+---------------+----------+--------------+-------+---------------+--------------+----------+----------+
| 1 | LocationA | -7 | --- | 10051 | 90 | 365 | 0 | 0 |
| 11 | LocationB | -7 | --- | 10051 | 30 | 365 | 1 | 1 |
+--------+---------------+----------+--------------+-------+---------------+--------------+----------+----------+
2 rows in set (0.00 sec)
Any ideas or thoughts would be greatly appreciated.
agentd log
... No active checks on server: host [Wazoo] not found
server log
... Sending list of active checks to [---] failed: host [Wazoo] not found
mysql> select hostid,status,proxy_hostid from hosts where host='Wazoo';
+------------------+--------+--------------+
| hostid | status | proxy_hostid |
+------------------+--------+--------------+
| 1101100000010047 | 0 | 0 |
+------------------+--------+--------------+
1 row in set (0.00 sec)
Here is where it is failing. The above query is only part of what is checked when the host asks for active checks.
select hostid,status from hosts where host='Wazoo' and status in (0,1) and proxy_hostid=0 and hostid between 000000000000000 and 099999999999999;
Notice the hostid?
000000000000000 << Range Low
099999999999999 << Range High
1101100000010047 << hostid with node 11
It would appear the nodeID is not being taken into account. Is there something I missed when setting this server as node 11? It shows as nodeid 11 in the database.
mysql> select * from nodes;
+--------+---------------+----------+--------------+-------+---------------+--------------+----------+----------+
| nodeid | name | timezone | ip | port | slave_history | slave_trends | nodetype | masterid |
+--------+---------------+----------+--------------+-------+---------------+--------------+----------+----------+
| 1 | LocationA | -7 | --- | 10051 | 90 | 365 | 0 | 0 |
| 11 | LocationB | -7 | --- | 10051 | 30 | 365 | 1 | 1 |
+--------+---------------+----------+--------------+-------+---------------+--------------+----------+----------+
2 rows in set (0.00 sec)
Any ideas or thoughts would be greatly appreciated.