Hello Just one more question here. Are you referring to From email or To email in your mysql query ?
Sincerely On 04/22/11 16:48, Reindl Harald wrote: > Am 22.04.2011 16:33, schrieb Dragan Zubac: > >> 2. Once this kind of email arrives,Postfix should route this email via >> remote relay host using SMTP AUTH with credentials from message body of >> email it received,like >> >> SMTP:remote.host.com (AUTH: customer_username,customer_password) > no problem, see below > for details look at the postfix-documentation of my params > yes this can be also a hash-file, but mysql-config si from a working system > >> and remove everything from email body above line >> '----------------------------' from the message body. > no way, postfix is a MTA and has nothing to do with the mailbody > > sender_dependent_relayhost_maps = > mysql:/etc/postfix/mysql-sender_relay_hosts.cf > smtp_sasl_password_maps = > mysql:/etc/postfix/mysql-sender_relay_hosts_auth.cf > smtp_sasl_auth_enable = yes > smtp_sender_dependent_authentication = yes > smtp_sasl_security_options = noanonymous > > cat /etc/postfix/mysql-sender_relay_hosts.cf > user = relayhost > password = ******************* > dbname = dbmail > hosts = unix:/var/lib/mysql/mysql.sock > query = select transport from dbma_sender_relay where email='%s'; > > cat /etc/postfix/mysql-sender_relay_hosts_auth.cf > user = relayhost > password = ******************* > dbname = dbmail > hosts = unix:/var/lib/mysql/mysql.sock > query = select concat(username, ':', password) from dbma_sender_relay > where email='%s'; >
