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 at 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 at nti.uff.br): SELECT 5000 AS
uid,
> 12 AS gid, mailbox, concat('*:bytes=', quota) AS quota_rule FROM
vmailbox
> WHERE address = 'sfrique at nti.uff.br';
> May 14 17:03:40 auth: Debug: master out: USER 1 sfrique at 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 at nti.uff.br): Debug: Effective uid=5000,
> gid=12, home> May 14 17:03:40 lda(sfrique at nti.uff.br): Debug: Quota
root: name=user
> backend=dict args=:proxy:/var/run/dovecot/dict:quota
> May 14 17:03:40 lda(sfrique at nti.uff.br): Debug: Quota rule: root=user
> mailbox=* bytes=209715200 messages=0
> May 14 17:03:40 lda(sfrique at nti.uff.br): Debug: dict quota: user>
sfrique at nti.uff.br, uri=proxy:/var/run/dovecot/dict:quota, noenforcing=0
> May 14 17:03:40 lda(sfrique at 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 at nti.uff.br): Debug: Quota root: name=user
> backend=dict args=:proxy:/var/run/dovecot/dict:quota
> May 14 17:03:40 lda(sfrique at nti.uff.br): Debug: Quota rule: root=user
> mailbox=* bytes=262144000 messages=0
> May 14 17:03:40 lda(sfrique at nti.uff.br): Debug: dict quota: user>
sfrique at nti.uff.br, uri=proxy:/var/run/dovecot/dict:quota, noenforcing=0
> May 14 17:03:40 lda(sfrique at 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 at 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 at 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 at 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