Defect #35879
closedmail handler failing when smilies inline
0%
Description
My system info:
Environment: Redmine version 4.2.1.stable Ruby version 2.7.3-p183 (2021-04-05) [aarch64-linux] Rails version 5.2.5 Environment production Database adapter Mysql2 Mailer queue ActiveJob::QueueAdapters::AsyncAdapter Mailer delivery smtp SCM: Subversion 1.13.0 Mercurial 5.3.1 Cvs 1.12.13 Bazaar 3.0.2 Git 2.25.1 Filesystem Redmine plugins: accept 0.0.2 additionals 3.0.2 issue_recurring 1.4 localizable 0.4.0 redmine_checklists 3.1.18 redmine_contacts 4.3.4 redmine_contacts_invoices 4.1.8 redmine_dashboard 2.7.1 redmine_issues_tree 0.0.14 redmine_lightbox2 0.5.1 redmine_logs 0.2.0 redmine_mentions 0.0.1 redmine_tags 4.0.0 redmine_theme_changer 0.4.0 redmine_timelog_timer 2.0.1 redmine_work_time 0.4.1
I am using mail aliases to pipe mail to mailhandler.
Unfortunately it fails when an e-mail contains an emoji/smiley see attached.
In receiving replay form server it initially is reported as possible permission problem:
The mail system <support@domain.my>: permission denied. Command output: Request was denied by your Redmine server. Possible reasons: email is sent from an invalid email address or is missing some information. Reporting-MTA: dns; domain.my X-Postfix-Queue-ID: 3521C1760 X-Postfix-Sender: rfc822; my.mail@domain.my Arrival-Date: Wed, 15 Sep 2021 11:40:37 +0300 (EEST) Final-Recipient: rfc822; support@domain.my Original-Recipient: rfc822;support@domain.my Action: failed Status: 5.7.0 Diagnostic-Code: x-unix; Request was denied by your Redmine server. Possible reasons: email is sent from an invalid email address or is missing some information.
but further investigations shows:
MailHandler: an unexpected error occurred when receiving email: Mysql2::Error: Incorrect string value: '\xF0\x9F\x98\x8A' for column 'description' at row 1: INSERT INTO `issues` (`tracker_id`, `project_id`, `subject`, `description`, `status_id`, `assigned_to_id`, `priority_id`, `author_id`, `created_on`, `updated_on`, `start_date`, `lock_version`) VALUES (3, 6, 'Fwd: Fwd: FW: Forems', 'Ttestam\r\n\r\nItkā sīkums, bet ja to var sakārtot, varbūt ir vērts
Files
Related issues