From iRedMail

ChangeLog

• 2013-01-08: [sql] Add 4 new columns in table vmail.mailbox for MySQL/PostgreSQL backends.
• 2012-10-24: [ldap] Supports alias domains in Postfix per-user bcc lookup files.

General (All backends should apply these steps)

No update available.

OpenLDAP backend special

Supports alias domains in Postfix per-user bcc lookup files

• In /etc/postfix/ldap/sender_bcc_maps_user.cf, replace "(mail=%s)" by "(|(mail=%s)(&(enabledService=shadowaddress)(shadowAddress=%s)))" in parameter "query_filter =". The final LDAP filter looks like below:

query_filter    = (&(|(mail=%s)(&(enabledService=shadowaddress)(shadowAddress=%s)))(objectClass=mailUser)(accountStatus=active)(enabledService=mail)(enabledService=senderbcc))

• Perform the same modification in file /etc/postfix/ldap/recipient_bcc_user.cf, the final LDAP filter looks like below:

query_filter    = (&(|(mail=%s)(&(enabledService=shadowaddress)(shadowAddress=%s)))(objectClass=mailUser)(accountStatus=active)(enabledService=mail)(enabledService=recipientbcc))

• Restarting Postfix service is required.

MySQL backend special

Add 4 new columns used for per-user restriction

New version of iRedAPD (Postfix policy daemon) requires 4 new columns in table vmail.mailbox: allowedsenders, rejectedsenders, allowedrecipients, rejectedrecipients. They're used for per-user restriction. For example, you can now define who can send email to your local user, or your user can send email to which external domains or users.

Please login to MySQL server as root user, execute SQL commands to add required columns and indexes.

# mysql -uroot -p
mysql> USE vmail;
mysql> ALTER TABLE mailbox ADD COLUMN allowedsenders TEXT NOT NULL DEFAULT '';
mysql> ALTER TABLE mailbox ADD COLUMN rejectedsenders TEXT NOT NULL DEFAULT '';
mysql> ALTER TABLE mailbox ADD COLUMN allowedrecipients TEXT NOT NULL DEFAULT '';
mysql> ALTER TABLE mailbox ADD COLUMN rejectedrecipients TEXT NOT NULL DEFAULT '';

Supported formats of sender/recipients are:

• user@example.com: single user
• @example.com: single domain
• @.example.com: domain and its sub domain
• @.: any users.

Multiple senders/recipients must be separated by comma, for example:

sql> INSERT INTO mailbox SET allowedsenders='@gmail.com,user@example.com';

PostgreSQL backend special

Add 4 new columns used for per-user restriction

New version of iRedAPD (Postfix policy daemon) requires 4 new columns in table vmail.mailbox: allowedsenders, rejectedsenders, allowedrecipients, rejectedrecipients. They're used for per-user restriction. For example, you can now define who can send email to your local user, or your user can send email to which external domains or users.

Please switch to PostgreSQL daemon user, then execute SQL commands to add required columns and indexes: On Linux, PostgreSQL daemon user is postgres. On FreeBSD, PostgreSQL daemon user is pgsql. On OpenBSD, PostgreSQL daemon user is """_postgresql".

# su - postgres
$ psql -d vmail
sql> ALTER TABLE mailbox ADD COLUMN allowedsenders TEXT NOT NULL DEFAULT '';
sql> ALTER TABLE mailbox ADD COLUMN rejectedsenders TEXT NOT NULL DEFAULT '';
sql> ALTER TABLE mailbox ADD COLUMN allowedrecipients TEXT NOT NULL DEFAULT '';
sql> ALTER TABLE mailbox ADD COLUMN rejectedrecipients TEXT NOT NULL DEFAULT '';

Supported formats of sender/recipients are:

• user@example.com: single user
• @example.com: single domain
• @.example.com: domain and its sub domain
• @.: any users.

Multiple senders/recipients must be separated by comma, for example:

sql> INSERT INTO mailbox SET allowedsenders='@gmail.com,user@example.com';