Postfix w/MySQL Virtual Alias Issue

Hello all,

I am having trouble with a virtual alias that is being run through a
Postfix (2.2.12) installation that uses MySQL for virtual domain
mappings. I get an error in my maillog that says the alias is an
unknown user after I send mail to that alias.

We'll assume virtual domain of example.com, and the alias is
"alias@example.com" and the destination is "realmail@example.com"

I have my main.cf as follows:

virtual_alias_maps = mysql:/etc/postfix/sql/virtual_alias_maps.cf

When I run a

#postmap -q "alias@example.com" mysql:/etc/postfix/sql/
virtual_alias_maps.cf

I get

realmail@example.com

So the mappings seem to be working correctly.

But when I

#mail alias@example.com

and send mail on to the alias@example.com address, this shows up in my
maillog:

Apr 29 15:26:03 example postfix/virtual[17937]: C771D11CC61B:
to=<alias@example.com>, relay=virtual, delay=1, status=bounced
(unknown user: "alias@example.com")

And then it is, obviously, lost :(

I can send mail directly to realmail@example.com without any issues so
I know that example.com is configured correctly (or at least,
correctly enough?)

Anyone have any ideas I could try to get aliases working?

Thanks,
Wesley

On 2008-04-30, wduffee <wduffee@gmail.com> wrote:
> Hello all,
>
> I am having trouble with a virtual alias that is being run through a
> Postfix (2.2.12) installation that uses MySQL for virtual domain
> mappings. I get an error in my maillog that says the alias is an
> unknown user after I send mail to that alias.
>
> We'll assume virtual domain of example.com, and the alias is
> "alias@example.com" and the destination is "realmail@example.com"
>
> I have my main.cf as follows:
>
> virtual_alias_maps = mysql:/etc/postfix/sql/virtual_alias_maps.cf

This is virtual_alias_maps, the thing which REWRITES addresses

> Apr 29 15:26:03 example postfix/virtual[17937]: C771D11CC61B:
> to=<alias@example.com>, relay=virtual, delay=1, status=bounced
> (unknown user: "alias@example.com")

THIS is the virtual delivery agent at work, which uses
virtual_MAILBOX_maps

--
Ralf Hildebrandt (i.A. des IT-Zentrums) Ralf.Hildebrandt@charite.de
Charite - Universitätsmedizin Berlin Tel. +49 (0)30-450 570-155
Gemeinsame Einrichtung von FU- und HU-Berlin Fax. +49 (0)30-450 570-962
IT-Zentrum Standort CBF send no mail to snickebo@charite.de

Sounds great - makes sense.

Thanks!

On May 1, 4:00 am, Ralf Hildebrandt <hil...@charite.de> wrote:
> On 2008-04-30, wduffee <wduf...@gmail.com> wrote:
>
> > Hello all,
>
> > I am having trouble with a virtual alias that is being run through a
> > Postfix (2.2.12) installation that uses MySQL for virtual domain
> > mappings. I get an error in my maillog that says the alias is an
> > unknown user after I send mail to that alias.
>
> > We'll assume virtual domain of example.com, and the alias is
> > "al...@example.com" and the destination is "realm...@example.com"
>
> > I have my main.cf as follows:
>
> > virtual_alias_maps = mysql:/etc/postfix/sql/virtual_alias_maps.cf
>
> This is virtual_alias_maps, the thing which REWRITES addresses
>
> > Apr 29 15:26:03 example postfix/virtual[17937]: C771D11CC61B:
> > to=<al...@example.com>, relay=virtual, delay=1, status=bounced
> > (unknown user: "al...@example.com")
>
> THIS is the virtual delivery agent at work, which uses
> virtual_MAILBOX_maps
>
> --
> Ralf Hildebrandt (i.A. des IT-Zentrums) Ralf.Hildebra...@charite.de
> Charite - Universitätsmedizin Berlin Tel. +49 (0)30-450 570-155
> Gemeinsame Einrichtung von FU- und HU-Berlin Fax. +49 (0)30-450 570-962
> IT-Zentrum Standort CBF send no mail to snick...@charite.de

On May 1, 4:00*am, Ralf Hildebrandt <hil...@charite.de> wrote:
> On 2008-04-30, wduffee <wduf...@gmail.com> wrote:
>
> > Hello all,
>
> > I am having trouble with a virtual alias that is being run through a
> > Postfix (2.2.12) installation that uses MySQL for virtual domain
> > mappings. I get an error in my maillog that says the alias is an
> > unknown user after I send mail to that alias.
>
> > We'll assume virtual domain of example.com, and the alias is
> > "al...@example.com" and the destination is "realm...@example.com"
>
> > I have my main.cf as follows:
>
> > virtual_alias_maps = mysql:/etc/postfix/sql/virtual_alias_maps.cf
>
> This is virtual_alias_maps, the thing which REWRITES addresses
>
> > Apr 29 15:26:03 example postfix/virtual[17937]: C771D11CC61B:
> > to=<al...@example.com>, relay=virtual, delay=1, status=bounced
> > (unknown user: "al...@example.com")
>
> THIS is the virtual delivery agent at work, which uses
> virtual_MAILBOX_maps
>
> --
> Ralf Hildebrandt (i.A. des IT-Zentrums) * * * * Ralf.Hildebra...@charite.de
> Charite - Universitätsmedizin Berlin * * * * * *Tel. *+49 (0)30-450 570-155
> Gemeinsame Einrichtung von FU- und HU-Berlin * *Fax. *+49 (0)30-450 570-962
> IT-Zentrum Standort CBF * * * * * * * * send no mail to snick...@charite.de

I've been having this same issue, and I am a bit lost in your reply.

How would one make it so the alias file works? rather then having a
box for each address.

> > > virtual_alias_maps = mysql:/etc/postfix/sql/virtual_alias_maps.cf
> >
> > This is virtual_alias_maps, the thing which REWRITES addresses
> >
> > > Apr 29 15:26:03 example postfix/virtual[17937]: C771D11CC61B:
> > > to=<al...@example.com>, relay=virtual, delay=1, status=bounced
> > > (unknown user: "al...@example.com")
> >
> > THIS is the virtual delivery agent at work, which uses
> > virtual_MAILBOX_maps

The error message is not related to that particular setting. You'll
need to take a closer look at the Virtual Address ReadMe to troubleshoot
your set up. If you grep your main.cf file for "virtual" then you'll
either find virtual *mailbox* settings that conflict with your
virtual *alias* settings or that the ultimate destination for the
aliased address is not configured properly in virtual mailboxes.

Chris