Displaying 2 results from an estimated 2 matches for "owns_domain".
Did you mean:
owndomain
2010 Aug 17
1
Master Login using MySQL problem - %{login_domain}
...y passdb looks like this:
passdb {
driver = sql
args = /etc/dovecot/dovecot-domain-owner-sql.conf
master = yes
pass = yes
}
dovecot-domain-owner-sql.conf contains:
user_query = SELECT user_name, domain_name FROM users WHERE user_name =
'%n' AND domain_name = '%d' AND owns_domain='1'
password_query = SELECT user_name, domain_name, password FROM users
WHERE user_name = '%n' AND domain_name = '%d' AND owns_domain='1' AND
'%d'='%{login_domain}'
In this example - bill at plf.net is an ordinary user. tom at plf.net is a
domain...
2010 Aug 17
0
Tricky Master User Query - need MySQL help
...servers multiple domains. I can set
a flag making someone a domain owner that allows that person to become
master of that domain. Here's the query for that.
password_query = SELECT user_name, domain_name, password FROM users
WHERE user_name = '%n' AND domain_name = '%d' AND owns_domain='1' AND
'%d'='%{login_domain}'
So - here's where we get tricky.
I have another table called "ownership" where I have 2 fields which is a
pairing of email addresses (login_id) and domains owned (owned_object).
Data might look like this:
joe at blow.com do...