Re: [Dovecot] director: non standart ports at backends

[Костырев Александр Алексеевич]

Thanks, that worked!

I ended up with:
password_query = select 'y' as proxy, \
NULL AS password, \
'y' as nopassword, \
case '%a' \
when 110  then 2110  \
when 995  then 2995  \
when 143  then 2143  \
when 993  then 2993  \
when 24   then 224   \
when 4190 then 24190 end \
as port, \
case '%a' \
when 995 then 'any-cert' \
when 993 then 'any-cert' end \
as `ssl`;




-----Original Message-----
From: Timo Sirainen [mailto:t...@iki.fi] 
Sent: Monday, June 11, 2012 11:48 PM
To: Костырев Александр Алексеевич
Cc: dovecot@dovecot.org
Subject: Re: [Dovecot] director: non standart ports at backends

Looking at your old mails, you seem to be using passdb static for director, but 
userdb sql? So you could switch to:

passdb {
 driver = sql
 args = /etc/dovecot/dovecot-sql.conf
}

password_query = select 'y' as proxy, 'y' as nopassword, if('%a'=143, 1430, 
9930) as port

where you'd change the if() to something that handles %s=imap vs %s=pop3 vs 
%s=lmtp and %a=143 vs %a=993 vs %a=110 vs %a=995. Maybe a "case" statement 
would be less ugly. Or simply make it a real table in sql. Anyway, that's the 
basic idea.

On 11.6.2012, at 15.39, Костырев Александр Алексеевич wrote:

> thanks Timo, for you time
> but I still don't get it)
> should I return "port" with just "port_num1,port_num2" value or how?
> I've tried to google an example but with no success.
> 
> -----Original Message-----
> From: Timo Sirainen [mailto:t...@iki.fi] 
> Sent: Monday, June 11, 2012 11:01 PM
> To: Костырев Александр Алексеевич
> Cc: dovecot@dovecot.org
> Subject: Re: [Dovecot] director: non standart ports at backends
> 
> On 11.6.2012, at 12.27, Костырев Александр Алексеевич wrote:
> 
>> hello,
>> I'm trying to figure out how to proxy pop3 and pop3s that listens on 
>> non-standart ports at backends.
>> For example, pop3 is at 1110 and pop3s at 1995 (on backend side).
>> is it possible? 
>> how should I separate this ports in director's config?
>> it's easy for one port:
>> for example lmtp - you just use passdb in protocol lmtp {}
> 
> The passdb needs to return the "port" field. You can't use static passdb for 
> this, since it has no conditionals and you can't do per-port configuration. 
> Maybe use sqlite (simply to use it as a scripting engine - empty database) or 
> checkpassword as your passdb.
>