Sorry for jumping in so late...

Looks like your main.cf already has that:

local_recipient_maps = mysql:/etc/postfix/mysql-localusers.cf


Just have mysql-localusers.cf point to your dbmail database and look in the aliases table like:

user = myuser
password = mypass
hosts = 127.0.0.1
dbname = dbmail
query = SELECT alias FROM dbmail_aliases WHERE alias='%s'



Andy Savage wrote:

Hey guys

I'm trying to combine DBMail with Postfix and basically I need your help!

I'm after 3 things as I'm having a few troubles currently and was wondering if some kind soul on the list could help me out.

I need the main.cf configuration for postfix to allow postfix to check whether a valid recipient exists in the dbmail database and if it doens't send a 450 reject message back to the user. I don't want to even accept mail for unknown users, it just burdens my mailserver.

Currently I have:
------------------main.cf----------------
myhostname = server.domain.tld
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = $myhostname, localhost, localhost.localdomain
relayhost =
mynetworks = 127.0.0.0/8
mailbox_command =
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all

mydestination = mysql:/etc/postfix/mysql-transport.cf
local_recipient_maps = mysql:/etc/postfix/mysql-localusers.cf
transport_maps = mysql:/etc/postfix/mysql-transport.cf

local_transport = dbmail-lmtp:

smtpd_recipient_restrictions = permit_mynetworks,permit_sasl_authenticated,reject_unauth_destination
smtpd_use_tls = yes
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
unknown_local_recipient_reject_code = 450
-----------------------------------------

Kind Regards,
Andy Savage
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail


--
Software Developer
The Selling Source, Inc.
Technology Driven Marketing Solutions
http://www.SellingSource.com
[EMAIL PROTECTED]
P: 800-397-7706 ext. 2129
F: 800-391-1178
Direct P: 702-407-0707 ext. 2129
Direct F: 702-407-0711

Reply via email to