Displaying 1 result from an estimated 1 matches for "domain_key".
2008 Jan 24
2
SQL user_query question
...t 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 AS uid,  
vu.virtual_gid AS gid, vd.domain AS domain FROM virtual_users vu,  
virtual_mailbox_domains...