Mass Mail not Sending mails

[lerg57]

I want to send Mass emails
have installed EC v4.8.1 in a AWS EC2 instance.

In Scheduled Jobs says:


Note: Add this line to the crontab file to run Espo Scheduled Jobs:
* * * * * cd /opt/bitnami/apps/espocrm/htdocs; /bitnami/lampstack-linux-x64/output/php/bin/php -f cron.php > /dev/null 2>&1

Please advise where I have to put the previous line:

- Check Group Email Accounts / Scheduling
- Send Mass Emails / Scheduling
- CRON.PHP thru SSH

Thanks

Luis R

[tarasm]

Please login via ssh and use this command to add a job for crontab:

sudo crontab -e -u daemon

[lerg57]

Dear Tarasm,
Thank you very much for the help.

After typing thru SSH ;

sudo crontab -e -u daemon

I receive this msg:

The user daemon cannot use this program (cronab)

The users I have available are : bitnami & root

I'm wandering if I have to add this line :

[I]* * * * * cd /opt/bitnami/apps/espocrm/htdocs; /bitnami/lampstack-linux-x64/output/php/bin/php -f cron.php > /dev/null 2>&1, [/I]

a) to crontab / http://bit.ly/2v7LwXc (Image)

b) To Scheduled Jobs -> Check Group Email Accounts -> Scheduling / http://bit.ly/2v7VYht (Image)

c) To Scheduled Jobs -> Send Mass Emails -> -> Scheduling / http://bit.ly/2v7W7S3 (Image)

Thank you

Luis R

[tarasm]

Then try to add for the bitmani user. Steps:
1. Run the command:

sudo crontab -e -u bitnami

2. Paste the line:

[I]* * * * * cd /opt/bitnami/apps/espocrm/htdocs; /bitnami/lampstack-linux-x64/output/php/bin/php -f cron.php > /dev/null 2>&1[/I]

3. Save crontab (for nano editor press Ctrl+O, then Ctrl+X)

Change your Scheduled Jobs:
b) Check Group Email Accounts -> Scheduling to

*/2 * * * *

c) Send Mass Emails -> Scheduling to

* * * * *

[lerg57]

Thank you.

In my installation it does exist this directory:

[I]/opt/bitnami/apps/espocrm/htdocs[/I]

But does not exist this directory:

[I]/bitnami/lampstack-linux-x64/output/php/bin/php[/I]

What I suppouse is that this line it is to execute CRON.PHP

 
 [I]/bitnami/lampstack-linux-x64/output/php/bin/php -f cron.php > /dev/null 2>&1[/I]

In my installation the file cron.php
Exists in this directory

/opt/bitnami/apps/espocrm/htdocs

So I paste in CRONTAB:

[I]* * * * * cd /opt/bitnami/apps/espocrm/htdocs; [/I]/opt/bitnami/apps/espocrm/htdocs/[I] -f cron.php > /dev/null 2>&1, [/I]

Please advise if it is correct. However with this change the mass mails are not sent. Thanks for your time.

Luis R

[tarasm]

Please correct your line to the following:

* * * * * cd /opt/bitnami/apps/espocrm/htdocs; /bitnami/lampstack-linux-x64/output/php/bin/php -f cron.php > /dev/null 2>&1

[lerg57]

I changed:

 
 [I]* * * * * cd /opt/bitnami/apps/espocrm/htdocs; [/I]/opt/bitnami/apps/espocrm/htdocs/[I] -f cron.php > /dev/null 2>&1[/I]

to:

 
 * * * * * cd /opt/bitnami/apps/espocrm/htdocs; /bitnami/lampstack-linux-x64/output/php/bin/php -f cron.php > /dev/null 2>&1

But did not work.

This directory does not exit in my installation

 
 /bitnami/lampstack-linux-x64/output/php/bin/php -f cron.php > /dev/null 2>&1

Please see this video where I change the EspoCRM Parameters:

http://bit.ly/2xs1ysm

And here I change the CRONTAB files:

Root User:

http://bit.ly/2xs33qu

Bitnami User:

http://bit.ly/2xrTpnY

Thank you

Luis R

[tarasm]

The correct crontab line. Please add to crontab under "root" user ("sudo crontab -e -u root").

* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/php/bin/php cron.php  > /dev/null 2>&1

[lerg57]

I wrote both of this:

* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/php/bin/php cron.php > /dev/null 2>&1

And

* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/apps/espocrm/htdocs cron.php > /dev/null $

Neither worked.

In order to understand this previous line, please explain the reason: of this line
This part:

* * * * * cd /opt/bitnami/apps/espocrm/htdocs;

Is for change and get into the directory /opt/bitnami/apps/espocrm/htdocs. Right?

And this part:

sudo -u daemon /opt/bitnami/php/bin/php cron.php > /dev/null 2>&1

