Re: [Dovecot] Can not Create Maildir using userdb

2009-01-13 Thread Henry Yonathan
ng List [mailto:dove...@dovecot.org] Subject: Re: [Dovecot] Can not Create Maildir using userdb > On Tue, 2009-01-13 at 10:27 +0700, Henry Yonathan wrote: > > Thank you for your reply. > > So, you mean that both user_query and password_query should have the > > same amount

Re: [Dovecot] Can not Create Maildir using userdb

2009-01-13 Thread Timo Sirainen
On Tue, 2009-01-13 at 10:27 +0700, Henry Yonathan wrote: > Thank you for your reply. > So, you mean that both user_query and password_query should have the > same amount of parameter and the mail parameter from user_query should > have the exact parameter as userdb_mail from password_query? > And a

Re: [Dovecot] Can not Create Maildir using userdb

2009-01-12 Thread Henry Yonathan
Henry From: Timo Sirainen [mailto:t...@iki.fi] To: Dovecot Mailing List [mailto:dove...@dovecot.org] Subject: Re: [Dovecot] Can not Create Maildir using userdb sql > On Jan 12, 2009, at 8:38 PM, Henry Yonathan wrote: > > > password_query = SELECT email AS user, password, CONCAT('/

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