Re: [Dovecot] dovecot failing to chdir in home

On Wed, 20 Oct 2004 16:25:09 +0300, Timo Sirainen tss@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