Showing all My confg again this time including the sql config:
*################ dovecot.conf: ##############*
## Dovecot configuration file
#
base_dir = /var/run/dovecot/
disable_plaintext_auth = no
#
# imap imaps pop3 pop3s (use imaps and pop3s if configured for SSL)
protocols = imap imaps pop3s pop3
#
# Uncomment the ssl_listen statements and comment out listen if using SSL
protocol imap {
listen = *:143
ssl_listen = *:993
mail_plugins = quota imap_quota
}
protocol pop3 {
listen = *:110
ssl_listen = *:995
}
log_path = /var/log/dovecot.log
log_timestamp = "%Y-%m-%d %H:%M:%S "
#syslog_facility = mail
#
# Uncomment these if using SSL
#ssl_cert_file = /etc/ssl/mycompany/mailserver/mail-cert.pem
#ssl_key_file = /etc/ssl/mycompany/mailserver/mail-key.pem
#ssl_ca_file = /etc/ssl/mycompany/ca/mycompany.pem
#ssl_verify_client_cert = yes
#ssl_parameters_regenerate = 168
#verbose_ssl = no
#
# Where the mailboxes are located
#mail_location = maildir:/vmail/%d/%u
mail_location = maildir:/vmail/[EMAIL PROTECTED]
#
#mail_access_groups = mail vmail postfix
#mail_extra_groups = mail vmail postfix
mail_privileged_group = mail
mail_debug = no
first_valid_uid = 150
last_valid_uid = 150
maildir_copy_with_hardlinks = yes
#
protocol imap {
login_executable = /usr/lib/dovecot/imap-login
mail_executable = /usr/lib/dovecot/imap
imap_max_line_length = 65536
}
protocol pop3 {
login_executable = /usr/lib/dovecot/pop3-login
mail_executable = /usr/lib/dovecot/pop3
pop3_uidl_format = %08Xu%08Xv
}
#protocol lda {
#postmaster_address = [EMAIL PROTECTED]
#sendmail_path = /usr/lib/sendmail
#auth_socket_path = /var/run/dovecot/auth-master
#}
#
auth_verbose = yes
auth_debug = yes
auth_debug_passwords = no
#
auth default {
mechanisms = login plain digest-md5 cram-md5
passdb sql {
args = /etc/dovecot/dovecot-sql.conf
}
userdb sql {
args = /etc/dovecot/dovecot-sql.conf
}
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 = postfix
}
}
#
# If you want client certificates, use these lines
# ssl_require_client_cert = yes
# ssl_username_from_cert = yes
}
plugin {
quota = maildir
}
*####################### dovecot-sql.conf
###################################*
driver = mysql
connect = host=127.0.0.1 dbname=SECRET-DB user=SECRET-USER password=SECRET-PASS
default_pass_scheme = MD5
user_query = SELECT '/vmail/[EMAIL PROTECTED]' AS home, 'maildir:/vmail/[EMAIL
PROTECTED]' AS
mail, 150 AS uid, 8 AS gid, CONCAT('dirsize:storage=', quota) AS quota
FROM mailbox WHERE username = '%u' AND active = '1'
password_query = SELECT username AS user, password, '/vmail/[EMAIL PROTECTED]'
AS
userdb_home, 'maildir:/vmail/[EMAIL PROTECTED]' AS userdb_mail, 150 AS
userdb_uid,
8 AS userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'
2008/4/28 Timo Sirainen <[EMAIL PROTECTED]>:
> On Sun, 2008-04-27 at 22:49 -0300, Eden wrote:
> > I configured dovecot to read the maildirsize file as described here:
> > http://wiki.dovecot.org/Quota/Maildir
> >
> > This link shows de maildirsize file using bytes as well.
>
> Yes, it's bytes in the maildirsize file. But how do you return the
> "quota" setting? I guess you're returning it from sql userdb? Show me
> the user_query from dovecot-sql.conf?
>
> (I'm guessing it contains "quota=maildir:storage=n" where n is quota
> limit in bytes (instead of in kilobytes), which overrides limits from
> maildirsize file).
>
>
