Hi There, We have postfix storing its transport and alias data in mysql, but we are getting this error (which has just appeared out of knowwhere - yes well, OK, not knowwhere, but we dont know where!)
# cat /etc/postfix/mysql-transport.cf user = mail-in1 password = ****** dbname = postfix table = transport hosts = 210.48.XX.XXX select_field = transport where_field = domain Here is the error: Jun 8 07:15:19 mail-in1 postfix/trivial-rewrite[23183]: warning: mysql query failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Jun 8 07:15:19 mail-in1 postfix/trivial-rewrite[23183]: fatal: mysql:/etc/postfix/mysql-transport.cf(0,lock|fold_fix): table lookup problem I have googled and have not really found a solution to this issue... can anyone assist please? THanks SImon
