Page 1 of 1
After upgrade to 5.7.1 all host and services state pendi
Posted: Mon Jun 15, 2020 7:01 am
by jpucholt
Hello,
after upgrade nagiosXI from version 5.6.12 to 5.7.1 are all checks and hosts in pending state.
In log file /usr/local/nagios/var/nagios.log i see this error:
Code: Select all
DO-3: ndo_return = 1 (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=')
[1592220845] NDO-3: ndo_get_object_id_name2(ndo.c:1161): Unable to execute statement
[1592220845] NDO-3: ndo_return = 1 (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=')
[1592220845] NDO-3: send_subquery(ndo-startup.c:438): Unable to execute statement
[1592220845] NDO-3: subquery failed to send in ndo_write_services_objects
[1592220845] NDO-3: ndo_write_services() failed. Disabling NDO.
Thanks for help.
Re: After upgrade to 5.7.1 all host and services state pendi
Posted: Mon Jun 15, 2020 4:37 pm
by benjaminsmith
Hi,
It looks to be a database collation error maybe, please run the following sql query and post the output.
Code: Select all
#Log into MySQL
mysql -uroot -pnagiosxi
# Run the following query and post the output
SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME
FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'nagios';
Also, can you send us your system profile, we'd like to check the settings in the ndo.cfg file. Thanks, Benjamin
To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.
Re: After upgrade to 5.7.1 all host and services state pendi
Posted: Tue Jun 16, 2020 2:45 am
by jpucholt
Hello, select is here:
Code: Select all
mysql> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME
-> FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'nagios';
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| latin1 | latin1_swedish_ci |
+----------------------------+------------------------+
1 row in set (0.00 sec)
Re: After upgrade to 5.7.1 all host and services state pendi
Posted: Tue Jun 16, 2020 3:17 pm
by benjaminsmith
Hi
@jpucholt,
Thanks for sending over your system profile. It looks this is from the Cent 6 / XI 5.6.8 server. Was this taken before the upgrade or were able to revert back the current system? Please let me know.
Currently, there are two separate issues with 5.7 on this system, the database collation error you're reported, and an issue that has been discovered with ModGearman ( not sure if they are related or not). We are working first to resolve the ModGearman error and I can provide steps once this is complete.
Benjamin
Re: After upgrade to 5.7.1 all host and services state pendi
Posted: Thu Jun 18, 2020 3:47 am
by jsimek
Hi Benjamin.
The system profile sent by my colleague comes from our production instance of Nagios XI, which is still in 5.6.8 version. I am sending you the correct file from our broken 5.7.1. testing instance.
DB select is nevertheless the same:
mysql> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME
-> FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'nagios';
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| latin1 | latin1_swedish_ci |
+----------------------------+------------------------+
1 row in set (0.00 sec)
Thanks!
Jaroslav
Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.
Re: After upgrade to 5.7.1 all host and services state pendi
Posted: Thu Jun 18, 2020 4:02 pm
by benjaminsmith
Hi Jaroslav,
Thanks for sending the profile from the test system. While it did successfully upgrade to 5.7.1, there are a few issues to work out here.
1. All the databases are offloaded, and the installer did not generate the correct ndo.cfg file for the new backend database.
2. Nage Core was not updated since the server is running Mod Gearman 2. There are numbers for important updates to Core in 5.7, so I would recommend upgrading Gearman to 3 to take advantage of these enhancements.
3. Some issues to correct with checks using check_nrpe
Let's move this over to a support ticket as it will be easier to work through these issues and it may require a remote session to fully resolve.
To open a support ticket go to:
https://support.nagios.com/tickets/
Please reference this forum thread when opening the ticket for fastest resolution.
Thanks,
Benjamin
Re: After upgrade to 5.7.1 all host and services state pendi
Posted: Mon Jun 22, 2020 10:59 am
by jsimek
I opened a ticket #453642
Jaroslav
Re: After upgrade to 5.7.1 all host and services state pendi
Posted: Mon Jun 22, 2020 12:24 pm
by benjaminsmith
Hi Jaroslav,
Thank you. I'll go ahead and lock this thread and we'll follow up with you in the ticket.