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\""