Manual Install Fails On MySQL Loads

[timlwhite]

Hello -

I have a 64-bit CentOS 6.4 machine that had Nagios Core on it, that I am trying to install XI (2012 R2.3) on manually.

I first uninstalled Nagios Core using rpm uninstallers and even deleting the /etc/nagios directory.

When I run the manual installer from /tmp/nagios, the subcomponent install for ndoutils (and nagiosql) both fail with something like:

Code: Select all

ERROR 1050 (42S01) at line 49: Table 'nagios_commands' already exists

(for NDOUtils)

or

Code: Select all

ERROR 1050 (42S01) at line 352: Table 'tbl_hosttemplate' already exists

(for NagiosQL)

I've gone into mysql and done 'drop database' and 'drop user' for both the nagios and nagiosql databases and matching users; and I still get this error for both.

What can I do to reset the mysql install such that these scripts will install?

Thanks!

Tim

[slansing]

Well idealy you would remove the mysql DB and let it reinstall with Nagios XI. Nagios XI requires a clean base system to install properly, anything else and there can be unforeseen issues. Can you not totally remove the database and let Nagios XI re install it?

[timlwhite]

Well, that's what I've done; I dropped every database inside mysql. There is nothing in there as far as I can tell. I'm not sure how else to remove the database?

[abrist]

Did you restart mysqld afterwards?

Code: Select all

service mysqld restart

Are the database files still on the disk:

Code: Select all

ls -la /var/lib/mysql/
ls -la /var/lib/mysql/nagios*

[timlwhite]

Ah - looks like with MySQL, even after dropping things, you have to do a FLUSH TABLES and FLUSH PRIVILEGES to clear all the caches.

Once I did that, I was able to get past this error...on to the next one.

[abrist]

Great. We will close the thread, though feel free to open a new one when your next error stumps you. Cheers.