GreenArrow Email Software Documentation

Logging all SimpleMH Messages

Every message passing through the SimpleMH system can have basic information about the message logged.

Enable this by setting the /var/hvmail/control/opt.simplemh_message_log file to the value of 1. Disable by setting to a zero-length file or a value of 0.

When enabled, a row is inserted into the simplemh_message_log table for each message that is sent through the SimpleMH system. Messages sent by Raw Injection are excluded.

Column name Type Meaning
id bigint Primary key of log entry
time timestamp Time message was logged
mailclass varchar Mail Class used in SimpleMH
from_address varchar From email address
recipient varchar First recipient email address
recipients_additional varchar JSON array of second and following recipient email addresses. If there is only one recipient email address then this will be NULL.
subject_header varchar The raw contents of the Subject header. This may include newlines due to header folding. This may also include RFC 2047 encoded words which are used to represent non-ASCII character sets, so be prepared to decode this.
message_id varchar Message-ID of the message.
smtp_auth_username varchar Username used for SMTP-AUTH, if SMTP-AUTH was used

This table is to be used as a queue. GreenArrow will insert rows into this table but never delete any rows, so the user is responsible for reading data and then deleting the rows.

Copyright © 2012–2023 GreenArrow Email