Search found 4 matches

by james_lin
Thu Apr 28, 2016 11:18 am
Forum: Nagios XI
Topic: Database connection failed SQL
Replies: 8
Views: 4945

Re: Database connection failed SQL

Great!! The problem is on postgres. After I run the code below, my nagios is up and running now. service postgresql stop su postgres echo "VACUUM FULL;" > /tmp/fix.sql postgres -D /var/lib/pgsql/data nagiosxi < /tmp/fix.sql postgres -D /var/lib/pgsql/data postgres < /tmp/fix.sql postgres -...
by james_lin
Wed Apr 27, 2016 2:52 pm
Forum: Nagios XI
Topic: Database connection failed SQL
Replies: 8
Views: 4945

Re: Database connection failed SQL

Hi,

I attached ps -ef output and screenshot of error message.
Please check it.

Thanks,
James
by james_lin
Wed Apr 27, 2016 11:40 am
Forum: Nagios XI
Topic: Database connection failed SQL
Replies: 8
Views: 4945

Re: Database connection failed SQL

Hi,

My Nagios Core is 4.1.1
Does it help?

Since my Nagios is down right now, I can't download profile. Could you show me the other way to get profile from command line?

Thanks.
by james_lin
Wed Apr 27, 2016 11:18 am
Forum: Nagios XI
Topic: Database connection failed SQL
Replies: 8
Views: 4945

Database connection failed SQL

Hi Guys, We have nagios running for several years. Right now, I got "Database connection failed SQL" error message. I also tried to run "/usr/local/nagiosxi/scripts/repair_databases.sh"; however, it didn't fix the problem. Please help. OS: CentOS release 5.6 x64 Nagios XI is manu...