[Dovecot] Dovecot

[Pascal Volk]

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 at 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 at 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 at domain.net/
       uid: 51
       gid: 51
      mail: maildir:~/Maildir
quota_rule: *:bytes=0


Regards,
Pascal
-- 
The trapper recommends today: beeffeed.0930105 at localdomain.org