On 10/28/2009 11:47 AM Claudio Prono wrote: > Now i am really confused. > > The result of that query i have wrotten in the last mail is this: > > +--------------------------------------------+-----+-----+------------+ > | maildir | uid | gid | quota_rule | > +--------------------------------------------+-----+-----+------------+ > | domain.net/clau...@domain.net/ | 51 | 51 | *:bytes=0 | > +--------------------------------------------+-----+-----+------------+ > > What is missing ? maildir can't be sufficient as home directory? >
Please stop top posting. http://wiki.dovecot.org/UserDatabase mentions: The user database lookup returns these fields: * uid * gid * home * mail Try this query: SELECT maildir AS home, 51 AS uid, 51 AS gid, 'maildir:~/Maildir' as mail, CONCAT('*:bytes=', mailbox.quota ) AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1' This should return something like: *************************** 1. row *************************** home: domain.net/clau...@domain.net/ uid: 51 gid: 51 mail: maildir:~/Maildir quota_rule: *:bytes=0 You should also prefix home with '/var/mail/virtual/' SELECT CONCAT('/var/mail/virtual/', maildir) AS home, 51 AS uid, 51 AS gid, 'maildir:~/Maildir' as mail, CONCAT('*:bytes=', mailbox.quota ) AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1' *************************** 1. row *************************** home: /var/mail/virtual/domain.net/clau...@domain.net/ uid: 51 gid: 51 mail: maildir:~/Maildir quota_rule: *:bytes=0 Regards, Pascal -- The trapper recommends today: beeffeed.0930...@localdomain.org
