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