Data Base Error

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
tavo2k4
Posts: 19
Joined: Thu Jan 24, 2013 9:17 am

Data Base Error

Post by tavo2k4 »

My trial license expired, I got a 30 day extension from Sales Department. After I applied 30 day license extension I could not see any of my configured servers in Nagios.

I restarted Nagios (Linux) server, but after the reboot I get "Database connection failed DB Connect Error [nagiosxi]" in my browser.

Can I get help on this please, I an evaluating for some of our customers but I can not do the last tests.

Thanks,

Gus G
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Data Base Error

Post by abrist »

Is selinux enabled?
Open up a terminal to the XI box, and run:

Code: Select all

getenforce
Post the output here.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
tavo2k4
Posts: 19
Joined: Thu Jan 24, 2013 9:17 am

Re: Data Base Error

Post by tavo2k4 »

It is "Disabled"
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Data Base Error

Post by abrist »

Next, is postgres running?

Code: Select all

service postgresql status
If it is, you may have to fix your db:
http://support.nagios.com/wiki/index.ph ... .22_in_log
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
tavo2k4
Posts: 19
Joined: Thu Jan 24, 2013 9:17 am

Re: Data Base Error

Post by tavo2k4 »

No, postregs is not running.

Do I need to fix my DB?

Thanks,
Gus G.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Data Base Error

Post by scottwilkerson »

You can start postgresql with

Code: Select all

service postgresql start
However, it could be stopped because the drive is full, I would run the following to check

Code: Select all

df -h
df -i
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
tavo2k4
Posts: 19
Joined: Thu Jan 24, 2013 9:17 am

Re: Data Base Error

Post by tavo2k4 »

I tried to start DB but it fails.

I am running Nagios as a virtual server, I expanded HD space to make sure I have enough to run Nagios, but it is still failing.

frustrating, I had all my servers set up and working, all I needed was screen shoots of my configuration to show to our customers.

Thanks
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Data Base Error

Post by slansing »

What is the exact error you receive when trying to start postgres? Don't worry this is not the end of the world, we should be able to get your install up and running again.
tavo2k4
Posts: 19
Joined: Thu Jan 24, 2013 9:17 am

Re: Data Base Error

Post by tavo2k4 »

Starting postgresql service: [FAILED]
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Data Base Error

Post by scottwilkerson »

again can you run

Code: Select all

df -h
df -i
and post the output
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked