[Dovecot] Question about dovecot imap proxy

[Timo Sirainen]

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..
> >
> >   
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20100429/ee0c5fc1/attachment.bin