Upgrade/iRedMail/0.7.3-0.7.4
From iRedMail
(Difference between revisions)
(→General) |
(→Add INDEXes for Amavisd database) |
||
| Line 26: | Line 26: | ||
mysql> ALTER TABLE msgs ADD INDEX maddr_idx_email (email); | 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 maddr_idx_domain (domain); | ||
| - | mysql> ALTER TABLE msgs ADD INDEX | + | 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 msgs ADD INDEX msgs_idx_mail_id (mail_id); | ||
| - | mysql> ALTER TABLE | + | mysql> ALTER TABLE quarantine ADD INDEX quar_idx_mail_id (mail_id); |
</pre>}} | </pre>}} | ||
Revision as of 23:45, 27 September 2011
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); |
