> On 19/05/2022 00:45 cesco <[email protected]> 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
