[Dovecot] IMAP proxy configuration

[Leonardo Rodrigues]

Em 13/03/2010 21:23, Timo Sirainen escreveu:
> So are you saying that the users table contains only local users, while
> some domain table contains all domains and their destination servers?
> Then you'll just need to do outer join. Something like:
>
> .., domains.host as host, 'Y' as proxy_maybe, ..
> from domains
> outer join emails on (username = '%u')
> where domain.domain = '%d'
>    

     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.

     Please check resultsets when querying a LOCAL user and when 
querying with a NON-local (to be proxied) user. Do you think this query 
will make things work as i need ?


     querying a LOCAL user:
http://pastebin.com/L3q6HGrA

     querying a NON-local (to be proxied) user:
http://pastebin.com/fV91LB0x

     querying a NON-local and NOT-to be proxied user (correctly returns 
an empty resultset)
http://pastebin.com/SBwCEVEm


-- 


	Atenciosamente / Sincerily,
	Leonardo Rodrigues
	Solutti Tecnologia
	http://www.solutti.com.br

	Minha armadilha de SPAM, NÃO mandem email
	gertrudes at solutti.com.br
	My SPAMTRAP, do not email it