over quota not working
Hi, On the stable release 3.0.7 (self-compiled on centos 6) I have lmtp_over_quota_perm_failure: on lmtp_strict_quota: on in my imapd.conf. I came from 2.5.5 where quotas where in effect but now messages are delivered even when the user is overquota. What may be the problem? Regards, Rudi G. signature.asc Description: Message signed with OpenPGP Cyrus Home Page: http://www.cyrusimap.org/ List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/ To Unsubscribe: https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus
ctl_mboxlist
Hi, with cyrus-imapd-2.4.17-caldav-beta10 there is also the ctl_mboxlist which should dump (-d) the contents of the databases in a daily cron job. When I select sql for some databases I always get something like the following: fatal error: invalid value 'sql' for mboxlist_db in line 6 with a -bash-3.2$ more /etc/imapd.conf configdirectory: /var/lib/imap partition-default: /var/spool/imap configdirectory: /var/lib/imap admins: cyrus root annotation_db: skiplist duplicate_db: sql mboxlist_db: sql ptscache_db: skiplist quota_db: sql … etc. This is true if I use mysql for the databases. Regards, Rudi Gabler Cyrus Home Page: http://www.cyrusimap.org/ List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/ To Unsubscribe: https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus
Re: Info-cyrus Digest, Vol 98, Issue 4 Update
Hi below my problem in 2013, now with 2.4.17-caldev-beta10, mariadb and recompile, the mysql connection problem vanished and cyrus is working as expected. Regards, Rudi Gabler info-cyrus@lists.andrew.cmu.edu On 11 Sep 2013, at 18:00, info-cyrus-requ...@lists.andrew.cmu.edu wrote: Send Info-cyrus mailing list submissions to info-cyrus@lists.andrew.cmu.edu To subscribe or unsubscribe via the World Wide Web, visit https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus or, via email, send a message with subject or body 'help' to info-cyrus-requ...@lists.andrew.cmu.edu You can reach the person managing the list at info-cyrus-ow...@lists.andrew.cmu.edu When replying, please edit your Subject line so it is more specific than Re: Contents of Info-cyrus digest... Today's Topics: 1. mysql problem (Rudolf Gabler) 2. Re: mysql problem (Bron Gondwana) 3. Re: mysql problem (Ken Murchison) 4. Re: mysql problem (Blake Hudson) -- Message: 1 Date: Wed, 11 Sep 2013 09:46:17 +0200 From: Rudolf Gabler r...@usm.lmu.de Subject: mysql problem To: info-cyrus@lists.andrew.cmu.edu Message-ID: adbe1ab6-540b-4fa2-adbe-98fda0973...@usm.lmu.de Content-Type: text/plain; charset=windows-1252 Hi, the cyrus-imapd-2.4.17-caldav-beta6 release shows the following: After a fresh start with a mysql database for several purposes duplicate_db: sql mboxlist_db: sql quota_db: sql tlscache_db: sql the system is running as expected. After approximately the 10 imaps contact suddenly the following occurs: Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL query failed: MySQL server has gone away Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL failed SELECT * FROM mailboxes_db WHERE dbkey = 'user?.. But the local mysql server is o.k. and running. After a restart of cyrus (/etc/init.d/cyrus-imapd restart) everything is working until the next appr. 10 connection times by the user. If I use sqlite instead everything is stable for at least a month. Any hint what may occur? Regards, Rudi Gabler -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 495 bytes Desc: Message signed with OpenPGP using GPGMail Url : http://lists.andrew.cmu.edu/pipermail/info-cyrus/attachments/20130911/7b0ff055/attachment-0001.bin -- Message: 2 Date: Wed, 11 Sep 2013 19:43:33 +1000 From: Bron Gondwana br...@fastmail.fm Subject: Re: mysql problem To: info-cyrus@lists.andrew.cmu.edu Cc: Ken Murchison mu...@andrew.cmu.edu Message-ID: 1378892613.11046.20578185.3fff8...@webmail.messagingengine.com Content-Type: text/plain; charset=utf-8 On Wed, Sep 11, 2013, at 05:46 PM, Rudolf Gabler wrote: Hi, the cyrus-imapd-2.4.17-caldav-beta6 release shows the following: After a fresh start with a mysql database for several purposes duplicate_db: sql mboxlist_db: sql quota_db: sql tlscache_db: sql the system is running as expected. After approximately the 10 imaps contact suddenly the following occurs: Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL query failed: MySQL server has gone away Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL failed SELECT * FROM mailboxes_db WHERE dbkey = 'user?.. But the local mysql server is o.k. and running. After a restart of cyrus (/etc/init.d/cyrus-imapd restart) everything is working until the next appr. 10 connection times by the user. Smells like connection handle leakage, or leakage of some other finite resource in the mysql library. Any hint what may occur? Ken - any ideas? You know this code better than I do. Bron. -- Bron Gondwana br...@fastmail.fm -- Message: 3 Date: Wed, 11 Sep 2013 07:00:09 -0400 From: Ken Murchison mu...@andrew.cmu.edu Subject: Re: mysql problem To: Bron Gondwana br...@fastmail.fm Cc: info-cyrus@lists.andrew.cmu.edu Message-ID: 52304d39.2030...@andrew.cmu.edu Content-Type: text/plain; charset=UTF-8; format=flowed On 9/11/13 5:43 AM, Bron Gondwana wrote: On Wed, Sep 11, 2013, at 05:46 PM, Rudolf Gabler wrote: Hi, the cyrus-imapd-2.4.17-caldav-beta6 release shows the following: After a fresh start with a mysql database for several purposes duplicate_db: sql mboxlist_db: sql quota_db: sql tlscache_db: sql the system is running as expected. After approximately the 10 imaps contact suddenly the following occurs: Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL query failed: MySQL server has gone away Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL failed SELECT * FROM mailboxes_db WHERE dbkey = 'user?.. But the local mysql server is o.k. and running. After a restart of cyrus (/etc/init.d/cyrus-imapd restart) everything is working until the next appr. 10
Re: Contents mysql problem
12:23:56 xmailer imaps[32711]: executing SQL cmd: SELECT * FROM mailboxes_db WHERE dbkey = 'user.rug.Solved.isdndec'; Sep 12 12:23:56 xmailer imaps[32711]: executing SQL cmd: SELECT * FROM mailboxes_db WHERE dbkey = 'user.rug.Solved.isdndec'; Sep 12 12:23:56 xmailer imaps[9881]: DBERROR: SQL backend could not connect to host localhost Sep 12 12:23:56 xmailer imaps[9881]: DBERROR: could not open SQL database 'cyrusdb' Sep 12 12:23:56 xmailer imaps[9881]: DBERROR: opening /var/lib/imap/quotas.db: cyrusdb error Sep 12 12:23:56 xmailer imaps[9881]: Fatal error: can't read quotas file Sep 12 12:23:56 xmailer imaps[32711]: fetching user_deny.db entry for 'rug' Sep 12 12:23:56 xmailer imaps[32711]: executing SQL cmd: SELECT * FROM mailboxes_db WHERE dbkey = 'user.rug.Solved.JENAM'; Sep 12 12:23:56 xmailer imaps[32711]: executing SQL cmd: SELECT * FROM mailboxes_db WHERE dbkey = 'user.rug.Solved.JENAM'; Sep 12 12:23:56 xmailer imaps[32711]: fetching user_deny.db entry for 'rug' .. Sep 12 12:23:56 xmailer master[32309]: process 9881 exited, status 75 Sep 12 12:23:56 xmailer master[32309]: service imaps pid 9881 in READY state: terminated abnormally -- Message: 1 Date: Wed, 11 Sep 2013 09:46:17 +0200 From: Rudolf Gabler r...@usm.lmu.de Subject: mysql problem To: info-cyrus@lists.andrew.cmu.edu Message-ID: adbe1ab6-540b-4fa2-adbe-98fda0973...@usm.lmu.de Content-Type: text/plain; charset=windows-1252 Hi, the cyrus-imapd-2.4.17-caldav-beta6 release shows the following: After a fresh start with a mysql database for several purposes duplicate_db: sql mboxlist_db: sql quota_db: sql tlscache_db: sql the system is running as expected. After approximately the 10 imaps contact suddenly the following occurs: Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL query failed: MySQL server has gone away Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL failed SELECT * FROM mailboxes_db WHERE dbkey = 'user?.. But the local mysql server is o.k. and running. After a restart of cyrus (/etc/init.d/cyrus-imapd restart) everything is working until the next appr. 10 connection times by the user. If I use sqlite instead everything is stable for at least a month. Any hint what may occur? Regards, Rudi Gabler -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 495 bytes Desc: Message signed with OpenPGP using GPGMail Url : http://lists.andrew.cmu.edu/pipermail/info-cyrus/attachments/20130911/7b0ff055/attachment-0001.bin -- Message: 2 Date: Wed, 11 Sep 2013 19:43:33 +1000 From: Bron Gondwana br...@fastmail.fm Subject: Re: mysql problem To: info-cyrus@lists.andrew.cmu.edu Cc: Ken Murchison mu...@andrew.cmu.edu Message-ID: 1378892613.11046.20578185.3fff8...@webmail.messagingengine.com Content-Type: text/plain; charset=utf-8 On Wed, Sep 11, 2013, at 05:46 PM, Rudolf Gabler wrote: Hi, the cyrus-imapd-2.4.17-caldav-beta6 release shows the following: After a fresh start with a mysql database for several purposes duplicate_db: sql mboxlist_db: sql quota_db: sql tlscache_db: sql the system is running as expected. After approximately the 10 imaps contact suddenly the following occurs: Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL query failed: MySQL server has gone away Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL failed SELECT * FROM mailboxes_db WHERE dbkey = 'user?.. But the local mysql server is o.k. and running. After a restart of cyrus (/etc/init.d/cyrus-imapd restart) everything is working until the next appr. 10 connection times by the user. Smells like connection handle leakage, or leakage of some other finite resource in the mysql library. Any hint what may occur? Ken - any ideas? You know this code better than I do. Bron. -- Bron Gondwana br...@fastmail.fm -- Message: 3 Date: Wed, 11 Sep 2013 07:00:09 -0400 From: Ken Murchison mu...@andrew.cmu.edu Subject: Re: mysql problem To: Bron Gondwana br...@fastmail.fm Cc: info-cyrus@lists.andrew.cmu.edu Message-ID: 52304d39.2030...@andrew.cmu.edu Content-Type: text/plain; charset=UTF-8; format=flowed On 9/11/13 5:43 AM, Bron Gondwana wrote: On Wed, Sep 11, 2013, at 05:46 PM, Rudolf Gabler wrote: Hi, the cyrus-imapd-2.4.17-caldav-beta6 release shows the following: After a fresh start with a mysql database for several purposes duplicate_db: sql mboxlist_db: sql quota_db: sql tlscache_db: sql the system is running as expected. After approximately the 10 imaps contact suddenly the following occurs: Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL query failed: MySQL server has gone away Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL failed SELECT * FROM mailboxes_db WHERE dbkey = 'user?.. But the local mysql server is o.k. and running. After a restart of cyrus
mysql problem
Hi, the cyrus-imapd-2.4.17-caldav-beta6 release shows the following: After a fresh start with a mysql database for several purposes duplicate_db: sql mboxlist_db: sql quota_db: sql tlscache_db: sql the system is running as expected. After approximately the 10 imaps contact suddenly the following occurs: Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL query failed: MySQL server has gone away Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL failed SELECT * FROM mailboxes_db WHERE dbkey = 'user….. But the local mysql server is o.k. and running. After a restart of cyrus (/etc/init.d/cyrus-imapd restart) everything is working until the next appr. 10 connection times by the user. If I use sqlite instead everything is stable for at least a month. Any hint what may occur? Regards, Rudi Gabler signature.asc Description: Message signed with OpenPGP using GPGMail Cyrus Home Page: http://www.cyrusimap.org/ List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/ To Unsubscribe: https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus
