8.7.80."307-424..." missing mails in different imap-clients
MailDroid on Android
Search Subject “issue” online (Subject from missing mails from trouble ticket system) , not in local phonecache.
Logs from Kopanogateway shows the discoveries, MailDroid can’t open them. eM Client similar problem, Thunderbird no problems,
<?xml version='1.0' encoding='UTF-8' standalone='yes' ?><report><board>MT6582</board><brand>Lenovo</brand><details>Create messages list screen.</details><domain>wvss-mannheim.de</domain><locale>Deutsch (Deutschland)</locale><model>Lenovo A7600-F</model><package_name>com.maildroid</package_name><package_version>4.91</package_version><protocol>imap</protocol><stack>javax.mail.MessagingException: Failed to load IMAP envelope at com.sun.mail.imap.IMAPMessage.loadEnvelope(IMAPMessage.java:1238) at com.sun.mail.imap.IMAPMessage.getSubject(IMAPMessage.java:345) at com.maildroid.second.ae.a(SessionUtils.java:48) at com.maildroid.service.o.c(SessionControllerDispatcher.java:107) at com.maildroid.service.o.a(SessionControllerDispatcher.java:40) at com.maildroid.service.n.a(SessionController.java:100) at com.maildroid.service.p.b(SessionControllerWithState.java:99) at com.maildroid.service.p.a(SessionControllerWithState.java:52) at com.maildroid.service.m.a(RemoteMailService.java:139) at com.maildroid.m.e.a(MailService.java:43) at com.maildroid.bk.c.a(TasksExecutor.java:41) at com.maildroid.bk.d$1.run(TasksExecutorThread.java:18) at com.flipdog.commons.u.a$1.run(ThreadUtils.java:46) at java.lang.Thread.run(Thread.java:761) </stack><uuid>6793fec8-3f71-4e6c-9591-a8ba47374707</uuid><version_incremental>18c2428f1f</version_incremental><version_release>7.1.2</version_release><version_sdk>25</version_sdk></report>
I build a second kopano-server on a different machine. Mails from t-online are invisiible in different imap-clients, thunderbird is ok, eM Client not.
Could somebody test this please?
So on the second server the behaviour is different?
Will check this out sometime in the beginning of next year.
Happy new year.
So on the second server the behaviour is different?
No, same behaviour. T-online mails are hidden on MailDroid and eM-Client. Thunderbird ist ok.
same problems with nightly kopano-gateway 220.127.116.112.1c7f107ba-0+44.1 on the testserver, it think it’s a problem with kopano-gateway.
Comment from another forum about the javaerror: “server seems to be broken”.
greets from germany
by the way, upgrade to 18.104.22.1682 php-mapi-error:
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/20151012/mapi.so' - /usr/lib/php/20151012/mapi.so: undefined symbol: _Z25zif_mapi_freebusy_openmsgP18_zend_execute_dataP12_zval_struct in Unknown on line 0 [Wed Jan 02 19:31:21.077162 2019] [mpm_prefork:notice] [pid 12493] AH00163: Apache/2.4.25 (Debian) OpenSSL/1.0.2q configured -- resuming normal operations
php-mapi-error ist fixed with 22.214.171.1244, t-online-mails still invisible in MailDroid and eM Client.
Does anybody have the same problems?
Worked before with old Zarafa
I did not see this bit before. Which Zarafa version are you speaking about?
We were able to reproduce the email not showing up in emclient with the t-online mail, but not with the mail commands you posted.
Hi Felix and thank you verry much for thist post,
I think it was last Zarafa-Version: 126.96.36.199 on Debian 8 and the mail commands perhaps only work from this one Server, old postfix 2. This machine runs our trouble ticket system. I will have a try from another one.
Edith: It’s strange, from the cli of the trouble ticket machine with postfix 2.11.3-1+deb8u2 without content-type is invisible in eM Client and in MailDroid, with content-type is ok, from other hosts all are ok, with or without.
mail -s “emShit”"$1" email@example.com <<< testtext
mail -s “emShit”"$1" -a “Content-Type: text/plain; charset=utf-8” firstname.lastname@example.org <<< testtext
Strange, in thunderbird are all missing mails from eM-Client visible, but a few others have no topics and no sender. Can’t reproduce them, a few of the missing parts are available a few hours later. In other thunderbird versions are only senders missing.
Are we the only ones with this imap problem? Problem exists with stable 8.6.9 too.
for reference, the ticket to follow for this would be https://jira.kopano.io/browse/KC-1375. In our tests we also saw that this occurs with 8.6 as well.
I find it interesting that during the list command the message is shown, but then not picked up by the imap client later on.
Currently busy with a customer escalation, will later spent some more time on this.
I think the problem is fixed in 8.7.0 and in nightly 188.8.131.529
New mails from problematic servers are shown, old ones not.
kopano-dbadm kc-1375 in old installation throws errors
kopano-dbadm kc-1375 Tue Jan 29 20:18:22 2019: [notice ] kc1375: purging problematic-looking IMAP envelopes... Tue Jan 29 20:18:25 2019: [error ] 0x55b9bbb977d0: SQL Failed: BIGINT UNSIGNED value is out of range in '(`kopano`.`p`.`tag` - 34049)', Query: "DELETE p FROM properties AS p INNER JOIN names AS n ON p.tag-34049=n.id WHERE n.guid=0x08F1F5003F8EC746AF725E201C2349E7 AND n.nameid=1 AND p.type=30 AND p.val_string LIKE '% (((%))) %'" Tue Jan 29 20:18:25 2019: [error ] KDatabase::I_Update() query failed: "BIGINT UNSIGNED value is out of range in '(`kopano`.`p`.`tag` - 34049)'", query: DELETE p FROM properties AS p INNER JOIN names AS n ON p.tag-34049=n.id WHERE n.guid=0x08F1F5003F8EC746AF725E201C2349E7 AND n.nameid=1 AND p.type=30 AND p.val_string LIKE '% (((%))) %' Tue Jan 29 20:18:25 2019: [error ] dbadm: action failed: disk error (80000007)
on a new testserver it works
kopano-dbadm kc-1375 Tue Jan 29 20:24:38 2019: [notice ] kc1375: purging problematic-looking IMAP envelopes... Tue Jan 29 20:24:40 2019: [notice ] kc1375: deleted 121 rows.
@fbartels : “purge” means it deletes the mails in cache or in database?
as the man page says:
Deletes all cached IMAP Envelopes that show signs of having address lists with excess parentheses.