Problem with access to Nagios xi - Database connection faile

Servo · Post by **Servo** » Fri Apr 22, 2011 12:50 am

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...

rdedon · Post by **rdedon** » Fri Apr 22, 2011 11:52 am

Hello Servo,
have you attempted to restart the server yet after increasing the disk size?

Servo · Post by **Servo** » Mon Apr 25, 2011 1:00 am

Yes, I had restarted server after increasing the disk size.

rdedon · Post by **rdedon** » Mon Apr 25, 2011 3:17 pm

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.

Servo · Post by **Servo** » Tue Apr 26, 2011 9:07 am

rdedon,

I Successfully resized disk.
But I still have problem with "DB Connect Error [nagiosxi]: Database connection failed"

mguthrie · Post by **mguthrie** » Tue Apr 26, 2011 1:50 pm

Are you able to log into the postgres database from the command-line with the following command?

Code: Select all

psql nagiosxi nagiosxi

Servo · Post by **Servo** » Wed Apr 27, 2011 3:36 am

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

mguthrie · Post by **mguthrie** » Thu Apr 28, 2011 9:29 am

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.

Servo · Post by **Servo** » Wed May 04, 2011 12:02 am

This is a system that has been in use.

No, password for nagiosxi user in the postgresql was not changed.

rdedon · Post by **rdedon** » Wed May 04, 2011 9:29 am

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.

Nagios Support Forum

Problem with access to Nagios xi - Database connection faile

Problem with access to Nagios xi - Database connection faile

Re: Problem with access to Nagios xi - Database connection f

Re: Problem with access to Nagios xi - Database connection f

Re: Problem with access to Nagios xi - Database connection f

Re: Problem with access to Nagios xi - Database connection f

Re: Problem with access to Nagios xi - Database connection f

Re: Problem with access to Nagios xi - Database connection f

Re: Problem with access to Nagios xi - Database connection f

Re: Problem with access to Nagios xi - Database connection f

Re: Problem with access to Nagios xi - Database connection f