<?xml version="1.0" encoding="UTF-8"?>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns="http://purl.org/rss/1.0/" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:syn="http://purl.org/rss/1.0/modules/syndication/" xmlns:admin="http://webns.net/mvcb/">
  <channel rdf:about="http://blog.gmane.org/gmane.mail.imap.dbmail.devel">
    <title>gmane.mail.imap.dbmail.devel</title>
    <link>http://blog.gmane.org/gmane.mail.imap.dbmail.devel</link>
    <description/>
    <syn:updatePeriod>hourly</syn:updatePeriod>
    <syn:updateFrequency>1</syn:updateFrequency>
    <syn:updateBase>1901-01-01T00:00+00:00</syn:updateBase>
    <items>
      <rdf:Seq>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12966"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12965"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12964"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12963"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12962"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12961"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12960"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12959"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12958"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12957"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12956"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12955"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12954"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12953"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12952"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12951"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12950"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12949"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12948"/>
        <rdf:li rdf:resource="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12947"/>
      </rdf:Seq>
    </items>
    <image rdf:resource="http://gmane.org/img/gmane-25t.png"/>
    <textinput rdf:resource=""/>
  </channel>
  <image rdf:about="http://gmane.org/img/gmane-25t.png">
    <title>Gmane</title>
    <url>http://gmane.org/img/gmane-25t.png</url>
    <link>http://gmane.org</link>
  </image>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12966">
    <title>[SCM]Paul's DBMail tree branch, master, updated. dec4b9c075876c02c76235ffd2adeeaa6b400ea7</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12966</link>
    <description>&lt;pre&gt;This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Paul's DBMail tree".

The branch, master has been updated
       via  dec4b9c075876c02c76235ffd2adeeaa6b400ea7 (commit)
      from  4e057f0741328a8c510cc4546555406c7415c140 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit dec4b9c075876c02c76235ffd2adeeaa6b400ea7
Author: Paul J Stevens &amp;lt;paul-oMN9YZNO2BY&amp;lt; at &amp;gt;public.gmane.org&amp;gt;
Date:   Thu May 24 10:05:33 2012 +0200

    relax gmime-2.6 requirement
    
    both gmime-2.4 and gmime-2.6 are accepted

-----------------------------------------------------------------------

Summary of changes:
 acinclude.m4   |   22 +++++++++++-----------
 configure      |   15 ++-------------
 debian/control |    2 +-
 3 files changed, 14 insertions(+), 25 deletions(-)


hooks/post-receive
--
Paul's DBMail tree
&lt;/pre&gt;</description>
    <dc:creator>Paul J Stevens</dc:creator>
    <dc:date>2012-05-24T08:05:54</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12965">
    <title>[DBMail 0000972]: Can't open cyrillic folders.</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12965</link>
    <description>&lt;pre&gt;
A NOTE has been added to this issue. 
====================================================================== 
http://dbmail.org/mantis/view.php?id=972 
====================================================================== 
Reported By:                ealekseev
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   972
Category:                   IMAP daemon
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     confirmed
target:                      
====================================================================== 
Date Submitted:             23-May-12 09:34 CEST
Last Modified:              23-May-12 10:37 CEST
====================================================================== 
Summary:                    Can't open cyrillic folders.
Description: 
Latest stable dbmail from git, Postgresql 9.0.7.

After some updates I can't open any existing (or new created) folders if
name set in cyrillic.

Full logs are in attachment.

It writes into log:

May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_prepare(+408): [0x252a8d0] [SELECT mailbox_idnr FROM
dbmail_mailboxes WHERE owner_idnr = ? AND name LIKE ? ]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_u64(+428): [0x29469e0] 1:[4]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_str(+416): [0x29469e0] 2:[_________________________________-]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_str(+416): [0x29469e0] 3:[&amp;amp;BB4EQgQ,BEAEMAQyBDsENQQ9BD0ESwQ1_]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Error:[db]
db_findmailbox_owner(+1795): SQLException: Parameter index is out of range

But when I make query in DB:

SELECT * from dbmail_mailboxes WHERE owner_idnr = 4 and name LIKE
'&amp;amp;BB4EQgQ,BEAEMAQyBDsENQQ9BD0ESwQ1_';

all is fine, no errors.
====================================================================== 

---------------------------------------------------------------------- 
 (0003450) paul (administrator) - 23-May-12 10:17
 http://dbmail.org/mantis/view.php?id=972#c3450 
---------------------------------------------------------------------- 
Please update your git tree or try this patch specifically:

http://git.dbmail.eu/paul/dbmail/diff/?id=8a70e9977fb3465012ab3c4d22313d0962837aea


---------------------------------------------------------------------- 
 (0003451) ealekseev (reporter) - 23-May-12 10:37
 http://dbmail.org/mantis/view.php?id=972#c3451 
---------------------------------------------------------------------- 
All works well now! Thank you. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
23-May-12 09:34  ealekseev      New Issue                                    
23-May-12 09:34  ealekseev      File Added: out_of_range.txt                    
23-May-12 10:17  paul           Note Added: 0003450                          
23-May-12 10:17  paul           Status                   new =&amp;gt; confirmed    
23-May-12 10:37  ealekseev      Note Added: 0003451                          
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-23T08:37:43</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12964">
    <title>[DBMail 0000972]: Can't open cyrillic folders.</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12964</link>
    <description>&lt;pre&gt;
The following issue has been CONFIRMED. 
====================================================================== 
http://dbmail.org/mantis/view.php?id=972 
====================================================================== 
Reported By:                ealekseev
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   972
Category:                   IMAP daemon
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     confirmed
target:                      
====================================================================== 
Date Submitted:             23-May-12 09:34 CEST
Last Modified:              23-May-12 10:17 CEST
====================================================================== 
Summary:                    Can't open cyrillic folders.
Description: 
Latest stable dbmail from git, Postgresql 9.0.7.

