On 19/05/2022 00:45 cesco cesco@esiliati.org wrote:
Hi
I'm trying to use the variable %{listener} in the following password mysql query:
password_query = SELECT accounts.mcf AS password FROM accounts, domains WHERE user = '%n' AND accounts.domain = '%d' AND accounts.domain = domains.domain AND domains.host = '%{hostname}' AND accounts.service IN ('master', '%{listener}')
but it doesn't expand, giving:
Failed to expand password_query=SELECT accounts.mcf AS password FROM accounts, domains WHERE user = '%n' AND accounts.domain = '%d' AND accounts.domain = domains.domain AND domains.host = '%{hostname}' AND accounts.service IN ('master', '%{listener} ') : Unknown variable '%listener'
%{hostname} works correctly, as well as other variables I tried.
many thanks Franz
below my doveconf -n:
Hi!
%{listener} is not available in authentication process, only in login process for logging purposes, as stated in documentation.
You can use %{service} instead?
Aki