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
}