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