Looks like MySQL treats ssl as a reserved word. Use 'yes' as 'ssl'.
On Thu, 2010-04-29 at 14:51 -0400, Monika Janek wrote:
This was my sql query:
password_query = SELECT NULL AS password, host, destuser, 'yes' AS ssl,'Y' AS nopassword, 'Y' AS nologin, 'Y' AS nodelay, 'Y' AS proxy FROM proxy WHERE user = '%u'
It's obviously something I'm doing! But I'll try the ssl_ca_file route too.
Timo Sirainen wrote:
On Thu, 2010-04-29 at 14:43 -0400, Monika Janek wrote:
I tried the 'Y' as starttls and I receive this:
imap-login: proxy: Received invalid SSL certificate
And the authentication fails. Could it be because I've signed my own certs?
Yes. Either put the cert into ssl_ca_file or use 'any-cert' as ssl so it doesn't check it.
Whenever I try the 'yes' as ssl in the sql query, I get a syntax error message:
Password query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ssl,'Y' AS nopassword, 'Y' AS nologin, 'Y' AS nodelay, 'Y' AS proxy FROM proxy W' at line 1
Wonder what you tried there..