Hi,

i delete 4 old hosts but i can see them in the statusengine-ui.

I try

opt/statusengine/worker/bin/Console.php cleanup

but no change.

Hi,

have you restarted Naemon/Nagios after you deleted the hosts?

The cleanup cronjob you mentioned will only delete historical data and performance data (graphs): https://statusengine.org/worker/#cleanup-database such as sent notifications, state change events etc.

If you delete a host (or a service) you have to restart Naemon/Nagios. The Statusengine Worker will than delete all records from the tables statusengine_hoststatus and statusengine_servicestatus and will than insert all existing hosts and services again. If this is not happening, you have probably disabled the statusngin_core_restart queue in the configuration of the broker module: https://github.com/statusengine/broker/blob/master/statusengine.toml#L19

When ever the Statusengine Worker catch a restart event from the monitoring core, it will write Catch monitoring restart. Trigger callbacks... to the syslog.

You can also run the Statusengine Worker in foreground to check for any errors: https://statusengine.org/worker/#debugging

Hi,

I use debian 10, nagios 4.4.6 and 10.3.27-MariaDB-0+deb10u1.

I have restart nagios and debian but no change.

I can´t find RestartData = "statusngin_core_restart" in /opt/statusengine/worker/etc/config.yml. I have no file with the name statusengine.toml

thanks for the help!

Output debug:

/opt/statusengine/worker/bin/StatusengineWorker.php statusengine-worker[25135]: Starting Statusengine-Worker Version 3.2.0 statusengine-worker[25135]: Fork new host status worker statusengine-worker[25135]: Fork new service status worker statusengine-worker[25135]: Fork new log entry worker statusengine-worker[25135]: Fork new state change worker statusengine-worker[25135]: Fork new host check worker statusengine-worker[25135]: Fork new service check worker statusengine-worker[25135]: Fork new misc worker statusengine-worker[25135]: Fork new performance data worker statusengine-worker[25135]: Finished daemonizing statusengine-worker[25143]: [1406] Data too long for column 'unit' at row 319 statusengine-worker[25143]: INSERT INTO statusengine_perfdata (hostname, service_description, label, timestamp, timestamp_unix, value, unit)VALUES(?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?) statusengine-worker[25143]: [1406] Data too long for column 'unit' at row 331 statusengine-worker[25143]: INSERT INTO statusengine_perfdata (hostname, service_description, label, timestamp, timestamp_unix, value, unit)VALUES(?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?) statusengine-worker[25142]: [1054] Unknown column 'start_time_usec' in 'field list' statusengine-worker[25142]: statusengine-worker[25142]: INSERT INTO statusengine_service_notifications statusengine-worker[25142]: (hostname, service_description, contact_name, command_name, command_args, state, start_time, start_time_usec, end_time, reason_type, output, ack_author, ack_data ) statusengine-worker[25142]: VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)

Did you updated from an older version recently? If yes, please check if you followed the update instructions: https://statusengine.org/worker/#update-to-3.7 This should resolve the statusengine-worker[25142]: [1054] Unknown column 'start_time_usec' in 'field list' issue.

I can´t find RestartData = "statusngin_core_restart" in /opt/statusengine/worker/etc/config.yml. I have no file with the name statusengine.toml

Than you are using the old broker module (I assume). Make sure you have set use_restart_data=1 in your nagios.cfg: https://statusengine.org/broker_old/#installation

Optional but recommended: Update the Statusengine Broker to the new C++ version: https://statusengine.org/broker/#installation

statusengine-worker[25143]: [1406] Data too long for column 'unit' at row 319 statusengine-worker[25143]: INSERT INTO statusengine_perfdata (hostname, service_description, label, timestamp, timestamp_unix,

This looks a bit terrifying to me. Looks like one of your checks is outputting invalid performance data

Hi,

1.) I have load an statusengine backup after update Debian from 8 to 10 and forgett the update. thx

2.) In the nagios.cfg i use this parameter:

broker_module=/opt/statusengine/module/statusengine-nagios.o use_process_data=0 use_system_command_data=0 use_comment_data=0 use_external_command_data=0 use_flapping_data=0 use_notification_data=1 use_program_status_data=0 use_contact_status_data=0 use_contact_notification_data=0 use_event_handler_data=0 use_object_data=0 use_restart_data=1 use_service_perfdata=1

