2.2a and postfix, what to put in virttable?

[Jev]

I think it is a postfix config question too. I apologies if people find 
this off topic, It does concern cyrus though, namely cyrus virtual 
domain support.

Anyway, ardrua.com is not the primary domain. And to specify a domain 
entry in mysql I just put 'ardrua.com' in the where_field and the string 
'RHDD' in the 'select_field', It's basically the same as a regular 
virtual file :)

Also, I'm using lmtp for delivery and not the 'cyrus' transport method, 
could this play a part? I can't test it now, but I will try later.

My setup works fine for regular accounts using mysql for virtual 
lookups, and using lmtp as the local delivery method.

All the best,
-Jev

Edward Zarecor wrote:
> I wonder if it's not a postfix configuration question then.  In my 
> postfix log, I see this when a message is delivered correctly:
> 
> Apr  8 09:47:04 rainman postfix/pipe[32454]: A5C8111800A: 
> to=<edward at example.org@example.com>, relay=cyrus, delay=1, status=sent 
> (rainman.example.com)
> 
> Also.
> 
> 1. is ardrua the primary cyrus domain?  If so, you shouldn't need a 
> virtual map at all.  Sorry if this is a stupid question.
> 2. how do you specify a domain entry in the postfix mysql config.  You 
> need to specificy the names of your virutal domains in your virtual 
> file, there must be a similar mechanism for mysql.
> 
> Ed.
> 
> Jev wrote:
> 
>> I'm actually using mysql for virttables, which I should have mentioned;
>>
>> My virtual file looks like this (host and user/pass ommited):
>> dbname = sysdb
>> table = mail
>> select_field = mailid
>> where_field = address
>>
>> I tried putting jev\\\@example.com into the mailid column (which would 
>> be the right-hand value in a regular virtual file) but mail fails to 
>> deliver, and I get this in my maillog:
>>
>> Apr  8 08:59:50 quintero postfix/error[87854]: 13C5BC9437: 
>> to=<jev\@ardrua.com>, orig_to=<jev at ardrua.com>, relay=none, delay=0, 
>> status=bounced (user unknown in virtual alias table)
>>
>> Thanks for the help!
>>
>> -Jev
>>
>>
>>
>> Edward Zarecor wrote:
>>
>>>  From the postfix virtual manpage:
>>>
>>> #        /etc/postfix/virtual:
>>> #            virtual.domain       anything (right-hand content does 
>>> not matter)
>>> #            postmaster at virtual.domain    postmaster
>>> #            user1 at virtual.domain address1
>>> #            user2 at virtual.domain address2, address3
>>>
>>> so, you've reversed them.  There's also the escaping concern with 
>>> virutal and cyrus.
>>>
>>> so for your example, you'd want something like
>>>
>>> example.com    DOMAIN
>>> jev at example.com    jev\\\@example.com
>>> jev2 at example.com  jev\\\@example.com
>>>
>>> This assumes example is not your "main" cyrus domain, which is what I 
>>> think you want.
>>>
>>> Ed.
>>>
>>> Jev wrote:
>>>
>>>> Hi again,
>>>>
>>>> When using postfix to deliver to virtual mailboxes what should I put 
>>>> in the left hand data position?
>>>>
>>>> If I do:
>>>>
>>>>
>>>>
>>>> jev at example.com            jev at example.com
>>>> ^-cyrus mailbox-^        ^-postifx virtual-^
>>>>
>>>>
>>>> or
>>>>
>>>> jev at example.com            jev at example2.com
>>>> ^-cyrus mailbox-^        ^-postifx virtual-^
>>>>
>>>>
>>>>
>>>> As I understand it, postfix will attempt to resend any mails sent to 
>>>> jev at example2.com to jev at example.com, instead of attempting to 
>>>> deliver them locally to cyrus.
>>>>
>>>> Slightly confused here,
>>>> TIA,
>>>> -Jev
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
> 
> 
>