Hi Timo!
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?
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
Thanks for all your help Timo. I'm so close! I've also compiled version 2.0 but I haven't used it yet. I have 1.2.11 installed from the Debian packages.
Timo Sirainen wrote:
On Thu, 2010-04-29 at 13:44 -0400, Monika Janek wrote:
password_query = SELECT NULL AS password, host, destuser, 'Y' AS nopassword, 'Y' AS nologin, 'Y' AS nodelay, 'Y' AS proxy FROM proxy WHERE user = '%u'
I take this as to just check the SQL for the existence of the username then pass the authentication onto the internal server. I tried putting in 'starttls' into the query string but it didn't work.
Looks like the current code is being kind of stupid here. It requires that you do:
'yes' as ssl, 'Y' as starttls
ssl's values can be either "yes" or "any-cert", anything else gets ignored. I changed v2.0 now so that it makes more sense and you could simply do 'y' as starttls.
-- Monika Janek Systems Administrator, Side Effects Software Toronto, Ontario Canada 416-504-9876 x207 www.sidefx.com