[Dovecot] MySQL user_query ignored

Helmut Zeilinger hz at hzlabs.de
Mon Jun 20 08:40:21 EEST 2005


Hi all,

i installed Dovecot 0.99.14. Everything works fine except that
the mysql setup directive "user_query" seems to be ignored -
however the password_query works.

Instead the default user query in db-mysql.c always takes effect.

Might this be a bug or is something worng wit my setup below?

(To keep on working i changed the default query in db-mysql.c..)


Helmut


dovecot-mysql.conf:


db_host = localhost
#db_port = 3306
db_unix_socket = /var/lib/mysql/mysql.sock
db = mail
db_user = mail
db_passwd =
db_client_flags = 0

default_pass_scheme = PLAIN

password_query = SELECT password FROM users WHERE login = '%n' and 
domain='%d'

user_query = SELECT '/var/mail/%d/%n' as home, 506 as uid, 100 as gid 
FROM users WHERE login = '%n' and domain='%d'



More information about the dovecot mailing list