On Mon, May 04, 2020 at 08:08:25PM +0100, Robert Nemet wrote:
> main.cf
>
> *** version one, working configuration ***
>
> virtual_mailbox_domains = myvirtualdomain.uk,myvirtualdomain2.uk,
> myvirtualdomain3.uk
A list of *domain names*.
> *** version two ***
>
> virtual_mailbox_domains =
> proxy:mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf
> [...]
> Mail is rejected:
A table that is expected to return a result for a query with a lookup
key of each of the *domain names* (the result is ignored, the
*existence* of the key is what counts).
> If I query the table with postmap, I get the same result as the working
> config:
>
> postmap -q robert.ne...@virtualdomain.uk
> mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf
> myvirtualdomain.uk,myvirtualdomain2.uk,myvirtualdomain3.uk
That's not the right lookup key, and an irrelevant result.
> Could anybody tell me what can be the problem?
The table does not hold the domains as lookup keys. But frankly, I
don't recommend using an SQL table for the virtual domains unless you're
going to be hosting a much larger (dynamic) population of these than
just three.
--
Viktor.
