Page 1 of 2
Problem with access to Nagios XI - Database connection faile
Posted: Fri Apr 22, 2011 12:50 am
by Servo
Hi all,
I read all topics about this error, but I do not find anything that could be solve my problem.
This issue was appeared after NAGIOS DISK SPACE was over.
With Nagios manual I have increased the size, but issue was not resolved.
When I open
http://mynagios/nagiosxi/ i have this error: DB Connect Error [nagiosxi]: Database connection failed
I'm trying restart httpd and postgresql:
Code: Select all
[root@nagios /]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]
[root@nagios /]# service postgresql restart
Stopping postgresql: [ OK ]
Starting postgresql: [ OK ]
and still nothing...
Re: Problem with access to Nagios XI - Database connection f
Posted: Fri Apr 22, 2011 11:52 am
by rdedon
Hello Servo,
have you attempted to restart the server yet after increasing the disk size?
Re: Problem with access to Nagios XI - Database connection f
Posted: Mon Apr 25, 2011 1:00 am
by Servo
Yes, I had restarted server after increasing the disk size.
Re: Problem with access to Nagios XI - Database connection f
Posted: Mon Apr 25, 2011 3:17 pm
by rdedon
If this was a VM Image there is a specific way of resizing the disk size. Here are instructions on how to do that:
http://assets.nagios.com/downloads/nagi ... M_Disk.pdf
You might have to delete some old information (such as logs) to make a little room from the command line.
Re: Problem with access to Nagios XI - Database connection f
Posted: Tue Apr 26, 2011 9:07 am
by Servo
rdedon,
I Successfully resized disk.
But I still have problem with "DB Connect Error [nagiosxi]: Database connection failed"
Re: Problem with access to Nagios XI - Database connection f
Posted: Tue Apr 26, 2011 1:50 pm
by mguthrie
Are you able to log into the postgres database from the command-line with the following command?
Re: Problem with access to Nagios XI - Database connection f
Posted: Wed Apr 27, 2011 3:36 am
by Servo
Code: Select all
[root@naigos /]# psql nagiosxi nagiosxi
psql: FATAL: ident authentication failed for user "nagiosxi"
You have new mail in /var/spool/mail/root
Re: Problem with access to Nagios XI - Database connection f
Posted: Thu Apr 28, 2011 9:29 am
by mguthrie
Is this a fresh install, or a system that has been in use for a while?
If it's a fresh install, I recommend re-installing.
If the system has been in use for a while, could the password for the nagiosxi user in the postgresql database have been changed? If so then the XI interface will not work. The XI interface logs into postgresql with the nagiosxi user.
Re: Problem with access to Nagios XI - Database connection f
Posted: Wed May 04, 2011 12:02 am
by Servo
This is a system that has been in use.
No, password for nagiosxi user in the postgresql was not changed.
Re: Problem with access to Nagios XI - Database connection f
Posted: Wed May 04, 2011 9:29 am
by rdedon
Servo wrote:rdedon,
I Successfully resized disk.
But I still have problem with "DB Connect Error [nagiosxi]: Database connection failed"
Yes but "how" did you resize it? Some methods will not work properly with the image.