Am 23.02.2011 17:47, schrieb Victor Duchovni: > On Wed, Feb 23, 2011 at 05:32:16PM +0100, Reindl Harald wrote: > >> "de.bp.com" does not exist anywhere and so why the sceond log entry? > > Subdomains of domains in mydestination are by default relay domains. > Set "relay_domains = " (empty) if you have no relay domains. For > relay_domains, Postfix uses "relay_transport".
Thank you for the information Can anybody explain why this default exists because it is not very clear for me and maybe others >> mysql-transport.cf: >> select transport from >> dbma_transports where mydestination like '%s' >> or mydestination like '%d' >> order by transport desc limit 1; > > This type of fuzzy "like" query is highly questionable in this context. > What's wrong with "="? Why match both "%s" and "%d"? I think you're > somewhat confused here, even if it does mostly work. this is because "dbma_transports" is a view and "dbma_recipient_relay" is for sender dependent relay hosts [root@nb-rhsoft:/etc/postfix]$ cat mysql-sender_relay_hosts.cf user = dbmail password = **** dbname = dbmail hosts = unix:/var/lib/mysql/mysql.sock inet:127.0.0.1:3307 query = select transport from dbma_sender_relay where email like '%s' [root@nb-rhsoft:/etc/postfix]$ cat mysql-sender_relay_hosts_auth.cf user = dbmail password = **** dbname = dbmail hosts = unix:/var/lib/mysql/mysql.sock inet:127.0.0.1:3307 query = select concat(username, ':', password) from dbma_sender_relay where email like '%s' CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `dbma_transports` AS select `dbma_mta`.`mydestination` AS `mydestination`,`dbma_mta`.`transport` AS `transport` from `dbma_mta` union (select `dbma_recipient_relay`.`mydestination` AS `mydestination`,`dbma_recipient_relay`.`transport` AS `transport` from `dbma_recipient_relay`)
signature.asc
Description: OpenPGP digital signature
