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:
Post
by scottwilkerson » Fri Nov 23, 2012 8:37 am
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
mbrowning
Posts: 34 Joined: Tue Oct 23, 2012 9:51 am
Post
by mbrowning » Mon Nov 26, 2012 9:09 am
The number returned is 29
lmiltchev
Bugs find me
Posts: 13589 Joined: Mon May 23, 2011 12:15 pm
Post
by lmiltchev » Mon Nov 26, 2012 11:03 am
Can you see any errors in the apache 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
Post
by mbrowning » Mon Nov 26, 2012 11:07 am
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
Post
by mguthrie » Mon Nov 26, 2012 11:21 am
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
Post
by nagiostest » Mon Nov 26, 2012 8:27 pm
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
Post
by mbrowning » Tue Nov 27, 2012 9:41 am
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:
Post
by scottwilkerson » Tue Nov 27, 2012 11:12 am
there should be no space between the -p and the password, run
Code: Select all
mysql -u nagiosql -pn@gweb nagiosql
mbrowning
Posts: 34 Joined: Tue Oct 23, 2012 9:51 am
Post
by mbrowning » Tue Nov 27, 2012 11:13 am
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:
Post
by scottwilkerson » Tue Nov 27, 2012 11:20 am
Please post the output of
Code: Select all
cat /etc/hosts
cat /usr/local/nagiosxi/etc/components/ccm_config.inc.php