dovecot - Nov 2008 - dovecot-1.1.6 fatal error: userdb didn't return a home directory

dovecot version 1.1.6
>dovecot -n
# 1.1.6: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.27-gentoo-r1 i686 Gentoo Base System release 2.0.0 xfs
base_dir: /var/run/dovecot/
protocols: imap pop3
listen(default): *:143
listen(imap): *:143
listen(pop3): *:110
ssl_disable: yes
disable_plaintext_auth: 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_greeting: Server ready.
login_process_per_connection: no
login_processes_count: 6
mail_privileged_group: vmail
mail_uid: vmail
mail_gid: vmail
mail_location: maildir:/var/spool/postfix/virtual/%h
mail_debug: yes
fsync_disable: yes
maildir_copy_preserve_filename: yes
mail_executable(default): /usr/libexec/dovecot/imap
mail_executable(imap): /usr/libexec/dovecot/imap
mail_executable(pop3): /usr/libexec/dovecot/pop3
mail_plugins(default): expire fts fts_squat
mail_plugins(imap): expire fts fts_squat
mail_plugins(pop3): expire
mail_plugin_dir(default): /usr/lib/dovecot/imap
mail_plugin_dir(imap): /usr/lib/dovecot/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/pop3
imap_client_workarounds(default): delay-newmail
imap_client_workarounds(imap): delay-newmail
imap_client_workarounds(pop3):
pop3_client_workarounds(default):
pop3_client_workarounds(imap):
pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
auth default:
  mechanisms: plain login
  cache_size: 1024
  debug: yes
  passdb:
    driver: sql
    args: /etc/dovecot/dovecot-sql.conf
  userdb:
    driver: sql
    args: /etc/dovecot/dovecot-sql.conf
  socket:
    type: listen
    master:
      path: /var/run/dovecot/auth-master
      mode: 384
      user: vmail
plugin:
  expire: Trash 7 Spam 30
  expire_dict: proxy::expire
  fts: squat
  fts_squat: partial=4 full=10
dict:
  expire: db:/var/lib/dovecot/expire.db

/etc/dovecot/dovecot-sql.conf

driver = mysql
connect = host=localhost dbname=postfix user=postfix password=****
default_pass_scheme = PLAIN
password_query = SELECT username, password FROM mailbox WHERE username
= '%u' AND active = '1'
user_query = SELECT maildir AS home, 1030 AS uid, 1030 AS gid FROM
mailbox WHERE username = '%u'


After upgrade from version 1.1.4 to 1.1.6, got following error when
dovecot starts

 * Starting dovecot ...
 Fatal: userdb didn't return a home directory, but mail location used it
 (%h): /var/spool/postfix/virtual/%h
 Error: imap dump-capability process returned 89
 Fatal: Invalid configuration in /etc/dovecot/dovecot.conf

Mail locations should be
/var/spool/postfix/virtual/domain/user at domain/ where %h domain/user at
domain/
Version 1.1.4 works fine with this settings.

On Tue, 2008-11-04 at 14:18 +0200, JM wrote:
> dovecot version 1.1.6
> 
> >dovecot -n
> # 1.1.6: /etc/dovecot/dovecot.conf
> # OS: Linux 2.6.27-gentoo-r1 i686 Gentoo Base System release 2.0.0 xfs
> base_dir: /var/run/dovecot/
> protocols: imap pop3
> listen(default): *:143
> listen(imap): *:143
> listen(pop3): *:110
> ssl_disable: yes
> disable_plaintext_auth: 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_greeting: Server ready.
> login_process_per_connection: no
> login_processes_count: 6
> mail_privileged_group: vmail
> mail_uid: vmail
> mail_gid: vmail
> mail_location: maildir:/var/spool/postfix/virtual/%h
> mail_debug: yes
> fsync_disable: yes
> maildir_copy_preserve_filename: yes
> mail_executable(default): /usr/libexec/dovecot/imap
> mail_executable(imap): /usr/libexec/dovecot/imap
> mail_executable(pop3): /usr/libexec/dovecot/pop3
> mail_plugins(default): expire fts fts_squat
> mail_plugins(imap): expire fts fts_squat
> mail_plugins(pop3): expire
> mail_plugin_dir(default): /usr/lib/dovecot/imap
> mail_plugin_dir(imap): /usr/lib/dovecot/imap
> mail_plugin_dir(pop3): /usr/lib/dovecot/pop3
> imap_client_workarounds(default): delay-newmail
> imap_client_workarounds(imap): delay-newmail
> imap_client_workarounds(pop3):
> pop3_client_workarounds(default):
> pop3_client_workarounds(imap):
> pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
> auth default:
>   mechanisms: plain login
>   cache_size: 1024
>   debug: yes
>   passdb:
>     driver: sql
>     args: /etc/dovecot/dovecot-sql.conf
>   userdb:
>     driver: sql
>     args: /etc/dovecot/dovecot-sql.conf
>   socket:
>     type: listen
>     master:
>       path: /var/run/dovecot/auth-master
>       mode: 384
>       user: vmail
> plugin:
>   expire: Trash 7 Spam 30
>   expire_dict: proxy::expire
>   fts: squat
>   fts_squat: partial=4 full=10
> dict:
>   expire: db:/var/lib/dovecot/expire.db
> 
> /etc/dovecot/dovecot-sql.conf
> 
> driver = mysql
> connect = host=localhost dbname=postfix user=postfix password=****
> default_pass_scheme = PLAIN
> password_query = SELECT username, password FROM mailbox WHERE username
> = '%u' AND active = '1'
> user_query = SELECT maildir AS home, 1030 AS uid, 1030 AS gid FROM
> mailbox WHERE username = '%u'
> 
> 
> After upgrade from version 1.1.4 to 1.1.6, got following error when
> dovecot starts
> 
>  * Starting dovecot ...
>  Fatal: userdb didn't return a home directory, but mail location used
it
>  (%h): /var/spool/postfix/virtual/%h
>  Error: imap dump-capability process returned 89
>  Fatal: Invalid configuration in /etc/dovecot/dovecot.conf
This error has been corrected:
http://hg.dovecot.org/dovecot-1.1/rev/2fbd36039526
http://hg.dovecot.org/dovecot-1.1/rev/cbde69815b8a

On Fri, 2008-10-31 at 18:07 +0200, Timo Sirainen wrote:
> One workaround is to use ~ instead of %h. It'll log errors, but it
still
> works.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 489 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20081104/e9d107b4/attachment-0002.bin>

Sorry, doesn't work for SQL, /var/spool/postfix/virtual/~ is pretty useless

Nov  4 14:31:04 jm dovecot: IMAP(user at domain):
Effective uid=1030, gid=1030,
home=domain/user at domain/
Nov  4 14:31:04 jm dovecot: IMAP(user at domain):
maildir: data=/var/spool/postfix/virtual/~
Nov  4 14:31:04 jm dovecot: IMAP(user at domain):

Thank you for patch, try to use it.

On Tue, Nov 4, 2008 at 2:29 PM, Thorsten Vollmer <thorsten at thvo.de>
wrote:
> This error has been corrected:
> http://hg.dovecot.org/dovecot-1.1/rev/2fbd36039526
> http://hg.dovecot.org/dovecot-1.1/rev/cbde69815b8a
>
> On Fri, 2008-10-31 at 18:07 +0200, Timo Sirainen wrote:
>> One workaround is to use ~ instead of %h. It'll log errors, but it
>> still works.
>
>