Cannot access Core Config Manager

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Cannot access Core Config Manager

Post by scottwilkerson »

Please run the following and send back the number returned

Code: Select all

echo "show processlist;"|  mysql -pnagiosxi|wc -l
Also can we tail the httpd error_log to see any errors that may have emerged

Code: Select all

tail -f /var/log/httpd/error_log
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
mbrowning
Posts: 34
Joined: Tue Oct 23, 2012 9:51 am

Re: Cannot access Core Config Manager

Post by mbrowning »

The number returned is 29
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: Cannot access Core Config Manager

Post by lmiltchev »

Can you see any errors in the apache error log?

Code: Select all

tail -f /var/log/httpd/error_log
Be sure to check out our Knowledgebase for helpful articles and solutions!
mbrowning
Posts: 34
Joined: Tue Oct 23, 2012 9:51 am

Re: Cannot access Core Config Manager

Post by mbrowning »

I get the following error:
You do not have the required permissions to view the files attached to this post.
mguthrie
Posts: 4380
Joined: Mon Jun 14, 2010 10:21 am

Re: Cannot access Core Config Manager

Post by mguthrie »

We still need to identify if the credentials the CCM is actually trying to connect with work, the most likely issue here is bad credentials. The connection credentials for the new Core Config Manager (CCM) are fetched from the following file: /usr/local/nagiosxi/html/config.inc.php and then the connection config is auto-generated into the following file for the CCM to use:

/usr/local/nagiosxi/etc/components/ccm_config.inc.php

Verify that file as created correctly, and that the mysql credentials in it are valid.
nagiostest
Posts: 23
Joined: Wed Sep 19, 2012 10:58 pm

Re: Cannot access Core Config Manager

Post by nagiostest »

I think i am having the same issue here. Mine was working initially. Did not change any credentials..
mbrowning
Posts: 34
Joined: Tue Oct 23, 2012 9:51 am

Re: Cannot access Core Config Manager

Post by mbrowning »

This is what I get when I run mysql -u username -p 'password' nagiosql from the credentials provided in the /var/www/html/nagiosql/config/settings.php
You do not have the required permissions to view the files attached to this post.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Cannot access Core Config Manager

Post by scottwilkerson »

there should be no space between the -p and the password, run

Code: Select all

mysql -u nagiosql -pn@gweb nagiosql
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
mbrowning
Posts: 34
Joined: Tue Oct 23, 2012 9:51 am

Re: Cannot access Core Config Manager

Post by mbrowning »

ok thanks. This is the results:

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 MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 226729
Server version: 5.1.61 Source distribution

Copyright (c) 2000, 2011, 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.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Cannot access Core Config Manager

Post by scottwilkerson »

Please post the output of

Code: Select all

cat /etc/hosts
cat /usr/local/nagiosxi/etc/components/ccm_config.inc.php
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked