Zabbix 1.6 and Alerts Mail sending

[french_newbie]

Hello all !

Recently, I upgrade my zabbix from 1.4.1 to 1.6.
But I have a big problem since the upgrade.
All my actions witch correctly work and send mail on Zabbix 1.4.1 don't work on upgrade 1.6.
All the configuration is OK and verified several times but Zabbix 1.6 don't want to send mail like before. In Administration/Notifications menu, ZERO mail are sent since the upgrade.
However, I recieve only one mail, the mail : "ZABBIX Database is down" when I restart server Zabbix...

I don't understand why with Zabbix 1.4 all mails were sent and now with Zabbix 1.6 there is no mail


Please help !

Thanks.

[french_newbie]

Hello,
my problem still exists.
I add information, My Zabbix runs on debian Lenny and I upgrade Zabbix from 1.4.1 to 1.6.

following a test action and my media parameters





It's very important
Thanks.

newbie

[v.rusinov]

Check your zabbix server log and your maillogs. Is there is anything interesting?

[french_newbie]

Hello all !

I solve my problem.

In Zabbix log there is this line :
10583:20081027:131422 Query failed: [insert into alerts (alertid, actionid,triggerid,userid,clock,mediatypeid,sendto ,subject,message,status,retries) values (2115,62,14205,3,1225109662,1,'***.***@***.fr','ZA BBIX Alert - Low free disk space on ***.***.net volume c:: ON','Il reste 10% d\'espace disque sur le C: de ***.',0,0)] Unknown column 'triggerid' in 'field list' [1054]

So I alter table alerts on MySQL to add triggerid and now it works.

Thank you v.rusinov for your advice.

bye all.

newbie

[troffasky]

I got bit by this too, so I have logged a bug against the Debian package.

[Signum]

I just checked why the index is not there. And I found the reason in the file

/upgrades/dbpatches/1.6/mysql/patch.sql

which reads (among many other SQL queries)

alter table alerts drop triggerid;

I'm not sure why the Zabbix developers added that. I tested an upgrade from Lenny (1.4) to Squeeze (1.8) though and that worked for me. Could you try to run the upgrade procedure to 1.8 if you still have the problem?

Christoph
(maintainer of the Debian Zabbix package)