<div dir="ltr"><div>Hello,</div><div><br></div><div>I have the problem with aliases. The emails did not delivery to correct email. I send email to email: <a href="mailto:to_alias@domain.com">to_alias@domain.com</a> that is valid alias and email should be sent to real email folder: <a href="mailto:to@domain.com">to@domain.com</a>. Dovecot creating to_alias folder and deliver the emails there. Here is the email log: / did not see <a href="mailto:to@domain.com">to@domain.com</a> below /<br></div><div><br></div><div><br>Apr  5 18:54:40 www postfix/smtpd[30547]: connect from <a href="http://mail-40137.protonmail.ch">mail-40137.protonmail.ch</a>[185.70.40.137]<br>Apr  5 18:54:40 www postfix/smtpd[30547]: Anonymous TLS connection established from <a href="http://mail-40137.protonmail.ch">mail-40137.protonmail.ch</a>[185.70.40.137]: TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) server-digest SHA384<br>Apr  5 18:54:52 www postfix/smtpd[30547]: 85A412E19B6: client=<a href="http://mail-40137.protonmail.ch">mail-40137.protonmail.ch</a>[185.70.40.137]<br>Apr  5 18:54:52 www postfix/cleanup[30556]: 85A412E19B6: message-id=<M07eijxF0PArGZ92wKYpeCndUNv5g3kSEgYljlhYwOVPxIor3AmNRxrPyNK9T8GcncG1dmxS6Lv35IfR5ompsUPEGPucNn9SjxkMxAgHzhI=@<a href="http://protonmail.com">protonmail.com</a>><br>Apr  5 18:54:53 www dccifd[1856]: stat(log directory "log"): No such file or directory<br>Apr  5 18:54:57 www postfix/qmgr[1398]: 85A412E19B6: from=<<a href="mailto:from@protonmail.com">from@protonmail.com</a>>, size=2767, nrcpt=1 (queue active)<br>Apr  5 18:54:57 www postfix/smtpd[30547]: disconnect from <a href="http://mail-40137.protonmail.ch">mail-40137.protonmail.ch</a>[185.70.40.137] ehlo=2 starttls=1 mail=1 rcpt=1 data=1 quit=1 commands=7<br>Apr  5 18:54:57 www dovecot: lmtp(30559): Connect from local<br>Apr  5 18:54:57 www dovecot: lmtp(<a href="mailto:compiz@domain.com">compiz@domain.com</a>)<30559><U8KALFFmTGJfdwAA8oMCvw>: sieve: msgid=<M07eijxF0PArGZ92wKYpeCndUNv5g3kSEgYljlhYwOVPxIor3AmNRxrPyNK9T8GcncG1dmxS6Lv35IfR5ompsUPEGPucNn9SjxkMxAgHzhI=@<a href="http://protonmail.com">protonmail.com</a>>: stored mail into mailbox 'INBOX'<br>Apr  5 18:54:57 www postfix/lmtp[30558]: 85A412E19B6: to=<<a href="mailto:to_alias@domain.com">to_alias@domain.com</a>>, relay=<a href="http://mail.domain.com">mail.domain.com</a>[private/dovecot-lmtp], delay=17, delays=17/0.01/0.01/0.01, dsn=2.0.0, status=sent (250 2.0.0 <<a href="mailto:to_alias@domain.com">to_alias@domain.com</a>> U8KALFFmTGJfdwAA8oMCvw Saved)<br>Apr  5 18:54:57 www dovecot: lmtp(30559): Disconnect from local: Logged out (state=READY)<br>Apr  5 18:54:57 www postfix/qmgr[1398]: 85A412E19B6: removed</div><div><br></div><div>I was playing with
password_query but not sure did I'm on right direction.<br></div><div><br></div><div>password_query = \<br>Â SELECT username AS user, password, \<br>Â Â Â '/var/spool/postmail/%d/%n' AS userdb_home, 1002 AS userdb_uid, 1001 AS userdb_gid \<br>Â FROM mailbox WHERE username = (SELECT goto FROM alias WHERE address = '%u')</div><div></div><div><br></div><div>I'm using dovecot --version: 2.3.18 (9dd8408c18) and my configuration is:</div><div><br></div><div><br># 2.3.18 (9dd8408c18): /etc/dovecot/dovecot.conf<br># Pigeonhole version 0.5.18 (0bc28b32)<br># OS: Linux 5.17.0 x86_64 Slackware 15.0+ ext4<br># Hostname: <a href="http://www.ixip.net">www.ixip.net</a><br>base_dir = /var/run/dovecot/<br>default_login_user = nobody<br>dict {<br>Â driver = sql<br>Â quota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext<br>}<br>disable_plaintext_auth = no<br>lda_mailbox_autocreate = yes<br>lda_mailbox_autosubscribe = yes<br>mail_location = maildir:/var/spool/postmail/%d/%n/Maildir<br>mail_privileged_group = vmail<br>managesieve_notify_capability = mailto<br>managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date index ihave duplicate mime foreverypart extracttext<br>namespace inbox {<br>Â inbox = yes<br>Â list = yes<br>Â location =<br>Â mailbox Drafts {<br>Â Â special_use = \Drafts<br>Â }<br>Â mailbox Junk {<br>Â Â special_use = \Junk<br>Â }<br>Â mailbox Sent {<br>Â Â special_use = \Sent<br>Â }<br>Â mailbox "Sent Messages" {<br>Â Â special_use = \Sent<br>Â }<br>Â mailbox Trash {<br>Â Â special_use = \Trash<br>Â }<br>Â prefix =<br>Â type = private<br>}<br>passdb {<br>Â args = /etc/dovecot/dovecot-sql.conf.ext<br>Â driver = sql<br>}<br>passdb {<br>Â args = /etc/dovecot/dovecot-sql.conf.ext<br>Â driver = sql<br>}<br>plugin {<br>Â sieve = /var/spool/postmail/%d/%n/.dovecot.sieve<br>Â sieve_dir = /var/spool/postmail/%d/%n/sieve/<br>Â sieve_global_dir = /var/lib/dovecot/sieve<br>Â sieve_global_path = /var/lib/dovecot/sieve/default.sieve<br>}<br>protocols = imap lmtp sieve sieve<br>service auth {<br>Â unix_listener /var/spool/postfix/private/auth {<br>Â Â group = postfix<br>Â Â mode = 0666<br>Â Â user = postfix<br>Â }<br>}<br>service imap-login {<br>Â inet_listener imap {<br>Â Â address = 127.0.0.1<br>Â Â port = 143<br>Â }<br>Â inet_listener imaps {<br>Â Â address = 127.0.0.1<br>Â Â port = 993<br>Â }<br>}<br>service lmtp {<br>Â unix_listener /var/spool/postfix/private/dovecot-lmtp {<br>Â Â group = postfix<br>Â Â mode = 0600<br>Â Â user = postfix<br>Â }<br>Â user = vmail<br>}<br>service managesieve-login {<br>Â inet_listener sieve {<br>Â Â address = 127.0.0.1<br>Â Â port = 4190<br>Â }<br>Â service_count = 1<br>Â vsz_limit = 64 M<br>}<br>ssl_cert = </etc/postfix/ssl/mail.stzbg.com.crt<br>ssl_dh = # hidden, use -P to show it<br>ssl_key = # hidden, use -P to show it<br>userdb {<br>Â args = uid=1002 gid=1001 home=/var/spool/postmail/%d/%n allow_all_users=yes<br>Â driver = static<br>}<br>protocol pop3 {<br>Â pop3_uidl_format = %08Xu%08Xv<br>}<br>protocol lmtp {<br>Â mail_plugins = " sieve"<br>}<br>protocol lda {<br>Â mail_plugins = " sieve"<br>}<br>protocol sieve {<br>Â managesieve_implementation_string = Dovecot Pigeonhole<br>}<br><br><br># grep -v '^ *\(#.*\)\?$' dovecot-sql.conf.ext<br>driver = mysql<br>connect = host=localhost dbname=postfix user=postfix password=password<br>default_pass_scheme = CRYPT<br>password_query = SELECT username AS user, password FROM mailbox WHERE username = '%u';</div><div><br></div><div>Kind Regards,</div><div>Chris</div><div><br></div><div><br></div></div>