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

Code: Select all

tail -f /var/log/httpd/error_log

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?

Code: Select all

tail -f /var/log/httpd/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