DB Connect Error [nagiosxi]: database connection failed

[wipro-cloud-services]

Hi Team,

While access the GUI web console ,i am getting the ERROR - " DB Connect Error [nagiosxi]: database connection failed ".

I already tried to start / stop the mysqld,but it didn't work.

Please provide us the solution.

Thanks & Regards
Kumar Gaurav
Email: [email protected]

[sreinhardt]

I moved this to the XI forum as this is not a core question. Anyway, when you say that you restarted mysql and it did not work, what exactly do you mean? Was the database not started, or did the errors not change in XI? Have you altered the mysql passwords at all?

Code: Select all

service mysqld status
service postgresql status

[wipro-cloud-services]

Hi,

We are able to login on Nagios web console after server reboot,however i am not able to view the Service Status "No matching services found".
I am able to view the Host details.

Could you please help on this to get the fix.

Authenticating with public key "imported-openssh-key"
[root@domU-12-31-39-0B-40-21 ~]# service mysqld status
mysqld (pid 1043) is running...
[root@domU-12-31-39-0B-40-21 ~]# service postgresql status
postmaster (pid 1087) is running...
[root@domU-12-31-39-0B-40-21 ~]#

Thanks & Regards
Kumar Gaurav

[slansing]

You may be experiencing crashed tables depending on how you rebooted your server. Lets run the database repair script and see if you have your services back in their tables on the web interface. Also, run the following commands and share the output:

Code: Select all

df -i

Code: Select all

df -h

http://assets.nagios.com/downloads/nagi ... tabase.pdf

[wipro-cloud-services]

Hi,

I tried the command ,but no luck,

Pls find the below details for further investigation.

[root@domU-12-31-39-0B-40-21 ~]# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/xvdf 524288 105880 418408 21% /
tmpfs 176551 1 176550 1% /dev/shm
[root@domU-12-31-39-0B-40-21 ~]#


[root@domU-12-31-39-0B-40-21 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/xvdf 7.9G 6.0G 1.6G 80% /
tmpfs 856M 0 856M 0% /dev/shm
[root@domU-12-31-39-0B-40-21 ~]#


pls help me for the next .

Regards,
Kumar Gaurav

[sreinhardt]

As previously asked, did you alter the mysql or postgres passwords at all? Run the command below as well please and return the output.

Code: Select all

tail -n 50 /var/log/httpd/error_log