Announcement

Collapse
No announcement yet.

Mass Email doesn't work

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

  • #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?

    Comment


    • #3
      Originally posted by yurikuzn View Post
      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


      • #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.

        Comment


        • #5
          Originally posted by yurikuzn View Post
          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


          • #6
            You can configure cron though your cpanel.

            Comment


            • #7
              Originally posted by yurikuzn View Post
              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


              • #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


                • #9
                  Need information what you have in logs.

                  Comment


                  • #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


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

                      Comment


                      • #12
                        I did that before I posted originally.

                        Comment


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

                          Comment


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

                            Comment


                            • #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

                              Working...
                              X