Hi, I'm going to be migrating users onto new back end servers and so need to enable per user transports.
I know I need to change my mysql_transport_maps.cf query from this: query = SELECT transport FROM domains WHERE DomainName='%s' to something like: query = SELECT transport FROM members WHERE Username='%u' AND Domain='%d' Is there anything else I should need to change on the gateway to enable per user transport to the back end servers or is that it? Thanks Guy #postconf -n 2bounce_notice_recipient = postmas...@domain.net alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases anvil_rate_time_unit = 60s biff = no bounce_notice_recipient = postmas...@domain.net bounce_template_file = /etc/postfix/bounce.cf broken_sasl_auth_clients = yes command_directory = /usr/sbin config_directory = /etc/postfix content_filter = smtp-amavis:[127.0.0.1]:10024 daemon_directory = /usr/lib/postfix data_directory = /var/lib/postfix delay_warning_time = 4h error_notice_recipient = postmas...@domain.net inet_interfaces = all local_recipient_maps = local_transport = error:local mail delivery is disabled mail_owner = postfix mailq_path = /usr/bin/mailq maximal_queue_lifetime = 2d message_size_limit = 31240000 mydestination = myhostname = server.domain.net mynetworks = 127.0.0.0/8 myorigin = $mydomain newaliases_path = /usr/bin/newaliases proxy_read_maps = $relay_domains $relay_recipient_maps $virtual_alias_maps $transport_maps queue_directory = /var/spool/postfix relay_domains = proxy:mysql:/etc/postfix/mysql_relay_domains.cf relay_recipient_maps = proxy:mysql:/etc/postfix/ mysql_relay_recipient_maps.cf proxy:mysql:/etc/postfix/ mysql_relay_recipient_alias_maps.cf remote_header_rewrite_domain = domain.unspecified sendmail_path = /usr/sbin/sendmail setgid_group = postdrop smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu) smtpd_client_connection_count_limit = 50 smtpd_client_connection_rate_limit = 100 smtpd_client_message_rate_limit = 500 smtpd_client_recipient_rate_limit = 100 smtpd_end_of_data_restrictions = check_policy_service inet:127.0.0.1:10031, smtpd_error_sleep_time = 1s smtpd_hard_error_limit = 20 smtpd_recipient_restrictions = reject_non_fqdn_sender, reject_unknown_sender_domain, reject_unknown_recipient_domain, permit_mynetworks, reject_unauth_destination, check_client_access cidr:/etc/postfix/postfix-dnswl-permit, check_client_access cidr:/etc/postfix/postfix-dnswl-custom, reject_invalid_hostname, check_recipient_access mysql:/etc/postfix/mysql_spamcheck_alias_bypass.cfmysql:/etc/postfix/ mysql_spamcheck_bypass.cf, reject_rbl_client zen.spamhaus.org, reject_rbl_client bl.spamcop.net, reject_rbl_client b.barracudacentral.org, reject_rbl_client dnsbl.aluminati.org, check_policy_service inet:127.0.0.1:10031, permit smtpd_sasl_auth_enable = yes smtpd_sasl_authenticated_header = yes smtpd_sasl_path = private/auth-client smtpd_sasl_type = dovecot smtpd_soft_error_limit = 10 smtpd_tls_CAfile = /etc/ssl/certs/ca-certificates.crt smtpd_tls_cert_file = /etc/ssl/certs/imapd.pem smtpd_tls_key_file = /etc/ssl/private/imapd.key smtpd_tls_received_header = yes smtpd_tls_session_cache_timeout = 3600s smtpd_use_tls = yes tls_random_source = dev:/dev/urandom transport_maps = hash:/etc/postfix/virtual_exception_transport_maps proxy:mysql:/etc/postfix/mysql_transport_maps.cf unknown_local_recipient_reject_code = 550 virtual_alias_maps = proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cfproxy:mysql:/etc/postfix/ mysql_virtual_catchall_maps.cf -- Don't just do something...sit there!
