[Dovecot] Postfix Query

[Tim]

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