After some updates I can't open any existing (or new created) folders if
name set in cyrillic.

Full logs are in attachment.

It writes into log:

May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_prepare(+408): [0x252a8d0] [SELECT mailbox_idnr FROM
dbmail_mailboxes WHERE owner_idnr = ? AND name LIKE ? ]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_u64(+428): [0x29469e0] 1:[4]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_str(+416): [0x29469e0] 2:[_________________________________-]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_str(+416): [0x29469e0] 3:[&amp;amp;BB4EQgQ,BEAEMAQyBDsENQQ9BD0ESwQ1_]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Error:[db]
db_findmailbox_owner(+1795): SQLException: Parameter index is out of range

But when I make query in DB:

SELECT * from dbmail_mailboxes WHERE owner_idnr = 4 and name LIKE
'&amp;amp;BB4EQgQ,BEAEMAQyBDsENQQ9BD0ESwQ1_';

all is fine, no errors.
====================================================================== 

---------------------------------------------------------------------- 
 (0003450) paul (administrator) - 23-May-12 10:17
 http://dbmail.org/mantis/view.php?id=972#c3450 
---------------------------------------------------------------------- 
Please update your git tree or try this patch specifically:

http://git.dbmail.eu/paul/dbmail/diff/?id=8a70e9977fb3465012ab3c4d22313d0962837aea


Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
23-May-12 09:34  ealekseev      New Issue                                    
23-May-12 09:34  ealekseev      File Added: out_of_range.txt                    
23-May-12 10:17  paul           Note Added: 0003450                          
23-May-12 10:17  paul           Status                   new =&amp;gt; confirmed    
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-23T08:17:35</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12963">
    <title>[DBMail 0000972]: Can't open cyrillic folders.</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12963</link>
    <description>&lt;pre&gt;
A NOTE has been added to this issue. 
====================================================================== 
http://dbmail.org/mantis/view.php?id=972 
====================================================================== 
Reported By:                ealekseev
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   972
Category:                   IMAP daemon
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             23-May-12 09:34 CEST
Last Modified:              23-May-12 10:17 CEST
====================================================================== 
Summary:                    Can't open cyrillic folders.
Description: 
Latest stable dbmail from git, Postgresql 9.0.7.

After some updates I can't open any existing (or new created) folders if
name set in cyrillic.

Full logs are in attachment.

It writes into log:

May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_prepare(+408): [0x252a8d0] [SELECT mailbox_idnr FROM
dbmail_mailboxes WHERE owner_idnr = ? AND name LIKE ? ]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_u64(+428): [0x29469e0] 1:[4]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_str(+416): [0x29469e0] 2:[_________________________________-]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_str(+416): [0x29469e0] 3:[&amp;amp;BB4EQgQ,BEAEMAQyBDsENQQ9BD0ESwQ1_]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Error:[db]
db_findmailbox_owner(+1795): SQLException: Parameter index is out of range

But when I make query in DB:

SELECT * from dbmail_mailboxes WHERE owner_idnr = 4 and name LIKE
'&amp;amp;BB4EQgQ,BEAEMAQyBDsENQQ9BD0ESwQ1_';

all is fine, no errors.
====================================================================== 

---------------------------------------------------------------------- 
 (0003450) paul (administrator) - 23-May-12 10:17
 http://dbmail.org/mantis/view.php?id=972#c3450 
---------------------------------------------------------------------- 
Please update your git tree or try this patch specifically:

http://git.dbmail.eu/paul/dbmail/diff/?id=8a70e9977fb3465012ab3c4d22313d0962837aea


Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
23-May-12 09:34  ealekseev      New Issue                                    
23-May-12 09:34  ealekseev      File Added: out_of_range.txt                    
23-May-12 10:17  paul           Note Added: 0003450                          
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-23T08:17:15</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12962">
    <title>[SCM]Paul's DBMail tree branch, master, updated. 4e057f0741328a8c510cc4546555406c7415c140</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12962</link>
    <description>&lt;pre&gt;This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Paul's DBMail tree".

The branch, master has been updated
       via  4e057f0741328a8c510cc4546555406c7415c140 (commit)
       via  8a70e9977fb3465012ab3c4d22313d0962837aea (commit)
      from  518024b22db53274e112fe4a9cfeafdbf7b4f800 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 4e057f0741328a8c510cc4546555406c7415c140
Author: Paul J Stevens &amp;lt;paul-oMN9YZNO2BY&amp;lt; at &amp;gt;public.gmane.org&amp;gt;
Date:   Wed May 23 10:15:58 2012 +0200

    switch to GMime-2.6 for development

commit 8a70e9977fb3465012ab3c4d22313d0962837aea
Author: Paul J Stevens &amp;lt;paul-oMN9YZNO2BY&amp;lt; at &amp;gt;public.gmane.org&amp;gt;
Date:   Wed May 23 10:15:44 2012 +0200

    IMAP: fix for #972

-----------------------------------------------------------------------

Summary of changes:
 acinclude.m4   |    8 ++++----
 configure      |    8 ++++----
 debian/control |    2 +-
 src/dm_db.c    |    8 ++++----
 4 files changed, 13 insertions(+), 13 deletions(-)


hooks/post-receive
--
Paul's DBMail tree
&lt;/pre&gt;</description>
    <dc:creator>Paul J Stevens</dc:creator>
    <dc:date>2012-05-23T08:16:19</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12961">
    <title>[DBMail 0000972]: Can't open cyrillic folders.</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12961</link>
    <description>&lt;pre&gt;
