Mass Email doesn't work

[jorgeyoma]

Hi.
I'm using EspoCrm v 4.2.7

I created Campaign but email sending stills in "Pending" status. This is the trouble shooting I did:
Crons:

Check Group Email Accounts

Check Group Email Accounts

Active

*/4 * * * *

Send Mass Emails

Send Mass Emails

Active

15 * * * *

1. Check if Sent Test works. If does't work then check if system SMTP settings are correct. DONE, OK.
2. Check if you have setup cron for your system, DONE, OK.
3. Check if you have Check Group Email Accounts Scheduled Job and it is Active. DONE, OK.
4. Check if there are something in Log. Last Success Log is on 11 Sep 22:24.

What if Tracking URLs has wrong url that does not lead to your crm.

Check 'siteUrl' paramater in data/config.php file. It mube be set as URL of your EspoCRM accessible from the external world.DONE. URL changed on September and I corrected today.

Can you tell me how can I restore the mass email?

Thanks.

[yuri]

Hi,

Thanks for nice formed reporting. Seems cron is not running, does it? Can you open Administration > Scheduled Jobs > top-right dropdown > Jobs. Are there any new entries?

[jorgeyoma]

Hi,

Thanks for nice formed reporting. Seems cron is not running, does it? Can you open Administration > Scheduled Jobs > top-right dropdown > Jobs. Are there any new entries?

Hi Yurikuzn.
The last report is from September.

Send Email Notifications

Success

11 Sep 22:24

3

11 Sep 22:24

What I did the was to create a subdomain to use Espocrm but I didn't change the folder. Before my url was https;//negociactivos.cl/na_espoCrm and now I use http://espocrm.negociactivos.cl/. The folder stills /public_html/na_espoCrm.

I checked the cron logs and this is the last one I found.
Nov 16 20:57:01 srv01 CROND[8267]: (negociactivos) CMD (/usr/local/bin/php -f /home/negociactivos/public_html/na_espoCrm/cron.php > /dev/null 2>&1)

Is from November. I think I upgraded EspoCrm on that date.I think that before the cron job executed but didn't work as I have the url wrong. Please confirm me that the url is http://espocrm.negociactivos.cl/ or http://espocrm.negociactivos.cl. But since the update the cron is not executing.

B/R

[yuri]

You need to setup cron in your system. It uses previous path and you need to define new. "crontab -e" command in linux systems.

[jorgeyoma]

You need to setup cron in your system. It uses previous path and you need to define new. "crontab -e" command in linux systems.

Hi Yurikuzn
I got lost here. In september I didn't change the path. I just created a subdomain that points to the same path.Today I deleted the cronjob and created again with EspoCrm code and it still doesn't work.
Note: Add this line to the crontab file to run Espo Scheduled Jobs:
* * * * * /usr/local/bin/php -f /home/negociactivos/public_html/na_espoCrm/cron.php > /dev/null 2>&1

I use cPanel to enter the cronjobs,
I exectuted crontab-e I got this message:

/home/negociactivos/public_html/na_espoCrm$ crontab -e
Error opening terminal: unknown.
/usr/bin/crontab: "pico" exited with status 1

Just to know, will a reinstall fix this?

Thanks.

[yuri]

You can configure cron though your cpanel.

[jorgeyoma]

You can configure cron though your cpanel.

Well, I did it and it didn't work. I decided to install a new Espo. The Cron Issue is gone, scheduled jobs are working ok. I set up the emails (personal and group) and tested them. I can also send emails with my I accounts. Everything seems to work Ok, I'll know when I resend the Campaing.

Thanks.

[bill1977]

I have the exact same problem. I upgraded from a previous version. Test mail works fine, love the product but stuck on this.

I ran crontab -e -u www-data

crontab -l now reads as * * * * * php -f /var/www/espocrm/cron.php > /dev/null 2>&1

but I still can't get mass mail to work.

Any thoughts?

[yuri]

Need information what you have in logs.

[bill1977]

What other logs do you need?

root@espocrm ~# grep CRON /var/log/syslog

Nov 28 07:09:01 espocrm CRON[8442]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 07:16:01 espocrm CRON[8503]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)

Nov 28 07:39:01 espocrm CRON[8599]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 08:09:01 espocrm CRON[8779]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 08:16:01 espocrm CRON[8864]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)

Nov 28 08:39:01 espocrm CRON[8961]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 08:49:01 espocrm CRON[9045]: (root) CMD (test -x /usr/sbin/cron-apt && /usr/sbin/cron-apt)

Nov 28 09:09:01 espocrm CRON[9154]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 09:16:01 espocrm CRON[9216]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)

Nov 28 09:32:48 espocrm cron-apt: CRON-APT RUN [/etc/cron-apt/config]: Mon Nov 28 08:49:01 ICT 2016

Nov 28 09:32:48 espocrm cron-apt: CRON-APT SLEEP: 2616, Mon Nov 28 09:32:37 ICT 2016

Nov 28 09:32:48 espocrm cron-apt: CRON-APT ACTION: 5-install

Nov 28 09:32:48 espocrm cron-apt: CRON-APT LINE: /usr/bin/apt-get -o quiet=1 dist-upgrade -q -y -o APT::Get::Show-Upgraded=true -o Dir::Etc::sourcelist=/etc/apt/sources.list.d/security.sources.list -o Dir::Etc::sourceparts=nonexistent -o DPkg::Options::=--force-confdef -o DPkg::Options::=--force-confold

Nov 28 09:39:01 espocrm CRON[9868]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 10:09:01 espocrm CRON[10047]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 10:16:01 espocrm CRON[10109]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)

Nov 28 10:39:01 espocrm CRON[10231]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 11:09:01 espocrm CRON[10393]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 11:16:01 espocrm CRON[10478]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)

Nov 28 11:39:01 espocrm CRON[10588]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 12:09:01 espocrm CRON[10777]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 12:16:01 espocrm CRON[10867]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)

Nov 28 12:39:01 espocrm CRON[10965]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 13:09:01 espocrm CRON[11148]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 13:16:01 espocrm CRON[11215]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)

Nov 28 13:39:01 espocrm CRON[11336]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 14:09:01 espocrm CRON[11521]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 14:16:01 espocrm CRON[11588]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)

Nov 28 14:39:01 espocrm CRON[11686]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 15:09:01 espocrm CRON[11956]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 15:16:01 espocrm CRON[12060]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)

Nov 28 15:39:01 espocrm CRON[12203]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 16:09:01 espocrm CRON[12443]: (root) CMD (  [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)

Nov 28 16:16:01 espocrm CRON[12511]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)

[yuri]

Can you check all items the same way as it's done in the initial post in this thread.

[bill1977]

I did that before I posted originally.

[bill1977]

I just set up a new test campaign there, new target list, new mass mail. Nothing.

[yuri]

Check if there is anything in Administration > Scheduled Jobs > Send Mass Emails > Log

[iscon]

Put your cron manually (via nano or such) into /etc/crontab and add the user: * * * * * root php -f /var/www/espocrm/cron.php > /dev/null 2>&1