Hello list,

Still need your help configuring proxy infrastructure.

Today, I really struggle configuring master passwords forwarding.

What I want:

master user can connect to any other account, on proxy.

Could please somebody help me, I read both articles about this on wiki, but still can't connect :(

What I did:

on proxy:

auth_master_user_separator=*

passdb sql { args = /usr/local/dovecot/etc/dovecot-master.conf master = yes pass = yes }

--

dovecot-master.conf: (...)

default_pass_scheme = CRYPT

password_query = SELECT password FROM master_users WHERE username= '%u' AND status = 'ok'

on destination server:

auth_master_user_separator=*

passdb sql { args = /usr/local/etc/dovecot-master.conf master = yes pass = yes }

default_pass_scheme = CRYPT

password_query = SELECT password FROM master_users WHERE username= '%u' AND status = 'ok'

I also tried on proxy:

password_query = SELECT NULL AS password, host, 'Y' AS nologin, 'Y' AS nodelay, 'Y' AS nopassword, 'Y' AS proxy,'%u' as user ,'%u*pierre' as destuser, '123' as pass FROM proxy WHERE domain = '%d'

instead of

password_query = SELECT NULL AS password, host, 'Y' AS nologin, 'Y' AS nodelay, 'Y' AS nopassword, 'Y' AS proxy,'%u' as user FROM proxy WHERE domain = '%d'

it did not work :(

LOGS:

on destination server:

[ID 583609 mail.info] auth(default): cache(pierre,127.0.0.1,master): expired [ID 583609 mail.info] auth-worker(default): sql(pierre,127.0.0.1): query: SELECT password FROM master_users WHERE username= 'pierre' AND status = 'ok' [ID 583609 mail.info] auth(default): passdb(pierre,127.0.0.1,master): Master user logging in as account@test.fr*pierre [ID 583609 mail.info] auth(default): cache(account@test.fr*pierre,127.0.0.1): miss [ID 583609 mail.info] auth-worker(default): sql(account@test.fr*pierre,127.0.0.1): query: SELECT CONCAT(pw_name, '@', pw_domain) AS user, pw_passwd AS password FROM vpopmail WHERE pw_name = 'julien' AND pw_domain = 'demarey.fr*pierre' [ID 583609 mail.info] auth-worker(default): sql(account@test.fr*pierre,127.0.0.1): unknown user [ID 583609 mail.info] auth(default): new auth connection: pid=8162 [ID 583609 mail.info] auth(default): client out: FAIL 1 user=account@test.fr*pierre authz

on proxy:

auth(default): client in: AUTH 2 PLAIN service=imap secured lip=127.0.0.1 rip=127.0.0.1 lport=143 rport=39978 resp= auth(default): cache(pierre,127.0.0.1,master): hit: user=pierre auth(default): passdb(pierre,127.0.0.1,master): Master user logging in as account@test.fr

auth(default): cache(account@test.fr,127.0.0.1): miss

auth-worker(default): sql(account@test.fr,127.0.0.1): query: SELECT NULL AS password, host, 'Y' AS nologin, 'Y' AS nodelay, 'Y' AS nopassword, 'Y' AS proxy,'account@test.fr' as user ,'account@test.fr*pierre' as destuser, '123' as pass FROM proxy WHERE domain = 'demarey.fr' auth(default): client out: OK 2 user=account@test.fr host=10.0.44.20 nologin proxy destuser=account@test.fr*pierre pass= master=pierre imap-login: proxy(account@test.fr): Login failed to 10.0.44.20:143/account@test.fr*pierre (master pierre): [AUTHORIZATIONFAILED] Authorization failed [ID 583609 mail.info] imap-login: Disconnected (auth failed, 1 attempts): user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured

both use dovecot version 1.2.9