search

NagiosEnterprises / ndoutils

NDOUtils - Database Output for Nagios Core
GNU General Public License v2.0
48 stars 19 forks source link

addition to unique key was added to wrong table #16

Closed maemigh closed 8 years ago

maemigh commented 8 years ago

Line 41 of mysql.sql:

UNIQUE KEY instance_id (instance_id, entry_time, entry_time_usec, logentry_id)

logentry_id doesn't exist in this table. It looks like this was supposed to be added to like 838 instead.

AnwarYagoub commented 8 years ago

same issue with ndoutils-2.1.1

qianpeng2 commented 8 years ago

I'm also meet this trouble,when I execute: ./installdb -u 'ndoutils' -p 'ndoutils_abcd' -h 'localhost' -d nagios ,it tells me that ERROR 1072 (42000) at line 27: Key column 'logentry_id' doesn't exist in table,and I find that there is no tables in nagios database, so i think that the mysql.sql in db directory maybe has error when create the first table nagios_acknowledgements(actrually when I copy this section to database and It does not run corrctly ), so,what is next ? my NDOUtils version is ndoutils-2.1.1.same problem with ndoutils-2.1.0.

IonCannon23 commented 8 years ago

Having the same issue for 2.1.1, the mysql.sql has a bug for logentry_id. It is not being created.

jfrickson commented 8 years ago

See issue https://github.com/NagiosEnterprises/ndoutils/issues/15

This was fixed in branch 'maint' via commit https://github.com/NagiosEnterprises/ndoutils/commit/d6d2075d46cc9545f31938a8f5729e038824842c

This fix will be in the next release (ndoutils-2.1.2) coming out soon.