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

[Guillaume Hilt]

In dovecot-sql.conf

user_query = SELECT CONCAT('/home/vmail/',maildir) AS maildir, 207 AS 
uid, 207 AS gid FROM mailbox WHERE username = '%u'
So I'll have a complete path like /home/vmail/mydomain/myuser/.

  Guillaume Hilt




Timo Sirainen a écrit :
> Where did you add that? You'll need to return a "home" field from 
> user_query poiting to the sieve script directory.
>
> On Jan 3, 2009, at 10:35 AM, Guillaume Hilt wrote:
>
>> Anyway, I correct the sql request by adding a concat with 
>> .home/vmail/ and now I have the good home directory but the error 
>> still occurs.
>> Setting sieve_global_dir didn't change anything.
>>
>> Guillaume Hilt
>>
>>
>>
>>
>> Timo Sirainen a écrit :
>>> On Jan 3, 2009, at 10:21 AM, Guillaume Hilt wrote:
>>>
>>>> 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.
>>>>
>>>> Postfixadmin inly store a portion of the maildir path.
>>>> Instead of storing /home/vmail/domain/user it stores domain/user.
>>>
>>>
>>> OK. Looks like I was a bit wrong. Your userdb doesn't return any 
>>> home directory (it's preferred to return one, 
>>> http://wiki.dovecot.org/VirtualUsers#homedirs) and deliver preserves 
>>> HOME environment which is set to /root in your case. That causes the 
>>> chdir() error. I think I'll have to do something about this in v1.2. 
>>> The HOME environment shouldn't be preserved when using -d parameter.
>>>
>>>
>
>