Postfix - Dovecot alias - dovecot

9 Apr 2022 · *\(#.*


      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=<M07eijxF0PArGZ92wKYpeCndUNv5g3kSEgYljlhYwOVPxIor3AmNRxrPyNK9T8GcncG1dmxS6Lv35IfR5ompsUPEGPucNn9SjxkMxAgHzhI=@
protonmail.com>
Apr  5 18:54:53 www dccifd[1856]: stat(log directory "log"): No such file
or directory
Apr  5 18:54:57 www postfix/qmgr[1398]: 85A412E19B6: from=<
from@protonmail.com>, size=2767, nrcpt=1 (queue active)
Apr  5 18:54:57 www postfix/smtpd[30547]: disconnect from
mail-40137.protonmail.ch[185.70.40.137] ehlo=2 starttls=1 mail=1 rcpt=1
data=1 quit=1 commands=7
Apr  5 18:54:57 www dovecot: lmtp(30559): Connect from local
Apr  5 18:54:57 www dovecot:
lmtp(compiz@domain.com)<30559><U8KALFFmTGJfdwAA8oMCvw>:
sieve:
msgid=<M07eijxF0PArGZ92wKYpeCndUNv5g3kSEgYljlhYwOVPxIor3AmNRxrPyNK9T8GcncG1dmxS6Lv35IfR5ompsUPEGPucNn9SjxkMxAgHzhI=@
protonmail.com>: stored mail into mailbox 'INBOX'
Apr  5 18:54:57 www postfix/lmtp[30558]: 85A412E19B6: to=<
to_alias@domain.com>, relay=mail.domain.com[private/dovecot-lmtp],
delay=17, delays=17/0.01/0.01/0.01, dsn=2.0.0, status=sent (250 2.0.0 <
to_alias@domain.com> U8KALFFmTGJfdwAA8oMCvw Saved)
Apr  5 18:54:57 www dovecot: lmtp(30559): Disconnect from local: Logged out
(state=READY)
Apr  5 18:54:57 www postfix/qmgr[1398]: 85A412E19B6: removed
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 = </etc/postfix/ssl/mail.stzbg.com.crt
ssl_dh = # hidden, use -P to show it
ssl_key = # hidden, use -P to show it
userdb {
args = uid=1002 gid=1001 home=/var/spool/postmail/%d/%n
allow_all_users=yes
driver = static
}
protocol pop3 {
pop3_uidl_format = %08Xu%08Xv
}
protocol lmtp {
mail_plugins = " sieve"
}
protocol lda {
mail_plugins = " sieve"
}
protocol sieve {
managesieve_implementation_string = Dovecot Pigeonhole
}
# 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

Postfix - Dovecot alias

John Doe

Benny Pedersen

John Doe

Alexander Dalloz

John Doe

tags

participants (3)