Hello,

I have a simple virtual domain configuration, based on postfix virtual
howto.
If I try to use mysql table for virtual domains, mails are rejected. If I
don't, everything works.

configuration:
Real server names are replaced in the configurations and logs.

master.cf:
I have my own delivery service for incoming mail, but it doesn't seem to
affect delivery at all.

main.cf

*** version one, working configuration ***

virtual_mailbox_domains = myvirtualdomain.uk,myvirtualdomain2.uk,
myvirtualdomain3.uk
virtual_mailbox_maps = proxy:mysql:/etc/postfix/
mysql-virtual-mailbox-maps.cf proxy:mysql:/etc/postfix/
mysql-virtual-mailbox-maps2.cf proxy:mysql:/etc/postfix/
mysql-virtual-recipients-alias.cf

Mail is delviered:

May  4 17:39:54 myserver postfix/smtpd[27490]: connect from
unknown[213.48.6.18]
May  4 17:39:55 myserver postfix/smtpd[27490]: 3B53D7E9C3:
client=unknown[213.48.6.18]
May  4 17:39:55 myserver postfix/cleanup[27493]: 3B53D7E9C3: message-id=<
1588613990.28840.3.ca...@mydomain.com>
May  4 17:39:55 myserver postfix/qmgr[26365]: 3B53D7E9C3: from=<
m...@mydomain.com>, size=1441, nrcpt=1 (queue active)
May  4 17:39:55 myserver postfix/smtpd[27490]: disconnect from
unknown[213.48.6.18] ehlo=2 starttls=1 mail=1 rcpt=1 data=1 quit=1
commands=7
May  4 17:39:55 myserver postfix/pipe[27494]: 3B53D7E9C3: to=<
robert.ne...@virtualdomain.uk>, relay=myservice, delay=0.43,
delays=0.04/0/0/0.39, dsn=2.0.0, status=sent (delivered via myservice
service)

*** version two ***

virtual_mailbox_domains = proxy:mysql:/etc/postfix/
mysql-virtual-mailbox-domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/
mysql-virtual-mailbox-maps.cf proxy:mysql:/etc/postfix/
mysql-virtual-mailbox-maps2.cf proxy:mysql:/etc/postfix/
mysql-virtual-recipients-alias.cf

Mail is rejected:

May  4 17:44:52 myserver postfix/smtpd[28478]: connect from
unknown[213.48.6.18]
May  4 17:44:52 myserver postfix/smtpd[28478]: NOQUEUE: reject: RCPT from
unknown[213.48.6.18]: 554 5.7.1 <robert.ne...@virtualdomain.uk>: Relay
access denied; from=<m...@mydomain.com> to=<robert.ne...@virtualdomain.uk>
proto=ESMTP helo=<mymailserver.com>
May  4 17:44:53 myserver postfix/smtpd[28478]: disconnect from
unknown[213.48.6.18] ehlo=2 starttls=1 mail=1 rcpt=0/1 data=0/1 rset=1
quit=1 commands=6/8

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

Could anybody tell me what can be the problem?

This is a test server, where I have only 3 domains. I have a few dozens on
my production server, and users can add their own if they want, therefore
using SQL tables would be reasonable. (Current production uses Exim, we
want to replace it with Postfix.)

Thanks
Robert

Reply via email to