Em 13/03/2010 23:12, Leonardo Rodrigues escreveu:
Timo i've tried JOINs, but i've never really understood those
crazy things (i'm really very far from being a SQL expert).
but seems i got the expected results using UNION and adjusting
queries to have the same number of columns. First i tried union with
normal queries but couldnt get it because queries must have the same
number of rows. Then i adjusted it ... and seems its OK.
got it working with few tweaks .... i had to return '127.0.0.1' as
host for local users ... without that, login process was segfaulting.
And had to return %w as password for the proxied-domains query.
query is: (with linebreaks for easy understanding)
password_query =
select
endereco as user,
password,
'/var/spool/mail/%u' as userdb_home,
'maildir:/var/spool/mail/%u' as userdb_mail,
8 as userdb_uid,
12 as userdb_gid,
concat('*:storage=', quota) as userdb_quota_rule,
'Trash:storage=100M' as userdb_quota_rule2,
'Y' as proxy_maybe,
'127.0.0.1' as host
from emails
where
endereco = '%u' and ativa = '1'
union
select
NULL as user,
'%w' as password,
NULL as userdb_home,
NULL as userdb_mail,
NULL as userdb_uid,
NULL as userdb_gid,
NULL as userdb_quota_rule,
NULL as userdb_quota_rule2,
'Y' as proxy_maybe,
imapproxy.host as host
from imapproxy
where
imapproxy.dominio = '%d'
that worked flawlessly :) And i didnt had to use JOINs hehehehe
log from the main server, for a proxied user:
Mar 13 23:48:48 correio dovecot: imap-login:
proxy(s...@proxieddomain.com.br): started proxying to 10.252.25.2:143:
user=<s...@proxieddomain.com.br>, method=PLAIN, rip=127.0.0.1,
lip=127.0.0.1, secured
log from the 10.252.25.2 server:
Mar 13 23:48:31 correio dovecot: imap-login: Login:
user=<s...@proxieddomain.com.br>, method=PLAIN, rip=192.168.1.2,
lip=10.252.25.2
the only minor problem is that when local users get logged in on
the main server, logs shows that they were proxied to 127.0.0.1 ....
Mar 13 23:33:52 correio dovecot: pop3-login: Login:
user=<localu...@localdomain.com.br>, method=PLAIN, rip=127.0.0.1,
lip=127.0.0.1, secured
Mar 13 23:33:52 correio dovecot: pop3-login:
proxy(localu...@localdomain.com.br): started proxying to 127.0.0.1:110:
user=<localu...@localdomain.com.br>, method=PLAIN, rip=10.255.176.67,
lip=192.168.1.2
i can easily live with that .... but i would like to see local
users logged as local connections not proxied to 127.0.0.1.
--
Atenciosamente / Sincerily,
Leonardo Rodrigues
Solutti Tecnologia
http://www.solutti.com.br
Minha armadilha de SPAM, NÃO mandem email
gertru...@solutti.com.br
My SPAMTRAP, do not email it
