[Dovecot] Problem with stored procedure
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
Fcuk F wrote:
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
That message is from MySQL. If your stored procedure returns more than one dataset you'll get that error.
~Seth
thanks for the reply Seth. I will try to change my procedure.
On Mon, Nov 16, 2009 at 10:25 PM, Seth Mattinen <sethm@rollernet.us> wrote:
Fcuk F wrote:
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
That message is from MySQL. If your stored procedure returns more than one dataset you'll get that error.
~Seth
participants (2)
-
Fcuk F
-
Seth Mattinen