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/claudio@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/claudio@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/claudio@domain.net/ uid: 51 gid: 51 mail: maildir:~/Maildir quota_rule: *:bytes=0
Regards, Pascal
The trapper recommends today: beeffeed.0930105@localdomain.org