Is to execute as daemon the program cron.php so this takes the CRONTAB parameters. Am I Right?

[tarasm]

Please remove the second line:

* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/apps/espocrm/htdocs cron.php > /dev/null

Explanation:
"* * * * *" - run cron every minute
"cd /opt/bitnami/apps/espocrm/htdocs" - get into the directory /opt/bitnami/apps/espocrm/htdocs.
"sudo -u daemon /opt/bitnami/php/bin/php cron.php > /dev/null 2>&1" - execute php script as daemon.

I have tested the "* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/php/bin/php cron.php > /dev/null 2>&1" line on my VM and it works fine.

Please try to run these commands in a terminal via SSH:

cd /opt/bitnami/apps/espocrm/htdocs
sudo -u daemon /opt/bitnami/php/bin/php cron.php

What is the result? Check last execution time of Scheduled Jobs in EspoCRM. Check a log file <espocrm-directory>/data/logs/2017-09-30.log.
Do you have this file "/opt/bitnami/php/bin/php"?

[lerg57]

I type the code

 cd /opt/bitnami/apps/espocrm/htdocs

 sudo -u daemon /opt/bitnami/php/bin/php cron.php

and these are the results:

http://bit.ly/2ekS3Dm

There is no <espocrm-directory>/data/logs/2017-09-30.log

I do not have "/opt/bitnami/php/bin/php"

The php file exist here:

http://bit.ly/2ekXF03

The file cron.php is located in: /opt/bitnami/apps/espocrm/htdocs/cron.php

The logs in Sheduled Jobs are empty

Thanks for your support

Luis R

[tarasm]

Regarding to your screenshot you ran this command:

sudo -u daemon /opt/bitnami/php/bin/php[B]/php[/B] cron.php

Please remove the last "/php". So the command should be:

sudo -u daemon /opt/bitnami/php/bin/php cron.php

[lerg57]

I wrote:

 
 sudo -u daemon /opt/bitnami/php/bin/php cron.php

Did not work.

Maybe is because this directory does not exist : /opt/bitnami/php/bin/php

I tried these options:

* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u bitnami /opt/bitnami/php/bin cron.php 
* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u root /opt/bitnami/php/bin cron.php 
* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/php/bin cron.php 

* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u bitnami /opt/bitnami/php/bin -f cron.php 
* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u root /opt/bitnami/php/bin -f cron.php 
* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/php/bin -f cron.php 

* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/php cron.php > /dev/null 2>&1 
* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u bitnami /opt/bitnami/php cron.php > /dev/null 2>&1
* * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u root /opt/bitnami/php cron.php > /dev/null 2>&1

None of them work.

These are the folders where CRON.PHP Is located: http://bit.ly/2gtky2l

These are the folders where different BIN´s folders are located: http://bit.ly/2gth0NB

These are the folders where different PHP´s folders are located: http://bit.ly/2gtySrA

There is no DAEMON user. The users are bitnami & root
Does the user daemon in LINUX always exist?

I'll appreciate if you explain to my the reason of this line:

sudo -u daemon /opt/bitnami/php/bin/php

Also in the EspoCRM Application, when you select the time to send the mass mail there are options every 30 min. Will it work if I set to 21:32 instead of 21.30 for example?
Please see picture: http://bit.ly/2gtyQ2E

I really really appreciate your help and patience with this issue.

Thanks

Luis R

[tarasm]

Are these files exist?:

/opt/bitnami/php/bin/php

/opt/bitnami/apps/espocrm/htdocs/cron.php

To check if the user exists:

id -u daemon

If you get this result "id: ‘daemon’: no such user", the user doesn't exist.

If all above information are ok, then do the following steps
1. Remove cache directory:

sudo rm -rf /opt/bitnami/apps/espocrm/htdocs/data/cache

2. Delete all cron definitions from crontab like

 * * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u bitnami /opt/bitnami/php/bin cron.php  * * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u root /opt/bitnami/php/bin cron.php  * * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/php/bin cron.php   * * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u bitnami /opt/bitnami/php/bin -f cron.php  * * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u root /opt/bitnami/php/bin -f cron.php  * * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/php/bin -f cron.php   * * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/php cron.php > /dev/null 2>&1  * * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u bitnami /opt/bitnami/php cron.php > /dev/null 2>&1 * * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u root /opt/bitnami/php cron.php > /dev/null 2>&1

3. Add the line to crontab:

 * * * * * cd /opt/bitnami/apps/espocrm/htdocs; sudo -u daemon /opt/bitnami/php/bin/php cron.php  > /dev/null 2>&1

[tarasm]

I wrote:
I'll appreciate if you explain to my the reason of this line:

sudo -u daemon /opt/bitnami/php/bin/php

The server runs under "daemon" user and "daemon" are also owner of files. Cron tab for the user "daemon" is diabled, so we have to add this command under "root" user.