[Dovecot] Update dovecot-1.0.13_1 --> dovecot-1.1.8 (AS proxy)

[Thorben Hemmler]

Hello List!

I´ve following problem after updating dovecot...

Error: (Empty password returned without nopassword)

Jan 21 15:56:15 test-mi dovecot: auth(default): new auth connection:
pid=83362
Jan 21 15:56:15 test-mi dovecot: auth(default): client in: AUTH 7
PLAIN   service=imap    lip=192.168.0.32        rip=192.168.0.86
lport=143       rport=2905      resp=AHRrdWV2NUBnb25lby5jb98AdGVzdHVzZXI1
Jan 21 15:56:15 test-mi dovecot: auth-worker(default):
sql(test at domain.com,192.168.0.86): query: SELECT NULL as password, mailhost
as host, 'Y' AS proxy  FROM mail_users WHERE username = 'test at domain.com'
and status='ok'
Jan 21 15:56:15 test-mi dovecot: auth-worker(default):
sql(test at domain.com,192.168.0.86): Empty password returned without
nopassword

#################################################################

My config:

dovecot -n
# 1.1.8: /usr/local/etc/dovecot.conf
# OS: FreeBSD 6.3-RELEASE-p3 i386  
base_dir: /var/run/dovecot/
protocols: imap pop3
listen(default): *:143
listen(imap): *:143
listen(pop3): *:110
ssl_listen(default): *:993
ssl_listen(imap): *:993
ssl_listen(pop3): *:995
ssl_disable: yes
ssl_parameters_regenerate: 0
disable_plaintext_auth: no
login_dir: /var/run/dovecot//login
login_executable(default): /usr/local/libexec/dovecot/imap-login
login_executable(imap): /usr/local/libexec/dovecot/imap-login
login_executable(pop3): /usr/local/libexec/dovecot/pop3-login
login_greeting: goneo mail ready.
login_process_per_connection: no
login_greeting_capability(default): yes
login_greeting_capability(imap): yes
login_greeting_capability(pop3): no
login_process_size: 128
login_processes_count: 20
login_max_processes_count: 256
login_max_connections: 2048
max_mail_processes: 1024
verbose_proctitle: yes
first_valid_gid: 0
mail_location: maildir:%h/mail/:INDEX=%h/index/:INBOX=%h/mail/.INBOX
mail_debug: yes
fsync_disable: yes
mail_executable(default): /usr/local/libexec/dovecot/imap
mail_executable(imap): /usr/local/libexec/dovecot/imap
mail_executable(pop3): /usr/local/libexec/dovecot/pop3
mail_plugins(default): quota imap_quota
mail_plugins(imap): quota imap_quota
mail_plugins(pop3): quota
mail_plugin_dir(default): /usr/local/lib/dovecot/imap
mail_plugin_dir(imap): /usr/local/lib/dovecot/imap
mail_plugin_dir(pop3): /usr/local/lib/dovecot/pop3
imap_client_workarounds(default): delay-newmail outlook-idle netscape-eoh
tb-extra-mailbox-sep
imap_client_workarounds(imap): delay-newmail outlook-idle netscape-eoh
tb-extra-mailbox-sep
imap_client_workarounds(pop3): 
pop3_client_workarounds(default): 
pop3_client_workarounds(imap): 
pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
auth default:
  verbose: yes
  debug: yes
  debug_passwords: yes
  passdb:
    driver: sql
    args: /usr/local/etc/dovecot-sql.conf
  userdb:
    driver: static
    args: uid=1000 gid=1000 home=/dev/null
  socket:
    type: listen
    client:
      path: /var/run/dovecot/auth-client
      mode: 432
    master:
      path: /var/run/dovecot/auth-master
      mode: 438
--------------------------------------------------------------------------

grep -v '^ *\(#.*\)\?$' dovecot-sql.conf

driver = mysql
connect = host=192.168.0.3 dbname=email user=readonly password=93700
default_pass_scheme = PLAIN
password_query = SELECT NULL as password, mailhost as host, 'Y' AS proxy
FROM mail_users WHERE username = '%u' and status='ok'

#################################################################

Any ideas what I can do?
Thanks for your help.

Best regards,
Thorben