Hello,

What is your dovecot version? If you are not using dovecot-1.0.5 (below versions are buggy) you cannot set the users' quota from mysqldb. I had tried with one of buggy version two days.

regards,


Osvaldo Alvarez Pozo wrote:

Hi all
Does the list work?
I have sent two mail without answer up today.
I want to change Courrier-imap by dovecot but i have problems with
quota and sieve in dovecot. would you help validating dovecot? I this
does not work i would have to stay with courier-imap.


This is the mail I sent before.


Hi
Well my problem is with quota it is not taken into account by deliver
i compiled dovecot from sorces and the resault is the same.

thoses are my files:

File /etc/dovecot/dovecot.conf
ssl_cert_file = /etc/apache2/ssl/server.crt
ssl_key_file = /etc/apache2/ssl/server.key
#ssl_ca_file = /etc/pki/dovecot/certs/ca-bundle.crt
protocols = imap pop3 imaps pop3s
log_timestamp = "%Y-%m-%d %H:%M:%S "
#mail_location = maildir:/export/mail/%d/%u
mail_location = maildir:/var/vmail/%d/%u/Maildir
mail_extra_groups = mail
first_valid_uid = 5000
last_valid_uid = 5000
maildir_copy_with_hardlinks = yes
disable_plaintext_auth = no
protocol imap {
 mail_plugins = quota imap_quota
 imap_client_workarounds = outlook-idle delay-newmail
}
protocol pop3 {
 mail_plugins = quota
 pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
protocol lda {
 postmaster_address = [EMAIL PROTECTED]
 mail_plugins = quota
 log_path = /var/log/dovecot-deliver.log
 info_log_path = /var/log/dovecot-deliver.log
 mail_plugins = cmusieve
#  sieve_global_dir = /etc/dovecot/sieve/
global_script_path =/etc/dovecot/sieve/dovecot.sieve
}
auth default {
# Having "login" also as a mechanism make sure outlook can use the
auth smtpd as well
# http://wiki.dovecot.org/Authentication/Mechanisms
 mechanisms = plain login
 passdb sql {
   args = /etc/dovecot/sql.conf
 }
 userdb sql {
   args = /etc/dovecot/sql.conf
 }
 userdb prefetch {
 }
 user = nobody
socket listen {
   master {
     path = /var/run/dovecot/auth-master
     mode = 0660
     user = vmail
     group = mail
   }
client {
     path = /var/spool/postfix/private/auth
     mode = 0660
     user = postfix
     group = mail
   }
 }
}
dict {
}
plugin {
 quota = maildir:storage=10240:messages=1000
 acl = vfile:/etc/dovecot/acls
 trash = /etc/dovecot/trash.conf
}
file /etc/dovecot/sql.conf
driver = mysql
default_pass_scheme = MD5
connect = host=localhost dbname=postfix user=postfix password=password
user_query = SELECT concat('/var/vmail/', maildir, 'Maildir') as home,
concat('maildir:/var/vmail/', maildir, 'Maildir') as mail, 5000 AS
uid, 8 AS gid, concat('maildir:storage=', floor(quota/1024)) AS quota
FROM mailbox WHERE username = '%u' AND active = '1'

password_query = SELECT username as user, password,
concat('/var/vmail/', maildir, 'Maildir') as userdb_home,
concat('maildir:/var/vmail/', maildir, 'Maildir') as userdb_mail, 5000
as userdb_uid, 12 as userdb_gid FROM mailbox WHERE username = '%u' AND
active = '1'

Thanks

Thanks in advance

Reply via email to