New installation emails not working

📦 Install & Upgrade Help
1

I setup a new install on a linode vps ( Ubuntu 14.04)
All looks good except auto send email when creating users, I’m guessing it’s the same thing for other automated emails.

I setup an exchange 365 mail acount tant sends without issues.

I added this line :

 *  *  *  *  cd /var/www/mysite/public_html;php -f cron.php> /dev/nell 2>&1

to the cron.php but I don’t see any changes, does this line have to be placed anywhere in perticular ??

I’m also seeing errors in the sugarcrm.log file :

Sat Mar 26 22:35:39 2016 [8756][-none-][FATAL]  Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = 'ACLActions' AND aow_workflow.status = 'Active' AND (aow_workflow.run_when = 'Always' OR aow_workflow.run_when = 'On_Save' OR aow_workflow.run_when = 'Create') AND aow_workflow.deleted = 0 : MySQL error 1146: Table 'suitecrm.aow_workflow' doesn't exist

Can anyone point me in the right direction here ?

thanks

Jeff

2

So I read alot on Crontab and I’m trying something else with I think is a better step Forward.

This is my understanding of what needs to happen:

The crontab line has to create a crontab job with this code “* * * * cd /var/www/mysite/public_html;php -f cron.php> /dev/nell 2>&1”

to create de job:

$ sudo crontab -e
choose the editor
Paste de suitecrm crontab line at the bottom
Save

alright now … still nothing is happening
I see the cron job in the syslog. but I’m not seing any emails in my exchange

Thanks for the help

3

UPDATE:

  • found that in the upgrade Wizard, the 1st step is a system check witch showed some folders with root:root privileges ( modules, cache, and … forgot witch other one) So I fixed that
  • (Repair - Quick Repair) I see a lineAudit table for AOW_WorkFlows already exists. skipping… and AOW_Processed not Audit Enabled I tought this would fix my tables
  • created a new user hopping the email would be sent… but that didn’t happen

jeffrey