Re: [Dovecot] Can not Create Maildir using userdb sql

2009-01-12 Thread Timo Sirainen
On Jan 12, 2009, at 8:38 PM, Henry Yonathan wrote: 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';

Re: [Dovecot] Can not Create Maildir using userdb sql

2009-01-12 Thread Henry Yonathan
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= p

Re: [Dovecot] Can not Create Maildir using userdb sql

2009-01-12 Thread Timo Sirainen
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.

Re: [Dovecot] Can not Create Maildir using userdb sql

2009-01-12 Thread 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/DovecotLDAPostfixAdminM

[Dovecot] Can not Create Maildir using userdb sql

2009-01-11 Thread 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