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

2009-01-23 Thread Mateusz Kijowski
Dnia czwartek, 22 stycznia 2009, Thorben Hemmler napisał:
 nopassword

http://wiki.dovecot.org/PasswordDatabase/ExtraFields?highlight=(nopassword)

-- 
Mateusz Kijowski
Biuro Informatyki DFQS
mail: mkijow...@dfqs.pl | tel: 058 7668 644
AA58 B5B3 4A94 997F 78E9 A28C 886D 4C58 F1A5 4F2B

***
Dom Finansowy QS Sp. z o.o. z siedzibą w Gdańsku przy ul. Piastowska 11,
wpisany do Rejestru Przedsiębiorców Krajowego Rejestru Sądowego 
przez Sąd Rejonowy Gdańsk - Północ w Gdańsku pod numerem KRS 66674,
z kapitałem zakładowym w wysokości 50.000,00 PLN, NIP 957-08-11-591.


signature.asc
Description: This is a digitally signed message part.


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

2009-01-22 Thread 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=imaplip=192.168.0.32rip=192.168.0.86
lport=143   rport=2905  resp=AHRrdWV2NUBnb25lby5jb98AdGVzdHVzZXI1
Jan 21 15:56:15 test-mi dovecot: auth-worker(default):
sql(t...@domain.com,192.168.0.86): query: SELECT NULL as password, mailhost
as host, 'Y' AS proxy  FROM mail_users WHERE username = 't...@domain.com'
and status='ok'
Jan 21 15:56:15 test-mi dovecot: auth-worker(default):
sql(t...@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