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 [email protected]*pierre
[ID 583609 mail.info] auth(default):
cache([email protected]*pierre,127.0.0.1): miss
[ID 583609 mail.info]
auth-worker(default): sql([email protected]*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([email protected]*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 [email protected]*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 [email protected]
auth(default): cache([email protected],127.0.0.1): miss
auth-worker(default): sql([email protected],127.0.0.1): query: SELECT NULL
AS password, host, 'Y' AS nologin, 'Y' AS nodelay, 'Y' AS nopassword, 'Y'
AS proxy,'[email protected]' as user ,'[email protected]*pierre' as destuser,
'123' as pass FROM proxy WHERE domain = 'demarey.fr'
auth(default): client
out: OK 2 [email protected] host=10.0.44.20 nologin proxy
[email protected]*pierre pass= master=pierre
imap-login:
proxy([email protected]): Login failed to
10.0.44.20:143/[email protected]*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
