Configuration
New Feature
The Event Notification System was introduced to SMTPProvider Application’s 4.30.0-1 release, in June, 2014. You can check which version of SMTPProvider Application you’re running by navigating to Admin
=> System
.
Contact DRH technical support if you’d like your SMTPProvider Application installation to be updated to support this feature.
This document describes how to enable and disable the Event Notification System for the types of SMTPProvider Application events that you wish to be notified about:
- SSH into your SMTPProvider server.
- Login to PostgreSQL as the SMTPProvider user:
/var/hvmail/postgres/default/bin/psql -U SMTPProvider
- Enable or disable the event types that you wish to receive by updating the desired
event_notification_*
columns in thes_system_configs
table:
Column Name Event Type event_notification_Application_click
Application_click
event_notification_Application_open
Application_open
event_notification_Application_unsub
Application_unsub
event_notification_bounce_all
bounce_all
event_notification_bounce_bad_address
bounce_bad_address
event_notification_scomp
scomp
event_notification_Application_subscriber_created
Application_subscriber_created
event_notification_Application_subscriber_updated
Application_subscriber_updated
- Example 1: To enable all event types, run:
UPDATE s_system_configs SET event_notification_Application_click = TRUE, event_notification_Application_open = TRUE, event_notification_Application_unsub = TRUE, event_notification_bounce_all = TRUE, event_notification_bounce_bad_address = TRUE, event_notification_scomp = TRUE, event_notification_Application_subscriber_created = TRUE, event_notification_Application_subscriber_updated = TRUE;
- Example 2: To disable all event types, run:
UPDATE s_system_configs SET event_notification_Application_click = TRUE, event_notification_Application_open = FALSE, event_notification_Application_unsub = FALSE, event_notification_bounce_all = FALSE, event_notification_bounce_bad_address = FALSE, event_notification_scomp = FALSE, event_notification_Application_subscriber_created = FALSE, event_notification_Application_subscriber_updated = FALSE;
- Example 1: To enable all event types, run:
- Logout of PostgreSQL:
\q
- Apply changes:
svc -t /service/hvmail-httpd /service/hvmail-Application-worker sleep 7 svstat /service/hvmail-httpd /service/hvmail-Application-worker
- Review the Event Delivery Methods document, and pick which method you would like to use to receive Event Notification System data.