3.) Do you have a idear how i can find the plugin which produce the problem?

I have try to install the new broker modul. I get follow errors on my test system:

cd /tmp git clone https://github.com/statusengine/broker.git broker cd broker/ export PKG_CONFIG_PATH=/usr/local/nagios/lib/pkgconfig/ meson setup -Dnagios=true -Drabbitmq=false -Dnagios_include_dir=/usr/local/nagios/include build The Meson build system Version: 0.57.1 Source dir: /tmp/broker Build dir: /tmp/broker/build Build type: native build Project name: statusengine-broker Project version: 4.2.0 C++ compiler for the host machine: c++ (gcc 8.3.0 "c++ (Debian 8.3.0-6) 8.3.0") C++ linker for the host machine: c++ ld.bfd 2.31.1 Host machine cpu family: x86_64 Host machine cpu: x86_64 Dependency uchardet found: YES 0.0.6 (cached) Dependency gearmand found: YES 1.1.18+ds (cached) Dependency librabbitmq found: YES 0.9.0 (cached) Dependency json-c found: YES 0.12.1 (cached) Build targets in project: 1

Found ninja-1.10.0.git.kitware.jobserver-1 at /usr/local/bin/ninja /tmp/broker# ninja -C build ninja: Entering directory `build' [1/6] Compiling C++ object src/libstatusengine.so.p/Statusengine.cpp.o FAILED: src/libstatusengine.so.p/Statusengine.cpp.o c++ -Isrc/libstatusengine.so.p -Isrc -I../src -I/usr/include/uchardet -I/usr/include/json-c -fdiagnostics-color=always -pipe -D_FILE_OFFSET_BITS=64 -Wall -Winvalid-pch -Wnon-virtual-dtor -Wextra -Wpedantic -std=c++11 -g -fPIC -isystem/usr/local/nagios/include -isystem../vendor -DBUILD_NAGIOS -DWITH_GEARMAN -MD -MQ src/libstatusengine.so.p/Statusengine.cpp.o -MF src/libstatusengine.so.p/Statusengine.cpp.o.d -o src/libstatusengine.so.p/Statusengine.cpp.o -c ../src/Statusengine.cpp In file included from ../src/Statusengine.h:8, from ../src/Statusengine.cpp:1: ../src/Nebmodule.h:13:10: fatal error: nagios/broker.h: Datei oder Verzeichnis nicht gefunden

include <nagios/broker.h>

      ^~~~~~~~~~~~~~~~~

compilation terminated. [2/6] Compiling C++ object src/libstatusengine.so.p/Nebmodule.cpp.o FAILED: src/libstatusengine.so.p/Nebmodule.cpp.o c++ -Isrc/libstatusengine.so.p -Isrc -I../src -I/usr/include/uchardet -I/usr/include/json-c -fdiagnostics-color=always -pipe -D_FILE_OFFSET_BITS=64 -Wall -Winvalid-pch -Wnon-virtual-dtor -Wextra -Wpedantic -std=c++11 -g -fPIC -isystem/usr/local/nagios/include -isystem../vendor -DBUILD_NAGIOS -DWITH_GEARMAN -MD -MQ src/libstatusengine.so.p/Nebmodule.cpp.o -MF src/libstatusengine.so.p/Nebmodule.cpp.o.d -o src/libstatusengine.so.p/Nebmodule.cpp.o -c ../src/Nebmodule.cpp In file included from ../src/Nebmodule.cpp:1: ../src/Nebmodule.h:13:10: fatal error: nagios/broker.h: Datei oder Verzeichnis nicht gefunden

include <nagios/broker.h>

      ^~~~~~~~~~~~~~~~~

