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