Saludos comunidad, en nuestro negocio utilizamos SuiteCRM hace algunos años, en este momento necesito dar un salto de calidad habilitando la funcionalidad de envíos de correo, luego de investigar y configurar todo como corresponde me encuentro con que los correos programados (tanto por campaña como por workflows) nunca se envían, pero si se envían cuando hago las pruebas, deberia tener que ver con cron pero los workflows de modificar campos o agregar tareas en oportunidades si funcionan, voy a detallar mi entorno y mis configuraciones para que me puedan ayudar mejor.
Actualmente corro Suitecrm Version 7.10.2 en un hosting shared
Algunos Workflows se inician atraves de cambios en el momento de grabar, no atraves del “scheduled job” que arranca desde cron. Entonces puedes tener esos funcionando, pero sin estar todavía bien tu configuración de cron.
Ve en Admin / Scheduler, entrando en cada Job para ver que tal esta el “Last ran successfully at”
Tambien puedes verificar en los logs si el cron esta arrancando, i si hay algun error
Hola pqr, gracias por tu respuesta, te paso el reporte:
Todos los Scheduler, en el campo “Last Successful Run” figura “Never”
Por otro lado te paso unas lineas de error_log (sería php_errors.log? ):
[20-Apr-2018 09:53:00 America/Argentina/Buenos_Aires] PHP Warning: Declaration of SchedulersViewDetail::_getModuleTitleListParam() should be compatible with SugarView::_getModuleTitleListParam($browserTitle = false) in /home/crm2dottransfers/public_html/modules/Schedulers/views/view.detail.php on line 69
[20-Apr-2018 09:53:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught Exception: cron.php is CLI only. in /home/crm2dottransfers/public_html/include/utils.php:1773
Stack trace:
#0 /home/crm2dottransfers/public_html/cron.php(49): sugar_die('cron.php is CLI...')
#1 {main}
thrown in /home/crm2dottransfers/public_html/include/utils.php on line 1773
[20-Apr-2018 09:53:04 America/Argentina/Buenos_Aires] PHP Notice: Undefined index: doc_type in /home/crm2dottransfers/public_html/include/SugarFields/Fields/File/SugarFieldFile.php on line 153
[20-Apr-2018 09:53:04 America/Argentina/Buenos_Aires] PHP Warning: exec() has been disabled for security reasons in /home/crm2dottransfers/public_html/include/utils.php on line 449
[20-Apr-2018 09:53:07 America/Argentina/Buenos_Aires] PHP Warning: Declaration of SchedulersViewDetail::_getModuleTitleListParam() should be compatible with SugarView::_getModuleTitleListParam($browserTitle = false) in /home/crm2dottransfers/public_html/modules/Schedulers/views/view.detail.php on line 69
[20-Apr-2018 09:54:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught Exception: cron.php is CLI only. in /home/crm2dottransfers/public_html/include/utils.php:1773
Stack trace:
#0 /home/crm2dottransfers/public_html/cron.php(49): sugar_die('cron.php is CLI...')
#1 {main}
thrown in /home/crm2dottransfers/public_html/include/utils.php on line 1773
[20-Apr-2018 09:54:14 America/Argentina/Buenos_Aires] PHP Warning: exec() has been disabled for security reasons in /home/crm2dottransfers/public_html/include/utils.php on line 449
[20-Apr-2018 09:55:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught Exception: cron.php is CLI only. in /home/crm2dottransfers/public_html/include/utils.php:1773
Stack trace:
#0 /home/crm2dottransfers/public_html/cron.php(49): sugar_die('cron.php is CLI...')
#1 {main}
thrown in /home/crm2dottransfers/public_html/include/utils.php on line 1773
[20-Apr-2018 09:55:03 America/Argentina/Buenos_Aires] PHP Warning: Declaration of SchedulersViewDetail::_getModuleTitleListParam() should be compatible with SugarView::_getModuleTitleListParam($browserTitle = false) in /home/crm2dottransfers/public_html/modules/Schedulers/views/view.detail.php on line 69
[20-Apr-2018 09:56:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught Exception: cron.php is CLI only. in /home/crm2dottransfers/public_html/include/utils.php:1773
Stack trace:
#0 /home/crm2dottransfers/public_html/cron.php(49): sugar_die('cron.php is CLI...')
#1 {main}
thrown in /home/crm2dottransfers/public_html/include/utils.php on line 1773
[20-Apr-2018 09:57:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught Exception: cron.php is CLI only. in /home/crm2dottransfers/public_html/include/utils.php:1773
Stack trace:
#0 /home/crm2dottransfers/public_html/cron.php(49): sugar_die('cron.php is CLI...')
#1 {main}
thrown in /home/crm2dottransfers/public_html/include/utils.php on line 1773
[20-Apr-2018 09:58:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught Exception: cron.php is CLI only. in /home/crm2dottransfers/public_html/include/utils.php:1773
Stack trace:
#0 /home/crm2dottransfers/public_html/cron.php(49): sugar_die('cron.php is CLI...')
#1 {main}
thrown in /home/crm2dottransfers/public_html/include/utils.php on line 1773
[20-Apr-2018 09:59:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught Exception: cron.php is CLI only. in /home/crm2dottransfers/public_html/include/utils.php:1773
Stack trace:
#0 /home/crm2dottransfers/public_html/cron.php(49): sugar_die('cron.php is CLI...')
#1 {main}
thrown in /home/crm2dottransfers/public_html/include/utils.php on line 1773
[20-Apr-2018 09:59:22 America/Argentina/Buenos_Aires] PHP Notice: Undefined index: record_id in /home/crm2dottransfers/public_html/modules/AOW_WorkFlow/aow_utils.php on line 598
[20-Apr-2018 09:59:29 America/Argentina/Buenos_Aires] PHP Notice: Undefined index: num_months in /home/crm2dottransfers/public_html/modules/iCals/HTTP_WebDAV_Server_iCal.php on line 217
[20-Apr-2018 10:00:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught Exception: cron.php is CLI only. in /home/crm2dottransfers/public_html/include/utils.php:1773
Stack trace:
#0 /home/crm2dottransfers/public_html/cron.php(49): sugar_die('cron.php is CLI...')
#1 {main}
thrown in /home/crm2dottransfers/public_html/include/utils.php on line 1773
[20-Apr-2018 10:01:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught Exception: cron.php is CLI only. in /home/crm2dottransfers/public_html/include/utils.php:1773
Stack trace:
#0 /home/crm2dottransfers/public_html/cron.php(49): sugar_die('cron.php is CLI...')
#1 {main}
thrown in /home/crm2dottransfers/public_html/include/utils.php on line 1773
Log de suitecrm.log:
Thu Apr 19 17:58:15 2018 [28569][1][ERROR] Unable to get proper side for link project_name_link
Thu Apr 19 17:58:15 2018 [28569][1][ERROR] Unable to get proper side for link project_name_link
Thu Apr 19 21:58:15 2018 [24588][1][ERROR] Unable to get proper side for link project_name_link
Thu Apr 19 21:58:15 2018 [24588][1][ERROR] Unable to get proper side for link project_name_link
Fri Apr 20 01:58:36 2018 [11600][1][ERROR] Unable to get proper side for link project_name_link
Fri Apr 20 01:58:36 2018 [11600][1][ERROR] Unable to get proper side for link project_name_link
Fri Apr 20 05:59:40 2018 [25786][1][ERROR] Unable to get proper side for link project_name_link
Fri Apr 20 05:59:40 2018 [25786][1][ERROR] Unable to get proper side for link project_name_link
Fri Apr 20 09:31:02 2018 [9593][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-03-26 20:44:30 from user format m/d/Y h:ia failed
Fri Apr 20 09:31:02 2018 [9593][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-04-20 12:31:02 from user format m/d/Y h:ia failed
Fri Apr 20 09:31:02 2018 [9593][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-03-26 20:44:30 from user format m/d/Y h:ia failed
Fri Apr 20 09:31:02 2018 [9593][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-04-20 12:31:02 from user format m/d/Y h:ia failed
Fri Apr 20 09:38:01 2018 [19076][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] Unable to load related bean by id
Fri Apr 20 09:38:02 2018 [19105][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][FATAL] Exception handling in /home/crm2dottransfers/public_html/include/MVC/Controller/SugarController.php:402
Fri Apr 20 09:38:02 2018 [19105][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][FATAL] Exception in Controller: Subpanel was not defined
Fri Apr 20 09:38:02 2018 [19105][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][FATAL] backtrace:
#0 /home/crm2dottransfers/public_html/include/SubPanel/SubPanelViewer.php(61): sugar_die('Subpanel was no...')
#1 /home/crm2dottransfers/public_html/include/MVC/Controller/SugarController.php(1081): require_once('/home/crm2dottr...')
#2 /home/crm2dottransfers/public_html/include/MVC/Controller/SugarController.php(465): SugarController->handleActionMaps()
#3 /home/crm2dottransfers/public_html/include/MVC/Controller/SugarController.php(373): SugarController->process()
#4 /home/crm2dottransfers/public_html/include/MVC/SugarApplication.php(109): SugarController->execute()
#5 /home/crm2dottransfers/public_html/index.php(52): SugarApplication->execute()
#6 {main}
Fri Apr 20 09:49:27 2018 [1887][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-04-13 20:51:39 from user format m/d/Y h:ia failed
Fri Apr 20 09:49:27 2018 [1887][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-04-20 12:49:27 from user format m/d/Y h:ia failed
Fri Apr 20 09:49:27 2018 [1887][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-04-13 20:51:39 from user format m/d/Y h:ia failed
Fri Apr 20 09:49:27 2018 [1887][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-04-20 12:49:27 from user format m/d/Y h:ia failed
Fri Apr 20 09:53:04 2018 [7085][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] Unable to load related bean by id
Fri Apr 20 09:53:05 2018 [7127][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][FATAL] Exception handling in /home/crm2dottransfers/public_html/include/MVC/Controller/SugarController.php:402
Fri Apr 20 09:53:05 2018 [7127][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][FATAL] Exception in Controller: Subpanel was not defined
Fri Apr 20 09:53:05 2018 [7127][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][FATAL] backtrace:
#0 /home/crm2dottransfers/public_html/include/SubPanel/SubPanelViewer.php(61): sugar_die('Subpanel was no...')
#1 /home/crm2dottransfers/public_html/include/MVC/Controller/SugarController.php(1081): require_once('/home/crm2dottr...')
#2 /home/crm2dottransfers/public_html/include/MVC/Controller/SugarController.php(465): SugarController->handleActionMaps()
#3 /home/crm2dottransfers/public_html/include/MVC/Controller/SugarController.php(373): SugarController->process()
#4 /home/crm2dottransfers/public_html/include/MVC/SugarApplication.php(109): SugarController->execute()
#5 /home/crm2dottransfers/public_html/index.php(52): SugarApplication->execute()
#6 {main}
Fri Apr 20 09:59:29 2018 [15877][1][ERROR] Unable to get proper side for link project_name_link
Fri Apr 20 09:59:29 2018 [15877][1][ERROR] Unable to get proper side for link project_name_link
Fri Apr 20 10:00:35 2018 [17415][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-04-02 15:09:27 from user format m/d/Y h:ia failed
Fri Apr 20 10:00:35 2018 [17415][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-04-20 13:00:35 from user format m/d/Y h:ia failed
Fri Apr 20 10:00:35 2018 [17415][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-04-02 15:09:27 from user format m/d/Y h:ia failed
Fri Apr 20 10:00:35 2018 [17415][6681f621-dc57-10a9-a47b-5a1c6bbaaf60][ERROR] fromUser: Conversion of 2018-04-20 13:00:35 from user format m/d/Y h:ia failed
A simple vista noto que en error_log muestra “sugar_die(‘cron.php is CLI…’)” como si se estuviese tratando de ejecutar cron desde un browser o desde wget, pero lo estoy ejecutando con este comando en cronjob:
Let me answer in English, it’s much faster for me, and I am sure you can understand. ou can continue replying in Spanish, no problem with that.
Are you sure you didn’t set up some of these web services to call cron.php, like easycron.com? Or some other program calling it with “curl”? Because that would explain the error in the logs.
Also, there can be more than one crontab in your system, you can list them like this:
crontab -l -u someuser
crontab -l -u root
etc
Try removing the line from all crontabs and see if that CLI error keeps coming up.
Then, you might also want to check syslog to see if there’s any problem with your command-line in cron.
[20-Apr-2018 11:42:01 America/Argentina/Buenos_Aires] PHP Warning: exec() has been disabled for security reasons in /home/crm2dottransfers/public_html/include/utils.php on line 449
[20-Apr-2018 11:42:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught InvalidArgumentException: Invalid CRON field value Friday as position 4 in /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php:123
Stack trace:
#0 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php(105): Cron\CronExpression->setPart(4, 'Friday')
#1 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php(84): Cron\CronExpression->setExpression('16 50 15 12 Fri...')
#2 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php(72): Cron\CronExpression->__construct('16 50 15 12 Fri...', Object(Cron\FieldFactory))
#3 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/AOR_Scheduled_Reports.php(179): Cron\CronExpression::factory('16 50 15 12 Fri...')
#4 /home/crm2dottransfers/public_html/modules/Schedulers/_AddJobsHere.php(729): AOR_Scheduled_Reports->shouldRun(Object(DateTime))
#5 /home/crm2dottransfers/public_html/modules/SchedulersJobs/Sc in /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php on line 123
[20-Apr-2018 11:43:01 America/Argentina/Buenos_Aires] PHP Warning: exec() has been disabled for security reasons in /home/crm2dottransfers/public_html/include/utils.php on line 449
[20-Apr-2018 11:43:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught InvalidArgumentException: Invalid CRON field value Friday as position 4 in /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php:123
Stack trace:
#0 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php(105): Cron\CronExpression->setPart(4, 'Friday')
#1 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php(84): Cron\CronExpression->setExpression('16 50 15 12 Fri...')
#2 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php(72): Cron\CronExpression->__construct('16 50 15 12 Fri...', Object(Cron\FieldFactory))
#3 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/AOR_Scheduled_Reports.php(179): Cron\CronExpression::factory('16 50 15 12 Fri...')
#4 /home/crm2dottransfers/public_html/modules/Schedulers/_AddJobsHere.php(729): AOR_Scheduled_Reports->shouldRun(Object(DateTime))
#5 /home/crm2dottransfers/public_html/modules/SchedulersJobs/Sc in /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php on line 123
[20-Apr-2018 11:43:07 America/Argentina/Buenos_Aires] PHP Warning: Declaration of SugarWidgetSubPanelEditRoleButton::displayHeaderCell(&$layout_def) should be compatible with SugarWidgetField::displayHeaderCell($layout_def) in /home/crm2dottransfers/public_html/include/generic/SugarWidgets/SugarWidgetSubPanelEditRoleButton.php on line 75
[20-Apr-2018 11:43:07 America/Argentina/Buenos_Aires] PHP Warning: Declaration of SugarWidgetSubPanelEditRoleButton::displayList(&$layout_def) should be compatible with SugarWidgetField::displayList($layout_def) in /home/crm2dottransfers/public_html/include/generic/SugarWidgets/SugarWidgetSubPanelEditRoleButton.php on line 75
[20-Apr-2018 11:43:42 America/Argentina/Buenos_Aires] PHP Warning: Declaration of SugarWidgetSubPanelEditRoleButton::displayHeaderCell(&$layout_def) should be compatible with SugarWidgetField::displayHeaderCell($layout_def) in /home/crm2dottransfers/public_html/include/generic/SugarWidgets/SugarWidgetSubPanelEditRoleButton.php on line 75
[20-Apr-2018 11:43:42 America/Argentina/Buenos_Aires] PHP Warning: Declaration of SugarWidgetSubPanelEditRoleButton::displayList(&$layout_def) should be compatible with SugarWidgetField::displayList($layout_def) in /home/crm2dottransfers/public_html/include/generic/SugarWidgets/SugarWidgetSubPanelEditRoleButton.php on line 75
[20-Apr-2018 11:44:01 America/Argentina/Buenos_Aires] PHP Warning: exec() has been disabled for security reasons in /home/crm2dottransfers/public_html/include/utils.php on line 449
[20-Apr-2018 11:44:01 America/Argentina/Buenos_Aires] PHP Fatal error: Uncaught InvalidArgumentException: Invalid CRON field value Friday as position 4 in /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php:123
Stack trace:
#0 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php(105): Cron\CronExpression->setPart(4, 'Friday')
#1 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php(84): Cron\CronExpression->setExpression('16 50 15 12 Fri...')
#2 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php(72): Cron\CronExpression->__construct('16 50 15 12 Fri...', Object(Cron\FieldFactory))
#3 /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/AOR_Scheduled_Reports.php(179): Cron\CronExpression::factory('16 50 15 12 Fri...')
#4 /home/crm2dottransfers/public_html/modules/Schedulers/_AddJobsHere.php(729): AOR_Scheduled_Reports->shouldRun(Object(DateTime))
#5 /home/crm2dottransfers/public_html/modules/SchedulersJobs/Sc in /home/crm2dottransfers/public_html/modules/AOR_Scheduled_Reports/lib/Cron/CronExpression.php on line 123
Puedes identificar como continuar según este error?
Saludos comunidad, el problema (de enviar notificaciones del sistema) esta solucionado! :cheer:
Cuando hice la modificacion en cron, con el registro de la respuesta anterior comenzaron a funcionar las tareas pero seguía sin poder enviar mails, al revisar el log encontre lo siguiente:
Thu Mar 29 11:10:02 2018 [15540][1][FATAL] Email Reminder: error sending e-mail (method: smtp), (error: SMTP Error: data not accepted.SMTP server error: DATA END command failed Detail: 5.7.60 SMTP; Client does not have permissions to send as this sender [RO1P215MB0393.LAMP215.PROD.OUTLOOK.COM]
SMTP code: 550)
Este error hace referencia a que el servidor smtp, en mi caso outlook365, no permitía enviar los emails del sistema, esto se debe a que muchos servidores smtp no permiten enviar un correo a nombre de otro y suite lo que hace es enviar la notificacion a nombre del propio usuario, por lo tanto lo que hice fue cambiar a gmail y ya logré enviar los mensajes de sistema, ahora estoy trabajando con los mails de campañas, considero que outlook365 no deberia tener problemas ya que no se va a suplantar ninguna identidad.
En cuanto tenga novedades al respecto o logs vuelvo.
parece que lo han solucionado hace algunos meses pero el codigo que esta en SuiteCRM es anterior. La verdad es que no sé exactamente que es esto, o como podriamos arreglarlo… ?