NagiosXI Offloading Mysql - Core Config Manager Failed

[mlopez]

Hi All,
I recently followed a guide named "Offloading_Mysql_to_Remote_Server.pdf" as per recommendations under my previous post "NagiosXI Applying Configuration taking a long time" as I have a large amount of hosts and services I followed the procedure.



I am able to bring up all the services, hosts etc.. but when I try to apply I am getting the following error:
-----------------------------------
Waiting for configuration verification....
Backend login to the Core Config Manager failed.
-----------------------------------

I have attached the following:
Logs:
cmd.txt
reconfig.txt

Also, I am not going through a proxy and please keep in mind all was working fine until I offloaded my mysql database to the secondary server.

Any help would be greatly appreciated.

Sincerely,
Michael

[slansing]

It looks like you might have skipped a step in the document, that is really the only way this issue would occur directly after offloading. I'd recommend going back and verifying each of the files that must be changed, make sure they all have the same login credentials and port if required.

[mlopez]

Hi Steve,
I thought so too but I checked the document 10 times already. The only thing I can think of is that when I was exporting the database I got an SQL error for the nagios DB so I repaired and reran the command and all went fine.

I have attached all my files.
- ndo2db
- config.inc
- settings


DB connectivity / account confirmation:
------------------------------------------------------------------------
[root@NagiosXI scripts]# mysql -u nagiosql -p'nagiosql' -h 10.200.1.152
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5588
Server version: 5.1.71 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit
Bye
------------------------------------------------------------------------

[root@NagiosXI scripts]# mysql -u nagios -p'nagios' -h 10.200.1.152
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5595
Server version: 5.1.71 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit
Bye
------------------------------------------------------------------------


Sincerely,
Michael

[mlopez]

Hi Steven,
Issue resolved.

Fix:
/var/www/html/nagiosql/config/settings.php

Changed from:
server = '10.200.1.152'
port = 3306
database = nagiosql
username = nagiosql
password = nagiosql

TO (Removed Quotes)

server = 10.200.1.152
port = 3306
database = nagiosql
username = nagiosql
password = nagiosql

Thanks again Steven for all your help for your fast reply before which made me re-read it yet again hehe.

Sincerely,
Michael

[tmcdonald]

Glad it was resolved! I'll be closing this now, feel free to open another thread if you need anything in the future.