[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