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" <[EMAIL PROTECTED]> 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: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: [email protected] >> 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 >> [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail >> _______________________________________________ >> Dbmail mailing list >> [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail > _______________________________________________ > Dbmail mailing list > [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
