DB Requirements for Nagios

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
jbennett
Posts: 522
Joined: Mon Apr 16, 2012 3:00 pm

DB Requirements for Nagios

Post by jbennett »

We are looking at offloading our Nagios DB to a MS SQL server.

Everything I see referrs to MySQL.

I haven't found anything that specifically states that MySQL must be used but before we attempt this, I want to be sure.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: DB Requirements for Nagios

Post by tmcdonald »

I know there are tools to convert between the two, and there are PHP libraries like PDO that are db-agnostic, but I don't believe we actually support this at the moment.
Former Nagios employee
jbennett
Posts: 522
Joined: Mon Apr 16, 2012 3:00 pm

Re: DB Requirements for Nagios

Post by jbennett »

Per the offloading document: 2 – Adjust Settings on Nagios Server - I see the following field in the nd02db.cfg file:

Code: Select all

db_servertype=mysql
If I were to change this to 'mssql' would it know how to handle that change?
User avatar
lmiltchev
Former Nagios Staff
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: DB Requirements for Nagios

Post by lmiltchev »

This hasn't been tested and won't be supported. I would highly suggest not doing it. If you want to play with it - set up a test server, but again, even if it worked, it wouldn't be supported.
Be sure to check out our Knowledgebase for helpful articles and solutions!
jbennett
Posts: 522
Joined: Mon Apr 16, 2012 3:00 pm

Re: DB Requirements for Nagios

Post by jbennett »

Are there any plans to support more enterprise level platforms like Oracle and MSSQL with Nagios?
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: DB Requirements for Nagios

Post by abrist »

Not currently.

EDIT: But you are welcome to submit a feature request to: tracker.nagios.com
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.
Locked