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:xxxx 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: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] > Network Administrator | Phone: (352) 334-3400 > Gainesville Regional Utilities | Web: http://www.gru.net/ > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Andy Savage > Sent: Thursday, December 29, 2005 7:01 AM > To: dbmail@dbmail.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_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 > Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
