2.2a and postfix, what to put in virttable?

[Jev]

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
>>
>>
>>
> 
> 
>