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