Mail Server / dovecot-sql.conf

# cat /usr/local/etc/dovecot-sql.conf

driver = mysql
connect = host=/tmp/mysql.sock dbname=mails user=xxxx password=xxxxxxxx
default_pass_scheme = PLAIN
password_query = SELECT userid as user, password, home as userdb_home, uid as userdb_uid, gid as userdb_gid FROM users WHERE userid = '%u'
user_query = SELECT home, uid, gid FROM users WHERE userid = '%u'