dovecot - Jan 2009 - 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 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.

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

On Jan 12, 2009, at 9:00 AM, Matt Rude wrote:
>> 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/
There is no such requirement anywhere in Dovecot.

I dont think mail_location:/home/vmail/%d/%n/Maildir should be terminated with
an /
Because I've try to use the mail_location with userdb static, dovecot still
able to create the directory anyway.
OK, below are my dovecot-sql.conf

driver = mysql

connect = host=127.0.0.1 dbname=email user=xxxx password=xxxx

default_pass_scheme = PLAIN-MD5

password_query = SELECT email AS user, password,
CONCAT('/home/vmail/%d/%n/', maildir) AS userdb_home,
CONCAT('maildir:/home/vmail/%d/%n/', maildir) AS userdb_mail, 5000 AS
userdb_uid, 5000 AS userdb_gid FROM view_users WHERE email = '%u';

user_query = SELECT '/home/vmail/%d/%n' AS home,
'/home/vmail/%d/%n/Maildir' AS mail, 5000 AS uid, 5000 AS gid,
CONCAT('maildir:storage=', ROUND(quota/1024)) AS quota FROM view_users
WHERE email = '%u';

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.