PPXX0001

From ESM Wiki

PPXX0001 is a general-purpose Postfix Policy Server module that includes MySQL-based policy message tracking.

Contents 1 Connection with MPP core logic 2 Processing logic 2.1 Policy message tracking 3 Configuration 3.1 PPXX0001_track_policy_connection

Connection with MPP core logic

Processing logic

Processing logic consists from the following elements:

• Policy message tracking (i.e. saving of policy request/response data) to MySQL database.

Policy message tracking

Policy message tracking (i.e. saving of policy request/response data) to MySQL database is performed using track_policy_request table specified in PPXX0001.sql.

Table track_policy_request has the following fields:

state	State of a request. Right after request is received the state is 'received'. After request is processed the state is updated to 'processed' and additional fields related to processing are updated.
received_timestamp	Time when request was received.
request ... stress	Different request properites as specified in SMTPD_POLICY_README. The only difference is that sender and recipient fields are split on local and reverse domain parts for searches optimization.
processed_timestamp	Request processing finish time.
ch_wbl ... greylist	MPP checks statuses.
error_text	Error text in case of abnormal termination of processing.
decision, decision_text	Decision that was made by MPP regarding request, human readable decision description text (if any).

Configuration

It is assumed that Postfix Policy Server is configured and enabled. To enable PPXX0001 module add the following MPP options:

<mppd>
    <common>
        <policy_begin_engines file="esm/PPXX0001.xml" xpath="/mppd/common/policy_begin_engines"/>
        <policy_end_engines file="esm/PPXX0001.xml" xpath="/mppd/common/policy_end_engines"/>
        <policy_end_exception_engines file="esm/PPXX0001.xml" xpath="/mppd/common/policy_end_exception_engines"/>
    </common>
    <engines file="esm/PPXX0001.xml" xpath="/mppd/engines"/>
</mppd>

PPXX0001_track_policy_connection

Description:	Defines options for connections to a message tracking database.
Configuration type:	MPP composite group-level option.
Value:	Composite value that have exact same structure as MySQL engine's connection common option.