The following issue has been SUBMITTED. 
====================================================================== 
http://dbmail.org/mantis/view.php?id=972 
====================================================================== 
Reported By:                ealekseev
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   972
Category:                   IMAP daemon
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             23-May-12 09:34 CEST
Last Modified:              23-May-12 09:34 CEST
====================================================================== 
Summary:                    Can't open cyrillic folders.
Description: 
Latest stable dbmail from git, Postgresql 9.0.7.

After some updates I can't open any existing (or new created) folders if
name set in cyrillic.

Full logs are in attachment.

It writes into log:

May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_prepare(+408): [0x252a8d0] [SELECT mailbox_idnr FROM
dbmail_mailboxes WHERE owner_idnr = ? AND name LIKE ? ]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_u64(+428): [0x29469e0] 1:[4]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_str(+416): [0x29469e0] 2:[_________________________________-]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Database:[db]
db_stmt_set_str(+416): [0x29469e0] 3:[&amp;amp;BB4EQgQ,BEAEMAQyBDsENQQ9BD0ESwQ1_]
May 23 11:07:17 ns1 dbmail-imapd[23048]: [0x2559470] Error:[db]
db_findmailbox_owner(+1795): SQLException: Parameter index is out of range

But when I make query in DB:

SELECT * from dbmail_mailboxes WHERE owner_idnr = 4 and name LIKE
'&amp;amp;BB4EQgQ,BEAEMAQyBDsENQQ9BD0ESwQ1_';

all is fine, no errors.
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
23-May-12 09:34  ealekseev      New Issue                                    
23-May-12 09:34  ealekseev      File Added: out_of_range.txt                    
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-23T07:34:49</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12960">
    <title>[DBMail 0000957]: imapd leaks sockets</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12960</link>
    <description>&lt;pre&gt;
A NOTE has been added to this issue. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=957 
====================================================================== 
Reported By:                gcth
Assigned To:                paul
====================================================================== 
Project:                    DBMail
Issue ID:                   957
Category:                   IMAP daemon
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     confirmed
target:                      
====================================================================== 
Date Submitted:             27-Jan-12 11:07 CET
Last Modified:              15-May-12 19:46 CEST
====================================================================== 
Summary:                    imapd leaks sockets
Description: 
I'm currently using latest git dbmail with imap only, and I've noticed that
it refuses connections after few hours of working. lsof shows lots of open
sockets:

dbmail-im 24466     dbmail 1352u     sock                0,6          0t0 
  1917799 can't identify protocol
dbmail-im 24466     dbmail 1353u     sock                0,6          0t0 
  1917800 can't identify protocol
dbmail-im 24466     dbmail 1354u     sock                0,6          0t0 
  1917801 can't identify protocol
dbmail-im 24466     dbmail 1355u     sock                0,6          0t0 
  1917802 can't identify protocol
dbmail-im 24466     dbmail 1356u     sock                0,6          0t0 
  1917803 can't identify protocol
dbmail-im 24466     dbmail 1357u     sock                0,6          0t0 
  1917804 can't identify protocol
dbmail-im 24466     dbmail 1358u     sock                0,6          0t0 
  1917805 can't identify protocol

they are increasing in time leading to saturation of nofiles ulimit. This
problem applies to imapd, I could not reproduce this problem with pop3.
Typical clients connects with latest thundderbird, mostly from local LAN.
Increasing ulimit -n to 8192 allows enough leaks to last for whole day, so
now as a workaround I restart dbmail every night. I'm attaching munin graph
for:
lsof -ln -u dbmail | grep ^dbmail-im   | fgrep sock\  -c
during normal work hours.
====================================================================== 

---------------------------------------------------------------------- 
 (0003392) paul (administrator) - 27-Jan-12 16:35
 http://www.dbmail.org/mantis/view.php?id=957#c3392 
---------------------------------------------------------------------- 
I can confirm this. Looks like there is a thread-race in the imap code.

 

---------------------------------------------------------------------- 
 (0003429) gcth (reporter) - 03-Apr-12 17:07
 http://www.dbmail.org/mantis/view.php?id=957#c3429 
---------------------------------------------------------------------- 
In current master this bug is still present.
Any chances for a fix? What else do you need to debug this? 

---------------------------------------------------------------------- 
 (0003449) vampyre (reporter) - 15-May-12 19:46
 http://www.dbmail.org/mantis/view.php?id=957#c3449 
---------------------------------------------------------------------- 
Hello Paul,

Could you please share your assumptions if you have some, as this is quite
major issue and it is important to get it fixed as fast as possible.

Thank you. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
27-Jan-12 11:07  gcth           New Issue                                    
27-Jan-12 11:07  gcth           File Added: sockets.png                      
27-Jan-12 16:35  paul           Note Added: 0003392                          
27-Jan-12 16:35  paul           Assigned To               =&amp;gt; paul            
27-Jan-12 16:35  paul           Status                   new =&amp;gt; confirmed    
03-Apr-12 17:07  gcth           Note Added: 0003429                          
15-May-12 19:46  vampyre        Note Added: 0003449                          
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-15T17:46:39</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12959">
    <title>[DBMail 0000962]: Sorting IMAP</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12959</link>
    <description>&lt;pre&gt;
A NOTE has been added to this issue. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=962 
====================================================================== 
Reported By:                qliratu
Assigned To:                paul
====================================================================== 
Project:                    DBMail
Issue ID:                   962
Category:                   IMAP daemon
Reproducibility:            N/A
Severity:                   minor
Priority:                   normal
Status:                     assigned
target:                      
====================================================================== 
Date Submitted:             13-Mar-12 09:00 CET
Last Modified:              15-May-12 18:22 CEST
====================================================================== 
Summary:                    Sorting IMAP
Description: 
Yesterday i downloaded 3.0.2 and build it.
Right after i noticed that the sorting of the e-mail is off.

New mails are not being sorted the right way and apear near the botom of
my mail list. build version 3.0.1 again and the problem disapears.
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
has duplicate       0000971 Rouncube Client - Date sorting broken
====================================================================== 

