Hello,
I have the problem with aliases. The emails did not delivery to correct email. I send email to email: to_alias@domain.com that is valid alias and email should be sent to real email folder: to@domain.com. Dovecot creating to_alias folder and deliver the emails there. Here is the email log: / did not see to@domain.com below /
Apr 5 18:54:40 www postfix/smtpd[30547]: connect from
mail-40137.protonmail.ch[185.70.40.137]
Apr 5 18:54:40 www postfix/smtpd[30547]: Anonymous TLS connection
established from mail-40137.protonmail.ch[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
Apr 5 18:54:52 www postfix/smtpd[30547]: 85A412E19B6: client=
mail-40137.protonmail.ch[185.70.40.137]
Apr 5 18:54:52 www postfix/cleanup[30556]: 85A412E19B6:
message-id=
I was playing with password_query but not sure did I'm on right direction.
password_query =
SELECT username AS user, password,
'/var/spool/postmail/%d/%n' AS userdb_home, 1002 AS userdb_uid, 1001 AS
userdb_gid
FROM mailbox WHERE username = (SELECT goto FROM alias WHERE address =
'%u')
I'm using dovecot --version: 2.3.18 (9dd8408c18) and my configuration is:
# 2.3.18 (9dd8408c18): /etc/dovecot/dovecot.conf # Pigeonhole version 0.5.18 (0bc28b32) # OS: Linux 5.17.0 x86_64 Slackware 15.0+ ext4 # Hostname: www.ixip.net base_dir = /var/run/dovecot/ default_login_user = nobody dict { driver = sql quota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext } disable_plaintext_auth = no lda_mailbox_autocreate = yes lda_mailbox_autosubscribe = yes mail_location = maildir:/var/spool/postmail/%d/%n/Maildir mail_privileged_group = vmail managesieve_notify_capability = mailto 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 namespace inbox { inbox = yes list = yes location = mailbox Drafts { special_use = \Drafts } mailbox Junk { special_use = \Junk } mailbox Sent { special_use = \Sent } mailbox "Sent Messages" { special_use = \Sent } mailbox Trash { special_use = \Trash } prefix = type = private } passdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } passdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } plugin { sieve = /var/spool/postmail/%d/%n/.dovecot.sieve sieve_dir = /var/spool/postmail/%d/%n/sieve/ sieve_global_dir = /var/lib/dovecot/sieve sieve_global_path = /var/lib/dovecot/sieve/default.sieve } protocols = imap lmtp sieve sieve service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0666 user = postfix } } service imap-login { inet_listener imap { address = 127.0.0.1 port = 143 } inet_listener imaps { address = 127.0.0.1 port = 993 } } service lmtp { unix_listener /var/spool/postfix/private/dovecot-lmtp { group = postfix mode = 0600 user = postfix } user = vmail } service managesieve-login { inet_listener sieve { address = 127.0.0.1 port = 4190 } service_count = 1 vsz_limit = 64 M } ssl_cert =
# grep -v '^ *\(#.*\)\?$' dovecot-sql.conf.ext driver = mysql connect = host=localhost dbname=postfix user=postfix password=password default_pass_scheme = CRYPT password_query = SELECT username AS user, password FROM mailbox WHERE username = '%u';
Kind Regards, Chris