workflow don't send email

[centoasa]

I really like this crm, that's why I would like to understand how I can solve this problem. My server uses cpanel, so I've enabled cron so: sh /var/www/crm/cron/vtigercron.sh &>/var/www/crm/cache/logs/cron.log On cron/vtigercron.sh I've setting--> export USE_PHP=/opt/alt/php56/etc/php.ini but doesn't work, so I've change cron in: curl -k "https://crm.100asa.it/cron/vtigercron.php?app_key=code-of-app-key" Workflow works well, but no emails start. SMTP test works well, but all email included in workflow doesn't start. Thank you

[migoi]

have you checked the logfiles for errors?

[centoasa]

system.log @migoi can you help me to understand where is issue?

[migoi]

there is nothing in the logs that jumps into my focus.

Have you run the cron "manually" via console?

[centoasa]

Cron works well, because the list of Cron files are updated. But no email are sent.

[vovpff]

@centoasa check here mail to send https://gitdeveloper.yetiforce.com/index.php?module=Mail&parent=Settings&view=List&block=8&fieldid=104

[centoasa]

Always empty. Maybe folder permission? Now I’ve all folder 755 and files 644 Only Cron files to 775

[vovpff]

@centoasa what is your wofkflow conditions and template. I has same problem with email template buggy value #5278

[vovpff]

@centoasa check /cache/logs/phperror.log file too

[centoasa]

I’ve only system.log

[vovpff]

@centoasa are you checked this file /cache/logs/phperror.log? Cache flder must be in yeti root.

[centoasa]

the only 2 files

[migoi]

log to file is activated in config? is there a workflow taks needed to produce the mails?

[centoasa]

[vovpff]

@centoasa what is path to cron.log and system.log file?

[centoasa]

/home/irnndaeb/yeti/cache/logs

[centoasa]

@migoi there are the standard workflows, all activated:

[vovpff]

@centoasa Can you place here screen of this tab: https://gitdeveloper.yetiforce.com/index.php?module=CronTasks&parent=Settings&view=List&block=15&fieldid=26

[centoasa]

[vovpff]

@centoasa check mails to send option. If mails list empty check your workflow conditions.

Or check your spam folder at mailbox.

[centoasa]

SMTP configuration was OK, so I've received confirmation mail. I've created workkflow for contact-->Every time a record is saved (eg. creating, modifying)-->no condition-->add note to description-->no email maybe here the issue-->

[vovpff]

@centoasa pls explain more detailed what you mean here no condition-->add note to description-->no email

[centoasa]

after I've added a simply note to contact-description, but no email contact have received (for testing is my gmail email) and no email was get by me (admin)

[mariuszkrzaczkowski]

Which version do you use?

[centoasa]

Latest on sourceforge 4.2.0

[mariuszkrzaczkowski]

This bug was already reported and repaired Duplicate #5354

[centoasa]

@mariuszkrzaczkowski I understand, but the strange (also verified on website by @vovpff ) Yeti doesn't send no type of email: only when setting smtp, Yeti send email for confirmation. No other email sent by Yeti. And my installation is 3 days ago with 4.2.0 Maybe be installing again with latest github release, or wait a 4.3?

[mariuszkrzaczkowski]

Check out the developer version ex. 4.2.564

[centoasa]

Just applied #5354 issue still remain

[centoasa]

open a new ticket at 15:08 cron-log at 15:11 say: 2017-11-29 15:09:02 | LBL_WORKFLOW - Start task 2017-11-29 15:09:02 | LBL_WORKFLOW - End task (0 s) So no email from system and/or workflow start, infact also from https://crm.100asa.it/portale/ the password recovery don't work!

[centoasa]

Just add my smtp server on GitDeveloper, wait the time for cron, but also for GitDeveloper Yeti don't send emails! Maybe my smtp with Yeti have problem? Same smtp works well on all others platform erp, ecommerce, client...

[vovpff]

@centoasa are you tried #5354 fix at your system?

[centoasa]

@vovpff 7 hr ago

[mariuszkrzaczkowski]

Not enough detail about the workflow task that sends the mail, there may be many reasons why the

• upload is not working.
• bad or missing recipient,
• problem with SMTP,
• Illegal sender in message
• workflow is queued, which is why cron work 100% correctly
• problem with server configuration

Start by checking all logs so there should be a message if you could not send the message. And you do not know how to buy a support package.

