Strange problem on

[bee]

Hi all,
i'm facing some strange problem, at least for me.
I've installed zabbix 1.4.1 on FreeBSD 4.11-STABLE with mysql 4.2. Installation running well no issue at all. I can login into zabbix web page and add new host and adding new SNMP v2 item(sysuptimeinstance).
The problem is, value of sysuptimeinstance did not show on zabbix web page. check the log and found these entries:

- enabling host test [test]
- cannot select host with hostid [xxxxxxxxxxxx]"

I've tried with other item, and the problem still occurs wtih the same error message on log file.



I'll be glad if there is someone who give me a bit clue on solve above issue.

Thanks,
BEE

[Alexei]

Please give me the full message, with xxxxxxxxx decrypted. Also do you have a host with the hostid equal to xxxxxxxxxxxxx:

select * from hosts where hostid=xxxxxxxxxx

where xxxxxx is your host id.

[bee]

Hi Alexei,
Thanks for you reply, here attached the full log:

359:20070730:084643 Cannot select host with hostid [8589944612]
359:20070730:084643 Enabling host [192.168.1.252]
359:20070730:084643 Cannot select host with hostid [8589944612]
359:20070730:084643 Enabling host [192.168.1.252]
359:20070730:084643 Cannot select host with hostid [8589944612]
359:20070730:084643 Enabling host [192.168.1.252]
359:20070730:084643 Cannot select host with hostid [8589944612]

Also, from zabbix database, cannot find the hostid as mentioned:

mysql> use zabbix;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from hosts where hostid=8589944612;
Empty set (0.01 sec)

In fact, the actual hostsid of monitored host are:
mysql> select * from hosts where host='192.168.1.252'
-> ;
+--------+-------------+-----+-------+-------------+-------+--------+---------------+-------+-----------+-------------+
| hostid | host | dns | useip | ip | port | status | disable_until | error | available | errors_from |
+--------+-------------+-----+-------+-------------+-------+--------+---------------+-------+-----------+-------------+
| 10020 | 192.168.1.252 | | 1 | 192.168.1.252 | 10050 | 0 | 0 | | 0 | 0 |
+--------+-------------+-----+-------+-------------+-------+--------+---------------+-------+-----------+-------------+
1 row in set (0.00 sec)

Thanks in advance.

Cheers,
BEE

[noxis]

I get exactly the same problem running a zabbix server and interface on FreeBSD 4.10. Is there any resolution to this?

Thanks.

Update: I have dumped the entire database and the value that it refers to as "hostid" does not appear anywhere. If it makes a difference the server is setup is a child node, node 2.

Update 2: It seems that whatever does the checking (poller?) it cant make an update to the database (wrong index?) as it loops over and over trying to enable a host but it doesnt get enabled. Manually enabling the host by updating the database then leads to it constantly trying to do its checks... however "show processlist" on the database show now update attempts (although the zabbix server user is connected).

[bee]

I get exactly the same problem running a zabbix server and interface on FreeBSD 4.10. Is there any resolution to this?

Unfortunetly no progress about this issue, and i don't have any idea on how to solve it as well. Hope in next release of zabbix will solve this issue.


Thanks,
BEE

[noxis]

Having spent a little time looking closer I *think* the problem is down to poller.c and the 32/64bit conversion. Alexei, this was introduced for Node support wasn't it? There appear to be issues *somewhere* in FreeBSD 4.x.

Any help here?

[Alexei]

Is there any chance to get a remote access to your box? Please send an email to a l e x @ z a b b i x @ c o m.

[noxis]

Is there any chance to get a remote access to your box? Please send an email to a l e x @ z a b b i x @ c o m.

I cant give you a login to that box but I can set it up on one of my own FreeBSD 4 boxes. Give me 15 - 30min...

[noxis]

Is there any chance to get a remote access to your box? Please send an email to a l e x @ z a b b i x @ c o m.

Done and sent. Many thanks for this.