====== 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
}