Table of Contents

1. Overview
2. Usage
3. Reference
4. Limitations

Overview

This puppet module configures sqlgrey - postfix greylisting policy service with an SQL database as storage backend

Usage

To configure sqlgrey module include it to puppet manifest and define config hash with sqlgrey parameters

class { '::sqlgrey:'
  config => {
    db_type => {
      value => 'mysql',
    },
    db_name => {
      value => 'sqlgrey',
    },
    db_user => {
      value => 'sqlgrey',
    },
    db_pass => {
      value => "DON'T SHARE SECRETS",
    },
    db_host => {
      value => 'localhost',
    },
    regect_code => {
      value => '451'
    },
  }
}

or the same but using using hiera

include ::sqlgrey

sqlgrey::config:
  db_type:
    value: 'mysql'
  db_name:
    value: 'sqlgrey'
  db_user:
    value: 'sqlgrey'
  db_pass:
    value: "DON'T SHARE SECRETS"
  db_host:
    value: 'localhost'
  prepend:
    value: '1'
  optmethod:
    value: 'optout'
  reject_first_attempt:
    value: 'immed'
  reject_early_reconnect:
    value: 'immed'
  regect_code:
    value: '451'
  admin_mail:
    value: /dev/null

To define fqdn or ip whitelist use clients_fqdn_whitelist or clients_ip_whitelist_ arrays:

sqlgrey::clients_fqdn_whitelist:
  - 'test.example.com'
  - 'test1.example.com'
sqlgrey::clients_ip_whitelist:
  - '192.168.0.0/24'
  - '10.0.0.0/8'

Reference

Check ./doc/index.html

Limitations

Tested on Debian 6/7 and RedHat 5/6/7 with Puppet4