Nagios Support Forum

Hello Nagios Team, especially Jeffrey Dunitz and Tom Griep.
Let me inform you about my progress in upgrading our Nagios xi 5.6.8 to a much recent version. In the last few months I have been trying with your help (support ticket #383868) to upgrade to several versions of xi as they were announced. Most of them caused me problems with interpretation of Czech diacritics and the upgrade process did skip to upgrade the ndo. It seems that the only version I did not try to upgrade to was 5.7.3. And it is, coincidentally, this version that upgrades the ndo correctly (it doesn't leave me with ndo2db) and that also does display most of Czech characters well.

I realized that after upgrading to 5.7.3 some fields in nagios DB did change it's collation from latin1_swedish_ci to utf8_bin. The fields were name1 and name2 in table nagios_objects. And these were the only ones displayed OK. So I decided to change collation to utf8 in the rest of the tables in this DB too ... and it worked! Since then everything looks OK and upgrading to further versions is smooth and flawless again.

Because changing collation did not work in all the other 5.7.x versions of xi - those, where ndo2db was not replaced by ndo3 - it leaves me with conclusion that the presence of ndo2db was guilty.

Anyway, thank you for your effort. I learned much during our attempts to fix this problem!

All's well that ends well.

Best regards.
Jaroslav

To je skvělá zpráva!

I'm glad we could help make this work for you, and I only wish we could have found the answer for you more quickly.

Nonetheless, I'm glad you were able to find a solution--we'll look into it a bit more based on what you've discovered here to find out why certain versions would behave differently than others.

Enjoy your properly-working xi system! And we're always here to help!

--Jeffrey