[Dovecot] Master User Features I'd like to see

[Marc Perkel]

On 8/16/2010 11:04 AM, Timo Sirainen wrote:
> On Mon, 2010-08-16 at 10:49 -0700, Marc Perkel wrote:
>> On 8/15/2010 3:06 PM, Timo Sirainen wrote:
>>> These are available in v2.0:
>>>
>>> %{login_user}
>>> %{login_username}
>>> %{login_domain}
>>>
>>> I guess they should be added to wiki..
>> Hi Timo,
>>
>> I just tried the 2.0 official release and these variables return an
>> empty string.
> Works with me:
>
> passdb {
>    driver = sql
>    master = yes
>    args = /usr/local/etc/dovecot/dovecot-sql-master.conf
>    pass = yes
> }
>
> password_query = \
>    SELECT "user", password FROM masters \
>      WHERE "user" = '%u' and '%d' = '%{login_domain}'
>
> auth: Debug: sql(master at dovecot.org,::1,master): query: SELECT "user", password FROM masters WHERE "user" = 'master at dovecot.org' and 'dovecot.org' = 'dovecot.org'
> auth: Debug: sql(master at dovecot.org,::1,master): query: SELECT "user", password FROM masters WHERE "user" = 'master at dovecot.org' and 'dovecot.org' = 'foobar.org'
>
>

Odd - wonder what I'm doing wrong then? My result:

Aug 16 10:44:43 auth: Debug: sql(support at junkemailfilter.com,127.0.0.1): 
query: SELECT user_name, domain_name, password FROM users WHERE 
user_name = 'support' AND domain_name = 'junkemailfilter.com' AND 
owns_domain='1' AND 'junkemailfilter.com'=''

My query:

password_query = SELECT user_name, domain_name, password FROM users 
WHERE user_name = '%n' AND domain_name = '%d' AND owns_domain='1' AND 
'%d'='%{login_domain}'