2013-04-03: [MySQL/PostgreSQL] Add one new column used for store preferred language for newly created mail users. Used in iRedAdmin-Pro.

General (All backends should apply these steps)

Update /etc/iredmail-release with iRedMail version number

iRedMail stores the initial version number in /etc/iredmail-release after installation completed, it's recommended to update this file after you upgraded iRedMail, so that you can know which version of iRedMail you're running. For example:

Fix incorrect ACL for attribute "memberOfGroup"

Permission for attribute memberOfGroup is not set correctly, it causes normal user can add himself to any mail list in LDAP. Default permission is writeable by self, it should be "read" by "self" instead.

Add SQL trigger in MySQL database: iredadmin

With OpenLDAP backend, Dovecot stores real-time mailbox quota in MySQL database iredadmin, table used_quota. But it's hard to calculate per-domain used mailbox quota, so we add a SQL trigger to set domain name while Dovecot inserting new record for mail user.

Add SQL trigger in MySQL database vmail

With MySQL backend, Dovecot stores real-time mailbox quota in MySQL database vmail, table used_quota. But it's hard to calculate per-domain used mailbox quota, so we add a SQL trigger to set domain name while Dovecot inserting new record for mail user.

Add SQL trigger in PostgreSQL database: vmail

With PostgreSQL backend, Dovecot stores real-time mailbox quota in PostgreSQL database vmail, table used_quota. But it's hard to calculate per-domain used mailbox quota, so we add a SQL trigger to set domain name while Dovecot inserting new record for mail user.