Am 06.07.2008 um 23:30 schrieb Andy Shellam:
I'm not 100% certain if this will work, but try changing your % in
your SQL query to %% (i.e. make them double %'s instead of single.)
Cool - Thats it !
Hi Nicola,
I'm guessing Dovecot is failing at your % character in "like
'var/pop3/%' THEN." - notice in the log, it's missing the final
apostrophe from that string ("like '/var/pop3/ THEN.".)
Dovecot is trying to take %' as a substitution character (like %u) and
converting it
Dovecot (1.1.1) criticises a sql user_query that's working on the sql
console and thats correct.
DOVECOT-LOG:
"dovecot: Jul 06 22:58:29 Error: auth(default): sql(nti): User query
failed: ERROR: syntax error at or near "mbox"
dovecot: Jul 06 22:58:29 Error: auth(default): LINE 1: ...gid, ho
