%{listener} not working

[Aki Tuomi]

> On 19/05/2022 00:45 cesco <cesco at 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