[Dovecot] Dovecot

[Claudio Prono]

Pascal Volk ha scritto:
> On 10/26/2009 05:26 PM Claudio Prono wrote:
>   
>> Sorry but for me is not clear what u say... I can't specify a mail
>> location manually? Like /var/mail/virtual/%d/%u ?
>>
>> Regards,
>>
>> Claudio.
>>     
>
> You have to modify your user_query in the dovecot-sql.conf file.
> Use for example:
> user_query = SELECT CONCAT('/var/mail/virtual/', '%d', '/', '%n') \
>     as home, ... FROM table WHERE ...
>
> In your dovecot.conf file set: mail_location = maildir:~/Mialdir
>
> The tilde (~) will be expanded to the home value from the user_query
>
>
> Regards,
> Pascal
>   
My user_query is this:

user_query = SELECT maildir, 51 AS uid, 51 AS gid,  CONCAT('*:bytes=',
mailbox.quota ) AS quota_rule FROM mailbox WHERE username = '%u' AND
active = '1'

Is wrong?

Regards,

Claudio.


-- 
------------
Claudio Prono
Systems Development @ PSS Srl, Divisione Implementazione Sistemi
Via San Bernardino, 17 - 10137 Torino (TO) - IT
Tel +39-011.32.72.100  Fax +39-011.32.46.497
PGP Fingerprint: 75C2 4049 E23D 2FBF A65F  40DB EA5C 11AC C2B0 3647
Disclaimer: http://atpss.net/disclaimer
------------