nemslinux/nconf

NEMS Configurator (NConf) for PHP7.0+ Enterprise Nagios configurator

nconf's Issues

Escalations

There was a contribution in the old nconf forum to add escalations:

http://forum.nconf.org/viewtopic.php?f=20&t=1120

Any chance to add this since this project here is active? I've been using this for nearly 6 years now - the only problem (that is still there) is mentioned in the original post:
"You can choose Hosts and services/advanced-services - wether they exist on the host or not! If you choose a service/advanced-service that doesn't exist on a host generating your nagios config will fail."

It's just a small change in the ExportNagios.pm and additional SQL entries.

Issue with cloning services within nconf

I am just testing 1.6 and noticed i was not able to clone services.

See the following link for the picture for reference

https://discordapp.com/channels/501816361706717184/501822444760203304/896764114741907496

grouping mysql keyword since 8.0.1

I've finaly found the time to debug my problem with nconf after upgrading my Ubuntu system.

grouping (name of a column) is a mysql keyword since 8.0.1 (see https://dev.mysql.com/doc/refman/8.0/en/keywords.html for keywords).

Fix is to change any query from grouping to `grouping`

I dind't make a pull since I've messed up my nconf quite a bit searching for the error but would like to let you know

Edit:
And it seems disabling a single service for a host now is broken, no services at all are returned from the query so the host has no services associated. Tried this with an old version running an older mysql instance the same query works as it should. If one service is disabled the query results NULL in my mysql 8 envorinment, in 5.7 it shows the remaining services. Switching no to yes results in the expected disabled service returned in 5.7 and in 8 it's still NULL as long as at least one service is enabled

SELECT ItemLinks.fk_id_item AS item_id,'','<HOSTID>' FROM ConfigValues,ItemLinks,ConfigAttrs,ConfigClasses WHERE ItemLinks.fk_id_item=ConfigValues.fk_id_item AND id_attr=ItemLinks.fk_id_attr AND fk_id_class=id_class AND config_class = 'service' AND (SELECT naming_attr FROM ConfigAttrs WHERE id_attr=ConfigValues.fk_id_attr)='yes' AND ItemLinks.fk_item_linked2='<HOSTID>' HAVING ((SELECT attr_value FROM ConfigValues, ConfigAttrs WHERE id_attr=fk_id_attr AND attr_name='service_enabled' AND fk_id_item=item_id) <> 'no' OR (SELECT attr_value FROM ConfigValues, ConfigAttrs WHERE id_attr=fk_id_attr AND attr_name='service_enabled' AND fk_id_item=item_id) IS NULL) ORDER BY attr_value