On Fri, August 28, 2009 23:46, Timo Sirainen wrote:
> On Fri, 2009-08-28 at 23:43 +0200, Benny Pedersen wrote:
>> On Fri 14 Aug 2009 02:51:33 AM CEST, Timo Sirainen wrote
>> in 1.1.16 i have also a problem with quotas, maildirsize file is not
>> created with new size when mailbox is maked, and if qoutas in sql
>> changes, then the maildirsize file does not follow
> That's a completely different problem, you should have just started a
> new thread instead of replying. Anyway, post your dovecot -n output and
> dovecot-sql.conf contents.
okay, did not know that, attached is my dovecot n and sql conf
--
xpoint
# 1.1.16: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.27-gentoo-r8 x86_64 Gentoo Base System release 1.12.11.1 ext3
base_dir: /var/run/dovecot/
protocols: pop3 imap managesieve pop3s imaps
ssl_listen: *
ssl_ca_file: /etc/ssl/certs/ca-certificates.crt
ssl_cert_file: /etc/ssl/private/home_server.pem
ssl_key_file: /etc/ssl/private/home_privatekey.pem
ssl_cipher_list: ALL:!LOW
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
login_executable(managesieve): /usr/libexec/dovecot/managesieve-login
login_greeting_capability(default): yes
login_greeting_capability(imap): yes
login_greeting_capability(pop3): no
login_greeting_capability(managesieve): no
login_processes_count: 2
login_max_processes_count: 10
first_valid_uid: 125
last_valid_uid: 125
first_valid_gid: 125
last_valid_gid: 125
mail_location: maildir:/home/vmail/%d/%u/.maildir
mail_executable(default): /usr/libexec/dovecot/imap
mail_executable(imap): /usr/libexec/dovecot/imap
mail_executable(pop3): /usr/libexec/dovecot/pop3
mail_executable(managesieve): /usr/libexec/dovecot/managesieve
mail_plugins(default): quota imap_quota
mail_plugins(imap): quota imap_quota
mail_plugins(pop3): quota
mail_plugins(managesieve):
mail_plugin_dir(default): /usr/lib/dovecot/imap
mail_plugin_dir(imap): /usr/lib/dovecot/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/pop3
mail_plugin_dir(managesieve): /usr/lib64/dovecot/managesieve
imap_client_workarounds(default): outlook-idle
imap_client_workarounds(imap): outlook-idle
imap_client_workarounds(pop3):
imap_client_workarounds(managesieve):
pop3_lock_session(default): no
pop3_lock_session(imap): no
pop3_lock_session(pop3): yes
pop3_lock_session(managesieve): no
pop3_client_workarounds(default):
pop3_client_workarounds(imap):
pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
pop3_client_workarounds(managesieve):
sieve_storage(default):
sieve_storage(imap):
sieve_storage(pop3):
sieve_storage(managesieve): /home/vmail/%d/%u/.sieve
sieve(default):
sieve(imap):
sieve(pop3):
sieve(managesieve): /home/vmail/%d/%u/.dovecot.sieve
namespace:
type: private
inbox: yes
list: yes
subscriptions: yes
auth default:
mechanisms: plain login
worker_max_count: 4
passdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
socket:
type: listen
client:
path: /var/spool/postfix/private/auth
mode: 432
user: postfix
group: postfix
master:
path: /var/run/dovecot/auth-master
mode: 438driver = mysql
connect = host=localhost dbname=dbname user=dbuser password=dbpass
default_pass_scheme = MD5-CRYPT
password_query = SELECT password FROM mailbox WHERE username = '%u'
user_query = SELECT concat('/home/vmail/', maildir) AS home,
concat('/home/vmail/', maildir) AS maildir, 125 AS uid, 125 AS gid,
concat('maildir:storage=', floor(quota/1024)) AS quota FROM mailbox WHERE
username = '%u'
