[Dovecot] Problem with stored procedure

Fcuk F fcuk03 at gmail.com
Mon Nov 16 18:30:40 EET 2009


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


More information about the dovecot mailing list