upgrade issue 5.6.14 -> 5.8.6

[ssax]

In addition to my previous post (please do that).

If you're able to do a remote session, please create a ticket for this and include a link back to this forum thread so we can get a remote session setup:

https://support.nagios.com/tickets/

Thank you!

[erkanerturk]

Hi
we have suceeded to upgrade. here are my observations...
1- upgrade command was not enough.. only after ./rpmupgrade command, we were able to see 5.8.6 version string in GUI. why is this so?
2- although we have seen 5.8.6, in nagios.log we have seen DB errors.. we checked and found that ndo2db service were still running. we have stopped it. some of the errors has gone..
3- there were some other errors. we have noticed that these are due to turkish characters..

Code: Select all

[1637756836] NDO-3: The following query failed while MySQL appears to be connected:
[1637756836] NDO-3: SELECT object_id FROM nagios_objects WHERE objecttype_id = 2 AND name1 = 'RTP_10.11.32.196' AND name2 = 'Uygulaması'
[1637756836] NDO-3: ndo_return = 1 (Commands out of sync; you can't run this command now)
[1637756836] NDO-3: ndo_get_object_id_name2(ndo.c:1317): Unable to store results

we have changed these service/host names.. these errors has gone..
4- we have seen the following error

Code: Select all

1637758530] NDO-3: Note: preceding query is longer than allowed according to maximum SQL buffer size.

we have added the following lines in /etc/my.cnf.d/server.cnf file

Code: Select all

max_allowed_packet=512M
sort_buffer_size=512K

now we have no erros in nagios.log

so our upgrade process has finished successfully.. do you have any points to consider?
But i want to ask why turkish chaarcters has caused the errors? we have made your utf8 changes like you said (in /usr/local/nagiosxi/html/config.php.inc)..

PS: our ndo.cfg file: (this file created after upgrade. before upgrade we had only /usr/local/nagios/etc/ndo2db.cfg file..)

Code: Select all

[root@server nagiosxi]# cat /usr/local/nagios/etc/ndo.cfg
# Default NDO config for Nagios XI

db_user=ndoutils
db_pass=XXX
db_name=nagios
db_host=localhost
db_port=3306
#db_socket=/var/lib/mysql.sock
db_max_reconnect_attempts=5

acknowledgement_data=1
comment_data=1
contact_status_data=1
downtime_data=1
event_handler_data=1
external_command_data=1
flapping_data=1
host_check_data=1
host_status_data=1
log_data=1
main_config_data=1
notification_data=1
object_config_data=1
process_data=1
program_status_data=1
retention_data=1
service_check_data=1
service_status_data=1
state_change_data=1
system_command_data=1
timed_event_data=1

config_output_options=2

max_object_insert_count=250

mysql_set_charset_name=utf8

#log_failed_queries=1

[ssax]

1. A subscript of the RPM upgrade failed which means it didn't actually upgrade properly even though the RPMs showed the proper version in yum.

2/3. Please PM me a FRESH copy of your profile.zip, you can download it from Admin > System Status by clicking the Download System Profile button.

4. Those are the proper fixes for that:

You may want to change it to:

Code: Select all

sort_buffer_size=32M

I've submitted a bug report to development for this:

Code: Select all

NEW TASK ID 15692 created - Nagios XI Bug Report: XI - EL8 - MySQL 8 - ERROR 1038 (HY001): Out of sort memory, consider increasing server sort buffer size

[erkanerturk]

Hi

thank you for your direction in our case
i can not share profile due to organizational policies. but you can study it if we make a session together..

if you think that it is necessary to inspect profile, please direct me to open an issue ticket.

[ssax]

Are you still seeing NDO3 errors in your nagios.log?

Code: Select all

grep NDO3 /usr/local/nagios/var/nagios.log