osTicket / osTicket

The osTicket open source ticketing system official project repository, for versions 1.8 and later
osticket.com
GNU General Public License v2.0
3.26k stars 1.67k forks source link

Outlook Meeting Invite Mail does not get parsed correctly > empty body #4114

Open Knaui opened 6 years ago

Knaui commented 6 years ago

Invite Mail shows up empty in OSticket - renders correctly in thunderbird (Box with date information) - mail and server information below - any idea why ? is there a fix for osticket? Thunderbird screenshot with correct rendering: thunderbird renders correctly

I guess the mail is multipart...


OSticket setup info: osTicket-Version v1.10 Server-Software Apache MySQL-Version 10.2.8 PHP-Version 7.0.22-0ubuntu0.16.04.1 gdlib imap xml xml-dom json mbstring phar intl fileinfo APCu Zend Opcache

Timezone CET (Interpreted as Europe/Berlin)


Header in osticket:

Return-Path: sender@outlookmeetinginvite.com X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on MS1 X-Spam-Level: X-Spam-Status: No, score=0.0 required=5.0 tests=HTML_MESSAGE,MIME_HTML_MOSTLY, SPF_PASS,UNPARSEABLE_RELAY autolearn=ham autolearn_force=no version=3.4.1 X-hMailServer-ExternalAccount: test@osticketemptybody.com Received-SPF: pass (ccc.at: domain of outlookmeetinginvite.com designates 46.XXX.XXX.XX as permitted sender) client-ip=46.XXX.XXX.85 Received: from ([127.0.0.1]) with MailEnable ESMTPS; Mon, 4 Dec 2017 14:06:20 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by webserver01.webofficeserver.info (Postfix) with ESMTP id 0164E1524620 for test@osticketemptybody.com; Mon, 4 Dec 2017 14:06:07 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at webserver01.webofficeserver.info Received: from webserver01.webofficeserver.info ([127.0.0.1]) by localhost (webserver01.webofficeserver.info [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id nw-xmWWp7JuJ for test@osticketemptybody.com; Mon, 4 Dec 2017 14:06:06 +0100 (CET) Received: from mail.outlookmeetinginvite.com (unknown [91.XXX.XXX.XX]) (Authenticated sender: admin@outlookmeetinginvite.com) by webserver01.webofficeserver.info (Postfix) with ESMTPSA id A4D4E15244AD for test@osticketemptybody.com; Mon, 4 Dec 2017 14:06:06 +0100 (CET) Received: from wserver.outlookmeetinginvite.local ([fe80::8d09:6975:2165:5526]) by wserver.outlookmeetinginvite.local ([fe80::8d09:6975:2165:5526%17]) with mapi id 14.03.0123.003; Mon, 4 Dec 2017 14:06:02 +0100 From: Tamara Juritsch sender@outlookmeetinginvite.com To: "test@osticketemptybody.com" test@osticketemptybody.com, Peter Stradner peter.stradner@outlookmeetinginvite.com Subject: Besprechung Thread-Topic: Besprechung Thread-Index: AdNs+ZMWH9Vy4MLOSzSMuCrTJpRQhAABw6Dw Date: Mon, 4 Dec 2017 13:06:01 +0000 Message-ID: 95A11B1B5B8E6E41A34492001D3C4AEBC8F31E12@wserver.outlookmeetinginvite.local Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.1.0.176] x-kse-serverinfo: wserver.outlookmeetinginvite.local, 9 x-kse-antivirus-interceptor-info: scan successful x-kse-antivirus-info: Clean, bases: 04.12.2017 11:06:00 x-kse-attachment-filter-scan-result: Clean Content-Type: multipart/alternative; boundary="_00095A11B1B5B8E6E41A34492001D3C4AEBC8F31E12wserveroutlookmeetinginviteloc" MIME-Version: 1.0 X-ME-CountryOrigin: DE X-Envelope-Sender: sender@outlookmeetinginvite.com X-ME-Bayesian: 0.123953 Return-Path: sender@outlookmeetinginvite.com


complete mail from thunderbird:

From - Mon Dec 11 09:41:22 2017 X-Account-Key: account11 X-UIDL: BA286750408F4450AC2188B65237670A X-Mozilla-Status: 0001 X-Mozilla-Status2: 00000000 X-Mozilla-Keys:
Received-SPF: pass (ccc.at: domain of outlookmeetinginvite.com designates 46.XXX.XXX.XX as permitted sender) client-ip=46.XXX.XXX.85 Received: from ([127.0.0.1]) with MailEnable ESMTPS; Mon, 4 Dec 2017 14:06:20 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by webserver01.webofficeserver.info (Postfix) with ESMTP id 0164E1524620 for test@osticketemptybody.com; Mon, 4 Dec 2017 14:06:07 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at webserver01.webofficeserver.info Received: from webserver01.webofficeserver.info ([127.0.0.1]) by localhost (webserver01.webofficeserver.info [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id nw-xmWWp7JuJ for test@osticketemptybody.com; Mon, 4 Dec 2017 14:06:06 +0100 (CET) Received: from mail.outlookmeetinginvite.com (unknown [91.XXX.XXX.XX]) (Authenticated sender: admin@outlookmeetinginvite.com) by webserver01.webofficeserver.info (Postfix) with ESMTPSA id A4D4E15244AD for test@osticketemptybody.com; Mon, 4 Dec 2017 14:06:06 +0100 (CET) Received: from wserver.outlookmeetinginvite.local ([fe80::8d09:6975:2165:5526]) by wserver.outlookmeetinginvite.local ([fe80::8d09:6975:2165:5526%17]) with mapi id 14.03.0123.003; Mon, 4 Dec 2017 14:06:02 +0100 From: Tamara Juritsch sender@outlookmeetinginvite.com To: "test@osticketemptybody.com" test@osticketemptybody.com, Peter Stradner peter.stradner@outlookmeetinginvite.com Subject: Besprechung Thread-Topic: Besprechung Thread-Index: AdNs+ZMWH9Vy4MLOSzSMuCrTJpRQhAABw6Dw Date: Mon, 4 Dec 2017 13:06:01 +0000 Message-ID: 95A11B1B5B8E6E41A34492001D3C4AEBC8F31E12@wserver.outlookmeetinginvite.local Accept-Language: de-AT, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.1.0.176] x-kse-serverinfo: wserver.outlookmeetinginvite.local, 9 x-kse-antivirus-interceptor-info: scan successful x-kse-antivirus-info: Clean, bases: 04.12.2017 11:06:00 x-kse-attachment-filter-scan-result: Clean Content-Type: multipart/alternative; boundary="_00095A11B1B5B8E6E41A34492001D3C4AEBC8F31E12wserveroutlookmeetinginviteloc" MIME-Version: 1.0 X-ME-CountryOrigin: DE X-Envelope-Sender: sender@outlookmeetinginvite.com X-ME-Bayesian: 0.123953 Return-Path: sender@outlookmeetinginvite.com

--_00095A11B1B5B8E6E41A34492001D3C4AEBC8F31E12wserveroutlookmeetinginviteloc Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

--_00095A11B1B5B8E6E41A34492001D3C4AEBC8F31E12wserveroutlookmeetinginviteloc Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr= osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:= //www.w3.org/TR/REC-html40">

<body lang=3D"DE" link=3D"#0563C1" vlink=3D"#954F72"> <div class=3D"WordSection1"> <p class=3D"MsoNormal"> </o:p>

--_00095A11B1B5B8E6E41A34492001D3C4AEBC8F31E12wserveroutlookmeetinginviteloc Content-Type: text/calendar; charset="utf-8"; method=REQUEST Content-Transfer-Encoding: base64

QkVHSU46VkNBTEVOREFSDQpNRVRIT0Q6UkVRVUVTVA0KUFJPRElEOk1pY3Jvc29mdCBFeGNoYW5n ZSBTZXJ2ZXIgMjAxMA0KVkVSU0lPTjoyLjANCkJFR0lOOlZUSU1FWk9ORQ0KVFpJRDpXLiBFdXJv cGUgU3RhbmRhcmQgVGltZQ0KQkVHSU46U1RBTkRBUkQNCkRUU1RBUlQ6MTYwMTAxMDFUMDMwMDAw DQpUWk9GRlNFVEZST006KzAyMDANClRaT0ZGU0VUVE86KzAxMDANClJSVUxFOkZSRVE9WUVBUkxZ O0lOVEVSVkFMPTE7QllEQVk9LTFTVTtCWU1PTlRIPTEwDQpFTkQ6U1RBTkRBUkQNCkJFR0lOOkRB WUxJR0hUDQpEVFNUQVJUOjE2MDEwMTAxVDAyMDAwMA0KVFpPRkZTRVRGUk9NOiswMTAwDQpUWk9G RlNFVFRPOiswMjAwDQpSUlVMRTpGUkVRPVlFQVJMWTtJTlRFUlZBTD0xO0JZREFZPS0xU1U7QllN T05USD0zDQpFTkQ6REFZTElHSFQNCkVORDpWVElNRVpPTkUNCkJFR0lOOlZFVkVOVA0KT1JHQU5J WkVSO0NOPVRhbWFyYSBKdXJpdHNjaDpNQUlMVE86VGFtYXJhLkp1cml0c2NoQHdhZ25hLmF0DQpB VFRFTkRFRTtST0xFPVJFUS1QQVJUSUNJUEFOVDtQQVJUU1RBVD1ORUVEUy1BQ1RJT047UlNWUD1U UlVFO0NOPU5ldHpwbGFudW4NCiBnQEVXRWJuZXIuYXQ6TUFJTFRPOk5ldHpwbGFudW5nQEVXRWJu ZXIuYXQNCkFUVEVOREVFO1JPTEU9UkVRLVBBUlRJQ0lQQU5UO1BBUlRTVEFUPU5FRURTLUFDVElP TjtSU1ZQPVRSVUU7Q049UGV0ZXIgU3RyYQ0KIGRuZXI6TUFJTFRPOnBldGVyLnN0cmFkbmVyQHdh Z25hLmF0DQpERVNDUklQVElPTjtMQU5HVUFHRT1kZS1ERTpcbg0KU1VNTUFSWTtMQU5HVUFHRT1k ZS1ERTpCZXNwcmVjaHVuZyBMZWl0dW5nIEVWVSBFYm5lcg0KRFRTVEFSVDtUWklEPVcuIEV1cm9w ZSBTdGFuZGFyZCBUaW1lOjIwMTcxMjA1VDEwMDAwMA0KRFRFTkQ7VFpJRD1XLiBFdXJvcGUgU3Rh bmRhcmQgVGltZToyMDE3MTIwNVQxMDMwMDANClVJRDowNDAwMDAwMDgyMDBFMDAwNzRDNUI3MTAx QTgyRTAwODAwMDAwMDAwRjA3OURBRjQwMTZERDMwMTAwMDAwMDAwMDAwMDAwMA0KIDAxMDAwMDAw MEFEM0Y3NTVBNUQzNkE4NEZCRjk1NUY4MkQwNUE5NjI1DQpDTEFTUzpQVUJMSUMNClBSSU9SSVRZ OjUNCkRUU1RBTVA6MjAxNzEyMDRUMTMwNjAwWg0KVFJBTlNQOk9QQVFVRQ0KU1RBVFVTOkNPTkZJ Uk1FRA0KU0VRVUVOQ0U6MA0KTE9DQVRJT047TEFOR1VBR0U9ZGUtREU6R2VtZWluZGVhbXQgV2Fn bmEgLSBCw7xybyBCw7xyZ2VybWVpc3Rlcg0KWC1NSUNST1NPRlQtQ0RPLUFQUFQtU0VRVUVOQ0U6 MA0KWC1NSUNST1NPRlQtQ0RPLU9XTkVSQVBQVElEOi01MDcxOTc0NzENClgtTUlDUk9TT0ZULUNE Ty1CVVNZU1RBVFVTOlRFTlRBVElWRQ0KWC1NSUNST1NPRlQtQ0RPLUlOVEVOREVEU1RBVFVTOkJV U1kNClgtTUlDUk9TT0ZULUNETy1BTExEQVlFVkVOVDpGQUxTRQ0KWC1NSUNST1NPRlQtQ0RPLUlN UE9SVEFOQ0U6MQ0KWC1NSUNST1NPRlQtQ0RPLUlOU1RUWVBFOjANClgtTUlDUk9TT0ZULURJU0FM TE9XLUNPVU5URVI6RkFMU0UNCkJFR0lOOlZBTEFSTQ0KQUNUSU9OOkRJU1BMQVkNCkRFU0NSSVBU SU9OOlJFTUlOREVSDQpUUklHR0VSO1JFTEFURUQ9U1RBUlQ6LVBUMTVNDQpFTkQ6VkFMQVJNDQpF TkQ6VkVWRU5UDQpFTkQ6VkNBTEVOREFSDQo=

--_00095A11B1B5B8E6E41A34492001D3C4AEBC8F31E12wserveroutlookmeetinginviteloc--

mchobbel commented 5 years ago

Is this still unresolved? Does anyone have a solution or workaround? Thanks!

Mike-Benoit commented 4 years ago

This affects us as well. They come through as a multi-part MIME encoded email, and osTicket doesn't appear to pull out the "quoted-printable" section for display. :(

kosli commented 4 years ago

I have this problem not only with the outlook meeting invitations, but with outlook emails sent from a client of mine. I am a step further. It seems the problem is not in fetching the mail, but when parsing it and when the body is in quoted-printable (just one single mime part with text/plain) and the text has special characters, like umlaut (e.g. "Einen sch=F6nen Tag" instead of "Einen schönen Tag" I can see on line https://github.com/osTicket/osTicket/blob/741122a614ce61f998aabf8982d3bcbd6e376aaa/include/class.mailfetch.php#L797 that the $vars['message'] is filled with the right content, but the umlauts are not "converted" and I assume that is a problem when the Ticket:create is called here: https://github.com/osTicket/osTicket/blob/741122a614ce61f998aabf8982d3bcbd6e376aaa/include/class.mailfetch.php#L898 -> if I manually change the original mail (straight in the IMAP mailbox) and replace the not-converted umlauts, the message is parsed right and the ticket contains the content.....

mchobbel commented 4 years ago

Use this plugin to solve the above issue:

https://github.com/mchobbel/osticket-ical