hello!
Is "doveadm director map" command suppose to work when I store
"host" value in mysql table?
It gives me nothing in output with no errors in log.
I've successfully setup directors with static passdb, and decided to give a
try setup with storing host value in mysql table.
The proxying is actually working, I'm just unhappy with no output from
"doveadm director map".
on the other hand output from "doveadm director map" is not empty,
when I configure my password_query not to return host from table.
director's settings in dovecot.sql is:
passdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf
}
userdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf
}
director_servers = 192.168.5.125
director_mail_servers = 192.168.5.110 192.168.5.111
service doveadm {
inet_listener {
port = 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
}
}