Importation of triggers and applications

[crillus]

Hello,

I'm currently working on a migration of an old Zabbix Server 1.8 to a new VM using Zabbix Server 2.0.6 and I have some problems of export/import of some triggers and applications on a part of my hosts. So I have two problems.

My first problem occure when I generate an XML export file using zabbix frontend for all my hosts but when the application is on a specific host and not in a template the application is never exported (the file only contains a "<application/>" tag) and I don't know how to export them correctly.

An my second problem is that a big part of my triggers have been design on each specific hosts and I think that they are included in the XML file but when I try to import them I juste have the many errors like the following when I try the importation :

Incorrect item key "web.test.fail[Disponibilite BROUSSAILLES]" provided for trigger expression on "SLIS - Broussailles".

I think that if I could correctly export my applications, the triggers should be considered as valid... but I haven't found how to do it properly.

Have you ever encounter such problems ? I hope I've correctly explain them.


Thank you in advance,

[richlv]

1. the first is probably a limitation if the 1.8 xml export, although i'm not completely sure it's properly resolved in 2.0

2. the second happens because xml import/export is not available for web monitoring related entities - https://support.zabbix.com/browse/ZBXNEXT-178 asks for that

keeping the existing database and upgrading it might be the only choice besides manual reconfiguration

[crillus]

Thank you for your response,

I the same time that I make a migration from 1.8.5 to 2.0.6 I make a migration from mysql to postgresql so I can't do an upgrade.

It's so bad, but I've begun to recreate manually the triggers and the applications.Apparently there isn't any problems for the applications but I can't recreate my triggers with just a copy/past of the expression, because when I do that I have a syntax problem.

In example, on one of my hosts 'external server' I create the following trigger for testing google :

{external server:web.test.fail[Disponibilite Google].last(0)}=1

It tells me something like ' "external server" item not found' when I try to create it. But there were not any items declared in the old zabbix server and it worked perfectly. Did the trigger functionalities completely changed between the versions ?

[richlv]

I the same time that I make a migration from 1.8.5 to 2.0.6 I make a migration from mysql to postgresql so I can't do an upgrade.

that can be done, actually - dumping the db in a simplified syntax can allow importing in pgsql. localised characters can cause issues, though.

what i would also suggest to try - set up zabbix 1.8.16 frontend in parallel and try exporting from there. maybe application export issue is fixed there, i can't recall it in detail right now

{external server:web.test.fail[Disponibilite Google].last(0)}=1

It tells me something like ' "external server" item not found' when I try to create it. But there were not any items declared in the old zabbix server and it worked perfectly. Did the trigger functionalities completely changed between the versions ?

it's not triggers. as i noted before, web scenarios are not supported for xml export/import. you don't have any monitoring of them anymore...

[crillus]

Actually I already tried to move my database from mysql to postgresql using several methods (parse, adapted dump ...) no one has worked due to problems with the history tables and one of the configuration table.


But it's not important.

Sorry for the time to answer, I tried to export using Zabbix 1.8.16 and it didn't work better.

But thank you about the web scenarii, it seems to be the source of my problems for a big part of my triggers, despite I could import them I can recreate them on the new VM now. So I gonna copy all my web scenarii before to retry to import my triggers (or finally recopy them manually).

It's all for now. I keep you in touch, thank you very much !