Le 22/01/2015 17:14, Adam Armstrong a écrit :
Signature email
You are using a MySQL server with non-expected settings.
 
You need to disable strict mode.
 
adam.

Thanks for your answers (with Tom).

I'm using Debian Wheezy and MariaDB 5.5.38 and it's configured with "sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" by default.

I changed it to "ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" only and it works now.

I just wonder why this value for "delay" is configured as "not null" in table structure if it can be "null".

Thanks a lot.

Joel

 
------ Original Message ------
From: "Joel Golliet" <joel@2lm.fr>
To: observium@observium.org
Sent: 1/22/2015 9:27:32 AM
Subject: Re: [Observium] Alerting configuration problem
 
I found in mysql log the requests that are done and when i try it i have this error :

[observium]> INSERT INTO `alert_table` (`device_id`,`entity_type`,`entity_id`,`alert_test_id`,`alert_assocs`)  VALUES ('31','storage','7','2','2');
ERROR 1364 (HY000): Field 'delay' doesn't have a default value

Should it have a default value in mysql table definition ?
How this value should be set in the mysql "insert" command ?

B.R.

Le 22/01/2015 15:32, Joel Golliet a écrit :
Hi,

I am starting with observium Professional Edition (i first installed community edition and upgraded it to pro with svn) and try to run the alerts.
I have enabled email alerts in configuration.

Nevertheless, when I create "alert checkers" (here a simple example with storage check), after clicking "Regenerate" this list me well the devices / entities corresponding with the check but when I look at the details of a check, I don't find anything in the list below.
See screenshots for details.

I had a look at my mysql database and tables "alerts", "alert_table" are empty (i don't know if it's normal).

Can someone help me please ? I don't know what to check.

B.R.