Always getting "An error occurred creating this alert" when adding an alert

Help
1

I’m trying to setup a very basic alert.
But whatever I try I’m getting “An error occured creating this alert”.

Here’s a screenshot:

image.png580×733 30 KB

The error message is so generic that I don’t really understand what’s wrong.

What means do I have to debug this?
Thanks

2

Run ./validate.php

3

here’s the result:

$ ./validate.php 
==========================================================
Component | Version
--------- | -------
LibreNMS  | 6890a71be43dc6d0aa54aa77585471babe5a1da5
DB Schema | 151
PHP       | 5.6.27-0+deb8u1
MySQL     | 10.0.28-MariaDB-1~jessie
RRDTool   | 1.4.8
SNMP      | NET-SNMP 5.7.2.1
==========================================================

[WARN]  Your install is out of date, last update: Wed, 23 Nov 2016 17:41:13 +0000
[FAIL]  We have found some files that are owned by a different user than librenms, this will stop you updating automatically and / or rrd files being updated causing graphs to fail:
If you don't run a bespoke install then you can fix this by running `chown -R librenms:librenms /home/librenms`
	 /home/librenms/html
	 /home/librenms/html/plugins/Weathermap/configs/backbone1.conf
	 /home/librenms/config.php
[OK]    Database connection successful
[WARN]  Your local git contains modified files, this could prevent automatic updates.
Modified files:
	 .php_cs
	 html/includes/functions.inc.php
	 html/pages/settings/alerting.inc.php

but I didn’t run this as root
(as recommended here: http://docs.librenms.org/Support/Install%20Validation/ )

so I need to check with the admin to run as root.

4

so we updated the installation:
first we stashed away the small php modifications.
and then performed a git pull to the latest version and schema update.

then ran validate again:

$ ./validate.php 
==========================================================
Component | Version
--------- | -------
LibreNMS  | 20ce209b2710f424f9be4f128a6eeab43074b626
DB Schema | 199
PHP       | 5.6.27-0+deb8u1
MySQL     | 10.0.28-MariaDB-1~jessie
RRDTool   | 1.4.8
SNMP      | NET-SNMP 5.7.2.1
==========================================================

[OK]    Database connection successful
[FAIL]  Database: incorrect column (dbSchema/version)
[FAIL]  Database: missing index (dbSchema/PRIMARY)
[FAIL]  We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (https://t.libren.ms/5gscd):
	 ALTER TABLE `dbSchema` CHANGE `version` `version` int(11) NOT NULL DEFAULT '0';
	 ALTER TABLE `dbSchema` ADD PRIMARY KEY (`version`);
[FAIL]  fping should be suid! [FIX] chmod u+s /usr/bin/fping
[FAIL]  fping6 should be suid! [FIX] chmod u+s /usr/bin/fping6

we fixed the database and suid rates.

and finally got a clean validate result.

$ ./validate.php 
==========================================================
Component | Version
--------- | -------
LibreNMS  | 20ce209b2710f424f9be4f128a6eeab43074b626
DB Schema | 199
PHP       | 5.6.27-0+deb8u1
MySQL     | 10.0.28-MariaDB-1~jessie
RRDTool   | 1.4.8
SNMP      | NET-SNMP 5.7.2.1
==========================================================

[OK]    Database connection successful
[OK]    Database schema correct

I reloaded the alert rules page and tried the same rule.
I could the rule without error this time.

Thanks