Message kill MailWatch SQL Loggin

Wed Aug 8 20:59:18 UTC 2018

Thank you Shawn, now I converted all columns from utf8 to utf8mb4. Just I didn’t know for those bug.

Dobril Dobrilov

IT Manager

 <mailto:dobril at stanga.net> dobril at stanga.net

43, Cherni Vrah Blvd. | 1407 Sofia - Bulgaria
Phone: +359 2 81 960 69 Fax: +359 2 81 960 70
Mobile: +359 878 749 387

We shape Digital  <http://www.stanga.net> www.stanga.net

We re-invent Video  <http://www.bsbvision.com> www.bsbvision.com

We build Apps  <http://www.shanga.co> www.shanga.co

We support Start-Ups  <http://www.mysbar.net> www.mysbar.net

From: MailScanner [mailto:mailscanner-bounces+dobril=stanga.net at lists.mailscanner.info] On Behalf Of Shawn Iverson
Sent: Wednesday, August 8, 2018 9:05 PM
To: MailScanner Discussion <mailscanner at lists.mailscanner.info>
Subject: Re: Message kill MailWatch SQL Loggin

This is a MailWatch issue, and probably is a result of the MailWatch DB/tables not set to use utf8mb4.

On Wed, Aug 8, 2018 at 11:39 AM, DobriL Dobrilov <dobril at stanga.net <mailto:dobril at stanga.net> > wrote:

I just saw there are no any processed emails for last 2 hours in MailWatch panel. In same there received messages emails and on each received I can see usual MailScanner[9303]: MailWatch: Logging message 804C46217E.A23FB to SQL…

Then I find this in the logs, after no more messages in Database.

Aug  8 16:32:08 mail MailScanner[5960]: Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging, it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st execute failed: Incorrect string value: '\xF0\x9F\x92\xB2\xF0\x9F...' for column 'subject' at row 1 at /usr/share/MailScanner/perl/custom/MailWatch.pm line 221, <CLIENT> line 7931.

MailScanner restart and it’s working again , but somehow the some message kill it.

Dobril Dobrilov

IT Manager

 <mailto:dobril at stanga.net> dobril at stanga.net

43, Cherni Vrah Blvd. | 1407 Sofia - Bulgaria
Phone: +359 2 81 960 69 Fax: +359 2 81 960 70
Mobile: +359 878 749 387

We shape Digital  <http://www.stanga.net> www.stanga.net

We re-invent Video  <http://www.bsbvision.com> www.bsbvision.com

We build Apps  <http://www.shanga.co> www.shanga.co

We support Start-Ups  <http://www.mysbar.net> www.mysbar.net

-- 
MailScanner mailing list
mailscanner at lists.mailscanner.info <mailto:mailscanner at lists.mailscanner.info> 
http://lists.mailscanner.info/mailman/listinfo/mailscanner

-- 

Shawn Iverson, CETL

Director of Technology

Rush County Schools

765-932-3901 x1171

iversons at rushville.k12.in.us <mailto:iversons at rushville.k12.in.us> 

  <https://docs.google.com/uc?export=download&id=0Bw5iD0ToYvs_cy1OZFNIZ0drYVU&revid=0Bw5iD0ToYvs_UitIcHVIWkJVVTl2VGpxVUE0d0FQcHBIRXk4PQ>   <https://docs.google.com/uc?export=download&id=0Bw5iD0ToYvs_Zkh4eEs3R01yWXc&revid=0Bw5iD0ToYvs_QWpBK2Y2ajJtYjhOMDRFekZwK2xOamk5Q3Y0PQ> 

  <https://docs.google.com/uc?export=download&id=1aBrlQou4gjB04FY-twHN_0Dn3GHVNxqa&revid=0Bw5iD0ToYvs_RnQ0eDhHcm95WHBFdkNRbXhQRXpoYkR6SEEwPQ> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180808/d9d15b1b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3762 bytes
Desc: not available
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180808/d9d15b1b/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 1151 bytes
Desc: not available
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180808/d9d15b1b/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 853 bytes
Desc: not available
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180808/d9d15b1b/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 1286 bytes
Desc: not available
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180808/d9d15b1b/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 930 bytes
Desc: not available
URL: <http://lists.mailscanner.info/pipermail/mailscanner/attachments/20180808/d9d15b1b/attachment-0003.jpg>