[Dovecot] Can not Create Maildir using userdb sql

[Matt Rude]

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 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:
Are you trying to use mbox or maildir?


> 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


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