[Dovecot] Dovecot Proxy with MySQL auth

[Justin Krejci]

The proxy_maybe is working well for us with MySQL auth. We have a much more
complicated SQL query as we are doing a lot more but the example was able to
get us the correct Dovecot specific portion working.

Thanks for the info we are starting to migrate users over to Dovecot now
that we put these proxy_maybe servers in front of our legacy pop/imap
server.

-----Original Message-----
From: dovecot-bounces+jkrejci=usinternet.com at dovecot.org
[mailto:dovecot-bounces+jkrejci=usinternet.com at dovecot.org] On Behalf Of
Justin Krejci
Sent: Sunday, November 30, 2008 1:50 AM
To: 'Timo Sirainen'
Cc: 'Dovecot Mailing List'
Subject: Re: [Dovecot] Dovecot Proxy with MySQL auth

The info is appreciated, thanks for the update!
We will try it out and respond with feedback.

-----Original Message-----
From: Timo Sirainen [mailto:tss at iki.fi] 
Sent: Saturday, November 29, 2008 7:49 PM
To: Justin Krejci
Cc: 'Dovecot Mailing List'
Subject: Re: [Dovecot] Dovecot Proxy with MySQL auth

On Wed, 2008-11-26 at 11:56 -0600, Justin Krejci wrote:
> http://wiki.dovecot.org/PasswordDatabase/ExtraFields/Proxy
> 
> At the bottom of this page it gives a query example of "SELECT NULL AS
> password, ." but that does not seem to allow for us to use the proxy_maybe

Right. The example is for a proxy-only server that doesn't know the
users' passwords. I added just now another example there that shows how
to use proxy_maybe. It's untested though, so please let me know if it
doesn't work.