[Dovecot] deliver looking into root directory for sieve configuration ?

[Guillaume Hilt]

Timo Sirainen a écrit :
> On Jan 2, 2009, at 9:38 AM, Guillaume Hilt wrote:
>
>> Jan  2 14:48:52 mail deliver(postmaster at adomain.fr): chdir(/root) 
>> failed: Permission denied
> ..
>> Why does it look inside the /root folder for sieve configuration ?
>
> Your userdb returns /root as home directory. Show your 
> dovecot-sql.conf and enable auth_debug=yes and show the logs again.
>
>
Oh.

Here's the relevant part of my dovecot-sql.conf file : (it uses the 
database created for postfixadmin)

connect = host=localhost dbname=XXXXX user=XXXX password=XXXX client_flags=0
default_pass_scheme = MD5-CRYPT
password_query = SELECT password FROM mailbox WHERE username = '%u'
user_query = SELECT maildir, 207 AS uid, 207 AS gid FROM mailbox WHERE 
username = '%u' (that's postfix uid and gid since I don't use a vmail 
user but postfix)

Ok I saw the problem.
Postfixadmin inly store a portion of the maildir path.
Instead of storing /home/vmail/domain/user it stores domain/user.

Thanks :)