From iRedMail

• We hope iRedMail users can donate us to make iRedMail continue active and exist. Donate now: http://www.iredmail.org/donate.html
• Get remote Installation Support and Upgrade Support from developers if you're not familiar with Linux/BSD.
• Please report bugs in our forum: http://www.iredmail.org/forum/

To be continued, do NOT apply below steps.

General Update, all backends should apply these changes

• All users should apply hotfix for iRedMail-0.6.1 before go further: Hotfix for iRedMail-0.6.1
• Upgrade Dovecot 1.1.x to 1.2.x
• TODO:
  • Fix disclaimer issue. Works with clients in "mynetworks", not authenticated users.
  • Quarantine SPAM/Virus with Amavisd-new.
  • Replace LDAP attributes: gn -> givenName, fax ->.

OpenLDAP backend only

Support mail list of alias domain

• Edit /etc/postfix/ldap_virtual_group_maps.cf, remove "domainName=%d" in search_base:

# OLD SETTING
search_base     = domainName=%d,o=domains,dc=XXX

# NEW SETTING
search_base     = o=domains,dc=XXX

MySQL backend only

Improve backup mx support

• Edit /etc/postfix/mysql_virtual_alias_maps.cf, change query = to below new setting:

query       = SELECT goto FROM alias,domain WHERE (alias.address='%s' OR alias.address='@%d') AND alias.active='1' AND domain.backupmx='0'

• Edit /etc/postfix/mysql_domain_alias_maps.cf, change query = to below new setting:

query       = SELECT goto FROM alias,alias_domain,domain WHERE alias_domain.alias_domain = '%d' and alias.address = CONCAT('%u', '@', alias_domain.target_domain) AND alias.active = 1 AND alias_domain.active='1' AND domain.backupmx='0'

Update SQL structure of vmail database

Add more columns and create indexes.

$ mysql -uroot -p
mysql> USE vmail;
mysql> ALTER TABLE admin ADD COLUMN name VARCHAR(255) DEFAULT '' COLLATE utf8_general_ci;
mysql> CREATE INDEX admin_active ON admin (active);

mysql> ALTER TABLE alias ADD COLUMN name VARCHAR(255) DEFAULT '' COLLATE utf8_general_ci;
mysql> ALTER TABLE mailbox ADD COLUMN local_part VARCHAR(255) NOT NULL DEFAULT '';