Noel Jones wrote:
Seems to me if you're getting a "relay access denied" then the
@testing.domain is working, and you have some other rule that's
rejecting the mail. Or maybe you somehow removed "testing.domain"
from relay_domains.
Sorry, I don't debug SQL. I suggest you get it working with flat
files first, then duplicate the setup with your SQL.
With flat files it works as expected - when I add "testing.domain" into
relay_domains and "@testing.domain OK" into relay_recipient_maps hash
file, Postfix accepts the mail and forwards it.
I was expecting Postfix to send some query with "@testing.domain"
(which would hint me what should I add into DB), but no such query
in PostgreSQL log.
Any ideas?
Maybe your query is broken.
That's not what I meant. Le me explain:
Let's say I use hash file for relay_recipient_maps, and send e-mail to
recipient@testing.domain. According to Postfix log, it tries to find
"recipient@testing.domain" in the hash file. It doesn't find the record,
so in the next step it tries to find "@testing.domain"; that's there in
the form "@testing.domain OK", so Postfix accepts the mail.
When I switch to pgsql, Postfix tries to find "recipient@testing.domain"
in DB. Again, it finds nothing, but this time the other step - attempt
to find @testing.domain somehow - is skipped and Postfix returns error
right away.
So while it's possible that my query is broken, I was assuming that
Postfix will try it regardless.
