Hi Timo/all
I am trying to use stored procedure for password query when it try to
connect i get authenticated only for the first user after that for
subsequent user it gives me this error.
Password query failed: Commands out of sync; you can't run this command now
You might have solved this issue before, did some search just found this
http://www.dovecot.org/list/dovecot/2006-October/017041.html (not resloved)
Could you please guide me how to resolve this issue. thanks in advance.
*dovecot-mysql.conf*
connect = host=xxxx dbname=dovecot user=xxx password=xxxxx
client_flags=65536
user_query = SELECT xx as uid, xx as gid, home FROM table WHERE User =
'%u'
password_query = call proxyMayBe('%u','%w','%r');
*Dovecot -n :
*# 1.2.6: /etc/dovecot.conf
# OS: Linux 2.6.18-164.el5 x86_64 CentOS release 5.4 (Final)
base_dir: /var/run/dovecot/
log_path: /var/log/dovecot.log
info_log_path: /var/log/dovecot-info.log
protocols: imap pop3
listen: *
ssl: no
login_dir: /var/run/dovecot//login
login_executable(default): /usr/libexec/dovecot/imap-login
login_executable(imap): /usr/libexec/dovecot/imap-login
login_executable(pop3): /usr/libexec/dovecot/pop3-login
login_process_per_connection: no
login_processes_count: 30
mail_location: maildir:~/
mail_executable(default): /usr/libexec/dovecot/imap
mail_executable(imap): /usr/libexec/dovecot/imap
mail_executable(pop3): /usr/libexec/dovecot/pop3
mail_plugin_dir(default): /usr/lib64/dovecot/imap
mail_plugin_dir(imap): /usr/lib64/dovecot/imap
mail_plugin_dir(pop3): /usr/lib64/dovecot/pop3
auth default:
passdb:
driver: sql
args: /etc/dovecot-mysql.conf
userdb:
driver: sql
args: /etc/dovecot-mysql.conf