Hi everybody,
I have a problem after moving our mail server to a new machine. Everything seems to be working so far - but not the virtual aliases. I'll try to explain: "test.mail.com" is a mail server administering several domains e.g. "my.domain". Mail user and aliases are stored in a MySQL database. Postfix is recovering the data from this database, and it's working fine for existing mailboxes postfix/qmgr[4566]: CD77E81A0F: from=<some.addr...@posteo.de>, size=4091, nrcpt=1 (queue active) postfix/smtpd[7633]: disconnect from mout01.posteo.de[185.67.36.65] ehlo=2 starttls=1 mail=1 rcpt=1 data=1 quit=1 commands=7 postfix/lmtp[7636]: CD77E81A0F: to=<some.user@my.domain>, relay=127.0.0.1[127.0.0.1]:24, delay=0.33, delays=0.31/0.01/0.01/0, dsn=2.0.0, status=sent (250 2.0.0 <some.user@my.domain> 5sHdOex9p2fVHQAA7jBDhg Saved) But let's say I send an email from some.address@ <mailto:some.address@> posteo.de to test@my.domain <mailto:test@my.domain> , which is an alias. The MySQL log files show no trouble: 3598 Connect postfixadmin@localhost on postfixadmin using Socket 3598 Query SELECT goto FROM alias WHERE address='posteo.de' AND active = '1' 3599 Connect postfixadmin@localhost on postfixadmin using Socket 3599 Query SELECT domain FROM domain WHERE domain='posteo.de' and active = '1' 3599 Query SELECT domain FROM domain WHERE domain='de' and active = '1' 3598 Query SELECT goto FROM alias WHERE address='my.domain' AND active = '1' 3599 Query SELECT domain FROM domain WHERE domain='my.domain' and active = '1' 3598 Query SELECT goto FROM alias WHERE address='posteo.de' AND active = '1' 3599 Query SELECT domain FROM domain WHERE domain='posteo.de' and active = '1' 3599 Query SELECT domain FROM domain WHERE domain='de' and active = '1' 3598 Query SELECT goto FROM alias WHERE address='test@my.domain' AND active = '1' 3598 Query SELECT goto FROM alias WHERE address='my.domain' AND active = '1' 3599 Query SELECT domain FROM domain WHERE domain='my.domain' and active = '1' 3600 Connect postfixadmin@localhost on postfixadmin using Socket 3600 Query SELECT concat('/vmail/', maildir) as home, concat('maildir:/vmail/', maildir) as mail, 1000 AS uid, 1009 AS gid, CONCAT('*:messages=10000:bytes=', quota) as quota_rule FROM mailbox WHERE username = 'test@my.domain' AND active = '1' 3598 Query SELECT goto FROM alias WHERE address='some.addr...@posteo.de' AND active = '1' 3598 Query SELECT goto FROM alias WHERE address='@posteo.de' AND active = '1' 3598 Query SELECT goto FROM alias WHERE address='posteo.de' AND active = '1' 3599 Query SELECT domain FROM domain WHERE domain='posteo.de' and active = '1' 3599 Query SELECT domain FROM domain WHERE domain='de' and active = '1' But postfix now will now concat the output data and deliver them to a MAILBOX t...@mydomain.de <mailto:t...@mydomain.de> which doesn't exist as it's an alias: postfix/qmgr[4566]: 3EA9481A40: from=<some.addr...@posteo.de>, size=4034, nrcpt=1 (queue active) postfix/smtpd[7319]: disconnect from mout02.posteo.de[185.67.36.66] ehlo=2 starttls=1 mail=1 rcpt=1 data=1 quit=1 commands=7 postfix/lmtp[7324]: 3EA9481A40: to=<test@my.domain>, relay=127.0.0.1[127.0.0.1]:24, delay=1.3, delays=1.2/0.01/0.01/0.02, dsn=5.1.1, status=bounced (host 127.0.0.1[127.0.0.1] said: 550 5.1.1 <test@my.domain> User doesn't exist: test@my.domain (in reply to RCPT TO command)) postfix/cleanup[7323]: 30DB081A5A: message-id=<20250208154131.30db081...@test.mail.com> postfix/bounce[7327]: 3EA9481A40: sender non-delivery notification: 30DB081A5A Ubuntu 24.04 Postfix version 3.8.6 (on the old server it was 3.4.13) Dovecot 2.3.7.2 MySQL Ver 15.1 Distrib 10.11.8-MariaDB SQL-related main.cf items: mydestination = $myhostname, localhost.$mydomain, localhost relay_domains = proxy:mysql:/etc/postfix/mysql-relay_domains_maps.cf virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_alias_maps.cf, regexp:/etc/postfix/virtual_regexp, hash:/etc/postfix/virtual I'd appreciate help! Thanks and regards Lothar
_______________________________________________ Postfix-users mailing list -- postfix-users@postfix.org To unsubscribe send an email to postfix-users-le...@postfix.org
