Page 2 of 3
Re: Cannot access Core Config Manager
Posted: Fri Nov 23, 2012 8:37 am
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
Re: Cannot access Core Config Manager
Posted: Mon Nov 26, 2012 9:09 am
by mbrowning
The number returned is 29
Re: Cannot access Core Config Manager
Posted: Mon Nov 26, 2012 11:03 am
by lmiltchev
Can you see any errors in the apache error log?
Re: Cannot access Core Config Manager
Posted: Mon Nov 26, 2012 11:07 am
by mbrowning
I get the following error:
Re: Cannot access Core Config Manager
Posted: Mon Nov 26, 2012 11:21 am
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.
Re: Cannot access Core Config Manager
Posted: Mon Nov 26, 2012 8:27 pm
by nagiostest
I think i am having the same issue here. Mine was working initially. Did not change any credentials..
Re: Cannot access Core Config Manager
Posted: Tue Nov 27, 2012 9:41 am
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
Re: Cannot access Core Config Manager
Posted: Tue Nov 27, 2012 11:12 am
by scottwilkerson
there should be no space between the -p and the password, run
Code: Select all
mysql -u nagiosql -pn@gweb nagiosql
Re: Cannot access Core Config Manager
Posted: Tue Nov 27, 2012 11:13 am
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.
Re: Cannot access Core Config Manager
Posted: Tue Nov 27, 2012 11:20 am
by scottwilkerson
Please post the output of
Code: Select all
cat /etc/hosts
cat /usr/local/nagiosxi/etc/components/ccm_config.inc.php