I setup a new server and installed nagios core. I ran through the scripts and it seems like things went better, but I am still hung up on the E-importnagiosql.
/usr/bin/php -q nagiosql_login.php
PHP Warning: mysql_pconnect(): Access denied for user 'ndoutils'@'localhost' (using password: YES) in /tmp/nagiosxi/nagiosxi/basedir/html/db/adodb/drivers/adodb-mysql.inc.php on line 382
PHP Warning: mysql_pconnect(): Access denied for user 'nagiosql'@'localhost' (using password: YES) in /tmp/nagiosxi/nagiosxi/basedir/html/db/adodb/drivers/adodb-mysql.inc.php on line 382
ERROR CONNECTING TO DATABASES!
I can get to the webpage, and click on access nagiosxi, but it goes to a blank page instead of giving me the starting username and password.
Should I create this user that is denied, or is the user already there and I need to change the password? Im not that good with mysql.
sappjt wrote:I didn't. I assumed that the scripts from nagiosxi would have everything. I will start over with a new server, install nagios core, and let you know how it works out.
Actually I don't want you to have done so - I was checking whether you had since it would explain some of the log entries you were seeing. Let the scripts install everything as you had before, and I'll try to think of another explanation for the things looking in /etc.
Did you have a MySQL root password defined before running the scripts? The scripts expect it to be blank, but many administrators set one when they first provision a box, which can cause the problem you're seeing there.
I didn't set a password for root, but one is set from the scripts. I also used phpmyadmin to look a the database and I don't have any other users besides root. I can log on with any username and no password though. I get access denied for user ndoutils'@'localhost, but I don't have that user in the database. It would work if the script didn't try to use a password, but it does and I get access denied. Should I create the users ndoutils and nagiosql in the database manually?
mguthrie wrote:Also, (this may be obvious but we've had recent problems with it), make sure you're install of RHEL is registered with the RHN (Redhat Network) because if it's not you won't have access to their repos and you'll be missing a lot of the required packages.
Just since this hasn't been explicitly confirmed, could you please state whether you have in fact registered with RHN and have working access to their yum repositories?
when I click on the access nagios xi I check the /var/log/error_log and it says
[Tue Dec 21 08:59:07 2010] [error] [client 134.20.6.30] PHP Warning: mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: Access denied for user 'ndoutils'@'localhost' (using password: YES) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 382, referer: http://nagiosxi/
[Tue Dec 21 08:59:07 2010] [error] [client 134.20.6.30] PHP Warning: mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: Access denied for user 'nagiosql'@'localhost' (using password: YES) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 382, referer: http://nagiosxi/
[Tue Dec 21 08:59:07 2010] [error] [client 134.20.6.30] PHP Notice: Unknown: Cannot set connection to blocking mode in Unknown on line 0, referer: http://nagiosxi/
tonyyarusso wrote:Did you have a MySQL root password defined before running the scripts? The scripts expect it to be blank, but many administrators set one when they first provision a box, which can cause the problem you're seeing there.
so I thought what the heck... I will run through all the scripts again. I did it and it seemed to work. Now I have a couple of questions...
1. I have a fix permission error. It says everything is in /usr/local/nagios/etc/ I have permission issues because there isn't any of those files in there. They are on more level down in objects. Should I copy them out of objects and into etc?
2. I can't log into the core config manager... What would be the default username and password?