I received the following logged errors
postfix/smtpd[126515]: connect from mx1.testo.tel[52.39.45.118]
postfix/proxymap[126516]: warning:
mysql:/etc/postfix/mysql_email_aliases: query failed: Illegal mix of
collations (latin1_swedish_ci,IMPLICIT) and
(utf8mb4_general_ci,COERCIBLE) for operation '='
postfix/trivial-rewrite[126523]: warning: virtual_alias_domains:
proxy:mysql:/etc/postfix/mysql_email_aliases: table lookup problem
postfix/trivial-rewrite[126523]: warning: virtual_alias_domains
lookup failure
postfix/smtpd[126515]: disconnect from mx1.testo.tel[52.39.45.118]
ehlo=1 mail=1 quit=1 commands=3
query = SELECT email FROM aliases WHERE alias = '%s' AND acceptMail
LIMIT 1
Can i trust postfix protects against SQL injections? I can't see what
the query ended up looking like but the query error makes me concerned.
I assumed if they can't escape the string quotes there shouldn't be a
query error. Or is this error harmless to security and nothing more than
just a failed lookup?