Server errors/restarting service & IMAP refreshing

[cwaltzer]

I am currently having a TON of hMailserver issues and do not even know where to begin. Outlook clients need to close and open outlook to receive new messages and the worst part seems to be that when I am on the mail server and am watching for issues and/or looking around I get COM errors and then the service seems to re-start as I then have to log back in to the hMailserver Administrator. Any help would be GREATLY aprreciated. Please let me know as soon as possible what you need from me in the way of logs etc. Thank you in advance for your help!

[Bill48105]

Hi. you didn't state what version of hmail you are on. some have known issues & crashing under certain circumstances (heavy load especially or seemingly randomly). Knowing the exact errors from hmail logs would be helpful too

[cwaltzer]

Sorry - Version 5.5.2-b2129.

[Bill48105]

ok great thanks if someone reads & has idea they can respond in meantime will see how far we can get to resolving your issues in IRC

[cwaltzer]

Hi. you didn't state what version of hmail you are on. some have known issues & crashing under certain circumstances (heavy load especially or seemingly randomly). Knowing the exact errors from hmail logs would be helpful too

Errors:

"ERROR" 2304 "2015-10-22 06:18:09.402" "Severity: 2 (High), Code: HM5032, Source: DALConnection::Execute, Description: MySQL: Incorrect string value: '\xF0\x9F\x99\x8F P...' for column 'metadata_subject' at row 1 (Additional info: INSERT INTO hm_message_metadata (metadata_accountid, metadata_folderid, metadata_messageid, metadata_dateutc, metadata_from, metadata_subject, metadata_to, metadata_cc) VALUES (43, 333, 1039080, '2014-11-14 23:39:28', '"USERNAME REMOVED" <EMAIL ADDRESS REMOVED>', 'FW: "ERROR" 2708 "2015-10-22 06:42:07.443" "Severity: 3 (Medium), Code: HM5042, Source: File::ReadTextFile, Description: An unknown error occurred while reading a text file from disk."
"ERROR" 2708 "2015-10-22 06:42:07.443" "Severity: 1 (Critical), Code: HM5062, Source: IMAPFetch::ReportCriticalError_, Description: ERROR HM10001 - IMAP FETCH: Error when loading MIME message. - C:\Program Files (x86)\hMailServer\Data\DOMAINREMOVED\USER REMOVED\CE\{CE35B637-79F9-4982-B9AD-0E30DBB2AE41}.eml"
"ERROR" 2708 "2015-10-22 06:42:07.459" "Severity: 3 (Medium), Code: HM5042, Source: File::ReadTextFile, Description: An unknown error occurred while reading a text file from disk."

[jimimaseye]

I think the problem is this

MySQL: Incorrect string value: '\xF0\x9F\x99\x8F P...' for column 'metadata_subject' at row 1 (Additional info: INSERT INTO hm_message_metadata

For explanation and resolve, see here: viewtopic.php?f=9&t=27884

I think there was a fix in 5.6 (but dont quote me)

[SorenR]

I think the problem is this

MySQL: Incorrect string value: '\xF0\x9F\x99\x8F P...' for column 'metadata_subject' at row 1 (Additional info: INSERT INTO hm_message_metadata

For explanation and resolve, see here: viewtopic.php?f=9&t=27884

I think there was a fix in 5.6 (but dont quote me)

Nah... Script no good...

Look here for a more permanent fix... hMailServer 5.5.2 contain half the fix (fixed in Version 5.5 - Build 2074), the other half is the proper config and version of MySQL.

viewtopic.php?f=7&t=26860&p=166080&hili ... b4#p166080