Here you go, first set are what I use in production with the
relay_domains method. I should note that I wrote my own
PlPgSQL function to check if a user is valid. I check the
users
table, then the alias table, plus I added a column that
lists a
user as "active" such that if they don't pay, they
can't get Email.
#
# postgresql config file for alias lookups on postfix
# comments are ok.
#
# the user name and password to log into the pgsql server
user = abc123
password = sshhhh
# the database name on the servers
dbname = dbmail
# the table name
table = dbmail_users
query = SELECT valid_email FROM valid_email('%s') WHERE
valid_email =
'OK'
# the hosts that postfix will try to connect to
# and query from (in the order listed)
hosts = host1
# end postgresql config file
Well it appears that I no longer have my old
virtual_mailboxes
setup at home. Basically I had two pgsql files, one that
simply
checked the domains (I got this info from my pdns server,
but
you could easily add a dbmail_domains table). The other
file
is simply the lookup for the user name in the dbmail_users
table.
Of course looking back on it, I probably wasn't checking the
aliases which was bad.
The only way I could figure to check the aliases AND the
users
was to do a function. I'm a big fan of those and why I use
postgres. We write functions to do pretty much everything,
imbed all the logic in the db we can, so we have maximum
flexibility with software. I'm sure someone will tell me a
better way now that I post this.
Actually I just had a really good idea that you might want
to
explore. If you use check_client_access function in your
smtpd_recipient_restrictions section, you could use a pgsql
lookup that returns OK or REJECT for a given username, or
domain.
I still think you should be able to use a pgsql file for
relay_domains.
You might want to check your version of postfix to see if a
newer
one supports that.
--
David A. Niblett | email: niblettda gru.net
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-----Original Message-----
From: dbmail-bouncesdbmail.org [mailto:dbmail-bouncesdbmail.org] On
Behalf Of andy
Sent: Thursday, January 12, 2006 12:59 AM
To: DBMail mailinglist
Subject: RE: [Dbmail] Postfix & DBMail (Plus Reject
messages)
Hello David
That has been very helpful thank you  .
Just for my own records, is there any chance you could copy
and paste
your pgsql files? (domains, users and virtual ones). It
would be very
useful just to check mine against yours since I'm using your
recommended
settings for the main.cf file.
Much appreciated your help so far.
Kind Regards,
Andy Savage
On Mon, 9 Jan 2006 15:42:40 -0500, "Niblett, David
A"
<NIBLETTDAgru.com> wrote:
> Sorry for that late reply, holiday madness around here.
>
> I had to go digging to find the setup I had with
Virtual Domains.
> This works too, I use it at home, it was my first
attempt at Postfix
> and DBMail. I have several domains:
>
> virtual_mailbox_base = /virtual/mail
> virtual_mailbox_domains =
pgsql:/etc/postfix/pgsql-domains.cf
> virtual_mailbox_maps =
pgsql:/etc/postfix/pgsql-users.cf virtual_maps
> = pgsql:/etc/postfix/pgsql-virtual.cf
> transport_maps = hash:/etc/postfix/transport
> transport_destination_recipient_limit = 1
>
> I believe you can make the transport maps as a pgsql
select to grab
> only the domain.name portion and hard code the
dbmail-lmtp transport
> part in the select.
>
> To be honest I don't really get the difference between
virtual_mailbox
> and relay_domains. I just recall reading somewhere
that relay_domains
> was prefered over virtual_mailbox. Regardless, you
should be able to
> provide a pgsql xxx
for the relay_domains option per:
> http://
www.postfix.org/uce.html#relay_domains
>
> The code to do virtual_mailbox_domains is practically
identical to
> relay_domains, so I'm not sure why it didn't work for
you. Just
> remember it has to return 2 columns, the first being
the domain and
> the second being "something". Postfix
doesn't care, but it has to get
> something there or else it's unhappy.
>
> Got any log output when you try this? Especially
useful is to use
> debug_peer = <IP> and set the debug level high.
Then you can connect
> from a specific IP (the one listed) and Postfix will
puke up TONS of
> logs about what exactly it's trying to do with the
delivery.
>
> --
> David A. Niblett | email: niblettdagru.net
> Network Administrator | Phone: (352) 334-3400
> Gainesville Regional Utilities | Web: http://www.gru.net/
>
>
>
> -----Original Message-----
> From: dbmail-bouncesdbmail.org
[mailto:dbmail-bouncesdbmail.org] On
> Behalf Of Andy Savage
> Sent: Thursday, December 29, 2005 6:12 PM
> To: DBMail mailinglist
> Subject: Re: [Dbmail] Postfix & DBMail (Plus Reject
messages)
>
>
> Thanks David, but one more thing I need to ask.
>
> I am interested in having everything stored in the
database, so I
> don't
> want to store relay_domains in the config file. What
would be the
> correct way to proxy that to mysql and what would my
query look like?
> Lets say I have a seperate table called
postfix_domains.
>
> You see I am accepting mail for many domains and it
makes it much
> easier
>
> having everything in the database.
>
> Also, can I ask, what is the difference between
relay_domains and
> virtual_domains?
>
> Kind Regards,
> Andy Savage
>
> Niblett, David A wrote:
>> Andy,
>>
>> I was on the same path as you. Since you are going
to use dbmail
>> lmtp for delivery I found you need to use
relay_domains.
>>
>> This is what I do:
>>
>> relay_domains = domain.com
>> relay_recipient_maps =
>> proxy:pgsql:/sql-configs/postfix-relay-pgsql.cf
>> relay_transport = dbmail-lmtp:[127.0.0.1]:24
>>
>>
>> That was all I needed to get everything to work and
reject messages.
>> I HIGHLY suggest you use a 550 to reject the Email.
By using a 450
you
>
>> are telling the other end that it's a soft error
and to try again
>> later. 550 tells the sender, it doesn't exist, and
to not try again.
>
>> By doing a 450, you will just clog up the sender
and they will just
>> eat more bandwidth and CPU hitting you again (most
likely every ~15m
>> for 5d).
>>
>> --
>> David A. Niblett | email:
niblettdagru.net
>> Network Administrator | Phone: (352)
334-3400
>> Gainesville Regional Utilities | Web: http://www.gru.net/
>>
>>
>>
>> -----Original Message-----
>> From: dbmail-bouncesdbmail.org
[mailto:dbmail-bouncesdbmail.org] On
>> Behalf Of Andy Savage
>> Sent: Thursday, December 29, 2005 7:01 AM
>> To: dbmaildbmail.org
>> Subject: [Dbmail] Postfix & DBMail (Plus Reject
messages)
>>
>>
>> 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_de
stination
>> 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
>> Dbmaildbmail.org htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>> _______________________________________________
>> Dbmail mailing list
>> Dbmaildbmail.org htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|