Genius! I did the 'any-cert' AS 'ssl' and put the '993' AS port and it worked. I'll do the ssl_ca_file as well. I thought that I had tried the 'yes' as 'ssl' but it works now. Thanks so much for your help Timo. I really appreciate it. :) I love dovecot!
Timo Sirainen wrote:
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..
-- Monika Janek Systems Administrator, Side Effects Software Toronto, Ontario Canada 416-504-9876 x207 www.sidefx.com