compilation terminated. [3/6] Compiling C++ object src/libstatusengine.so.p/MessageHandler_GearmanClient.cpp.o FAILED: src/libstatusengine.so.p/MessageHandler_GearmanClient.cpp.o c++ -Isrc/libstatusengine.so.p -Isrc -I../src -I/usr/include/uchardet -I/usr/include/json-c -fdiagnostics-color=always -pipe -D_FILE_OFFSET_BITS=64 -Wall -Winvalid-pch -Wnon-virtual-dtor -Wextra -Wpedantic -std=c++11 -g -fPIC -isystem/usr/local/nagios/include -isystem../vendor -DBUILD_NAGIOS -DWITH_GEARMAN -MD -MQ src/libstatusengine.so.p/MessageHandler_GearmanClient.cpp.o -MF src/libstatusengine.so.p/MessageHandler_GearmanClient.cpp.o.d -o src/libstatusengine.so.p/MessageHandler_GearmanClient.cpp.o -c ../src/MessageHandler/GearmanClient.cpp In file included from ../src/NagiosObject.h:7, from ../src/MessageHandler/MessageHandler.h:9, from ../src/MessageHandler/GearmanClient.h:3, from ../src/MessageHandler/GearmanClient.cpp:1: ../src/Nebmodule.h:13:10: fatal error: nagios/broker.h: Datei oder Verzeichnis nicht gefunden

include <nagios/broker.h>

      ^~~~~~~~~~~~~~~~~

compilation terminated. ninja: build stopped: subcommand failed.

find / -name broker.h /tmp/broker/devtools/ci/naemon/broker.h /tmp/broker/devtools/ci/nagios/broker.h

thx for the help

Do you have a idear how i can find the plugin which produce the problem?

I released a new version which will print corresponding SQL query in case of an error. Unfortunately PHP PDO can only print the query to stdout, so I can't write it into a log file which is a bit of a bummer.

To find the service which is causing the problem i would recommend this steps:

Update Statusengine Worker to the new Version: https://github.com/statusengine/worker/releases/tag/3.7.1
Set number_of_bulk_records=1 in the config.yml of the worker
Run Statusengine Worker in foreground mode and it will print the faulty SQL query.

Don't forget to set number_of_bulk_records back to the default and restart Statusengine Worker via systemctl.

I have try to install the new broker modul. I get follow errors on my test system:

This is due to missing header files. Please see this post how to resolve this: https://github.com/statusengine/broker/issues/23#issuecomment-794122880

Hope this helps

Hi,

the install from the new broker was successfull but i cant start nagios.

