Re: [Dovecot] Postfix Query
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
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: USER1
>>
>> tim at subdomain.example.com maildir=example.com/subdomain/tim
>> uid=mailuser
>> gid=mailgroupquota_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
Re: [Dovecot] Postfix Query
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 t...@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 t...@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(t...@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(t...@subdomain.example.com): Info: maildir: data=/var/mail/subdomain.example.com/tim/Maildir May 10 21:51:20 deliver(t...@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
