n***@sourcecomb.com
2017-09-25 03:29:31 UTC
Hi there.
I have Dovecot set up nicely to find out about users from a very basic
SQLite database. Unfortunately, I can't seem to get Postfix to recognise
the same set of users.
To be clear: sending email *from* the users in the database works fine,
since Postfix uses Dovecot for auth. The problem is sending email *to*
these users.
What makes this all the more confusing is that the following command
behaves exactly as expected:
postmap -q ***@mydomain.com sqlite:/etc/postfix/conf.d/sqlite-local-recipients.cf
However, when I actually try to send an email, I keep getting
*Undelivered Mail Returned to Sender*. This address definitely
exists, Dovecot is fine with it, and I can send mail from it.
I will note that I *can* send email to addresses that do have corresponding
system users (i.e. I can send to ***@mydomain.com).
I appreciate any assistance that can be spared.
// Nelson
P.S.: Postfix 3.2.2 on Fedora 26, /etc/postfix/main.cf contains this
relevant line:
local_recipient_maps = sqlite:/etc/postfix/conf.d/sqlite-local-recipients.cf
And /etc/postfix/conf.d/sqlite-local-recipients.cf contains:
dbpath = /var/logmail/logmail.db
query = SELECT username FROM users WHERE username = '%u' AND domain = '%d';
I have Dovecot set up nicely to find out about users from a very basic
SQLite database. Unfortunately, I can't seem to get Postfix to recognise
the same set of users.
To be clear: sending email *from* the users in the database works fine,
since Postfix uses Dovecot for auth. The problem is sending email *to*
these users.
What makes this all the more confusing is that the following command
behaves exactly as expected:
postmap -q ***@mydomain.com sqlite:/etc/postfix/conf.d/sqlite-local-recipients.cf
However, when I actually try to send an email, I keep getting
*Undelivered Mail Returned to Sender*. This address definitely
exists, Dovecot is fine with it, and I can send mail from it.
I will note that I *can* send email to addresses that do have corresponding
system users (i.e. I can send to ***@mydomain.com).
I appreciate any assistance that can be spared.
// Nelson
P.S.: Postfix 3.2.2 on Fedora 26, /etc/postfix/main.cf contains this
relevant line:
local_recipient_maps = sqlite:/etc/postfix/conf.d/sqlite-local-recipients.cf
And /etc/postfix/conf.d/sqlite-local-recipients.cf contains:
dbpath = /var/logmail/logmail.db
query = SELECT username FROM users WHERE username = '%u' AND domain = '%d';