20 Jun
2005
20 Jun
'05
8:40 a.m.
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'