Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Having difficulty getting Postfix to know about users defined in SQLite database

20 views
Skip to first unread message

n...@sourcecomb.com

unread,
Sep 24, 2017, 11:29:32 PM9/24/17
to
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 tes...@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 ncr...@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

unread,
Oct 4, 2017, 6:50:49 PM10/4/17
to
On Monday, 25 September 2017 16:29:32 UTC+13, n...@sourcecomb.com wrote:
> 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
0 new messages