X-Git-Url: http://www.jernoble.com/postfix.git/blobdiff_plain/6e5d449e15a8544549b3d2c9b941f4e461f7e2e0..04cc8df19762366dfb7f00bfaade105520d45692:/dovecot/dovecot-sql.conf.ext

diff --git a/dovecot/dovecot-sql.conf.ext b/dovecot/dovecot-sql.conf.ext
new file mode 100644
index 0000000..8ef9ae7
--- /dev/null
+++ b/dovecot/dovecot-sql.conf.ext
@@ -0,0 +1,4 @@
+driver = mysql
+connect = host=localhost dbname=postfix user=dovecot password=dovecot
+user_query = SELECT concat('/var/spool/vmail/', maildir) as home, concat('maildir:/var/spool/vmail/', maildir) as mail, 101 AS uid, 12 AS gid, concat('maildir:storage=', quota) AS quota, concat('/var/spool/vmail/', maildir) as sieve_dir, concat('/var/spool/vmail/', maildir, 'dovecot.sieve') as sieve FROM mailbox WHERE username = '%u' AND active = '1'
+password_query = SELECT username as user, password, concat('/var/spool/vmail/', maildir) as userdb_home, concat('maildir:/var/spool/vmail/', maildir) as userdb_mail, 101 as userdb_uid, 12 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'