+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: [ solved ] issue for mail converter (/showthread.php?tid=1784)
[ solved ] issue for mail converter - rslemer - 05-03-2020
one mailbox scanner shows me the error
[INFO]: MailScanner - cron task had timedout as it is not completed last time it run- restarting Scanning imap.umbler.com in progress Sorry! Attempt to access restricted file.
We are looking for this file path: modules//.php
We are looking here:
Real file path:
Root dir path: /usr/share/corebos/corebos-master/
how I can solved that?
RE: issue for mail converter - joebordes - 05-03-2020
that error message is usually caused by an SQL error, activate the debug log and see if you can see it. Share that, see if we can understand what is happening
RE: issue for mail converter - rslemer - 05-04-2020
I found that message
2020-05-04T09:15:19-03:00 INFO DB DB >ADODB error Query Failed:insert into vtiger_crmentity (crmid,smcreatorid,smownerid,setype,description,modifiedby,createdtime,modifiedtime,cbuuid) values(?,?,?,?,?,?,?,?,?)::->[1366]Incorrect string value: '\xE9rica,...' for column `NossoCRM`.`vtiger_crmentity`.`description` at row 1
RE: issue for mail converter - joebordes - 05-04-2020
from this discussion https://stackoverflow.com/questions/2108824/mysql-incorrect-string-value-error-when-save-unicode-string-in-django
I understand that the problem is with the database.
Is your database and specifically your vtiger_crmentity.description using UTF-8?
RE: issue for mail converter - rslemer - 05-04-2020
yes, DB and table set UTF-8
there another Error in log
2020-05-04T15:35:23-03:00 DEBUG index > pquery insert into vtiger_troubletickets(ticketid,ticket_no,parent_id,priority,severity,status,category,update_log,hours,days,from_portal,title,solution,from_mailscanner,commentadded) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2020-05-04T15:35:23-03:00 DEBUG index > pquery parameters [149339,TT84855,0,,,Open,,,0,0,0,[Fail2Ban] SSH-issabel: banned 188.87.199.55 from localhost,,1,0]
2020-05-04T15:35:23-03:00 INFO DB DB >ADODB error Query Failed:insert into vtiger_troubletickets(ticketid,ticket_no,parent_id,priority,severity,status,category,update_log,hours,days,from_portal,title,solution,from_mailscanner,commentadded) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)::->[1452]Cannot add or update a child row: a foreign key constraint fails (`NossoCRM`.`vtiger_troubletickets`, CONSTRAINT `fk_1_vtiger_troubletickets` FOREIGN KEY (`ticketid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE)
2020-05-04T15:35:23-03:00 DEBUG index > insertIntoEntityTable HelpDesk vtiger_ticketcf
2020-05-04T15:35:23-03:00 DEBUG index > getTabid HelpDesk
2020-05-04T15:35:23-03:00 DEBUG index < getTabid
020-05-04T15:35:23-03:00 DEBUG index > pquery insert into vtiger_ticketcf(ticketid,cf_748,cf_752,cf_785,cf_787,cf_788,cf_1075) values(?,?,?,?,?,?,?)
2020-05-04T15:35:23-03:00 DEBUG index > pquery parameters [149339,0,,0,,,0]
2020-05-04T15:35:23-03:00 INFO DB DB >ADODB error Query Failed:insert into vtiger_ticketcf(ticketid,cf_748,cf_752,cf_785,cf_787,cf_788,cf_1075) values(?,?,?,?,?,?,?)::->[1452]Cannot add or update a child row: a foreign key constraint fails (`NossoCRM`.`vtiger_ticketcf`, CONSTRAINT `fk_1_vtiger_ticketcf` FOREIGN KEY (`ticketid`) REFERENCES `vtiger_troubletickets` (`ticketid`) ON DELETE CASCADE)
2020-05-04T15:35:23-03:00 DEBUG index > insertIntoTicketCommentTable
2020-05-04T15:35:23-03:00 DEBUG index < insertIntoTicketCommentTable
2020-05-04T15:35:23-03:00 INFO DB DB >TRANS Rolled Back
2020-05-04T15:35:23-03:00 INFO DB DB >TRANS Completed
RE: issue for mail converter - joebordes - 05-04-2020
Apply this change and let me know if it makes a difference
Code:
diff --git a/modules/Settings/MailScanner/core/MailScannerAction.php b/modules/Settings/MailScanner/core/MailScannerAction.php
index 10ce017d9..969e39fd7 100644
--- a/modules/Settings/MailScanner/core/MailScannerAction.php
+++ b/modules/Settings/MailScanner/core/MailScannerAction.php
@@ -67,6 +67,10 @@ class Vtiger_MailScannerAction {
}
}
+ public function cleanUTF8($value) {
+ return function_exists('iconv') ? @iconv('UTF-8', 'UTF-8//IGNORE', $value) : $value;
+ }
+
/**
* Create/Update the information of Action into database.
*/
@@ -238,8 +242,8 @@ class Vtiger_MailScannerAction {
public function __CreateTicket($mailscanner, $mailrecord) {
global $adb;
// Prepare data to create trouble ticket
- $usetitle = $mailrecord->_subject;
- $description = $mailrecord->getBodyText();
+ $usetitle = $this->cleanUTF8($mailrecord->_subject);
+ $description = $this->cleanUTF8($mailrecord->getBodyText());
// There will be only on FROM address to email, so pick the first one
$fromemail = $mailrecord->_from[0];
@@ -338,9 +342,9 @@ class Vtiger_MailScannerAction {
$focus->column_fields['parent_type'] = $module;
$focus->column_fields['activitytype'] = 'Emails';
$focus->column_fields['parent_id'] = "$linkfocus->id@$relid|";
- $focus->column_fields['subject'] = $mailrecord->_subject;
+ $focus->column_fields['subject'] = $this->cleanUTF8($mailrecord->_subject);
- $focus->column_fields['description'] = $mailrecord->getBodyHTML();
+ $focus->column_fields['description'] = $this->cleanUTF8($mailrecord->getBodyHTML());
$focus->column_fields['assigned_user_id'] = $linkfocus->column_fields['assigned_user_id'];
$focus->column_fields['date_start'] = date('Y-m-d', $mailrecord->_date);
$focus->column_fields['email_flag'] = 'MAILSCANNER';RE: issue for mail converter - rslemer - 05-05-2020
It's is very strange situation
e-mails originally sent to a mailbox in gMail and mail converter read and created ticket, without a problem
When I change destination to another mail server ( umbler ) and changed mail scanner rules, problem occurs
I try include this path, and not solved
I completed removed mailbox, scanner rules, and recreated them
Until now, scanner woks