Problem with access to Nagios XI - Database connection faile

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

[rdedon]

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

[Servo]

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

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

[Servo]

rdedon,

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

[mguthrie]

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

Code: Select all

psql nagiosxi nagiosxi

[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

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

[Servo]

This is a system that has been in use.

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

[rdedon]

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.