Discussion:
Having difficulty getting Postfix to know about users defined in SQLite database
(too old to reply)
n***@sourcecomb.com
2017-09-25 03:29:31 UTC
Permalink
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';
n***@sourcecomb.com
2017-10-04 22:50:47 UTC
Permalink
Post by n***@sourcecomb.com
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.
For anyone looking through this in the future: you need to use *virtual mailboxes* rather than *local recipients*. See http://www.postfix.org/VIRTUAL_README.html

// Nelson

Loading...