dovecot - May 2022 - %{listener} not working

> 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

> 
> 
> 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
Hi
sorry, for whatever reason I was thinking the query is executed in
'login' context, but clearly is in auth. my mistake.

Unfortunately, %{service} has not enough granularity for my case. I'm trying
to discriminate logins based on various listeners I created on different ports.
I can use ports (that seems to work), but %listener was better as I can assign
to them arbitrary names to match in database.
Are there other ways to do that?

many thanks
Franz