This is an old revision of the document!

Devocot hacks

Devocot + MySQL

Creating user table

CREATE TABLE users (
    userid VARCHAR(128) NOT NULL,
    password VARCHAR(64) NOT NULL,
    home VARCHAR(255) NOT NULL,
    uid INTEGER NOT NULL,
    gid INTEGER NOT NULL,
    active CHAR(1) DEFAULT 'Y' NOT NULL,
    PRIMARY KEY(userid)
);

Configuration:

auth_passdb = mysql /etc/dovecot/dovecot-mysql.conf
auth_userdb = mysql /etc/dovecot/dovecot-mysql.conf
default_mail_env = maildir:/home/virtual_mail/%u/Maildir:INDEX=/var/mail/%u

dovecof.conf

login_greeting_capability=yes

protocol imap {

mail_plugins = expire

} protocol pop3 {

mail_plugins = expire

}

plugin {

# Trash 7d, Spam 30d
expire = Trash 7 Spam 30

}