Displaying 2 results from an estimated 2 matches for "m_mailbox".
Did you mean:
_mailbox
2012 Jun 10
1
director userdb problem
...uilt-in default iterate_query: SELECT username, domain FROM users)
in my dovecot.conf I have:
userdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf
}
passdb {
driver = static
args = proxy=y nopassword=y
}
and in /etc/dovecot/dovecot-sql.conf:
user_query = select MBOX_NAME AS user from M_MAILBOX WHERE (MBOX_NAME = '%u');
Do I have to use special table named users ? is it hard-coded?
2012 Jun 20
1
director map and mysql
...t = 24245
}
}
protocol doveadm {
auth_socket_path = director-userdb
}
doveadm_proxy_port = 24245
in /etc/dovecot/dovecot-sql.conf at director there's
password_query = SELECT \
NULL AS password,\
'Y' as nopassword, \
'Y' AS proxy, \
MBOX_NAME as user, \
host2 as host \
from M_MAILBOX \
where MBOX_NAME = '%u'
user_query = SELECT \
MBOX_NAME AS username, \
MAIL_DIRECTORY as home \
from M_MAILBOX \
where MBOX_NAME = '%u';
iterate_query = select MBOX_NAME AS username from M_MAILBOX;
backend's conf:
service doveadm {
inet_listener {
port = 24245
}
}