How to delete database and recreate it.?

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
Drishti
Posts: 12
Joined: Fri Feb 16, 2018 6:51 am

How to delete database and recreate it.?

Post by Drishti »

Hi,

I have configured Nagios XI server in ubuntu. By mistake I deleted database (nagiosql and nagiosxi). I didn't setup any host or services. I want to recreate databases and tables. Anybody can help me regarding it.?

I'm getting bellow msg on nagiosxi web page:
Databse Error
A database connection error has been detected, please follow the repair prompt below. If the issue persists, 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



Thanks in advance :)
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: How to delete database and recreate it.?

Post by mcapra »

Per the official installation documentation and system requirements:
As of the time of writing, Nagios Enterprises is only able to officially provide support for installing Nagios XI on
the following Linux Distributions:
  • RHEL 6.x 32-bit and 64-bit, RHEL 7.x
    • RHEL requires the Optional software channel to be enabled, further details are located here:
    • Enabling RHEL Optional Software Channel
  • CentOS 6.x 32-bit and 64-bit, CentOS 7.x
Ubuntu support is still a work in progress. I would suggest not using this product on Ubuntu for the time being.

A fresh install on a clean system is probably the best option.
Former Nagios employee
https://www.mcapra.com/
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: How to delete database and recreate it.?

Post by lmiltchev »

@Drishti, @mcapra is correct - Nagios XI installs on Ubuntu are not currently supported.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Drishti
Posts: 12
Joined: Fri Feb 16, 2018 6:51 am

Re: How to delete database and recreate it.?

Post by Drishti »

Thanks.

Re-Installed NagiosXI on fresh ubuntu system.
Working fine now

Thank you .
Locked