Converting to nodeid 1.4.1 [solved]

[limo]

Hi to all,

I just converted our zabbix server from normal instalation to nodeid 1. Because it was not so easy, I want to share my experiences.

zabbix_server -n 1 coverted most of thinks but there were some mistakes:

- there was problem with images because of id changes. I had to do something like

update images set imageid=imageid-100000000000000;

- there was problem with actions because of variable ids change.

update conditions set value=CAST(value+100000000000000 AS unsigned)

Now it seems to work. Please note this will work only for nodeid=1. And take care of this, because it can damage your zabbix references. And , I am not sure that my fix is clean way. This should be fixed inside zabbix_server process when changing nodeid. But it works for me....


Lukas

[limo]

Just reminder, I found a mistake, there are even string and trigger values in condition variables, so this update will break it. There should be some where clausule which will repair only some rows, not all... but I have no time to spent on it now.