[Dovecot] Can not Create Maildir using userdb sql
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@zlack.net): Nov 19 13:51:27 Info: Loading modules from directory: /usr/lib/dovecot/lda deliver(harry@zlack.net): Nov 19 13:51:27 Info: Module loaded: /usr/lib/dovecot/lda/lib10_quota_plugin.so deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: harry@zlack.net deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: home=/home/vmail/zlack.net/harry deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: mail=/home/vmail/zlack.net/harry/Maildir deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: uid=5000 deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: gid=5000 deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: quota=maildir:storage=10240 deliver(harry@zlack.net): Nov 19 13:51:27 Info: Home dir not found: /home/vmail/zlack.net/harry deliver(harry@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@zlack.net): Nov 19 13:51:27 Info: mbox autodetect: data=/home/vmail/zlack.net/harry/Maildir deliver(harry@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@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@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@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@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@zlack.net): Nov 19 13:51:27 Fatal: Failed to create storage for 'harry@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.
On Mon, January 12, 2009 1:12 am, Henry Yonathan wrote:
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 This needs to end with a / when using maildir change it to 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@zlack.net): Nov 19 13:51:27 Info: Loading modules from directory: /usr/lib/dovecot/lda deliver(harry@zlack.net): Nov 19 13:51:27 Info: Module loaded: /usr/lib/dovecot/lda/lib10_quota_plugin.so deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: harry@zlack.net deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: home=/home/vmail/zlack.net/harry deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: mail=/home/vmail/zlack.net/harry/Maildir deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: uid=5000 deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: gid=5000 deliver(harry@zlack.net): Nov 19 13:51:27 Info: auth input: quota=maildir:storage=10240 deliver(harry@zlack.net): Nov 19 13:51:27 Info: Home dir not found: /home/vmail/zlack.net/harry deliver(harry@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@zlack.net): Nov 19 13:51:27 Info: mbox autodetect: data=/home/vmail/zlack.net/harry/Maildir deliver(harry@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@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@zlack.net): Nov 19 13:51:27 Info: mbox autodetect: has inbox: Are you trying to use mbox or maildir?
stat(/home/vmail/zlack.net/harry/Maildir/inbox) failed: No such file or directory deliver(harry@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@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@zlack.net): Nov 19 13:51:27 Fatal: Failed to create storage for 'harry@zlack.net' with mail '/home/vmail/zlack.net/harry/Maildir'
Kind Regards,
Henry Yonathan
Show us /etc/dovecot-sql.conf also, your problem may be in there.
-Matt
-- Matt Rude website: http://www.mattrude.com - wiki: http://wiki.mattrude.com PGP Fingerprint: 0E94 70DA 89F8 5102 0862 5EA2 CB10 759E E65F 2C46
participants (3)
-
Henry Yonathan
-
Matt Rude
-
Timo Sirainen