NDO2DB - Table nagios.nagios_conninfo does not exist

[JadedNI]

Hi

I've installed a backup Nagios XI 5.8.1 server, and as the LIVE server had downgraded NDO 3 back to NDO2DB I did the same on the fresh build.

I followed these steps while downgrading:

systemctl stop nagios
mkdir /tmp/utilities/downgrade
cd /tmp/utilities/downgrade
wget https://assets.nagios.com/downloads/nag ... .14.tar.gz
tar zxf xi-5.6.14.tar.gz
cd /tmp/utilities/downgrade/nagiosxi/subcomponents/ndoutils
./install
systemctl enable ndo2db
systemctl start ndo2db

Edited the /usr/local/nagios/etc/nagios.cfg to load ndo2db not NDO 3

When I restarted nagios and checked the status of the ndo2db service I see the following errors:

Jun 15 14:58:27 ####### ndo2db[process#1]: Error: mysql_query() failed for 'UPDATE nagios_conninfo SET last_checkin_time...d='0''
Jun 15 14:58:27 ####### ndo2db[process#1]: mysql_error: 'Table 'nagios.nagios_conninfo' doesn't exist'

Any assistance, greatly appreciated

[vtrac]

Hi,
How are you doing?
I have attached the "nagios_conninfo.sql" file.
Please download the file and put it under "/tmp".

nagios_conninfo.sql

Install instruction
Please open the Nagios XI command prompt and run the following commands:

Code: Select all

cd /tmp

mysql -uroot -pnagiosxi nagios < nagios_conninfo.sql

Best Regards,
Vinh

[JadedNI]

Hi Vinh

Running the .sql file looks to have resolved the issue.
I'm no longer seeing any messages relating to the conninfo table not existing.
Would you have any idea why the table would have failed to be created when I ran the ./install command?

Thanks for your assistance.

[vtrac]

Hi,
How are you doing?
I'm glad that this has help resolved the issue you are having.

Since 5.8.x came default with NDO3. I check with development, here's what they said:

Yea, if they're using ndo-2, they'll need to re-add that table to their database.

Best Regards,
Vinh