systemctl start nagios systemctl status nagios ● nagios.service - Nagios Core Loaded: loaded (/etc/systemd/system/nagios.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Thu 2021-03-25 10:26:52 CET; 33ms ago Docs: https://www.nagios.org/documentation Process: 8050 ExecStartPre=/usr/local/nagios/bin/nagios -v /etc/nagios/nagios.cfg (code=exited, status=0/SUCCESS) Process: 8051 ExecStart=/usr/local/nagios/bin/nagios -d /etc/nagios/nagios.cfg (code=exited, status=0/SUCCESS) Process: 8057 ExecStopPost=/bin/rm -f /usr/local/nagios/var/rw/nagios.cmd (code=exited, status=0/SUCCESS) Main PID: 8052 (code=exited, status=1/FAILURE)

Mär 25 10:26:50 NAGIOSTST nagios[8052]: wproc: Successfully registered manager as @wproc with query handler Mär 25 10:26:50 NAGIOSTST nagios[8052]: wproc: Registry request: name=Core Worker 8053;pid=8053 Mär 25 10:26:50 NAGIOSTST nagios[8052]: wproc: Registry request: name=Core Worker 8056;pid=8056 Mär 25 10:26:50 NAGIOSTST nagios[8052]: wproc: Registry request: name=Core Worker 8055;pid=8055 Mär 25 10:26:50 NAGIOSTST nagios[8052]: wproc: Registry request: name=Core Worker 8054;pid=8054 Mär 25 10:26:50 NAGIOSTST nagios[8052]: Error: Could not load module '/opt/statusengine/lib/libstatusengine.so' -> file not found Mär 25 10:26:50 NAGIOSTST nagios[8052]: Error: Failed to load module '/opt/statusengine/lib/libstatusengine.so'. Mär 25 10:26:50 NAGIOSTST nagios[8052]: Error: Module loading failed. Aborting. Mär 25 10:26:50 NAGIOSTST systemd[1]: nagios.service: Main process exited, code=exited, status=1/FAILURE Mär 25 10:26:52 NAGIOSTST systemd[1]: nagios.service: Failed with result 'exit-code'.

ls -la /opt/statusengine/lib/libstatusengine.so -rwxr-xr-x 1 root root 6703792 Mär 25 09:50 /opt/statusengine/lib/libstatusengine.so

Test

chown nagios /opt/statusengine/lib/libstatusengine.so chgrp nagcmd /opt/statusengine/lib/libstatusengine.so -rwxr-xr-x 1 nagios nagcmd 6703792 Mär 25 09:50 /opt/statusengine/lib/libstatusengine.so

-> fail with same error

systemctl status statusengine ● statusengine.service - Statusengine Worker Loaded: loaded (/lib/systemd/system/statusengine.service; enabled; vendor preset: enabled) Active: active (running) since Thu 2021-03-25 10:11:34 CET; 25min ago Main PID: 7933 (StatusengineWor) Tasks: 9 (limit: 2358) Memory: 29.0M CGroup: /system.slice/statusengine.service ├─7933 /usr/bin/php /opt/statusengine/worker/bin/StatusengineWorker.php ├─7936 /usr/bin/php /opt/statusengine/worker/bin/StatusengineWorker.php ├─7937 /usr/bin/php /opt/statusengine/worker/bin/StatusengineWorker.php ├─7938 /usr/bin/php /opt/statusengine/worker/bin/StatusengineWorker.php ├─7939 /usr/bin/php /opt/statusengine/worker/bin/StatusengineWorker.php ├─7940 /usr/bin/php /opt/statusengine/worker/bin/StatusengineWorker.php ├─7941 /usr/bin/php /opt/statusengine/worker/bin/StatusengineWorker.php ├─7942 /usr/bin/php /opt/statusengine/worker/bin/StatusengineWorker.php └─7943 /usr/bin/php /opt/statusengine/worker/bin/StatusengineWorker.php

Mär 25 10:11:34 NAGIOSTST StatusengineWorker.php[7933]: statusengine-worker[7933]: Fork new misc worker Mär 25 10:11:34 NAGIOSTST StatusengineWorker.php[7933]: statusengine-worker[7933]: Fork new performance data worker Mär 25 10:11:34 NAGIOSTST statusengine-worker[7933]: Fork new log entry worker Mär 25 10:11:34 NAGIOSTST statusengine-worker[7933]: Fork new state change worker Mär 25 10:11:34 NAGIOSTST statusengine-worker[7933]: Fork new host check worker Mär 25 10:11:34 NAGIOSTST statusengine-worker[7933]: Fork new service check worker Mär 25 10:11:34 NAGIOSTST statusengine-worker[7933]: Fork new misc worker Mär 25 10:11:34 NAGIOSTST statusengine-worker[7933]: Fork new performance data worker Mär 25 10:11:34 NAGIOSTST StatusengineWorker.php[7933]: statusengine-worker[7933]: Finished daemonizing Mär 25 10:11:34 NAGIOSTST statusengine-worker[7933]: Finished daemonizing

One question, if I make a new clean installation i didnt need the update because the final version is 3.7.1?

Thanks for the help

Hi,

I found the problem, why the old hosts don't be deleted.

In my old system the node name was "A" but in the new system with the backup "B" with /opt/statusengine/worker/bin/Console.php cluster I see both.

+--------------+--------------+---------------------+ | Node Name | Node Version | Last Start Time | +--------------+--------------+---------------------+ | A | 3.2.0 | 2021-03-10 15:35:48 | | B | 3.2.0 | 2021-03-23 07:09:13 | +--------------+--------------+---------------------+

in "A" was the 4 host which no longer exist. I deleted this node_name "A" and all be fine.

I think statusengine can't fix this problem because in the config is only node "B".

For the other problem I testet this:

meson setup --prefix=/usr/local/nagios -Dnagios=true -Drabbitmq=false -Dnagios_include_dir=/usr/local/nagios/include build

--prefix does nothing

___Additional meson build flags Installation path The default installation path for the library is /usr/local, which means that the so file will be placed under /usr/local/lib/libstatusengine.so.

You can specify --prefix=/opt/naemon as meson argument to change the path.__

ninja -C build ninja -C build install

cp build/src/libstatusengine.so /usr/local/nagios/lib/libstatusengine.so

chgrp nagcmd /usr/local/nagios/lib/libstatusengine.so chown nagios /usr/local/nagios/lib/libstatusengine.so

curl https://raw.githubusercontent.com/statusengine/broker/master/statusengine.toml > /etc/nagios/statusengine.toml

chgrp nagcmd /etc/nagios/statusengine.toml chown nagios /etc/nagios/statusengine.toml

nagios.cfg broker_module=/usr/local/nagios/lib/libstatusengine.so /etc/nagios/statusengine.toml

same error nagios service can't start.

Sobald ich nach dem erstellen (wie oben beschrieben) der libstatusengine.so versuche diese auszuführen kommt ein "Speicherzugriffsfehler" . Gibt es vielleicht unter Debian 10 Probleme?

Guten Morgen,

soll ich für den "Speicherzugriffsfehler" ein neues Ticket anlegen, da es nix mit dem Ursprünglichen Fehler zu tun hat?

I tested the Broker on Ubuntu 20.04 with Nagios and it is working fine. I don't know why its not working on your system - probably you missed some important part from the docs. I created a setup script which is literally just copy and past from the docs. It will install Nagios + all Statusengine components. Do not use this for production, it uses unsafe passwords and so one. But you can use it to setup a working system and you can go through the script and see what's missing on your system.

https://gist.github.com/nook24/0e5f870f6492d6a8cbb69982654aa934 I only tested this script on Ubuntu Focal 20.04. I used a 2 Cores 2GB RAM DigitalOcean Droplet

Have fun :)

