Expiration trigger

[Richard]

Hello,

I'm trying to configure trigger to send email and slack notification when Certificate is about to expire.

Ive created custom extension for certificate. Configured email and slack notifications. Tested on object creation trigger.

But i cant get the expiration trigger to work. I've tried:
* Using Trigger (on object mention)
with Mentioned filter
SELECT Certificate
WHERE expiry_date > NOW()
AND expiry_date <= DATE_ADD(NOW(), INTERVAL 30 DAY)
Didnt work
* Tried using https://github.com/Hoglandets-IT/itop-warn-expiration
Configured on date pass trigger runned cron manually with command
root@1bde463ae724:/var/www/html# su -s /bin/bash -c "/usr/local/bin/php /var/www/html/webservices/cron.php --param_file=/etc/itop-cron.params" www-data
Starting: 1737035485 (2025-01-16 14:51:25)
Start processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopStart processing TriggerOnDatePassStart loopStart loopExiting: 1737036085 (2025-01-16 15:01:25)
root@1bde463ae724:/var/www/html#
No notification was sent ive also checked logs dir in itop. There was no error in error log
*

Is there a way to make it work?

Thanks