Hello David,

D> Hi, someone mentioned using the transport map for
D> mydestination field.  What is postfix expecting as the
D> return and what should the transport table look like? 
D> i.e. fields.

When querying the table for mydestination, postfix ONLY needs to have
a valid row returned. When querying for transport, it wants the
routing returned.

Excerpt from main.cf:
---
mydestination = mysql:/etc/postfix/my_trans.cf
transport_maps =  mysql:/etc/postfix/my_trans.cf
---

Partial contents of forwarder.mytransport table:
---
id      domain                  transport       comment
1       csrye.org               dbmail:         First Test      
2       espi.com                dbmail:         Second test victim
3       cruftware.com           dbmail:         
4       dididahdahdidit.com     dbmail:         
---

my_trans.cf contents:
---
user = postfix
password = [password]
dbname = forwarder
table = mytransport
hosts = 192.168.2.142
select_field = transport
where_field = domain
---

The same configuration file works for both, because Postfix doesn't
care what is returned the first time, just that a row was found.

-- 
Jeff Brenton
President,
Engineered Software Products, Inc
http://espi.com
Questionable web page: http://dididahdahdidit.com

Liberalism grants you the freedom to advocate any idea*.
 * Please see http://www.dididahdahdidit.com/except.php for a
   current list of exceptions

Reply via email to