%{listener} not working

[cesco]

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:

# 2.3.19 (b3ad6004dc): /etc/dovecot/dovecot.conf
# Pigeonhole version 0.5.19 (4eae2f79)
# OS: Linux 5.10.0-13-amd64 x86_64 Debian 11.3
# Hostname: example.org
auth_debug = yes
auth_mechanisms = plain login
auth_verbose = yes
disable_plaintext_auth = no
doveadm_password = # hidden, use -P to show it
doveadm_port = 12345
hostname = example.org
login_log_format_elements = method=%m lip=%l %c %k
mail_fsync = never
mail_location = maildir:/var/vmail/%d/%n@%d/:INDEX=/var/vmail_indexes/%d/%n@%d/
mail_max_userip_connections = 200
mail_plugins = " notify replication fts fts_lucene"
maildir_stat_dirs = yes
maildir_very_dirty_syncs = yes
managesieve_notify_capability = mailto
managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date index ihave duplicate mime foreverypart extracttext
namespace inbox {
   inbox = yes
   location =
   mailbox Drafts {
     auto = subscribe
     special_use = \Drafts
   }
   mailbox Sent {
     auto = subscribe
     special_use = \Sent
   }
   mailbox Spam {
     auto = subscribe
     special_use = \Junk
   }
   mailbox Trash {
     auto = subscribe
     special_use = \Trash
   }
   prefix =
}
passdb {
   args = /etc/dovecot/sql.conf.ext
   driver = sql
}
plugin {
   fts = lucene
   fts_autoindex = yes
   fts_autoindex_max_recent_msgs = 80
   fts_index_timeout = 90
   fts_lucene = whitespace_chars=@.
   last_login_dict = proxy::lastlogin
   last_login_key = # hidden, use -P to show it
   sieve_extensions = +vnd.dovecot.filter
   sieve_global_extensions = +vnd.dovecot.filter
   sieve_plugins = sieve_extprograms
}
protocols = imap pop3 lmtp sieve submission
service aggregator {
   fifo_listener replication-notify-fifo {
     user = dovemail
   }
   unix_listener replication-notify {
     user = dovemail
   }
}
service dict {
   unix_listener dict {
     group = dovemail
     mode = 0660
     user = root
   }
}
service doveadm {
   inet_listener {
     port = 12345
   }
}
service imap-login {
   service_count = 1
}
service imap {
   executable = imap
}
service lmtp {
   inet_listener lmtp {
     port = 24
   }
   process_min_avail = 5
}
service managesieve-login {
   inet_listener sieve {
     port = 4190
   }
}
service pop3-login {
   service_count = 1
}
service pop3 {
   executable = pop3
}
service replicator {
   process_min_avail = 1
   unix_listener replicator-doveadm {
     group = dovemail
     mode = 0600
     user = dovemail
   }
}
service submission-login {
   inet_listener submissions {
     port = 465
     ssl = yes
   }
}
ssl_cipher_list = ALL:!LOW:!SSLv2:!EXP:!aNULL:!RC4::!eNULL:!LOW:!3DES:!MD5:!EXP:!PSK:!SRP:!DSS
ssl_dh = # hidden, use -P to show it
ssl_key = # hidden, use -P to show it
ssl_prefer_server_ciphers = yes
submission_max_mail_size = 100000000 B
submission_max_recipients = 100
submission_relay_host = 127.0.0.1
submission_relay_port = 10025
userdb {
   args = uid=1000 gid=1000 home=/var/vmail/%d/%n@%d/ plain_pass=#hidden_use-P_to_show# user_part=%n domain_part=%d
   driver = static
}
userdb {
   driver = prefetch
}
userdb {
   args = /etc/dovecot/sql.conf.ext
   driver = sql
}
valid_chroot_dirs = /var/vmail:/var/vmail_indexes
protocol imap {
   mail_plugins = " notify replication fts fts_lucene imap_zlib last_login"
}
protocol pop3 {
   mail_plugins = " notify replication fts fts_lucene last_login"
}
protocol lmtp {
   mail_fsync = optimized
   mail_plugins = " notify replication fts fts_lucene sieve"
}