dovecot - May 2013 - problem with proxy setup

Hi all,

i have some troubles in the implementation of my proxyconfiguration.
i have two kind of users, the first will be proxied to a dovecot backend 
with masteruser-login, the other one will be proxied to another 
non-dovecot imapserver with nopassword.
Everything looks to work if i use  passwd-file like this:

user1:{PLAIN}pass1:::::::proxy=y host=192.168.1.1 
destuser=user1*masteruser pass=masterpass
user2::::::::nopassword proxy=y host=192.168.2.2

In an second step i try the same behavior with sql (postgresql), but 
there are my problems.
In my thinking, the sql query should return the right fields (in 
passwd-file) like proxy, host, ..
but whats the trick, to get only the  correct fields i need for the 
different funktions?
first proxy, host, destuser, pass and on the other side nopassword, 
proxy and host.

Maybe i have mistakes in reasoning, but in sql i get in one query always 
the same fields.

I hope someone can give me some hints an tricks.

thanks, Claus

Hi all,

i could solve my problem.

the solution is to set the unneeded fields to "NULL" - it's
described in
WIKI, but i overlooked this important statement.

Sorry for my blindness

On 22.05.2013 18:37, Claus wrote:
> Hi all,
>
> i have some troubles in the implementation of my proxyconfiguration.
> i have two kind of users, the first will be proxied to a dovecot 
> backend with masteruser-login, the other one will be proxied to 
> another non-dovecot imapserver with nopassword.
> Everything looks to work if i use  passwd-file like this:
>
> user1:{PLAIN}pass1:::::::proxy=y host=192.168.1.1 
> destuser=user1*masteruser pass=masterpass
> user2::::::::nopassword proxy=y host=192.168.2.2
>
> In an second step i try the same behavior with sql (postgresql), but 
> there are my problems.
> In my thinking, the sql query should return the right fields (in 
> passwd-file) like proxy, host, ..
> but whats the trick, to get only the  correct fields i need for the 
> different funktions?
> first proxy, host, destuser, pass and on the other side nopassword, 
> proxy and host.
>
> Maybe i have mistakes in reasoning, but in sql i get in one query 
> always the same fields.
>
> I hope someone can give me some hints an tricks.
>
> thanks, Claus
>