haraka-plugin-rcpt-postgresql v1.0.1

haraka-plugin-rcpt-postgresql

Validates the rcpt_to addresses (recipient addresses) by connecting to a PostgreSQL database.

Install

cd /my/haraka/config/dir
npm install haraka-plugin-rcpt-postgresql

Enable

Add the following line to the config/plugins file.

rcpt-postgresql

Config

The rcpt-postgresql.json file has the following structure (defaults shown). Also note that this file will need to be created, if not present, in the config directory.

{
  "user": "thihara",
  "database": "haraka",
  "password": "",
  "host": "127.0.0.1",
  "port": 5432,
  "max": 20,
  "idleTimeoutMillis": 30000,
  "sqlQuery": "SELECT EXISTS(SELECT 1 FROM valid_emails WHERE email_id=$1) AS \"exists\""
}