I have a weird situation, probably I made some mistakes and I hope the community will help.
We have a problem with the lock tables during the optimize process, so after some research we've decided to upgrade the MySQL to a version compartible with 5.7, because as far as I know there is a way to avoid lock tables in the optimize process.
I'm doing some test in my INT environment:
Nagios Core 4.4.6
NagiosXI 5.8.7
MariaDB 5.5.68
NDO 3.0.7
I've upgraded the MariaDB component to 10.6.10 and now I'm receiving this messages in nagios.log file:
cat /usr/local/nagios/var/nagios.log | grep NDO-3
Code: Select all
[1668164808] NDO-3: Callbacks deregistered
[1668164808] NDO-3: NDO - Shutdown complete
[1668164810] NDO-3: NDO 3.0.7 (c) Copyright 2009-2020 Nagios - Nagios Core Development Team
[1668164810] NDO-3: Unable to connect to mysql. Configuration may be incorrect or database may have temporarily disconnected.
[1668164810] NDO-3: NDO was not able to initialize the database (main context) and will not start.
Code: Select all
| localhost | ndoutils | {"access":549755813887,"version_id":100610,"plugin":"mysql_native_password","authentication_string":"*244733929909A95DDF1A7F78DD067589B4092EE7","password_last_changed":1667467358}
/usr/local/nagios/etc/ndo.cfg with "default" conf:
Default NDO config for Nagios XI
Code: Select all
db_user=ndoutils
db_pass=*************
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
Code: Select all
...
# NDOUtils module
# Commented out by NDO 'make install-broker-line' on Tue Feb 8 12:09:40 CET 2022
#broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg
...
# Added by NDO 'make install-broker-line' on Tue Feb 8 12:09:40 CET 2022
broker_module=/usr/local/nagios/bin/ndo.so /usr/local/nagios/etc/ndo.cfg
Code: Select all
mysql -undoutils -D nagios -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 827
Server version: 10.6.10-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [nagios]>
Why NDO3 can't login into the database?
Thanks in advance.
BR,
Juanma.