Backend login to the Core Config Manager failed

[pteegarden]

I have installed and played with 2 other demo versions of NagiosXI. Added/deleted hosts/services - all worked fine.

Management decided to purchase and I decided to get a new one up and running on new hardware.
Once we get the license, I can easily install it without having to restart from scratch.

I thought I would just try to add a server as a test. it fails with:


Linux Server Monitoring Wizard
<green check> Configuration submitted for processing...
<red exclaimation> Waiting for configuration verification....
<red exclaimation> Backend login to the Core Config Manager failed.

Configuration Error

An error occurred while attempting to apply your configuration to the monitoring engine.
Contact your Nagios administrator if this problem persists.


What? Yes, I did change the default passwords (twice) but maybe I did something wrong.
Even though I can login to the CCM, it seems that NagiosXI is having a hard time on the Backend?

I then went into Admin -> Reset Security Credentials. Rebooted. And tried to add the server again.
Same error.

I am at a loss as to what to try next.

[scottwilkerson]

Please follow this procedure and attach reconfig.txt & cmd.txt

http://support.nagios.com/wiki/index.ph ... n_Problems

[pteegarden]

Thanks for the quick response. I have run the two procedures and generated the two files.

[lmiltchev]

Run the following command and show us the output:

Code: Select all

ll /usr/local/nagiosxi/scripts | grep nagiosql

[pteegarden]

[root@monitor ~]# ll /usr/local/nagiosxi/scripts | grep nagiosql
-rwxr-x--- 1 nagios nagios 649 Feb 4 14:06 export_nagiosql.sh
-rwxr-x--- 1 nagios nagios 429 Feb 4 14:06 import_nagiosql.sh
-rw-r--r-- 1 root root 153 Feb 10 11:47 nagiosql.cookies
-rwxr-x--- 1 nagios nagios 272372 Feb 4 14:06 nagiosql_defaults.sql
-rwxr-x--- 1 nagios nagios 970 Feb 4 14:06 nagiosql_delete_contact.php
-rwxr-x--- 1 nagios nagios 2010 Feb 4 14:06 nagiosql_delete_host.php
-rwxr-x--- 1 nagios nagios 505 Feb 4 14:06 nagiosql_delete_object.sh
-rwxr-x--- 1 nagios nagios 3118 Feb 4 14:06 nagiosql_delete_service.php
-rwxr-x--- 1 nagios nagios 993 Feb 4 14:06 nagiosql_delete_timeperiod.php
-rw-r--r-- 1 root root 7400 Feb 4 14:07 nagiosql.export.additional
-rwxr-x--- 1 nagios nagios 1637 Feb 4 14:06 nagiosql_exportall.php
-rw-r--r-- 1 root root 7096 Feb 4 14:07 nagiosql.export.monitoring
-rwxr-x--- 1 nagios nagios 1323 Feb 4 14:06 nagiosql_importall.php
-rw-r--r-- 1 root root 11680 Feb 4 14:06 nagiosql.import.monitoring
-rw-r--r-- 1 root root 116 Feb 10 11:47 nagiosql.login
-rwxr-x--- 1 nagios nagios 1847 Feb 4 14:06 nagiosql_login.php
-rwxr-x--- 1 nagios nagios 2108 Feb 4 14:06 nagiosql_snapshot.sh
-rwxr-x--- 1 nagios nagios 258 Feb 4 14:06 nagiosql_trim_backups.sh

the nagiosql.login file contains only the following line:
Error while connecting to database:<br>[localhost] Connection to the database server has failed by reason:<br>

[lmiltchev]

Run the following command in terminal:

Code: Select all

chown nagios:nagios /usr/local/nagiosxi/scripts/nagiosql*

Then try to run again:

Code: Select all

cd /usr/local/nagiosxi/scripts
./reconfigure_nagios.sh

[pteegarden]

Ok, I did the chown, and then ran:
[root@monitor ~]# cd /usr/local/nagiosxi/scripts
[root@monitor scripts]# ./reconfigure_nagios.sh
URL: http://localhost/nagiosql/index.php
CMDLINE
/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies http://localhost/nagiosql/index.php --no-check-certificate --post-data 'Submit=Login&tfUsername=nagiosxi&tfPassword=nuurtf' -O nagiosql.login--2013-02-11 10:02:38-- http://localhost/nagiosql/index.php
Resolving localhost... ::1, 127.0.0.1
Connecting to localhost|::1|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 116 [text/html]
Saving to: ânagiosql.loginâ

100%[======================================================================================>] 116 --.-K/s in 0s

2013-02-11 10:02:38 (12.3 MB/s) - ânagiosql.loginâ

NAGIOSQL LOGIN FAILED!
[root@monitor scripts]# wc -l nagiosql.login
2 nagiosql.login
[root@monitor scripts]# cat nagiosql.login
Error while connecting to database:<br>[localhost] Connection to the database server has failed by reason:<br>

<br>[root@monitor scripts]#

The output looks pretty much similar to the first time I ran it, don't your think?

[mguthrie]

Are you able to access the Legacy CCM from the web interface?

Can you access the Admin->Reset Security Credentials page and try resetting the subsystem credentials?

[pteegarden]

I think the answer to your first question is "No":

After selecting the Configure tab, I see two choices in the menu on the left.
The first choice is "Core Config Manager".
The Second choice is "Legacy CCM".

When attempting to access Legacy CCM from the web interface, I get:

Error while connecting to database:
[localhost] Connection to the database server has failed by reason:

Just those two lines, no additional lines that one might expect for the reason.
I deduce that this option fails.

However, the other choice, Core Config Manager, does allow me to login. The first page has Nagios CCM 1.03 at the top.


The answer to your second question appears to be "Yes".
After filling in the Component Credentials New Config Manager Admin Password and all three boxex in the
Sub-System Credentials section (XI Subsystem Ticket, Config Manager Backend Password, and Nagios Core Backend Password), I clicked on the "Update Credentials" button and it responds with:

Security credentials updated successfully.

I conclude that it had no problems with this second step.


I rebooted the server and tied "Core Config Manager" and "Legacy CCM" again. Same results

[mguthrie]

Can you verify your database credentials in /var/www/html/nagiosql/config/settings.php and make sure those match what is also in the /usr/local/nagiosxi/html/config.inc.php for the nagiosql database?