Page 1 of 2
Message : A database connection error has been detected
Posted: Tue Jul 19, 2016 2:15 am
by Frédéric GRANAT
Hi,
This morning, NagiosXI is unreachable and it displays : Message : A database connection error has been detected, we are attempting to repair the server ...etc
Usually, when I've got that error, it comes from a lack of space but it seems to be not the case that time :
Code: Select all
[root@nagiosxi scripts]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
29329476 21097392 6718484 76% /
/dev/sda1 101086 31686 64181 34% /boot
tmpfs 1553548 0 1553548 0% /dev/shm
I restarted the services : no effect
I restarted the server : no effect
I ran repair_databases.sh : no effect
Please help me.
Frederic
Re: Message : A database connection error has been detected
Posted: Tue Jul 19, 2016 9:51 am
by rkennedy
Can you PM over a profile for us to look at? (Admin -> System Profile -> Download Profile)
Re: Message : A database connection error has been detected
Posted: Tue Jul 19, 2016 10:25 am
by Frédéric GRANAT
Hi,
Sorry I'm not quite sure to understand but NagiosXI is unreachable : so I cannot access Admin part
Rgds,
Re: Message : A database connection error has been detected
Posted: Tue Jul 19, 2016 12:03 pm
by ssax
Please try running this command:
Re: Message : A database connection error has been detected
Posted: Tue Jul 19, 2016 7:14 pm
by Box293
This KB article should help resolve the issue:
https://support.nagios.com/kb/article.php?id=25
Re: Message : A database connection error has been detected
Posted: Wed Jul 20, 2016 1:34 am
by Frédéric GRANAT
Please try running this command:
Code: Select all
service postgresql restart
=> No effect
Re: Message : A database connection error has been detected
Posted: Wed Jul 20, 2016 1:43 am
by Frédéric GRANAT
This KB article should help resolve the issue:
https://support.nagios.com/kb/article.php?id=25
=> I tried the possibles solutions except vaccuum postgre (the error message is linked to mysql) and no effect
Re: Message : A database connection error has been detected
Posted: Wed Jul 20, 2016 9:39 am
by Frédéric GRANAT
Hi,
Three days already that nagiosxi doesn't work.
The support seems to be available only from approximately 5PM every day (french hour).
In these conditions, I can ask a question per day and have an answer per day.
You will agree that it won't be easy to quickly solve my problem.
Is it possible to plan a chat session at 4-5 PM tomorrow ?
Frederic
Re: Message : A database connection error has been detected
Posted: Wed Jul 20, 2016 11:56 am
by tmcdonald
I agree, and normally we would not go beyond our office hours but in this case I will personally make an exception and stay late to help you out. Please send in an email ticket with a link to this thread, and "Attn: Trevor" in the subject. I will take the ticket and provide you with details on how to get a remote session set up with myself.
Re: Message : A database connection error has been detected
Posted: Thu Jul 21, 2016 9:11 am
by tmcdonald
I have received your ticket, and we will continue there. I will be locking this thread now.