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

[Timo Sirainen]

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'