Virtual alias in MySQL fails
NeonNero
alt.comp.mail.postfix, so I'll repeat myself here, in the hope that
someone might know what to do.
I'm basically stumped while setting up a new Postfix installation
using
a MySQL database from a previous installation (exact Postfix config
for
that one was lost during a harddrive crash, which is why I'm setting
up
this new Postfix).
While sending e-mail to a mailbox account on the system, it passes
through without any problems whatsoever. When I send an e-mail to an
alias address (on the same domain as the mailbox account I mentioned),
it's rejected as unknown user.
When I set up logging in MySQL, it's revealed that somewhere in the
message queue, Postfix checks the SENDER address in the alias table,
rather than the recipient address. I've posted the exact results here
(sender and recipient addresses replaced by example placeholders):
http://capture.kimandre.com/usenet/postfix/mysqlresponse.html
Contents of main.cf:
http://capture.kimandre.com/usenet/postfix/main.txt
Contents of master.cf:
http://capture.kimandre.com/usenet/postfix/master.txt
Contents of mysql-virtual_alias.cf, mysql-virtual_domains.cf,
mysql-virtual_email2email.cf, mysql-virtual_mailboxes.cf,
mysql-virtual_mailbox_limit_maps.cf and mysql-virtual_transports.cf
(MySQL password removed):
http://capture.kimandre.com/usenet/postfix/mysql-virtual_alias.txt
http://capture.kimandre.com/usenet/postfix/mysql-virtual_domains.txt
http://capture.kimandre.com/usenet/postfix/mysql-virtual_email2email.txt
http://capture.kimandre.com/usenet/postfix/mysql-virtual_mailboxes.txt
http://capture.kimandre.com/usenet/postfix/mysql-virtual_mailbox_limit_maps.txt
http://capture.kimandre.com/usenet/postfix/mysql-virtual_transports.txt
I've yet to install amavisd-new and other content filters, as I'm
trying to get this part working first. Port 25 in to this server is
still blocked until everything is in place.
The Postfix is installed on a Debian system for an AMD64 processor.
Can anyone please point me in the right direction to resolve this
issue?
andrew
Try this.
Change --> mydestination = mx3.betadome.net, nansen.betadome.net,
localhost
To this --> mydestination =
I'm having somewhat of a similar problem. I came to this group to see
if I could get help. Our configuration is about the same.
However, if I do mail from the server, the alias works. So for
example:
1: mail al...@domain.com
2: Subject: test
3: test
4: .
5: CC:.
Let me know what you find out, please.
Thanks,
Andrew
On Nov 6, 8:02 am, NeonNero <neonn...@gmail.com> wrote:
> I got pretty impatient waiting for a response to my problems in
> alt.comp.mail.postfix, so I'll repeat myself here, in the hope that
> someone might know what to do.
>
> I'm basically stumped while setting up a new Postfix installation
> using
> a MySQL database from a previous installation (exact Postfix config
> for
> that one was lost during a harddrive crash, which is why I'm setting
> up
> this new Postfix).
>
> While sending e-mail to a mailbox account on the system, it passes
> through without any problems whatsoever. When I send an e-mail to an
> alias address (on the same domain as the mailbox account I mentioned),
> it's rejected as unknown user.
>
> When I set up logging in MySQL, it's revealed that somewhere in the
> message queue, Postfix checks the SENDER address in the alias table,
> rather than the recipient address. I've posted the exact results here
> (sender and recipient addresses replaced by example placeholders):http://capture.kimandre.com/usenet/postfix/mysqlresponse.html
>
> Contents of main.cf:http://capture.kimandre.com/usenet/postfix/main.txt
>
> Contents of master.cf:http://capture.kimandre.com/usenet/postfix/master.txt
>
> Contents of mysql-virtual_alias.cf, mysql-virtual_domains.cf,
> mysql-virtual_email2email.cf, mysql-virtual_mailboxes.cf,
> mysql-virtual_mailbox_limit_maps.cf and mysql-virtual_transports.cf
NeonNero
>
> > I've yet to install amavisd-new and other content filters, as I'm
> > trying to get this part working first. Port 25 in to this server is
> > still blocked until everything is in place.
>
> > The Postfix is installed on a Debian system for an AMD64 processor.
>
> > Can anyone please point me in the right direction to resolve this
> > issue?
The same thing happened - it bounced back just as before.
I'm open for any other ideas, though.
NeonNero
This weekend, I essentially gave up on trying to find the solution for
free, and posted my problem on Experts-Exchange.com. After a few days,
I finally found the solution (via a response, of course).
It seemed that the following configuration line was the culprit in my
case:
receive_override_options = no_address_mappings
Removing it or commenting it out from main.cf solved the problem, so
if you had the same problem yourself, try that.
spork
Wow. I was just struggling with the exact same problem. I was
watching extra debugging on qmgr, watching sql queries in mysql's
query log, going over my main.cf again and again looking for a mistake
and just couldn't find anything.
Like you, I'd simply moved a working set of config files from a test
server to a new server and I had the same failure with aliases.
The one config change I found was that my content_filter line was
commented out since I'd not yet setup another amavis instance for this
setup. Below the content_filter line was the receive_override_options
line. I believe this is necessary *when using a content filter*, but
will screw things up otherwise.
Anyhow, commenting receive_override_options out fixed everything up.
It would have taken me a few days to figure this out... Thanks so
much for posting your solution!
Charles