On Tue, May 20, 2025 at 4:08 AM Cam Ellison via dovecot <dovecot@dovecot.org>
wrote:
The system in question primarily sends emails to group members but
also has a
few virtual email accounts for officers. Usernames and passwords are
looked up
from a mysql (MariaDB) database. After the upgrade incoming mail now
goes to a
vmail account that Dovecot creates because it cannot match the email
to the
user for whom it is intended (there is no user 'vmail' in the
system). Users
can log in and read their mail and send mail, but any emails received
since the
change to 2.4 are understandably inaccessible.
Below is the output from doveconf -n. Can anyone see what is wrong?
# 2.4.1-4 (7d8c0e5759): /etc/dovecot/dovecot.conf
# Pigeonhole version 2.4.1-4 (0a86619f)
# OS: Linux 6.1.0-20-rt-686-pae i686 Debian 13.0 ext4
# Hostname: football.scasl.ca
# 4 default setting changes since version 2.4.0
dovecot_config_version = 2.4.0
auth_debug = yes
auth_debug_passwords = yes
auth_mechanisms = plain login
base_dir = /var/run/dovecot/
dovecot_storage_version = 2.4.0
first_valid_gid = 5000
first_valid_uid = 5000
fts_autoindex = yes
fts_autoindex_max_recent_msgs = 999
fts_search_add_missing = yes
hostname = scasl.ca
listen = * ::
login_trusted_networks = 209.121.143.10/32
mail_debug = yes
mail_driver = maildir
mail_gid = 5000
mail_home = /var/vmail/%{user|username}
mail_inbox_path = /var/vmail/%{user|username}/Maildir/INBOX
mail_path = /var/vmail/%{user|username}/Maildir
mail_privileged_group = vmail
mail_uid = 5000
postmaster_address = postmas...@scasl.ca
protocols {
imap = yes
}
sql_driver = mysql
dict quota {
}
mysql scasl.ca {
dbname = scasl
host = localhost
password = # hidden, use -P to show it
port = 3306
user = scasl
}
userdb sql {
iterate_query = SELECT email_username AS username, domain FROM
league
query = SELECT CONCAT('/var/vmail/',email_username) AS home, 5000 AS
uid, 5000
AS gid FROM league WHERE email_username = '%{user|username}'
}
passdb sql {
default_password_scheme = BLF-CRYPT
query = SELECT password FROM login WHERE ID IN (SELECT ID FROM
league WHERE
email_username='%{user|username}')
}
maildir {
very_dirty_syncs = yes
}
namespace inbox {
mail_driver = maildir
mail_home = /var/vmail/%{user|username}
mail_inbox_path = /var/vmail/%{user|username}/Maildir/INBOX
mail_path = /var/vmail/%{user|username}/Maildir
inbox = yes
separator = /
mailbox Drafts {
auto = subscribe
special_use = "\\Drafts"
}
mailbox Junk {
special_use = "\\Junk"
}
mailbox Trash {
special_use = "\\Trash"
}
mailbox Sent {
special_use = "\\Sent"
}
mailbox "Sent Messages" {
special_use = "\\Sent"
}
}
service imap-login {
inet_listener imap {
}
inet_listener imaps {
}
}
service submission-login {
inet_listener submission {
}
}
service lmtp {
unix_listener lmtp {
mode = 0666
}
}
service imap {
}
service pop3 {
}
service submission {
}
service auth {
unix_listener auth-userdb {
mode = 0666
}
unix_listener auth-client {
mode = 0666
}
}
service auth-worker {
}
service dict {
unix_listener dict {
}
}
service stats {
unix_listener stats-reader {
group = vmail
mode = 0666
}
unix_listener stats-writer {
group = vmail
mode = 0666
}
}
ssl_server {
cert_file = /etc/letsencrypt/live/scasl.ca/fullchain.pem
key_file = /etc/letsencrypt/live/scasl.ca/privkey.pem
}
Cheers
Cam
You resolved this issue, right?
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
In an Internet failure case, the #1 suspect is a constant: DNS.
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
[How to ask smart questions: http://www.catb.org/~esr/faqs/smart-
questions.html]
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
