[Dovecot] Question about dovecot imap proxy

[Monika Janek]

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