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 mailto:joel@2lm.fr> To: observium@observium.org mailto: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 alertsin 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.