Guten Morgen,

du hast einen Fehler im Skript. Curl wird erst in Zeile 103 installiert aber bereits in Zeile 97 verwendet.

Curl muss also in Zeile 83 hinzugefügt werden.

Ich habe Zeile 103 zusätzlich geändert und an Debian 10 angepasst. Es sollten jetzt Ubuntu und Debian 10 gehen:

if [ -f /etc/debian_version ] then debian_version=$(cat /etc/debian_version | cut -f1 -d".") else debian_version=0 fi if [ ${debian_version%.*} -eq 10 ] then apt-get install -y git php-cli php-zip php-redis redis-server php-mysql php-json php-bcmath php-mbstring unzip php-cli wget mariadb-server gearman-job-server libgearman-dev gearman-tools uuid-dev libjson-c-dev manpages-dev build-essential libglib2.0-dev php-common php-gearman librrds-perl rrdtool php-rrd phpenmod -s ALL gearman
phpenmod -v ALL -s ALL rrd else apt-get install -y git php-cli php-zip php-redis redis-server php-mysql php-json php-bcmath php-mbstring unzip php-cli wget mysql-server

# install php-gearman on Ubuntu Focal

wget https://statusengine.org/uploads/php7.4-gearman_2.1.0+1.1.2-5+ubuntu20.04.1+deb.sury.org+1_amd64.deb dpkg -i php7.4-gearman_2.1.0+1.1.2-5+ubuntu20.04.1+deb.sury.org+1_amd64.deb

apt-get install -f -y fi

Die Installation hat funktioniert und Nagios konnte gestartet werden. Ich vergleiche nun die Skripte um Unterschiede zu finden.

Vielen Dank

Ich habe den Fehler gefunden! =)

Zeile 90, sobald der Parameter -Drabbitmq=false verwendet wird ist die Datei libstatusengine.so beschädigt.

Error: Could not load module '/opt/statusengine/lib/libstatusengine.so' -> /opt/statusengine/lib/libstatusengine.so: undefined symbol: amqp_empty_bytes

meson setup -Dnagios=true -Dnagios_include_dir=/opt/nagios/include -Drabbitmq=false build

Danach kann nagios nicht mehr starten wegen der beschädigten Datei.

Ich habe es mit meinen Installationsskript getestet und ohne den Parameter geht es nun auch.

Ich habe dafür mal ein Issue direkt im Broker Repo erstellt: https://github.com/statusengine/broker/issues/24

statusengine / interface

Delete OLD Hosts and Services #47

include <nagios/broker.h>

include <nagios/broker.h>

include <nagios/broker.h>