LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, pl (https://www.linuxquestions.org/questions/linux-server-73/message-a-database-connection-error-has-been-detected-we-are-attempting-to-repair-the-server-if-the-repair-does-not-resolve-the-issue-pl-4175594017/)

deva420patra 11-22-2016 03:47 AM

Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, pl
 
1 Attachment(s)
Hi Everyone
I have installed Nagios application last night (Application & Database same server) & also able to login to it's WEB interface but after some hours it showed an error in web interface :

Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.

Run the following from the CLI as root to attempt to repair the DB

/usr/local/nagiosxi/scripts/repair_databases.sh


I have executed the same & repaired completed successfully(Attached)


I have followed below link instructions& found everything fine in my nagios server
https://support.nagios.com/kb/print.php?id=25

Server Details
Linux drmailsrv1.co-opbank.co.in 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux

All required Services are running properly also
service nagios status
nagios (pid 12272) is running...
service mysqld status
mysqld (pid 16260) is running...
service postgresql status
postmaster (pid 23625) is running...
service httpd status
httpd (pid 12419) is running...

I also dont have any Disk-Size Issues

df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_drmailsrv1-lv_root
50G 16G 32G 34% /
tmpfs 7.8G 0 7.8G 0% /dev/shm
/dev/sda2 485M 38M 423M 9% /boot
/dev/sda1 200M 256K 200M 1% /boot/efi
/dev/mapper/vg_drmailsrv1-lv_home
2.0G 153M 1.8G 8% /home
/dev/mapper/vg_drmailsrv1-lv_wipro
60G 247M 56G 1% /wipro
/dev/mapper/vg_drmailsrv1-lvol0
9.9G 4.8G 4.7G 51% /nagios
/nagios/rhel-server-6.3-x86_64-dvd.iso
3.5G 3.5G 0 100% /DVD


My sqld.logs are also not showing any error

tail /var/log/mysqld.log
161122 13:14:12 [Note] /usr/libexec/mysqld: Shutdown complete

161122 13:14:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
161122 13:14:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161122 13:14:13 InnoDB: Initializing buffer pool, size = 8.0M
161122 13:14:13 InnoDB: Completed initialization of buffer pool
161122 13:14:13 InnoDB: Started; log sequence number 0 44233
161122 13:14:13 [Note] Event Scheduler: Loaded 0 events
161122 13:14:13 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

deva420patra 11-22-2016 06:54 AM

Guys Please Help..Anyone :confused:

frankbell 11-22-2016 08:48 PM

Have you checked Nagios support for information on this?

https://support.nagios.com/kb/print.php?id=25

deva420patra 11-22-2016 09:50 PM

I already mentioned in my post that I had check the link & all settings are seems to be fine in my server. If you want any specific output then please ask frankly.

TB0ne 11-23-2016 07:40 AM

Quote:

Originally Posted by deva420patra (Post 5633295)
Hi Everyone
I have installed Nagios application last night (Application & Database same server) & also able to login to it's WEB interface but after some hours it showed an error in web interface :

Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.
Run the following from the CLI as root to attempt to repair the DB

/usr/local/nagiosxi/scripts/repair_databases.sh

I have executed the same & repaired completed successfully(Attached) I have followed below link instructions& found everything fine in my nagios server
https://support.nagios.com/kb/print.php?id=25

Server Details Linux drmailsrv1.co-opbank.co.in 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux

All required Services are running properly also
service nagios status
nagios (pid 12272) is running...
service mysqld status
mysqld (pid 16260) is running...
service postgresql status
postmaster (pid 23625) is running...
service httpd status
httpd (pid 12419) is running...

I also dont have any Disk-Size Issues

df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_drmailsrv1-lv_root
50G 16G 32G 34% /
tmpfs 7.8G 0 7.8G 0% /dev/shm
/dev/sda2 485M 38M 423M 9% /boot
/dev/sda1 200M 256K 200M 1% /boot/efi
/dev/mapper/vg_drmailsrv1-lv_home 2.0G 153M 1.8G 8% /home
/dev/mapper/vg_drmailsrv1-lv_wipro 60G 247M 56G 1% /wipro
/dev/mapper/vg_drmailsrv1-lvol0 9.9G 4.8G 4.7G 51% /nagios
/nagios/rhel-server-6.3-x86_64-dvd.iso 3.5G 3.5G 0 100% /DVD

My sqld.logs are also not showing any error
tail /var/log/mysqld.log
161122 13:14:12 [Note] /usr/libexec/mysqld: Shutdown complete

161122 13:14:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
161122 13:14:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161122 13:14:13 InnoDB: Initializing buffer pool, size = 8.0M
161122 13:14:13 InnoDB: Completed initialization of buffer pool
161122 13:14:13 InnoDB: Started; log sequence number 0 44233
161122 13:14:13 [Note] Event Scheduler: Loaded 0 events
161122 13:14:13 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

...and, just over three WHOLE HOURS later
Quote:

Originally Posted by deva420patra
Guys Please Help..Anyone 

As you've been told before, DO NOT BUMP YOUR OWN THREADS, unless you are adding more information or clarifying something. Again, since you've missed this before, all you managed to do is remove your post from the zero-reply list, making it LESS VISIBLE and LESS LIKELY to be answered. Not to mention the fact that we volunteer our time here..we don't sit and wait for you to post a question...if you need a reply urgently, then I would suggest you get a version of Linux that you pay for, and call their support whenever you'd like. And you can also feel free to pay for Nagios and call *THEIR* support. Have you done either?

Much like your other Nagios thread:
http://www.linuxquestions.org/questi...ed-4175591240/
http://www.linuxquestions.org/questi...er-4175588558/

...where you did the same thing. Then you posted back to frankbell:
Quote:

Originally Posted by deva420patra
I already mentioned in my post that I had check the link & all settings are seems to be fine in my server. If you want any specific output then please ask frankly.

...which indicates that you also have not read what HE sent you either...much like those other two threads. Checking the services is ONE STEP on that whole document. Did you check the rest?


All times are GMT -5. The time now is 07:58 PM.