[Dovecot] %d isn't expanded

[Roy Sigurd Karlsbakk]

Hi all

I have a box running Debian Lenny 5.0.1 and Dovecot 1.0.15. The user  
query given below does not expand %d, making logins fail. The password  
query seems to work well, according to the mysql query log.

Any ideas why this happens?

Best regards

roy

user_query = SELECT 'maildir:/var/spool/dovecot/%d/%n' as mail, uid,  
gid, domain FROM users WHERE username = '%n' and domain = '%d'


# 1.0.15: /etc/dovecot/dovecot.conf
log_path: /var/log/dovecot/dovecot.log
log_timestamp: %Y-%m-%d %H:%M:%S
disable_plaintext_auth: no
verbose_ssl: yes
login_dir: /var/run/dovecot/login
login_executable: /usr/lib/dovecot/imap-login
verbose_proctitle: yes
mail_privileged_group: mail
mail_location: maildir:/var/spool/dovecot/%d/%n
auth default:
   default_realm: eventchief.com
   verbose: yes
   debug: yes
   passdb:
     driver: sql
     args: /etc/dovecot/dovecot-sql.conf
   userdb:
     driver: sql
     args: /etc/dovecot/dovecot-sql.conf

--
Roy Sigurd Karlsbakk
(+47) 97542685 / 98013356
roy at karlsbakk.net
http://blogg.karlsbakk.net/
--
I all pedagogikk er det essensielt at pensum presenteres  
intelligibelt. Det er et elementært imperativ for alle pedagoger å  
unngå eksessiv anvendelse av idiomer med fremmed opprinnelse. I de  
fleste tilfeller eksisterer adekvate og relevante synonymer på norsk.