Page 1 of 1

How to delete database and recreate it.?

Posted: Mon Aug 06, 2018 5:18 am
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 :)

Re: How to delete database and recreate it.?

Posted: Mon Aug 06, 2018 10:12 am
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.

Re: How to delete database and recreate it.?

Posted: Mon Aug 06, 2018 2:42 pm
by lmiltchev
@Drishti, @mcapra is correct - Nagios XI installs on Ubuntu are not currently supported.

Re: How to delete database and recreate it.?

Posted: Tue Aug 07, 2018 8:14 am
by Drishti
Thanks.

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

Thank you .