---------------------------------------------------------------------- 
 (0003419) paul (administrator) - 13-Mar-12 09:28
 http://www.dbmail.org/mantis/view.php?id=962#c3419 
---------------------------------------------------------------------- 
Some additional information is required. What email client are you using? 

---------------------------------------------------------------------- 
 (0003420) qliratu (reporter) - 13-Mar-12 10:50
 http://www.dbmail.org/mantis/view.php?id=962#c3420 
---------------------------------------------------------------------- 
Roundcube 0.7.2

And another wierd thing..
send mail from gmail to dbmail everything is oké.
send from my corperate mail NOK.
Send from another ubuntu dbmail server NOK. 

---------------------------------------------------------------------- 
 (0003421) qliratu (reporter) - 13-Mar-12 10:50
 http://www.dbmail.org/mantis/view.php?id=962#c3421 
---------------------------------------------------------------------- 
I dont know where to look for additional logging. if u tell me where i
shoud look i can get it for u. 

---------------------------------------------------------------------- 
 (0003422) gweaver (reporter) - 15-Mar-12 18:03
 http://www.dbmail.org/mantis/view.php?id=962#c3422 
---------------------------------------------------------------------- 
I can confirm this behaviour with dbmail 3.0.2 and roundcube 0.7.2. I have
reverted to dbmail 3.0.1 and it is behaving again.
I'm afraid I'm too busy to produce logs right now, sorry. Maybe at the
weekend. 

---------------------------------------------------------------------- 
 (0003423) paul (administrator) - 15-Mar-12 23:48
 http://www.dbmail.org/mantis/view.php?id=962#c3423 
---------------------------------------------------------------------- 
Please try to verify against a 3.0.2 installation with a truncated and
rebuild header-cache:

mysql&amp;gt; truncate dbmail_headers

dbmail-util -by

If that doesn't help I need specific IMAP command and response traces, for
3.0.1 and 3.0.2 

---------------------------------------------------------------------- 
 (0003424) qliratu (reporter) - 16-Mar-12 09:12
 http://www.dbmail.org/mantis/view.php?id=962#c3424 
---------------------------------------------------------------------- 
I have builded version 3.02 again and truncate dbmail_header (no s).

After that i used dbmail-util -by to recreate all of the headers envelopes
etc..

This did not resolved the issue.

if u can guide me a bit with the imap command and response i can give u
that information. 

---------------------------------------------------------------------- 
 (0003425) paul (administrator) - 16-Mar-12 09:54
 http://www.dbmail.org/mantis/view.php?id=962#c3425 
---------------------------------------------------------------------- 
You need to set file_logging_levels=127

I just did a fresh install of roundcube, and things look just fine to
me... 

---------------------------------------------------------------------- 
 (0003439) qliratu (reporter) - 13-Apr-12 07:56
 http://www.dbmail.org/mantis/view.php?id=962#c3439 
---------------------------------------------------------------------- 
Hello,

I have not paid attention to this problem couple of weeks now.. but i saw
your twitter about resolving imap sort issue.
Today i tried it and now my e-mail is being sorted like it always have.

Meening issue resolved ticket can be closed

Thank u very mutch!

 

---------------------------------------------------------------------- 
 (0003448) Bloody (reporter) - 15-May-12 18:22
 http://www.dbmail.org/mantis/view.php?id=962#c3448 
---------------------------------------------------------------------- 
How you can resolve issue? 
I upgrade installation to 3.0.2, do 
TRUNCATE dbmail_headername, dbmail_header, dbmail_headervalue,
dbmail_referencesfield
and still have invalid sorting by date 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
13-Mar-12 09:00  qliratu        New Issue                                    
13-Mar-12 09:28  paul           Note Added: 0003419                          
13-Mar-12 10:50  qliratu        Note Added: 0003420                          
13-Mar-12 10:50  qliratu        Note Added: 0003421                          
15-Mar-12 18:03  gweaver        Note Added: 0003422                          
15-Mar-12 23:48  paul           Note Added: 0003423                          
15-Mar-12 23:49  paul           Assigned To               =&amp;gt; paul            
15-Mar-12 23:49  paul           Status                   new =&amp;gt; assigned     
16-Mar-12 09:12  qliratu        Note Added: 0003424                          
16-Mar-12 09:54  paul           Note Added: 0003425                          
13-Apr-12 07:55  qliratu        Note Added: 0003439                          
13-Apr-12 07:56  qliratu        Note Edited: 0003439                         
09-May-12 09:24  paul           Relationship added       has duplicate 0000971
15-May-12 18:22  Bloody         Note Added: 0003448                          
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev&amp;lt; at &amp;gt;dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-15T16:22:30</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12958">
    <title>[SCM]Paul's DBMail tree branch, master, updated. 518024b22db53274e112fe4a9cfeafdbf7b4f800</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12958</link>
    <description>&lt;pre&gt;This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Paul's DBMail tree".

