[Dovecot] Question about dovecot imap proxy

[Monika Janek]

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