Hello All,
I am trying to get the report scheduler working. Iām not sure where to start (for you to offer assistance). Iāve got the report(s) built, and scheduled. Iāve got the line provided in the documentation added to CRON, and CRON is running. However the report is never listed as run.
CRON is listing an āInfoā in syslog that says MTA Not Found, but my googling leads me to believe that itās not relevant to this issue. But I could be wrong there. Do I need Postfix on my server?
Please let me know what you need and Iāll provide anything I can to help you help me.
youāll need the cronjob to be working. Your tasks inside the scheduler / cronjobs show as being executed?
And then, youāll need to have a system outbound email setup and working.
Do the assignment / forgot password emails work?
Do emails from a workflow work?
What you can do to test both components: Build a workflow, that is triggered only by the scheduler and sends an email.
Does the report itself work? Do you see data there?
And eventually: There have been quite some bug fixes since 8.5.
If all the above is working, you could go through the release notes and check all the bug fixes and see whether there has been sth. along the lines of your described issue.
Hi Bastian,
As far as I can tell, CRON is running and the tasks are being executed. I believe based on the fact that CRON is asking for an MTA, that thereās data present (aka, running). Does Suite need an MTA in order to send emails? See the below screenshot:
Additionally, after creating a workflow, and then looking through the scheduler, it appears nothing in the scheduler has ever run. Every record in the scheduler has āneverā listed in the ālast successful runā field.
The cron jobs produce some output and the system wants to send it to you.
Could you execute the cron job manually from the CLI to see what the output is?
If none of them ever ran, there is an issue around the cron / scheduler system.
Yes, via the command line is correct (sorry for the abbreviation. CLI = Command Line Interface - so exactly like you suggested).
If you do:
cd /SuiteCRM Install Path/public/legacy
sudo -u www-data php -f cron.php
Your cron job should be executed as the www-data user (youād need to change it to your webserver user, if its different).
It should execute without any print outs.
Afterwards, in your scheduler, you should see in the task: Process Workflow Tasks
the execution in the āJob Logā subpanel.
Hi Bastian,
Thereās light at the end of the tunnel! Running it manually via the CLI, as you described, worked. I received about 140 emails based off of my workflow and email template (which I obviously need to refine). But it worked.
If youāre executing the cron as a user without write permissions to the CRM cache folder, itāll fail and never show as executed.
So www-data is a safe bet on most servers. Youād have to adjust it according to your server setup to match the webserver user.
Bastian,
Iām not quite sure how to say thank you, but Thank You! Iām not sure whatās different between your cron job and mine, but when I took yours, adjusted the file path, and then cut and pasted into my cron, it worked and has been working since.
