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 } }