[Dovecot] Master Login using MySQL problem - %{login_domain}

[Marc Perkel]

On 8/17/2010 11:16 AM, Timo Sirainen wrote:
> On Tue, 2010-08-17 at 10:45 -0700, Marc Perkel wrote:
>
>> Aug 17 10:42:04 auth: Debug: auth(tom at plf.net,127.0.0.1,master): Master
>> user lookup for login: bill at plf.net
>> Aug 17 10:42:04 auth: Debug: sql(tom at plf.net,127.0.0.1): query: SELECT
>> user_name, domain_name, password FROM users WHERE user_name = 'tom' AND
>> domain_name = 'plf.net' AND owns_domain='1' AND 'plf.net'=''
> Oh, right, MySQL. I was only testing it with PostgreSQL. This'll fix it:
> http://hg.dovecot.org/dovecot-2.0/rev/3ba227176cde
>
>

WORKS!!!


Aug 17 11:29:37 auth: Debug: auth(tom at plf.net,127.0.0.1,master): Master 
user lookup for login: bill at plf.net
Aug 17 11:29:37 auth: Debug: sql(tom at plf.net,127.0.0.1,master): query: 
SELECT user_name, domain_name, password FROM users WHERE user_name = 
'tom' AND domain_name = 'plf.net' AND owns_domain='1' AND 
'plf.net'='plf.net'
Aug 17 11:29:37 auth: Info: passdb(tom at plf.net,127.0.0.1,master): Master 
user logging in as bill at plf.net
Aug 17 11:29:37 auth: Debug: sql(bill at plf.net,127.0.0.1): query: SELECT 
user_name, domain_name, password FROM users WHERE user_name = 'bill' AND 
domain_name = 'plf.net'
Aug 17 11:29:37 auth: Debug: client out: OK     25      
user=bill at plf.net       user_name=tom   domain_name=plf.net     
user_name=bill  domain_name=plf.net
Aug 17 11:29:37 auth: Debug: master out: USER   1       bill at plf.net    
master_user=tom at plf.net
Aug 17 11:29:37 imap-login: Info: Login: user=<bill at plf.net>, 
method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=32204, secured
Aug 17 11:29:37 imap(bill at plf.net): Info: Disconnected: Logged out 
bytes=28/635
Aug 17 11:29:38 auth: Debug: auth(tom at plf.net,127.0.0.1,master): Master 
user lookup for login: bill at plf.net
Aug 17 11:29:38 auth: Debug: sql(tom at plf.net,127.0.0.1,master): query: 
SELECT user_name, domain_name, password FROM users WHERE user_name = 
'tom' AND domain_name = 'plf.net' AND owns_domain='1' AND 
'plf.net'='plf.net'
Aug 17 11:29:38 auth: Info: passdb(tom at plf.net,127.0.0.1,master): Master 
user logging in as bill at plf.net
Aug 17 11:29:38 auth: Debug: sql(bill at plf.net,127.0.0.1): query: SELECT 
user_name, domain_name, password FROM users WHERE user_name = 'bill' AND 
domain_name = 'plf.net'
Aug 17 11:29:38 auth: Debug: client out: OK     27      
user=bill at plf.net       user_name=tom   domain_name=plf.net     
user_name=bill  domain_name=plf.net
Aug 17 11:29:38 auth: Debug: master out: USER   1       bill at plf.net    
master_user=tom at plf.net
Aug 17 11:29:38 imap-login: Info: Login: user=<bill at plf.net>, 
method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=32216, secured
Aug 17 11:29:38 imap(bill at plf.net): Info: Disconnected: Logged out 
bytes=97/497


Now - on to the really tricky stuff.