Hello,
i set up a transport map with mysql backend but when i try use the SQL
like command in the WHERE clause i've got an db_common_parse error :
postmap -q '[EMAIL PROTECTED]' mysql:/etc/postfix/mysql_transport.cf
postmap: fatal: db_common_parse: /etc/postfix/mysql_transpor.cf: Invalid
query template: SELECT transport FROM users WHERE mail='%s' AND l3id
like 'P\%'
the query used in mysql_transport.cf :
query = SELECT transport FROM users WHERE mail='%s' AND l3id like 'P%'
Does postfix confuse the % character of the like command with the % for
a variable subsitution (%s) so like command can't be used in the SQL
query or is there a tip to avoid this ?
thank you
