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 ------------