Hi, I opened; http://bugs.otrs.org/show_bug.cgi?id=11951
Thanks! 2016-03-18 4:49 GMT-03:00 Martin Gruner <martin.gru...@otrs.com>: > Hello John, > > this sounds like a bug. Could you open an entry at http://bugs.otrs.org > please and attach a failing raw email to it please? > > Best regards, > > Martin Gruner > Team Lead R&D > > OTRS AG > Bahnhofplatz 1a > 94315 Straubing > > T: +49 (0)6172 681988 0 > F: +49 (0)9421 56818 18 > I: www.otrs.com/ > > Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: > DE256610065 > Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann > (Vorsitzender), Christopher Kuhn, Sabine Riedel > > Mobile Kommunikation und transparente Prozesse - Mit der OTRS Business > Solution™ Managed 5 schnell und ohne eigene IT-Ressourcen starten - Jetzt > neue Features entdecken und bestellen > > https://www.otrs.com/neu-in-otrs-business-solution-5-mobile-kommunikation-transparente-prozesse/?lang=de > > > Am 11.02.2016 um 23:25 schrieb John O'Neill <john.oneill...@gmail.com>: > > > > Hi > > > > We have OTRS 5 in place at the moment, all is working well except for > when we receive emails in from certain users who have the following footer > in their emails > > > > Kind Regards / Mit freundlichen Grüßen / Freundliche Grüße / Saludos > cordiales / Saygılarımla / Cordialement > > > > > > > > Were working on the assumption that the issue has something to do with > the character set, our database is working in UTF8, with the following > settings in my.cnf > > > > [client] > > default-character-set=utf8 > > > > > > [mysqld] > > character-set-server=utf8 > > > > > > The show variables statement shows the following > > > > > > SHOW VARIABLES LIKE "character_set_%"; > > +--------------------------+----------------------------+ > > | Variable_name | Value | > > +--------------------------+----------------------------+ > > | character_set_client | utf8 | > > | character_set_connection | utf8 | > > | character_set_database | utf8 | > > | character_set_filesystem | binary | > > | character_set_results | utf8 | > > | character_set_server | utf8 | > > | character_set_system | utf8 | > > | character_sets_dir | /usr/share/mysql/charsets/ | > > +--------------------------+----------------------------+ > > > > So it seems that everything is set to be UTF8 and as such should be able > to handle the different character sets. > > > > Every time we get a mail in with the special characters we get the > following error > > > > "There was an error executing Execute() in > Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch: [Thu > Feb 11 22:24:12 2016] otrs.Daemon.pl: DBD::mysql::db do failed: Incorrect > string value: '\xC4\xB1lar\xC4...' for column 'a_body' at row 1 at > /opt/otrs/Kernel/System/DB.pm line 449." > > > > > > I have run out of ideas now and was wondering if anyone might be able to > suggest where I could go next, we are running otrs 5.0.3-01 on CentOS > release 6.7 (Final) > > > > > > Many thanks, > > John > > > > --------------------------------------------------------------------- > > OTRS mailing list: otrs - Webpage: http://otrs.org/ > > Archive: http://lists.otrs.org/pipermail/otrs > > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs -- Atenciosamente, Davi Albergaria
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs