hi
i dont know exactly what succeeded but me alias don't run any more :-/
i know i used to be able to send mail via aliases from mae to mar...@domain.com
The names have of course been changed, simply for reasons of data protection.
frendly asking i need little help, i think i have syntax mistake on mysql
syntax call
please why auth-worker don't find the alias mae, and send back "unknown user" ?
emails send to mar...@domain.com and also other mail adresses will run without
problems.
only the function alias no longer wants to.
Feb 05 Time Dovecot/lmtp(279699): Info: Connect from local
Feb 05 Time Dovecot/auth-worker(279700): Info: conn unix:auth-worker
(pid=279685,uid=113): auth-worker<5>: sql(m...@domain.com): unknown user
Feb 05 Time Dovecot/lmtp(279699): Info: Disconnect from local: Client has quit
the connection (state=READY)
dovecot.conf
[snip]
passdb {
args = /etc/dovecot/dovecot-sql.conf
driver = sql
}
userdb {
args = /etc/dovecot/dovecot-sql.conf
driver = sql
}
cat auth-sql.conf.ext
[snip]
passdb {
driver = mysql
args = /etc/dovecot/dovecot-sql.conf
}
userdb {
driver = mysql
args = /etc/dovecot/dovecot-sql.conf
}
# cat dovecot-sql.conf
driver = mysql
connect = host=localhost dbname=mailserver user=username password=
default_pass_scheme = CRYPT
user_query = SELECT '/srv/vmail/%d/%n' AS home, '10000' AS uid, '10000' AS gid,
CONCAT('*:storage=', (quota*1024)) as quota_rule FROM mailbox WHERE
username='%u' AND active = 1
password_query = SELECT username AS user, password, '/srv/vmail/%d/%n' AS
userdb_home, '10000' AS userdb_uid, '10000' AS userdb_gid,
CONCAT('maildir:storage=', (quota*1024)) as userdb_quota FROM mailbox WHERE
username='%u' AND active = 1
yes this exist as mailbox
# dovecot user mar...@domain.com
field value
uid 10000
gid 10000
home /srv/vmail/domain.com/markus
mail maildir:~/Maildir
quota_rule *:storage=0
yes the mae are only a alias, so i think this are right!?
# dovecot user m...@domain.com
userdb lookup: user m...@domain.com doesn't exist
field value
MariaDB [mailserver]> SELECT * FROM mailbox;
+------------------
+----------+--------+---------------------+------------+------------+---------+
| username | password | name | maildir | local_part |
domain | active |
+-------------------+----------+--------+---------------------+------------+------------+---------+
| mar...@domain.com | ******** | markus | domain.com/markus/ | Markus M |
domain.com | 1 |
MariaDB [mailserver]> SELECT * FROM alias;
+-----------------+--------------------+------------+--------+
| address | goto | domain | active |
+-----------------+---------------------------------+--------+
| m...@domain.com | mar...@domain.com | domain.com | 1 |
+-----------------+---------------------------------+--------+
34 rows in set (0.001 sec)
dovecot --version 2.3.13 (89f716dc2)
postconf mail_version 3.5.23
mysql Ver 15.1 Distrib 10.5.21-MariaDB
debian 11 bullseye
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
