[Dovecot] dovecot failing to chdir in home

[Stefano Maffulli]

On Wed, 20 Oct 2004 16:25:09 +0300, Timo Sirainen <tss at iki.fi> wrote:
> What you probably want is:
> 
> select 1001 as uid, 1001 as gid, concat('/var/mail/domains/', maildir)
> as home where username = '%u'

Thanks Timo.  I figured that only after I sent the mail this morning,
after I spent a few hours strugling last night :)  I have used this as
user_query:

user_query = SELECT 1001 AS uid, 1001 AS gid,
'maildir:/var/mail/domains/%d/%n' AS maildir FROM mailbox WHERE
username = '%u'

and it works.  I would change it only if your sintax is the Right one :)

Actually, since we are at it, I was wondering yesterday why you don't
mention mysql as a possible db backend for dovecot, since it seems to
work like a charm.

thanks
stef