LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 11-22-2016, 03:47 AM   #1
deva420patra
LQ Newbie
 
Registered: Apr 2016
Posts: 29

Rep: Reputation: Disabled
Exclamation Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, pl


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
Attached Files
File Type: txt Database repaired.txt (22.5 KB, 43 views)
 
Old 11-22-2016, 06:54 AM   #2
deva420patra
LQ Newbie
 
Registered: Apr 2016
Posts: 29

Original Poster
Rep: Reputation: Disabled
Guys Please Help..Anyone
 
Old 11-22-2016, 08:48 PM   #3
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Ubuntu MATE, Mageia, and whatever VMs I happen to be playing with
Posts: 16,428
Blog Entries: 27

Rep: Reputation: 4962Reputation: 4962Reputation: 4962Reputation: 4962Reputation: 4962Reputation: 4962Reputation: 4962Reputation: 4962Reputation: 4962Reputation: 4962Reputation: 4962
Have you checked Nagios support for information on this?

https://support.nagios.com/kb/print.php?id=25
 
Old 11-22-2016, 09:50 PM   #4
deva420patra
LQ Newbie
 
Registered: Apr 2016
Posts: 29

Original Poster
Rep: Reputation: Disabled
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.
 
Old 11-23-2016, 07:40 AM   #5
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 22,979

Rep: Reputation: 6379Reputation: 6379Reputation: 6379Reputation: 6379Reputation: 6379Reputation: 6379Reputation: 6379Reputation: 6379Reputation: 6379Reputation: 6379Reputation: 6379
Quote:
Originally Posted by deva420patra View Post
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?
 
  


Reply

Tags
linux, mysqld, nagios


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
sme server 7.3 Repair file system error jamesjainfo Linux - Newbie 3 05-04-2013 07:53 PM
System crash - Shell prompt weirdness after attempting to repair - Suggestions? EnderX Linux - Newbie 4 12-01-2010 03:41 AM
Lost connection to MySQL server during query when executing 'REPAIR TABLE ... '? Ujjain Linux - Server 3 03-20-2009 09:05 AM
I need a Linux OS other than Ubuntu which has a repair disk or repair software jhmac77 Linux - Newbie 1 03-17-2008 07:04 AM
how to repair rpm database zaldyd Linux - Newbie 3 07-10-2003 11:17 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 06:15 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration