After upgrade to 5.7.1 all host and services state pendi

[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.

[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.

[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)

Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.

[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

[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.

[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

[jsimek]

I opened a ticket #453642

Jaroslav

[benjaminsmith]

Hi Jaroslav,

Thank you. I'll go ahead and lock this thread and we'll follow up with you in the ticket.