On 2014-02-18 15:18, Paul J Stevens wrote:
On 18-02-14 12:17, Peter Milesson wrote:
I used 78bee4a96c625a9f22b1e13a7f7d9a9e72532f56. Then I backed down to
the standard 3.1.10 with the patch
8c612adbe6468e2cb4d520789cd35156145c5f37. That didn't help a bit, the
behavior was the same.
78bee4a96c625a9f22b1e13a7f7d9a9e72532f56 is from the master branch. That
branch contains auto-migration of the database schema. All of those are
backward compatible as far as I can tell.
The database is currently around 70GB in size, with about 300000
messages stored. I've tuned it with mysqltuner.
I have no idea what that entails.
- First, DBMail 3.1.10 is much slower compared to 3.0.2. It seems to
take a lot more time to fetch the message body.
That is surprising since the underlying mechanism is very much identical.
It seems to be the gmime problem. I will continue testing during the
evening.
- For those users that have got huge mailboxes with lots of folders and
subfolders, the message lists end up like a mixed salad. Mostly, the
same set of message headers are displayed in the list, when opening an
arbitrary folder. The Mozilla Repair function does not help. It does not
help deleting cached headers/messages, the mixed salad is there. Using
exactly the same database with 3.0.2, everything is displayed neatly and
in good order, and each message is listed in the folder where it belongs.
It must be something in your database. Would you mind sharing a schema-dump?
I've compared the dbmail database with the create scripts, plus the
added view for DBMail 3.1.x. They are identical.
- If AVG mail scanning is active (here's your proxy Paul!) The messages
are not fetched from the database while browsing through the message
list, that is no preview is shown. It is necessary to open the message
in a separate window first, or choose to display it as plain text (a
Thunderbird-only function). Even that does not help sometimes. It's
necessary to open another message, and then go back. After the first
message has been opened, most messages are displayed in the preview
pane, but not all. I noticed in one case with 3.0.2, that neither the
message, nor information about attachment was displayed in the preview
pane. When I opened the message, text and attachment was visible.
I have *no* idea what AVG mail scanning is. You mean there is a proxy
between dbmail and the imap client that does scanning on the wire? If so
that is *so* weird. Normally emails are scanned before entering the
system using tools like amavis. But ok, people do weird shit :-) Maybe
if I could see a IMAP trace (tshark) of the actual conversation.
AVG is a quite common anti virus system. Under Windows it works like a
transparent proxy and filters IMAP, POP3, and SMTP traffic. I use it in
stand alone work stations, where the users have got hardware access
(flash keys, DVDs, etc.).
- There's still parts of a bug I reported previously, and that was
corrected with 8c612adbe6468e2cb4d520789cd35156145c5f37. The patch works
if there are attachments. If the message contains only plain text, the
message doesn't look right. I can supply messages processed by DBMail
3.0.2, as well as 3.1.10.
If the message contains only plain text the patch is a no-op. Also, the
codebase contains a *lot* of unit-testing around message reconstruction,
and all those pass just fine.
But again, without seeing the imap conversation, I can't tell.
After half a day of operation with DBMail 3.0.2 and support
libraries/systems according to the following:
MariaDB 5.5.34
gmime 2.6.19
glib 2.36.4
glibc 2.17
libevent 2.0.21
libzdb 2.12 (also tried 3.0)
libsieve 2.3.1
To my dismay, I must state the following:
- there is no indication of attachments in the message list
Afaik, Thunderbird derives that indication from the Content-Type header.
Again, this is an indication something is wrong with the schema.
I'm going to dump the schema, but as I stated before, I've compared
everything with the create scripts. It's a gmime problem.
Best regards,
Peter
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