The branch, master has been updated
       via  518024b22db53274e112fe4a9cfeafdbf7b4f800 (commit)
      from  ede5490ffdb6e3ba47be03f64a2069d8a4f2560a (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 518024b22db53274e112fe4a9cfeafdbf7b4f800
Author: Paul J Stevens &amp;lt;paul-oMN9YZNO2BY&amp;lt; at &amp;gt;public.gmane.org&amp;gt;
Date:   Thu May 10 16:56:41 2012 +0200

    IMAP: allow setting interval between keepalive messages during IDLE
    
    setting this to a high value will improve battery life for mobile
    clients like K-9, and allow thunderbird to keep IDLE session IDLE
    for longer. Make sure imap_timeout * imap_interval &amp;lt; 1800 (30
    minutes)

-----------------------------------------------------------------------

Summary of changes:
 dbmail.conf |    9 +++++++++
 src/imap4.c |   11 ++++++++++-
 2 files changed, 19 insertions(+), 1 deletions(-)


hooks/post-receive
--
Paul's DBMail tree
&lt;/pre&gt;</description>
    <dc:creator>Paul J Stevens</dc:creator>
    <dc:date>2012-05-10T14:59:09</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12957">
    <title>[DBMail 0000971]: Rouncube Client - Date sorting broken</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12957</link>
    <description>&lt;pre&gt;
The following issue has been CLOSED 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=971 
====================================================================== 
Reported By:                Bobbnz
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   971
Category:                   IMAP daemon
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     closed
target:                      
Resolution:                 duplicate
Duplicate:                  0
Fixed in Version:           
====================================================================== 
Date Submitted:             09-May-12 05:29 CEST
Last Modified:              09-May-12 09:25 CEST
====================================================================== 
Summary:                    Rouncube Client - Date sorting broken
Description: 
Upgraded from 3.0.1 to Git Source 2012-05-05 (3.0.2+). Date sorting in
Roundcube client was OK but totally broken since upgrade to 3.0.2
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
duplicate of        0000962 Sorting IMAP
====================================================================== 

---------------------------------------------------------------------- 
 (0003447) paul (administrator) - 09-May-12 09:24
 http://www.dbmail.org/mantis/view.php?id=971#c3447 
---------------------------------------------------------------------- 
You need to truncate and re-generate the header caches:

mysql&amp;gt; truncate dbmail_headers

dbmail-util -by 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
09-May-12 05:29  Bobbnz         New Issue                                    
09-May-12 09:24  paul           Note Added: 0003447                          
09-May-12 09:24  paul           Relationship added       duplicate of 0000962
09-May-12 09:24  paul           Status                   new =&amp;gt; feedback     
09-May-12 09:25  paul           Status                   feedback =&amp;gt; closed  
09-May-12 09:25  paul           Resolution               open =&amp;gt; duplicate   
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-09T07:25:08</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12956">
    <title>[DBMail 0000971]: Rouncube Client - Date sorting broken</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12956</link>
    <description>&lt;pre&gt;
The following issue requires your FEEDBACK. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=971 
====================================================================== 
Reported By:                Bobbnz
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   971
Category:                   IMAP daemon
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
target:                      
====================================================================== 
Date Submitted:             09-May-12 05:29 CEST
Last Modified:              09-May-12 09:24 CEST
====================================================================== 
Summary:                    Rouncube Client - Date sorting broken
Description: 
Upgraded from 3.0.1 to Git Source 2012-05-05 (3.0.2+). Date sorting in
Roundcube client was OK but totally broken since upgrade to 3.0.2
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
duplicate of        0000962 Sorting IMAP
====================================================================== 

---------------------------------------------------------------------- 
 (0003447) paul (administrator) - 09-May-12 09:24
 http://www.dbmail.org/mantis/view.php?id=971#c3447 
---------------------------------------------------------------------- 
You need to truncate and re-generate the header caches:

mysql&amp;gt; truncate dbmail_headers

dbmail-util -by 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
09-May-12 05:29  Bobbnz         New Issue                                    
09-May-12 09:24  paul           Note Added: 0003447                          
09-May-12 09:24  paul           Relationship added       duplicate of 0000962
09-May-12 09:24  paul           Status                   new =&amp;gt; feedback     
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-09T07:24:46</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12955">
    <title>[DBMail 0000962]: Sorting IMAP</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12955</link>
    <description>&lt;pre&gt;
The issue 0000971 has been set as DUPLICATE OF the following issue. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=962 
====================================================================== 
Reported By:                qliratu
Assigned To:                paul
====================================================================== 
Project:                    DBMail
Issue ID:                   962
Category:                   IMAP daemon
Reproducibility:            N/A
Severity:                   minor
Priority:                   normal
Status:                     assigned
target:                      
====================================================================== 
Date Submitted:             13-Mar-12 09:00 CET
Last Modified:              13-Apr-12 07:55 CEST
====================================================================== 
Summary:                    Sorting IMAP
Description: 
Yesterday i downloaded 3.0.2 and build it.
Right after i noticed that the sorting of the e-mail is off.

New mails are not being sorted the right way and apear near the botom of
my mail list. build version 3.0.1 again and the problem disapears.
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
has duplicate       0000971 Rouncube Client - Date sorting broken
====================================================================== 

---------------------------------------------------------------------- 
 (0003419) paul (administrator) - 13-Mar-12 09:28
 http://www.dbmail.org/mantis/view.php?id=962#c3419 
---------------------------------------------------------------------- 
Some additional information is required. What email client are you using? 

---------------------------------------------------------------------- 
 (0003420) qliratu (reporter) - 13-Mar-12 10:50
 http://www.dbmail.org/mantis/view.php?id=962#c3420 
---------------------------------------------------------------------- 
Roundcube 0.7.2

And another wierd thing..
send mail from gmail to dbmail everything is oké.
send from my corperate mail NOK.
Send from another ubuntu dbmail server NOK. 

---------------------------------------------------------------------- 
 (0003421) qliratu (reporter) - 13-Mar-12 10:50
 http://www.dbmail.org/mantis/view.php?id=962#c3421 
---------------------------------------------------------------------- 
I dont know where to look for additional logging. if u tell me where i
shoud look i can get it for u. 

---------------------------------------------------------------------- 
 (0003422) gweaver (reporter) - 15-Mar-12 18:03
 http://www.dbmail.org/mantis/view.php?id=962#c3422 
---------------------------------------------------------------------- 
I can confirm this behaviour with dbmail 3.0.2 and roundcube 0.7.2. I have
reverted to dbmail 3.0.1 and it is behaving again.
I'm afraid I'm too busy to produce logs right now, sorry. Maybe at the
weekend. 

---------------------------------------------------------------------- 
 (0003423) paul (administrator) - 15-Mar-12 23:48
 http://www.dbmail.org/mantis/view.php?id=962#c3423 
---------------------------------------------------------------------- 
Please try to verify against a 3.0.2 installation with a truncated and
rebuild header-cache:

mysql&amp;gt; truncate dbmail_headers

dbmail-util -by

If that doesn't help I need specific IMAP command and response traces, for
3.0.1 and 3.0.2 

---------------------------------------------------------------------- 
 (0003424) qliratu (reporter) - 16-Mar-12 09:12
 http://www.dbmail.org/mantis/view.php?id=962#c3424 
---------------------------------------------------------------------- 
I have builded version 3.02 again and truncate dbmail_header (no s).

After that i used dbmail-util -by to recreate all of the headers envelopes
etc..

This did not resolved the issue.

if u can guide me a bit with the imap command and response i can give u
that information. 

---------------------------------------------------------------------- 
 (0003425) paul (administrator) - 16-Mar-12 09:54
 http://www.dbmail.org/mantis/view.php?id=962#c3425 
---------------------------------------------------------------------- 
You need to set file_logging_levels=127

I just did a fresh install of roundcube, and things look just fine to
me... 

---------------------------------------------------------------------- 
 (0003439) qliratu (reporter) - 13-Apr-12 07:56
 http://www.dbmail.org/mantis/view.php?id=962#c3439 
---------------------------------------------------------------------- 
Hello,

I have not paid attention to this problem couple of weeks now.. but i saw
your twitter about resolving imap sort issue.
Today i tried it and now my e-mail is being sorted like it always have.

Meening issue resolved ticket can be closed

Thank u very mutch!

 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
13-Mar-12 09:00  qliratu        New Issue                                    
13-Mar-12 09:28  paul           Note Added: 0003419                          
13-Mar-12 10:50  qliratu        Note Added: 0003420                          
13-Mar-12 10:50  qliratu        Note Added: 0003421                          
15-Mar-12 18:03  gweaver        Note Added: 0003422                          
15-Mar-12 23:48  paul           Note Added: 0003423                          
15-Mar-12 23:49  paul           Assigned To               =&amp;gt; paul            
15-Mar-12 23:49  paul           Status                   new =&amp;gt; assigned     
16-Mar-12 09:12  qliratu        Note Added: 0003424                          
16-Mar-12 09:54  paul           Note Added: 0003425                          
13-Apr-12 07:55  qliratu        Note Added: 0003439                          
13-Apr-12 07:56  qliratu        Note Edited: 0003439                         
09-May-12 09:24  paul           Relationship added       has duplicate 0000971
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev&amp;lt; at &amp;gt;dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-09T07:24:34</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12954">
    <title>[DBMail 0000971]: Rouncube Client - Date sorting broken</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12954</link>
    <description>&lt;pre&gt;
The following issue has been set as DUPLICATE OF issue 0000962. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=971 
====================================================================== 
Reported By:                Bobbnz
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   971
Category:                   IMAP daemon
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             09-May-12 05:29 CEST
Last Modified:              09-May-12 09:24 CEST
====================================================================== 
Summary:                    Rouncube Client - Date sorting broken
Description: 
Upgraded from 3.0.1 to Git Source 2012-05-05 (3.0.2+). Date sorting in
Roundcube client was OK but totally broken since upgrade to 3.0.2
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
duplicate of        0000962 Sorting IMAP
====================================================================== 

---------------------------------------------------------------------- 
 (0003447) paul (administrator) - 09-May-12 09:24
 http://www.dbmail.org/mantis/view.php?id=971#c3447 
---------------------------------------------------------------------- 
You need to truncate and re-generate the header caches:

mysql&amp;gt; truncate dbmail_headers

dbmail-util -by 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
09-May-12 05:29  Bobbnz         New Issue                                    
09-May-12 09:24  paul           Note Added: 0003447                          
09-May-12 09:24  paul           Relationship added       duplicate of 0000962
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-09T07:24:33</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12953">
    <title>[DBMail 0000971]: Rouncube Client - Date sorting broken</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12953</link>
    <description>&lt;pre&gt;
A NOTE has been added to this issue. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=971 
====================================================================== 
Reported By:                Bobbnz
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   971
Category:                   IMAP daemon
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             09-May-12 05:29 CEST
Last Modified:              09-May-12 09:24 CEST
====================================================================== 
Summary:                    Rouncube Client - Date sorting broken
Description: 
Upgraded from 3.0.1 to Git Source 2012-05-05 (3.0.2+). Date sorting in
Roundcube client was OK but totally broken since upgrade to 3.0.2
====================================================================== 

---------------------------------------------------------------------- 
 (0003447) paul (administrator) - 09-May-12 09:24
 http://www.dbmail.org/mantis/view.php?id=971#c3447 
---------------------------------------------------------------------- 
You need to truncate and re-generate the header caches:

mysql&amp;gt; truncate dbmail_headers

dbmail-util -by 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
09-May-12 05:29  Bobbnz         New Issue                                    
09-May-12 09:24  paul           Note Added: 0003447                          
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-09T07:24:19</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12952">
    <title>[DBMail 0000970]: Messages with HTML content not formatted correctly when forwarded by DBMail</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12952</link>
    <description>&lt;pre&gt;
A NOTE has been added to this issue. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=970 
====================================================================== 
Reported By:                Bobbnz
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   970
Category:                   general delivery
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             09-May-12 05:08 CEST
Last Modified:              09-May-12 09:19 CEST
====================================================================== 
Summary:                    Messages with HTML content not formatted correctly
when forwarded by DBMail
Description: 
Whenever message is forwarded by dbmail to external user, html content is
not assembled correctly. 
====================================================================== 

---------------------------------------------------------------------- 
 (0003445) Bobbnz (reporter) - 09-May-12 05:31
 http://www.dbmail.org/mantis/view.php?id=970#c3445 
---------------------------------------------------------------------- 
Product Build should read latest GIT 05/05/2012 

---------------------------------------------------------------------- 
 (0003446) paul (administrator) - 09-May-12 09:19
 http://www.dbmail.org/mantis/view.php?id=970#c3446 
---------------------------------------------------------------------- 
This report is too scant on details.

Your not including any information about the actual breakage, what's wrong
with the message after forwarding, when exactly it occurs, what your MTA
setup is, or any other details about actually reproducing your problem.

Forwarding does not entail any kind of re-formatting or re-assembling of
messages. 

Maybe the message was malformed and GMime couldn't parse it to begin
with.
Maybe dot-stuffing lines starting with dots is messed up somewhere.

Too many maybe's. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
09-May-12 05:08  Bobbnz         New Issue                                    
09-May-12 05:31  Bobbnz         Note Added: 0003445                          
09-May-12 09:19  paul           Note Added: 0003446                          
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-09T07:19:59</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12951">
    <title>[DBMail 0000970]: Messages with HTML content not formatted correctly when forwarded by DBMail</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12951</link>
    <description>&lt;pre&gt;
A NOTE has been added to this issue. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=970 
====================================================================== 
Reported By:                Bobbnz
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   970
Category:                   general delivery
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             09-May-12 05:08 CEST
Last Modified:              09-May-12 05:31 CEST
====================================================================== 
Summary:                    Messages with HTML content not formatted correctly
when forwarded by DBMail
Description: 
Whenever message is forwarded by dbmail to external user, html content is
not assembled correctly. 
====================================================================== 

---------------------------------------------------------------------- 
 (0003445) Bobbnz (reporter) - 09-May-12 05:31
 http://www.dbmail.org/mantis/view.php?id=970#c3445 
---------------------------------------------------------------------- 
Product Build should read latest GIT 05/05/2012 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
09-May-12 05:08  Bobbnz         New Issue                                    
09-May-12 05:31  Bobbnz         Note Added: 0003445                          
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-09T03:31:42</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12950">
    <title>[DBMail 0000971]: Rouncube Client - Date sorting broken</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12950</link>
    <description>&lt;pre&gt;
The following issue has been SUBMITTED. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=971 
====================================================================== 
Reported By:                Bobbnz
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   971
Category:                   IMAP daemon
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             09-May-12 05:29 CEST
Last Modified:              09-May-12 05:29 CEST
====================================================================== 
Summary:                    Rouncube Client - Date sorting broken
Description: 
Upgraded from 3.0.1 to Git Source 2012-05-05 (3.0.2+). Date sorting in
Roundcube client was OK but totally broken since upgrade to 3.0.2
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
09-May-12 05:29  Bobbnz         New Issue                                    
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-09T03:29:16</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12949">
    <title>[DBMail 0000970]: Messages with HTML content not formatted correctly when forwarded by DBMail</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12949</link>
    <description>&lt;pre&gt;
The following issue has been SUBMITTED. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=970 
====================================================================== 
Reported By:                Bobbnz
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   970
Category:                   general delivery
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             09-May-12 05:08 CEST
Last Modified:              09-May-12 05:08 CEST
====================================================================== 
Summary:                    Messages with HTML content not formatted correctly
when forwarded by DBMail
Description: 
Whenever message is forwarded by dbmail to external user, html content is
not assembled correctly. 
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
09-May-12 05:08  Bobbnz         New Issue                                    
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-09T03:08:02</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12948">
    <title>[DBMail 0000969]: bad usage of snprintf() for LIKEqueries</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12948</link>
    <description>&lt;pre&gt;
The following issue has been SUBMITTED. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=969 
====================================================================== 
Reported By:                baobab
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   969
Category:                   Database layer
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             08-May-12 09:59 CEST
Last Modified:              08-May-12 09:59 CEST
====================================================================== 
Summary:                    bad usage of snprintf() for LIKE queries
Description: 
at at least one place (found mine in dbmail-mailbox.c line 1228),
we can see the following :

snprintf(partial, DEF_FRAGSIZE, "%%%s%%", s-&amp;gt;search);

if "s-&amp;gt;search" is larger than "DEF_FRAGSIZE", the closing "%" never get a
chance to show in the query.


====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
08-May-12 09:59  baobab         New Issue                                    
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-08T07:59:28</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12947">
    <title>[SCM]Paul's DBMail tree branch, master, updated. ede5490ffdb6e3ba47be03f64a2069d8a4f2560a</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12947</link>
    <description>&lt;pre&gt;This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Paul's DBMail tree".

The branch, master has been updated
       via  ede5490ffdb6e3ba47be03f64a2069d8a4f2560a (commit)
       via  611da1405f6cc8d96574d8a2ceb9942bf200f7fa (commit)
       via  3eadb7ba4040c02f3896530b057fcdf72942490f (commit)
      from  88052e1d317a23bccb0ee365cec4a0e4bf52f6ad (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit ede5490ffdb6e3ba47be03f64a2069d8a4f2560a
Author: Paul J Stevens &amp;lt;paul-oMN9YZNO2BY&amp;lt; at &amp;gt;public.gmane.org&amp;gt;
Date:   Mon May 7 09:55:52 2012 +0200

    minor cleanups

commit 611da1405f6cc8d96574d8a2ceb9942bf200f7fa
Author: Paul J Stevens &amp;lt;paul-oMN9YZNO2BY&amp;lt; at &amp;gt;public.gmane.org&amp;gt;
Date:   Thu May 3 14:45:12 2012 +0200

    reduce reachable

commit 3eadb7ba4040c02f3896530b057fcdf72942490f
Author: Paul J Stevens &amp;lt;paul-oMN9YZNO2BY&amp;lt; at &amp;gt;public.gmane.org&amp;gt;
Date:   Tue Apr 24 16:40:43 2012 +0200

    allow explicit disabling of jemalloc
    
    jemalloc is great, but valgrind doesn't cooperate with it

-----------------------------------------------------------------------

Summary of changes:
 acinclude.m4   |   13 ++++++++-----
 config.in      |    3 +++
 configure      |   15 ++++++++++-----
 debian/rules   |    1 +
 src/dm_db.c    |   45 +++++++++++++++++++++++++++------------------
 src/dm_debug.c |    3 ---
 src/server.c   |    1 -
 7 files changed, 49 insertions(+), 32 deletions(-)


hooks/post-receive
--
Paul's DBMail tree
&lt;/pre&gt;</description>
    <dc:creator>Paul J Stevens</dc:creator>
    <dc:date>2012-05-07T07:55:55</dc:date>
  </item>
  <item rdf:about="http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12946">
    <title>[DBMail 0000964]: Imap Deamon stop to work randomly</title>
    <link>http://permalink.gmane.org/gmane.mail.imap.dbmail.devel/12946</link>
    <description>&lt;pre&gt;
A NOTE has been added to this issue. 
====================================================================== 
http://dbmail.org/mantis/view.php?id=964 
====================================================================== 
Reported By:                bajizs
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   964
Category:                   IMAP daemon
Reproducibility:            random
Severity:                   crash
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             23-Mar-12 12:37 CET
Last Modified:              04-May-12 09:58 CEST
====================================================================== 
Summary:                    Imap Deamon stop to work randomly
Description: 
For last 14 days the dbmail-imapd randomly hangs up and stopped to work. In
error and system logs I have nothing (file_logging_levels= 63). I can't
turn on logging on debug level, because this is a production server with
high mail load. Other applications works normally (dbmail-lmtpd,
dbmail-timsieved, mysql, apache, smb etc). Turned on TLS, and heavy used
function by users. The CPU usage by dbmail-imapd always 80-100% (server is
with 2 cores, CPU usage can be 200%). The dbmail-imapd app two times hangs
up at the times when no user logged in - at the night. In this time we make
backup some files, we have haevy hdd and memory usage. We try to solve
problem with more memory - at the moment I don't know result, because we
order new memory banks today. Can be this solve the problem? Can i see why
is the CPU usege to high? Can I see why hangs up the process at random
time?
====================================================================== 

---------------------------------------------------------------------- 
 (0003426) Bobbnz (reporter) - 24-Mar-12 20:54
 http://dbmail.org/mantis/view.php?id=964#c3426 
---------------------------------------------------------------------- 
Would seem to me you do have insufficient RAM for high load. Also, have you
followed the recommended procedures for optimizing mysql? 

http://dbmail.org/dokuwiki/doku.php/mysql_notes

I would also be curious to know what you consider to be high load in terms
of messages/day, and also the type of storage you are using, eg
SCSI/SAS/SATA?

 

---------------------------------------------------------------------- 
 (0003428) bajizs (reporter) - 03-Apr-12 07:48
 http://dbmail.org/mantis/view.php?id=964#c3428 
---------------------------------------------------------------------- 
I think, the database is optimal - don't see any problem in performance
status informations. 

Storage: SATA raid mirror

CC 800 recived mail for the day, from 08:00AM to 02:00PM CC 550 mail, but
all this mails stored in server (Only IMAP is allowed for users). We have
62 user on system, users have 500Mb - 5Gb mails in his IMAP storage.

I dont know why CPU usage is always on 100% by dbmail-imapd (see attached
picture)

 

---------------------------------------------------------------------- 
 (0003440) bajizs (reporter) - 18-Apr-12 08:03
 http://dbmail.org/mantis/view.php?id=964#c3440 
---------------------------------------------------------------------- 
Memory added to system, but dbmail-imapd CPU usage is 100%. What can be
wrong? 

---------------------------------------------------------------------- 
 (0003444) bajizs (reporter) - 04-May-12 09:58
 http://dbmail.org/mantis/view.php?id=964#c3444 
---------------------------------------------------------------------- 
OK, memory soves the problem of random crash. The dbmail-imapd don't stop
working after 18 days of work.

Maybe You can add code for logging out of memory exceptions, this can be
solve a lot of problem.

Other side, CPU usage not solved, it is always on 100%. How can see wat
dbmail-imapd do? 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
23-Mar-12 12:37  bajizs         New Issue                                    
24-Mar-12 20:39  Bobbnz         Note Added: 0003426                          
24-Mar-12 20:48  Bobbnz         Note Edited: 0003426                         
24-Mar-12 20:52  Bobbnz         Note Edited: 0003426                         
24-Mar-12 20:54  Bobbnz         Note Edited: 0003426                         
02-Apr-12 17:45  bajizs         File Added: dbmail-100% CPU usage.png           
        
02-Apr-12 17:45  bajizs         Note Added: 0003428                          
03-Apr-12 07:48  bajizs         Note Edited: 0003428                         
18-Apr-12 08:03  bajizs         Note Added: 0003440                          
04-May-12 09:58  bajizs         Note Added: 0003444                          
======================================================================
&lt;/pre&gt;</description>
    <dc:creator>Mantis Bug Tracker</dc:creator>
    <dc:date>2012-05-04T07:58:00</dc:date>
  </item>
  <textinput rdf:about="http://search.gmane.org/?group=$group=gmane.mail.imap.dbmail.devel">
    <title>Search Engine</title>
    <description>Search the mailing list at Gmane</description>
    <name>query</name>
    <link>http://search.gmane.org/?group=$group=gmane.mail.imap.dbmail.devel</link>
  </textinput>
</rdf:RDF>

