Mass Mail not Sending mails

[lerg57]

Dear Tarasm,
It finally worked sending mass mail!!!
There was a mistake in the cron.php file that is located in /opt/bitnami/apps/espocrm/htdocs.

It was missing this PHP instruction:

"?>"

I really really appreciate your help and your patience.

Without your help I would have not resolved it.

Thank you!!!

Best regards

Luis R
Mexico

[tarasm]

This folder does not exist:
Code:
/opt/bitnami/php/bin/php

It should be a file, not folder.

/opt/bitnami/php/bin - folder
php - file inside this folder

Did you try to remove cache folder and run cron with this command:

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

[lerg57]

This folder does not exist:

/opt/bitnami/php/bin/php

This file does exist:

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

This is what it contains: http://bit.ly/2iXwCxk


This

id -u daemon

Displays:

1

Here is the image for daemon, bitnami and root users: http://bit.ly/2iWt6TM

[tarasm]

I wrote:
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

If you set to 21:32, it will run at 22:00.

[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.

[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

[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]

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 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]

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 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]

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 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]

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]

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