[Dovecot] Can not Create Maildir using userdb sql

[Henry Yonathan]

Dear all,

I've been experiencing this problem and still can't find a solution for this.
I want to have a dynamic quota for each virtual user.
I've followed instruction from :
http://wiki.dovecot.org/HowTo/DovecotLDAPostfixAdminMySQL
http://workaround.org/articles/ispmail-etch/
But still can't give what I want.
But if I use userdb static, I works fluently.

Below are my Dovecot configuration :

# 1.0.15: /etc/dovecot.conf
base_dir: /var/run/dovecot/
protocols: imap pop3
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
mail_privileged_group: mail
mail_location: maildir:/home/vmail/%d/%n/Maildir
mail_debug: 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): quota imap_quota
mail_plugins(imap): quota imap_quota
mail_plugins(pop3): quota
mail_plugin_dir(default): /usr/lib/dovecot/imap
mail_plugin_dir(imap): /usr/lib/dovecot/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/pop3
pop3_uidl_format(default): 
pop3_uidl_format(imap): 
pop3_uidl_format(pop3): %08Xu%08Xv
namespace:
  type: private
  separator: .
  prefix: INBOX.
  inbox: yes
auth default:
  mechanisms: plain login
  verbose: yes
  debug: yes
  passdb:
    driver: sql
    args: /etc/dovecot-sql.conf
  userdb:
    driver: sql
    args: /etc/dovecot-sql.conf
  socket:
    type: listen
    client:
      path: /var/run/dovecot/auth-client
      mode: 432
      user: postfix
      group: postfix
    master:
      path: /var/run/dovecot/auth-master
      mode: 384
      user: vmail
plugin:
  quota: maildir:storage=5120

---------------------------------------------------------
Below are my dovecot error log
deliver(harry at zlack.net): Nov 19 13:51:27 Info: Loading modules from directory: /usr/lib/dovecot/lda
deliver(harry at zlack.net): Nov 19 13:51:27 Info: Module loaded: /usr/lib/dovecot/lda/lib10_quota_plugin.so
deliver(harry at zlack.net): Nov 19 13:51:27 Info: auth input: harry at zlack.net
deliver(harry at zlack.net): Nov 19 13:51:27 Info: auth input: home=/home/vmail/zlack.net/harry
deliver(harry at zlack.net): Nov 19 13:51:27 Info: auth input: mail=/home/vmail/zlack.net/harry/Maildir
deliver(harry at zlack.net): Nov 19 13:51:27 Info: auth input: uid=5000
deliver(harry at zlack.net): Nov 19 13:51:27 Info: auth input: gid=5000
deliver(harry at zlack.net): Nov 19 13:51:27 Info: auth input: quota=maildir:storage=10240
deliver(harry at zlack.net): Nov 19 13:51:27 Info: Home dir not found: /home/vmail/zlack.net/harry
deliver(harry at zlack.net): Nov 19 13:51:27 Info: maildir autodetect: stat(/home/vmail/zlack.net/harry/Maildir/cur) failed: No such file or directory
deliver(harry at zlack.net): Nov 19 13:51:27 Info: mbox autodetect: data=/home/vmail/zlack.net/harry/Maildir
deliver(harry at zlack.net): Nov 19 13:51:27 Info: mbox autodetect: INBOX file: stat(/home/vmail/zlack.net/harry/Maildir) failed: No such file or directory
deliver(harry at zlack.net): Nov 19 13:51:27 Info: mbox autodetect: has .imap/: stat(/home/vmail/zlack.net/harry/Maildir/.imap) failed: No such file or directory
deliver(harry at zlack.net): Nov 19 13:51:27 Info: mbox autodetect: has inbox: stat(/home/vmail/zlack.net/harry/Maildir/inbox) failed: No such file or directory
deliver(harry at zlack.net): Nov 19 13:51:27 Info: mbox autodetect: has mbox: stat(/home/vmail/zlack.net/harry/Maildir/mbox) failed: No such file or directory
deliver(harry at zlack.net): Nov 19 13:51:27 Error: Ambiguous mail location setting, don't know what to do with it: /home/vmail/zlack.net/harry/Maildir (try prefixing it with mbox: or maildir:)
deliver(harry at zlack.net): Nov 19 13:51:27 Fatal: Failed to create storage for 'harry at zlack.net' with mail '/home/vmail/zlack.net/harry/Maildir'


Kind Regards,


Henry Yonathan

"All successful communication is Hypnosis" - Milton H. Erickson
----
Belanja buku lewat internet, GRATIS ONGKOS KIRIM ke seluruh Indonesia.
Kunjungi website http://www.bookoopedia.com.

Hipokuku.com - Cara Baru Isi Pulsa Lewat Internet.
Kunjungi website http://www.hipokuku.com untuk informasi selengkapnya.