Upgrade/iRedMail/0.6.1-0.7.0

From iRedMail

(Difference between revisions)
Jump to: navigation, search
(→Update SQL structure of vmail database)
(→Update SQL structure of vmail database)
Line 51: Line 51:
mysql> ALTER TABLE alias ADD COLUMN name VARCHAR(255) DEFAULT '' COLLATE utf8_general_ci;
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 ''
</pre>}}
</pre>}}

Revision as of 07:39, 15 January 2011

Contents



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:
File: /etc/postfix/ldap_virtual_group_maps.cf 
# 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:
File: /etc/postfix/mysql_virtual_alias_maps.cf 
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:
File: /etc/postfix/mysql_domain_alias_maps.cf 
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.

Terminal: 
$ 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 ''
Retrieved from "http://www.iredmail.org/wiki/index.php?title=Upgrade/iRedMail/0.6.1-0.7.0"
Personal tools