driver = mysql
connect = host=10.0.0.67 port=3306 user=mailsys password=password dbname=mailsys
default_pass_scheme = PLAIN

password_query = SELECT u.password AS password,                                                 \
                        a.localpart AS username,                                                \
                        d.name AS domain,                                                       \
                        500 AS userdb_uid,                                                      \
                        500 AS userdb_gid,                                                      \
                        CONCAT('/mailstore/', d.name, '/users/', a.localpart) AS userdb_home,   \
                        'maildir:~/Maildir' AS userdb_mail                                      \
                FROM    account u,                                                              \
                        address a,                                                              \
                        domain d                                                                \
                WHERE   u.address = a.id                                                        \
                AND     a.domain = d.id                                                         \
                AND     d.name = '%d'                                                           \
                AND     a.localpart = '%n'                                                      \
                AND     d.disabled = false                                                      \
                AND     u.disabled = false

user_query =    SELECT  500 AS uid,                                                             \
                        500 AS gid,                                                             \
                        CONCAT('/mailstore/', ud.name, '/users/', ua.localpart) AS home,        \
                        'maildir:~/Maildir' AS mail                                             \
                FROM    account u,                                                              \
                        address a,                                                              \
                        address ua,                                                             \
                        domain d,                                                               \
                        domain ud                                                               \
                WHERE   a.owner = u.id                                                          \
                AND     a.domain = d.id                                                         \
                AND     u.address = ua.id                                                       \
                AND     ua.domain = ud.id                                                       \
                AND     d.name = '%d'                                                           \
                AND     a.localpart = '%n'                                                      \
                AND     d.disabled = false                                                      \
                AND     u.disabled = false

iterate_query = SELECT  CONCAT(a.localpart, '@', d.name) AS username                            \
                FROM    account u,                                                              \
                        address a,                                                              \
                        domain d                                                                \
                WHERE   u.address = a.id                                                        \
                AND     a.domain = d.id                                                         \
                AND     d.disabled = false                                                      \
                AND     u.disabled = false