[Dovecot] Question about dovecot imap proxy

[Monika Janek]

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