Mass Emails - Queue?

[TomV]

Unfortunately, my Mass Emails don't go out and the "Date Start" time passes without anything is sent. I tried:

1. Mass Email Test Button - That works, the emails go out fine and contact fields are mapped good.
2. My Campaign status is "Active"
3. My Mass Email status is "Pending" (why is there no "Active"? I can only select "Draft" or "Pending"...)
4. I still worry about the cron and even asked for enhancement for better debugging. Still not 100% sure it's working ok; although the "red warning that I should configure cron" has disappeared.
5. But another clue is that "Queue Items" stay empty. The docs dont explain anything about Queue Items. When should items appear in that Queue? After cron execution or when creating/updating the Mass Email?
6. The same doc writes "Create new Campaign with a status Email or Newsletter.", but I have only status Planning, Active, Inactive and Complete...?

What is the likely issue?

[tanya]

Hello,
go to Scheduled Jobs > Send Mass Emails - is this job active? What is in Log of this job?

[TomV]

Thanks for quick response... The "Scheduled Jobs" panel shows:

Job: Send Mass Emails
Status: Active
Name: Send Mass Emails
Scheduling: 15 * * * *
Log

Success	20 Mar 10:16

Created 23 Feb 20:39 » System


Note, there is no Log entry for today (March 23), should it be?

[tanya]

According to scheduling this job has to be run every hour.
Next to Create Scheduled Job button you could view all Jobs.
When was the last successful execution (of any jobs)?

[TomV]

That gives me:

Check Group Email Accounts Pending Today 11:34 1 Today 11:32
Send Email Reminders Pending Today 11:34 1 Today 11:32
Send Email Notifications Pending Today 11:34 1 Today 11:32
Auth Token Control Pending Today 11:36 1 Today 11:32
Check for New Version (job) Pending Tomorrow 04:06 1 Today 11:32
Check Group Email Accounts Success Today 11:20 1 Today 11:18
Send Email Reminders Success Today 11:20 1 Today 11:18
Send Email Notifications Success Today 11:20 1 Today 11:18
Send Mass Emails Pending Today 12:15 1
Auth Token Control Success Today 11:24 1 Today 11:18
Dummy Pending Today 13:01 1 Today 09:33
Check for New Version Pending Tomorrow 06:15 1 Today 09:33
Send Mass Emails Success Today 10:15 1 Today 09:33

[tanya]

seams cron is working, but why so long delay from previous email sending?
espocrm log is clear (data/logs)?
what espocrm version do you use?

[TomV]

Earlier this afternoon, we found the issue. We are running Espo based in 3 Docker containers (nginx, php, mysql). The cron job was a bit unstable running in the php container as it did not boot automatically. After each new build it was a hit or miss if cron was running or not..

We have solved it now in a Dockerfile:

# ** SET UP CRON
# Espocrm cron configuration from file in ./php/cron
RUN apt-get update && apt-get install -y cron
# create cron log
RUN touch /var/log/cron.log
RUN chown www-data:www-data /var/log/cron.log
# Make crontab file available
COPY ./cron/espo.crontab /etc/cron.d/espo.crontab
# Load the crontab Dockerfile
RUN crontab -u www-data /etc/cron.d/espo.crontab

# ** START both cron **AND** php
CMD service cron start >> /var/log/cron.log; php-fpm --nodaemonize

And the espo.crontab file:

* * * * * /usr/local/bin/php -f /usr/share/nginx/html/cron.php >> /var/log/cron.log 2>&1

If you would be interested, we are happy to share the Dockerfiles and configuration with others, as it's been an interesting learning curve with a result we are very happy with

Have a good day! ))

[SteveS]

I would certainly be interested in seeing the Dockerfiles and configuration. Sounds like you have done some good work to overcome any issues, and I wouldn't want to have to repeat that.

Thanks.