[vovpff]

@mariuszkrzaczkowski I tried to check @centoasa system and found what after modifying any record there are no updates for record tracked. Record labels not updated as configured in Search configuration. Maybe this information helps.

[mariuszkrzaczkowski]

Since the label update handler does not work, it probably does not work for the workflow handler on which the mail is sent. Hard to say without access to the system. This situation should not be. Are system requirements correct?

[centoasa]

upload is not working.-->explain better
bad or missing recipient,-->my gmail email
problem with SMTP,-->configuration is OK, so sent confirmation
Illegal sender in message-->my domain email
workflow is queued, which is why cron work 100% correctly-->explain better
problem with server configuration-->server configuration all is OK (also in ssl)

[centoasa]

deleted all and reinstall all, using php7 (my hope was issue based on php 5.6) None: no type of email sent by crm when create account, create ticket and so on. Only 2 security errors; I've got only 2 emails, one at the moment I've setup smtp and "system warning", so I think it's only workflow have some broken.

@mariuszkrzaczkowski what do you mean with "workflow is queued"? It's correct my workflow configuration?

[mariuszkrzaczkowski]

Mails sent in workflow are queued. When editing a mail record, it is added to the queue and then sent inCRON task .

[centoasa]

addedd #5354 cron works well, but no emails start from yetiforce: for contact, for tickets... the strange is also I've installed vtiger and all emails sent successully I think of abandoning this project

[bpabiszczak]

I think it's a good idea. Good luck!

[centoasa]

I'm still investigating why my Yeti installation doesn't send email: if I setup smtp with my domain account, smtp data being saved, instead if I try to add my external smtp account (pepipost.com or serversmtp.com) I've always: SMTP ERROR: Failed to connect to server: Connection refused (111) SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting I've also setting all permission to 775

[vovpff]

@centoasa problem not in email system. Main problem your system at all. Something going wrong with updates as I see.

[mariuszkrzaczkowski]

SMTP ERROR: Failed to connect to server: Connection refused (111) SMTP connect() failed.

In the logs you can see that there is a problem with the SMTP connection, this is not an error in CRM

@centoasa problem not in email system. Main problem your system at all. Something going wrong with updates as I see.

After the upgrade, the system sometimes requires reconfiguration, eg workflow. In the yetiforce, we have the latest version of the phpmailer library (because older ones contain security bugs), vtiger has old libraries from four years ago (5.2.6). That is why there may be differences.

It's best to test on the latest development version. Specially for you, I tested the functionality of sending an e-mail and works properly. I enclose a video to show how it works.

Your problem requires a programmer analysis, you did not provide sufficient information about the error.

[centoasa]

Ok. Ask me for all the info you need to solve this problem. And if you want to give me more information so I can verify and correct the affected files.

[paula-w]

It’s an individual case that needs to be analyzed on the server where your CRM is installed. We provide this kind of support but unfortunately we charge for this service.

[centoasa]

`2017-12-14 17:34:18 1ePWSg-000AKB-TU <= crm@100asa.it H=(YetiForceCRM) [89.40.172.82]:38479 P=esmtpsa X=TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128 CV=no A=dovecot_login:crm@100asa.it S=2556 id=579e3577a392719121717cd6366bdc66@YetiForceCRM T="Test mail about the mail server configuration." for r.ruberto@100asa.it 2017-12-14 17:57:15 1ePWot-000Tiq-PI <= crm@100asa.it H=(YetiForceCRM) [89.40.172.199]:56968 P=esmtpsa X=TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128 CV=no A=dovecot_login:crm@100asa.it S=2557 id=35cb5a1289dfcecb02a7ba1a059de282@YetiForceCRM T="Test mail about the mail server configuration." for r.ruberto@100asa.it

` The developer of our hosting has verified, but there are no outgoing emails from the server when it triggers the workflow. Out of curiosity, to avoid misunderstanding, is this workflow configuration correct?

[vovpff]

@centoasa problem not in e-mail system. Problem at your installation at all because you system don't track record modifications. If modification not tracked then workflow not started.

[vovpff]

@centoasa try to make workflow what update fields. I think this workflow will be non-working too.

[centoasa]

@vovpff How do you say the system doesn't track changes to records? From where I can detect it?

[vovpff]

@centoasa go to any available account in your system and change account name. At page header name must be updated and at history widget/tab must be added what you changed name of account. In your system there are no changes.