search for: virtual_gid

...results coming back correctly for the password_query in the log file: dovecot: auth(default): client out: OK 1 user=user1 domain=domain.com Yet, the user_query that is logged shows: dovecot: auth(default): sql(user1,192.168.0.77): SELECT vu.virtual_mailbox AS home, vu.virtual_uid AS uid, vu.virtual_gid AS gid, vd.domain AS domain FROM virtual_users vu, virtual_mailbox_domains vd WHERE vu.domain_key = vd.id AND vu.username = 'user1' AND vd.domain = '' And the actual query in my dovecot-sql.conf looks like this: user_query = SELECT vu.virtual_mailbox AS home, vu.virtual_uid...

...I don't think it matters, but for the sake of formality: server# grep -v '^ *\(#.*\)\?$' dovecot-sql.conf driver = mysql connect = host=/tmp/mysql.sock dbname=******** user=******** password=******* password_query = SELECT md5(userpassword) AS password, home, virtual_uid AS userdb_uid, virtual_gid AS userdb_gid FROM virtual_users WHERE email = '%u' AND active = 1