Mass Email doesn't work

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jorgeyoma
    Member
    • Mar 2016
    • 46
    #1

    Mass Email doesn't work

    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.
    Last edited by jorgeyoma; 11-23-2016, 06:59 PM.
    Tags: None
    • yuri
      Member
      • Mar 2014
      • 8440
      #2
      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?

      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

        Comment

        • jorgeyoma
          Member
          • Mar 2016
          • 46
          #3
          Originally posted by yurikuzn
          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
          Last edited by jorgeyoma; 11-24-2016, 10:51 AM.

            Comment

            • yuri
              Member
              • Mar 2014
              • 8440
              #4
              You need to setup cron in your system. It uses previous path and you need to define new. "crontab -e" command in linux systems.
              If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                Comment

                • jorgeyoma
                  Member
                  • Mar 2016
                  • 46
                  #5
                  Originally posted by yurikuzn
                  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.
                  Last edited by jorgeyoma; 11-24-2016, 11:28 AM.

                    Comment

                    • yuri
                      Member
                      • Mar 2014
                      • 8440
                      #6
                      You can configure cron though your cpanel.
                      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                        Comment

                        • jorgeyoma
                          Member
                          • Mar 2016
                          • 46
                          #7
                          Originally posted by yurikuzn
                          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.
                          Last edited by jorgeyoma; 11-24-2016, 02:46 PM.

                            Comment

                            • bill1977
                              Junior Member
                              • Nov 2016
                              • 7
                              #8
                              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?

                                Comment

                                • yuri
                                  Member
                                  • Mar 2014
                                  • 8440
                                  #9
                                  Need information what you have in logs.
                                  If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                                    Comment

                                    • bill1977
                                      Junior Member
                                      • Nov 2016
                                      • 7
                                      #10
                                      What other logs do you need?

                                      HTML Code:
                                      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)

                                        Comment

                                        • yuri
                                          Member
                                          • Mar 2014
                                          • 8440
                                          #11
                                          Can you check all items the same way as it's done in the initial post in this thread.
                                          If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                                            Comment

                                            • bill1977
                                              Junior Member
                                              • Nov 2016
                                              • 7
                                              #12
                                              I did that before I posted originally.

                                                Comment

                                                • bill1977
                                                  Junior Member
                                                  • Nov 2016
                                                  • 7
                                                  #13
                                                  I just set up a new test campaign there, new target list, new mass mail. Nothing.

                                                    Comment

                                                    • yuri
                                                      Member
                                                      • Mar 2014
                                                      • 8440
                                                      #14
                                                      Check if there is anything in Administration > Scheduled Jobs > Send Mass Emails > Log
                                                      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                                                        Comment

                                                        • iscon
                                                          Active Community Member
                                                          • May 2014
                                                          • 187
                                                          #15
                                                          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
                                                          ------------------
                                                          Robert Laussegger
                                                          iscon group
                                                          http://www.iscongroup.net
                                                          mailto://info@iscongroup.net

                                                            Comment

                                                            Previous template Next
                                                            Working...