Re: [Dovecot] Postfix Query
user_query = SELECT maildir, mailuser as uid, mailgroup as gid,concat('*:bytes=',quota) as quota_rule FROM virtual_mailbox WHERE username = '%u'
and maildir should return example.com/subdomain/tim for this particular user
What does your user_query look like in dovecot-sql.conf.ext?
On 2012-05-10 17:13, Tim wrote:
Hello,
Another question!!
Was just trying to sort out mail delivery to subdomains. I set up my system so that I have a mail address of tim at subdomain.example.com. I've sorted out Postfix to correctly identify this and pass on to Dovecot for delivery but Dovecot doesn't seem to deliver where I want it to. Ideally I would like to have a structure so that mail is delivered to
/var/mail/example.com/subdomain/user
My users are stored in MySQL and they are being pulled out correctly, but dovecot is delivering to
/var/mail/subdomain.example.com/tim
Looking at my logs it seems that the mail location is being picked up not being acted on...
May 10 21:51:20 auth(default): Info: master out: USER 1
tim at subdomain.example.com maildir=example.com/subdomain/tim uid=mailuser gid=mailgroup quota_rule=*:bytes=2147483647
...a bit further down...
May 10 21:51:20 deliver(tim at subdomain.example.com): Info: auth input: maildir=example.com/subdomain/tim
...then further down it seems to change all of a sudden...
May 10 21:51:20 deliver(tim at subdomain.example.com): Info: maildir: data=/var/mail/subdomain.example.com/tim/Maildir May 10 21:51:20 deliver(tim at subdomain.example.com): Info: maildir++: root=/var/mail/subdomain.example.com/tim/Maildir, index=, control=, inbox=/var/mail/subdomain.example.com/tim/Maildir
Bit confused! Any help would be appreciated!
Cheers,
Tim
On Fri, 2012-05-11 at 19:07 +0100, Tim wrote:
user_query = SELECT maildir, mailuser as uid, mailgroup as gid,concat('*:bytes=',quota) as quota_rule FROM virtual_mailbox WHERE username = '%u'
and maildir should return example.com/subdomain/tim for this particular user
Returning a "maildir" doesn't do anything with Dovecot. I guess you want something like:
select concat('/var/mail/', maildir) as home, ...
and in dovecot.conf:
mail_location = maildir:~/Maildir
participants (2)
-
Tim
-
Timo Sirainen