Upgrade/iRedMail/0.7.3-0.7.4

From iRedMail

Revision as of 23:45, 27 September 2011 by ZhangHuangbin (Talk | contribs)
Jump to: navigation, search

Contents


WORKING IN PROGRESS, DO *NOT* APPLY IT.

General

Fix incorrect per-user sieve_dir setting in Dovecot

Note: This fix only works for Dovecot-1.x.

In /etc/dovecot.conf or /etc/dovecot/dovecot.conf, remove the last slash (/) in setting sieve_dir = like below:

File: dovecot.conf 
# Original setting:
#sieve_dir = /var/vmail/sieve/%Ld/%Ln/

# Change to:
sieve_dir = /var/vmail/sieve/%Ld/%Ln              # <-- Remove the last slash.

Add INDEXes for Amavisd database

Terminal: 
$ mysql -uroot -p
mysql> USE amavisd;
mysql> ALTER TABLE msgs ADD INDEX maddr_idx_email (email);
mysql> ALTER TABLE msgs ADD INDEX maddr_idx_domain (domain);
mysql> ALTER TABLE msgs ADD INDEX msgs_idx_content_time_num (content, time_num);
mysql> ALTER TABLE msgs ADD INDEX msgs_idx_mail_id (mail_id);
mysql> ALTER TABLE quarantine ADD INDEX quar_idx_mail_id (mail_id);
Retrieved from "http://www.iredmail.org/wiki/index.php?title=Upgrade/iRedMail/0.7.3-0.7.4"
Personal tools