[Dovecot] problem with userdb_ on pgsql
# 1 password_query = SELECT login as user, passwd as password FROM mail.dovecot_passwd_v WHERE login = '%n'
# 2 user_query = SELECT home, 5020 as uid, 5020 as gid FROM mail.dovecot_passwd_v WHERE login = '%n'
# 3 # password_query = SELECT login as user, passwd as password, home as userdb_home, 5020 as userdb_uid, 5020 as userdb_gid FROM mail.dovecot_passwd_v WHERE login = '%n'
when #3, instead of #1 and #2 is used, it still calls a default user_query.
Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
On Mon, 2006-04-03 at 11:42 -0700, chester c young wrote:
# password_query = SELECT login as user, passwd as password, home as userdb_home, 5020 as userdb_uid, 5020 as userdb_gid FROM mail.dovecot_passwd_v WHERE login = '%n'
when #3, instead of #1 and #2 is used, it still calls a default user_query.
Yes it does if you've "userdb sql" in dovecot.conf. Remove it and add "userdb prefetch".
participants (2)
-
chester c young
-
Timo Sirainen