Nagios Support Forum

Hello,
Please assist
I am trying to install Nagios XI on a clean RHEL 7.* VM, followed the documentation on how to install Nagios XI in a offline environment.
when I tried to install as root, its prompting for password, I tried my root password, nagiosadmin default password "nagiosxi" both didn't work.

Installing : nagiosxi-ndoutils-5-4.13.el7.x86_64
Installing : perl-Crypt-Rijndael-1.12-1.el7.x86_64
Installing : perl-Mail-IMAPClient-3.37-1.el7.noarch
Installing : fping-3.10-4.el7.x86_64
Installing : nagiosxi-nagiosql-5-4.13.el7.x86_64
Installing : perl-Number-Format-1.73-14.el7.noarch
Installing : libidn2-0.10-2.el7.x86_64
Installing : jwhois-4.0-38.el7.x86_64
Installing : nagiosxi-5-4.13.el7.x86_64
Enter password:
Enter password:

Thanks,

Had you previously installed mysql and created a password for that? If so it may be asking for that root password

Hi,

I have entered and proceeded further with installation, the installation is success but we ran in to database errors and NAGIOSSQL write configs failed.

LOGIN SUCCESSFUL!
URL: http://localhost/nagiosxi/includes/components/ccm/
CMDLINE:
/usr/bin/wget --load-cookies=nagiosql.cookies http://localhost/nagiosxi/includes/components/ccm/ --no-check-certificate --post-data 'backend=1&cmd=apply&type=writeConfig' -O nagiosql.export.monitoring
--2018-04-12 14:57:21-- http://localhost/nagiosxi/includes/components/ccm/
Resolving localhost (localhost)... 127.0.0.1
Connecting to localhost (localhost)|127.0.0.1|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: 'nagiosql.export.monitoring'

0K .......... ........ 2.47M=0.007s

2018-04-12 14:57:21 (2.47 MB/s) - 'nagiosql.export.monitoring' saved [18525]

NAGIOSQL WRITE CONFIGS FAILED!\n


errors:
ALTER TABLE `nagios_logentries` DROP INDEX `logentry_time_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'logentry_time_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_logentries` DROP INDEX `logentry_data_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'logentry_data_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_logentries` DROP INDEX `instance_id_2` ;
ALTER TABLE `nagios_statehistory` DROP INDEX `state_time_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'state_time_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_statehistory` DROP INDEX `object_id_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'object_id_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_notifications` DROP INDEX `start_time_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'start_time_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_notifications` DROP INDEX `object_id_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'object_id_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_notifications` DROP INDEX `instance_id_2` ;
ALTER TABLE `nagios_contactnotifications` DROP INDEX `notification_id_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'notification_id_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_contactnotifications` DROP INDEX `contact_object_id_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'contact_object_id_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_contactnotificationmethods` DROP INDEX `contactnotification_id_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'contactnotification_id_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_objects` DROP INDEX `objecttype_id_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'objecttype_id_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_objects` DROP INDEX `name1_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'name1_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_objects` DROP INDEX `name2_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'name2_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_objects` DROP INDEX `is_active_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'is_active_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_timedeventqueue` DROP INDEX `queued_time_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'queued_time_2'; check that column/key exists</pre></p>
ALTER TABLE `nagios_timedevents` DROP INDEX `queued_time_2` ;
<p><pre>SQL Error [ndoutils] : Can't DROP 'queued_time_2'; check that column/key exists</pre></p>
NDOUtils patched to level 103 successfully.


Thanks,

The bottom portion is not a problem.

The NAGIOSQL WRITE CONFIGS FAILED! is definitely a problem, and my guess is that something didn't get installed correctly.

Can you post your install.log from the installation directory.

Thanks

I have attached the install.log file, have a look at it and help me in resolving the issue.

Thanks,

Thanks, please also attach /usr/local/nagiosxi/scripts/nagiosql.export.monitoring

Thanks.

Can you please see the other thread of Installation error and help on it.
https://support.nagios.com/forum/viewto ... =6&t=48549

See a solution for the same issue here: https://support.nagios.com/forum/viewto ... 11#p251211

Thanks, it worked for me.

Great! I am locking this topic.