I can not use quota/dict when i configure it come outs this error.
If the configuration gos wrong it just do not happen anything, but if the filds and name are ok, happen this..
May 14 17:03:40 auth: Debug: Loading modules from directory: /usr/lib/dovecot/auth May 14 17:03:40 auth: Debug: master in: USER 1 sfrique@nti.uff.br service=lda May 14 17:03:40 auth: Debug: Loading modules from directory: /usr/lib/dovecot/auth May 14 17:03:40 auth: Info: mysql: Connected to 10.0.0.100 (postfix) May 14 17:03:40 auth: Debug: sql(sfrique@nti.uff.br): SELECT 5000 AS uid, 12 AS gid, mailbox, concat('*:bytes=', quota) AS quota_rule FROM vmailbox WHERE address = 'sfrique@nti.uff.br'; May 14 17:03:40 auth: Debug: master out: USER 1 sfrique@nti.uff.br uid=5000 gid=12 mailbox=nti.uff.br/var/spool/mail/sfrique quota_rule=*:bytes=209715200 May 14 17:03:40 lda(sfrique@nti.uff.br): Debug: Effective uid=5000, gid=12, home= May 14 17:03:40 lda(sfrique@nti.uff.br): Debug: Quota root: name=user backend=dict args=:proxy:/var/run/dovecot/dict:quota May 14 17:03:40 lda(sfrique@nti.uff.br): Debug: Quota rule: root=user mailbox=* bytes=209715200 messages=0 May 14 17:03:40 lda(sfrique@nti.uff.br): Debug: dict quota: user= sfrique@nti.uff.br, uri=proxy:/var/run/dovecot/dict:quota, noenforcing=0 May 14 17:03:40 lda(sfrique@nti.uff.br): Debug: fs: root=/vdomains/ nti.uff.br/home/sfrique/mail, index=/tmp/imap-index/nti.uff.br-sfrique, control=, inbox=/vdomains/nti.uff.br/var/spool/mail/sfrique May 14 17:03:40 lda(sfrique@nti.uff.br): Debug: Quota root: name=user backend=dict args=:proxy:/var/run/dovecot/dict:quota May 14 17:03:40 lda(sfrique@nti.uff.br): Debug: Quota rule: root=user mailbox=* bytes=262144000 messages=0 May 14 17:03:40 lda(sfrique@nti.uff.br): Debug: dict quota: user= sfrique@nti.uff.br, uri=proxy:/var/run/dovecot/dict:quota, noenforcing=0 May 14 17:03:40 lda(sfrique@nti.uff.br): Debug: none: root=, index=, control=, inbox= May 14 17:03:40 dict: Info: mysql: Connected to 10.0.0.100 (postfix) May 14 17:03:40 lda(sfrique@nti.uff.br): Info: msgid=unspecified: saved mail to INBOX May 14 17:03:40 dict: Panic: file driver-mysql.c: line 482 (transaction_send_query): assertion failed: (rows != (my_ulonglong)-1) May 14 17:03:40 dict: Error: Raw backtrace: /usr/lib/dovecot/libdovecot.so.0 [0x7f3ff91aade2] -> /usr/lib/dovecot/libdovecot.so.0 [0x7f3ff91aae4a] -> /usr/lib/dovecot/libdovecot.so.0(i_error+0) [0x7f3ff91ab1f3] -> dovecot/dict [0x409d07] -> dovecot/dict [0x409d43] -> dovecot/dict [0x4090b1] -> dovecot/dict [0x40675e] -> dovecot/dict [0x404c81] -> dovecot/dict [0x40469d] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_handler_run+0xcb) [0x7f3ff91b5b1b] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_run+0x18) [0x7f3ff91b4c98] -> /usr/lib/dovecot/libdovecot.so.0(master_service_run+0x13) [0x7f3ff91a4813] -> dovecot/dict(main+0x16b) [0x4052bb] -> /lib64/libc.so.6(__libc_start_main+0xe6) [0x7f3ff77fd526] -> dovecot/dict [0x404349] May 14 17:03:40 lda(sfrique@nti.uff.br): Error: read(/var/run/dovecot/dict) failed: Remote disconnected May 14 17:03:40 master: Error: service(dict): child 1837 killed with signal 6 (core dumps disabled)
and my doveconf -n
auth_debug = yes
auth_default_realm = vm.uff.br auth_socket_path = /var/run/dovecot/auth-userdb auth_verbose = yes base_dir = /var/run/dovecot/ default_login_user = dovecot dict { quota = mysql:/etc/dovecot/dovecot-dict-quota.conf } disable_plaintext_auth = no first_valid_uid = 1000 fsync_disable = yes hostname = mail1.uff.br lda_mailbox_autocreate = yes listen = * log_path = /var/log/dovecot.log mail_access_groups = mail mail_debug = yes mail_location = mbox:/vdomains/%d/home/%n/mail:INBOX=/vdomains/%d/var/spool/mail/%n:INDEX=/tmp/imap-index/%d-%n passdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } plugin { quota = dict:user::proxy:/var/run/dovecot/dict:quota quota_rule = *:storage=250M sieve = /var/spool/sieve-scripts/%d/%n/.sieve sieve_global_path = /etc/dovecot/default.sieve } postmaster_address = sfrique@nti.uff.br protocols = imap pop3 service auth { user = root } service imap-postlogin { executable = script /usr/local/bin/dovecot-imap } service imap { executable = imap imap-postlogin } service pop3-postlogin { executable = script /usr/local/bin/dovecot-pop3 } service pop3 { executable = pop3 pop3-postlogin } ssl = no userdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } protocol imap { mail_plugins = quota imap_quota } protocol lda { mail_plugins = $mail_plugins quota }
Does anyone have any idea ?
[]'sf.rique