Menu
SuiteCRM dedicated support by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: Trouble with Campaigns and Cron

Trouble with Campaigns and Cron 1 week 5 days ago #72695

  • MPH
  • MPH's Avatar
  • Offline
  • New Member
  • Posts: 6
  • Karma: 0
Hi. I'm looking for some help to fix my problem with Campaigns.
Everything in SuiteCRM is working well but I can't run Cron jobs to send off campaigns.
My googling leads me to think that it may be because I didn't install SuiteCRM with the correct user settings. I think it's because I'm using root as the user. I installed SuiteCRM using Softaculous and I can't recall being asked to use a non-root user.

I'd prefer a solution that didn't involve too much messing around in SQL. I can cut and paste SQL if I have good instructions about where to put it.

Alternatively, perhaps some suggestions for someone I can pay for an hour's work to fix this for me.

I'm using Version 7.10.5 hosted on an Apache server running Linux.
The administrator has disabled public write access.

Trouble with Campaigns and Cron 1 week 4 days ago #72708

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7856
  • Thank you received: 1220
  • Karma: 284
DO you have SSH access to your server? If so, please paste here the results of these commands, given from the root of your SuiteCRM installation:
ls -al
ps -ef | egrep '(httpd|apache2|apache)' | grep -v `whoami` | grep -v root | head -n1 | awk '{print $1}'
crontab -l -u root
crontab -l -u apache

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
The following user(s) said Thank You: MPH

Trouble with Campaigns and Cron 1 week 4 days ago #72718

  • MPH
  • MPH's Avatar
  • Offline
  • New Member
  • Posts: 6
  • Karma: 0
pgr wrote:
DO you have SSH access to your server? If so, please paste here the results of these commands, given from the root of your SuiteCRM installation:

Thanks for your help. The ls command worked but I didn't have much luck with the others
ls -al
melbou96@c3s3-1e-mel [~/public_html/suitecrm]# ls -al
total 28808
drwxr-xr-x 20 melbou96 melbou96 4096 Oct 9 11:00 ./
drwxr-x--- 14 melbou96 nobody 4096 Oct 6 14:16 ../
-rw-r--r-- 1 melbou96 melbou96 1525 Jun 3 22:13 .htaccess
-rw-r--r-- 1 melbou96 melbou96 3094 May 17 18:20 CODE_OF_CONDUCT.md
-rw-r--r-- 1 melbou96 melbou96 2808 May 17 18:20 HandleAjaxCall.php
-rw-r--r-- 1 melbou96 melbou96 34539 May 17 18:20 LICENSE.txt
drwxr-xr-x 3 melbou96 melbou96 4096 Jun 3 22:13 ModuleInstall/
-rw-r--r-- 1 melbou96 melbou96 3760 May 17 19:31 README.md
-rw-r--r-- 1 melbou96 melbou96 194 May 17 18:20 RoboFile.php
-rw-r--r-- 1 melbou96 melbou96 5327 May 17 18:20 SugarSecurity.php
-rw-r--r-- 1 melbou96 melbou96 5839 May 17 18:20 TreeData.php
drwxr-xr-x 2 melbou96 melbou96 4096 Jun 3 22:13 XTemplate/
drwxr-xr-x 7 melbou96 melbou96 4096 Jun 3 22:13 Zend/
-rw-r--r-- 1 melbou96 melbou96 411 May 17 18:20 bower.json
drwxrwxrwx 16 melbou96 melbou96 4096 Aug 20 21:03 cache/
-rw-r--r-- 1 melbou96 melbou96 3587 May 17 18:20 campaign_tracker.php
-rw-r--r-- 1 melbou96 melbou96 1305 May 17 18:20 composer.json
-rw-r--r-- 1 melbou96 melbou96 39795 May 17 19:35 composer.lock
-rw-r--r-- 1 melbou96 melbou96 12196 Jul 15 16:38 config.php
-rw-r--r-- 1 melbou96 melbou96 1291 Jul 24 17:38 config_override.php
-rw-r--r-- 1 melbou96 melbou96 5052 Aug 23 12:21 cron.php
-rw-r--r-- 1 melbou96 melbou96 2446 May 17 18:20 crossdomain.xml
drwxrwxrwx 12 melbou96 melbou96 4096 Jul 14 21:33 custom/
drwxr-xr-x 3 melbou96 melbou96 4096 Jun 3 22:13 data/
-rw-r--r-- 1 melbou96 melbou96 2386 May 17 18:20 dictionary.php
-rw-r--r-- 1 melbou96 melbou96 12794 May 17 18:20 download.php
-rw-r--r-- 1 melbou96 melbou96 2390 May 17 18:20 emailmandelivery.php
-rw-r--r-- 1 melbou96 melbou96 27332721 Oct 9 21:11 error_log
-rw-r--r-- 1 melbou96 melbou96 4918 May 17 18:20 export.php
-rw-r--r-- 1 melbou96 melbou96 967627 May 17 18:20 files.md5
-rw-r--r-- 1 melbou96 melbou96 2367 May 17 18:20 ical_server.php
drwxr-xr-x 58 melbou96 melbou96 4096 Jun 3 22:13 include/
-rw-r--r-- 1 melbou96 melbou96 2374 May 17 18:20 index.php
drwxr-xr-x 6 melbou96 melbou96 4096 Jun 3 22:13 install/
-rw-r--r-- 1 melbou96 melbou96 31893 May 17 18:20 install.php
-rw-r--r-- 1 melbou96 melbou96 2275 May 17 18:20 json_server.php
drwxr-xr-x 3 melbou96 melbou96 4096 Jun 3 22:13 jssource/
drwxr-xr-x 7 melbou96 melbou96 4096 Jun 3 22:13 lib/
-rw-r--r-- 1 melbou96 melbou96 2313 May 17 18:20 log_file_restricted.html
-rw-r--r-- 1 melbou96 melbou96 2376 May 17 18:20 maintenance.php
drwxr-xr-x 2 melbou96 melbou96 4096 Jun 3 22:13 metadata/
drwxrwxrwx 119 melbou96 melbou96 4096 Jun 3 22:13 modules/
-rw-r--r-- 1 melbou96 melbou96 2886 May 17 18:20 pdf.php
-rw-r--r-- 1 melbou96 melbou96 304 May 17 18:20 php_version.php
drwxrwxrwx 2 melbou96 melbou96 4096 Jul 29 15:57 public/
-rw-r--r-- 1 melbou96 melbou96 73 May 17 18:20 robots.txt
-rw-r--r-- 1 melbou96 melbou96 3588 May 17 18:20 run_job.php
drwxr-xr-x 12 melbou96 melbou96 4096 Jun 3 22:13 service/
drwxr-xr-x 2 melbou96 melbou96 4096 Jun 3 22:13 soap/
-rw-r--r-- 1 melbou96 melbou96 4031 May 17 18:20 soap.php
-rw-r--r-- 1 melbou96 melbou96 154 May 17 18:20 sugar_version.json
-rw-r--r-- 1 melbou96 melbou96 2296 May 17 18:20 sugar_version.php
-rwxrwxrwx 1 melbou96 melbou96 0 Jun 3 22:13 sugarcrm.log*
-rwxrwxrwx 1 melbou96 melbou96 7700 Jun 3 23:16 suitecrm.log*
-rw-r--r-- 1 melbou96 melbou96 234 Jun 4 07:18 suitecrm_06_03_18.log
-rw-r--r-- 1 melbou96 melbou96 275 Jun 5 07:10 suitecrm_06_04_18.log
-rw-r--r-- 1 melbou96 melbou96 2262 Jun 5 12:05 suitecrm_06_05_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Jun 10 12:01 suitecrm_06_10_18.log
-rw-r--r-- 1 melbou96 melbou96 7358 Jul 11 08:57 suitecrm_07_10_18.log
-rw-r--r-- 1 melbou96 melbou96 85609 Jul 11 14:35 suitecrm_07_11_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Jul 12 11:34 suitecrm_07_12_18.log
-rw-r--r-- 1 melbou96 melbou96 222 Jul 13 14:07 suitecrm_07_13_18.log
-rw-r--r-- 1 melbou96 melbou96 9817 Jul 14 23:12 suitecrm_07_14_18.log
-rw-r--r-- 1 melbou96 melbou96 40286 Jul 15 21:39 suitecrm_07_15_18.log
-rw-r--r-- 1 melbou96 melbou96 17329 Jul 16 22:45 suitecrm_07_16_18.log
-rw-r--r-- 1 melbou96 melbou96 2566 Jul 18 08:52 suitecrm_07_17_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Jul 18 10:00 suitecrm_07_18_18.log
-rw-r--r-- 1 melbou96 melbou96 315 Jul 20 08:03 suitecrm_07_19_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Jul 20 10:00 suitecrm_07_20_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Jul 23 09:59 suitecrm_07_22_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Jul 23 10:00 suitecrm_07_23_18.log
-rw-r--r-- 1 melbou96 melbou96 779 Jul 24 17:33 suitecrm_07_24_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Jul 27 08:55 suitecrm_07_26_18.log
-rw-r--r-- 1 melbou96 melbou96 882 Jul 28 15:29 suitecrm_07_28_18.log
-rw-r--r-- 1 melbou96 melbou96 7893 Jul 30 09:26 suitecrm_07_29_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Jul 30 10:00 suitecrm_07_30_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Jul 31 18:52 suitecrm_07_31_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Aug 1 10:10 suitecrm_08_01_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Aug 10 11:18 suitecrm_08_10_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Aug 13 15:36 suitecrm_08_13_18.log
-rw-r--r-- 1 melbou96 melbou96 2422 Aug 14 10:40 suitecrm_08_14_18.log
-rw-r--r-- 1 melbou96 melbou96 2581 Aug 16 09:04 suitecrm_08_15_18.log
-rw-r--r-- 1 melbou96 melbou96 452 Aug 19 12:08 suitecrm_08_19_18.log
-rw-r--r-- 1 melbou96 melbou96 124694 Aug 21 09:59 suitecrm_08_20_18.log
-rw-r--r-- 1 melbou96 melbou96 203040 Aug 22 09:59 suitecrm_08_21_18.log
-rw-r--r-- 1 melbou96 melbou96 202813 Aug 23 09:59 suitecrm_08_22_18.log
-rw-r--r-- 1 melbou96 melbou96 19738 Aug 23 12:21 suitecrm_08_23_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Aug 24 10:00 suitecrm_08_24_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Aug 25 10:00 suitecrm_08_25_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Aug 26 10:00 suitecrm_08_26_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Aug 27 10:00 suitecrm_08_27_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Aug 28 10:00 suitecrm_08_28_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Aug 29 10:00 suitecrm_08_29_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Aug 30 10:00 suitecrm_08_30_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Aug 31 10:00 suitecrm_08_31_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 1 10:00 suitecrm_09_01_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 2 10:00 suitecrm_09_02_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 3 10:00 suitecrm_09_03_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 4 10:00 suitecrm_09_04_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 5 10:00 suitecrm_09_05_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 6 10:00 suitecrm_09_06_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 7 10:00 suitecrm_09_07_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 8 10:00 suitecrm_09_08_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 9 10:00 suitecrm_09_09_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 10 10:00 suitecrm_09_10_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 11 10:00 suitecrm_09_11_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 12 10:00 suitecrm_09_12_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 13 10:00 suitecrm_09_13_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 14 10:00 suitecrm_09_14_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 15 10:00 suitecrm_09_15_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 16 10:00 suitecrm_09_16_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 17 10:00 suitecrm_09_17_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 18 10:00 suitecrm_09_18_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 19 10:00 suitecrm_09_19_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 20 10:00 suitecrm_09_20_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 21 10:00 suitecrm_09_21_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 22 10:00 suitecrm_09_22_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 23 10:00 suitecrm_09_23_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 24 10:00 suitecrm_09_24_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 25 10:00 suitecrm_09_25_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 26 10:00 suitecrm_09_26_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 27 10:00 suitecrm_09_27_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 28 10:00 suitecrm_09_28_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 29 10:00 suitecrm_09_29_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Sep 30 10:00 suitecrm_09_30_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Oct 1 10:00 suitecrm_10_01_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Oct 2 10:00 suitecrm_10_02_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Oct 3 10:00 suitecrm_10_03_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Oct 4 10:00 suitecrm_10_04_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Oct 5 10:00 suitecrm_10_05_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Oct 6 10:00 suitecrm_10_06_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Oct 7 11:00 suitecrm_10_07_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Oct 8 11:00 suitecrm_10_08_18.log
-rw-r--r-- 1 melbou96 melbou96 0 Oct 9 11:00 suitecrm_10_09_18.log
-rw-r--r-- 1 melbou96 melbou96 170 May 21 15:46 suitecrm_version.php
drwxr-xr-x 4 melbou96 melbou96 4096 Jun 3 22:13 themes/
-rw-r--r-- 1 melbou96 melbou96 93 May 17 18:20 travis.php.ini
drwxrwxrwx 6 melbou96 melbou96 4096 Jul 29 15:57 upload/
-rw-r--r-- 1 melbou96 melbou96 2976 May 17 18:20 vCard.php
-rw-r--r-- 1 melbou96 melbou96 2248 May 17 18:20 vcal_server.php
drwxr-xr-x 21 melbou96 melbou96 4096 Jun 3 22:13 vendor/




ps -ef | egrep '(httpd|apache2|apache)' | grep -v `whoami` | grep -v root | head -n1 | awk '{print $1}'

No result shown ( I tried pasting and typing)

crontab -l -u root


must be privileged to use -u

crontab -l -u apache

must be privileged to use -u
The administrator has disabled public write access.

Trouble with Campaigns and Cron 1 week 4 days ago #72720

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7856
  • Thank you received: 1220
  • Karma: 284
Ok, try just
crontab -l

If you already set up your Scheduler jobs, there should be an entry there. If not, you'll have to add one. Maybe this can be done from CPanel.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
The following user(s) said Thank You: MPH

Trouble with Campaigns and Cron 1 week 3 days ago #72802

  • MPH
  • MPH's Avatar
  • Offline
  • New Member
  • Posts: 6
  • Karma: 0
pgr wrote:
Ok, try just
crontab -l

If you already set up your Scheduler jobs, there should be an entry there. If not, you'll have to add one. Maybe this can be done from CPanel.


This is the crontab -l output

MAILTO="This email address is being protected from spambots. You need JavaScript enabled to view it."
SHELL="/usr/local/cpanel/bin/jailshell"
11 14 * * 6 /usr/local/cpanel/3rdparty/bin/php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/cli.php --backup --auto=1 --insid=26_10922
01 16 * * * /usr/local/cpanel/3rdparty/bin/php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/cli.php --backup --auto=1 --insid=26_89969
13 22 * * * /usr/local/cpanel/3rdparty/bin/php "/usr/local/cpanel/whostmgr/docroot/cgi/softaculous"/cli.php --backup --auto=1 --insid=492_41221
* * * * * cd /home/melbou96/public_html/suitecrm; php -f cron.php > /dev/null 2>&1

I have setup the scheduler jobs with the info at the bottom of the Scheduler page - * * * * * cd /home/melbou96/public_html/suitecrm; php -f cron.php > /dev/null 2>&1
The administrator has disabled public write access.

Trouble with Campaigns and Cron 1 week 2 days ago #72827

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7856
  • Thank you received: 1220
  • Karma: 284
Just apply the recommended permissions. From your SuiteCRM root folder give these commands:
  sudo chown -R melbou96:melbou96 .
  sudo chmod -R 755 .
  sudo chmod -R 775 cache custom modules themes data upload
  sudo chmod 775 config_override.php 2>/dev/null

You cron set up looks alright. You can check by going in Admin / Schedulers, and checking the "Last ran successfully" time in some of those jobs. Check also if they are in the correct timezone.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
The following user(s) said Thank You: MPH

Trouble with Campaigns and Cron 1 week 2 days ago #72856

  • MPH
  • MPH's Avatar
  • Offline
  • New Member
  • Posts: 6
  • Karma: 0
Thanks again pgr.
I ran those commands using ssh. I had to remove the sudo for them to run.

All of my jobs still say 'Last successful run: Never'.
I change one, so that it should be firing every minute and nothing on that either.

Any other tips?
The administrator has disabled public write access.

Trouble with Campaigns and Cron 6 days 4 hours ago #72907

  • MPH
  • MPH's Avatar
  • Offline
  • New Member
  • Posts: 6
  • Karma: 0
pgr has been really helpful but I think I've reached the end of my technical knowledge.

Can anyone recommend someone that I can pay to do a few hours work on my server and CRM implementation?

I tried SalesAgility but they only have service packages. I think once I get over this hump that I'll be able to maintain it myself.
The administrator has disabled public write access.

Trouble with Campaigns and Cron 5 days 21 hours ago #72921

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7856
  • Thank you received: 1220
  • Karma: 284
Try changing your cron command like this:
* * * * * cd /home/melbou96/public_html/suitecrm;  /usr/local/cpanel/3rdparty/bin/php -f cron.php > /dev/null 2>&1

(I am adding a full PHP binary path, based on what I saw on your other existing cron commands).

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
The following user(s) said Thank You: MPH

Trouble with Campaigns and Cron 4 days 21 hours ago #72962

  • MPH
  • MPH's Avatar
  • Offline
  • New Member
  • Posts: 6
  • Karma: 0
Thanks again pgr.
It all got a bit beyond my skills, so I contacted urdhva-tech.com/ based on a recommendation in one of pgr's earlier posts.
They were amazing. The support guy spent over an hour working on my server and then didn't charge anything.
The problem was solved by tweaking some of the server settings and also using pgr's last suggestion.
The administrator has disabled public write access.

Trouble with Campaigns and Cron 4 days 21 hours ago #72964

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7856
  • Thank you received: 1220
  • Karma: 284
I am glad you got it working! :-)

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Trouble with Campaigns and Cron 4 days 1 hour ago #73005

  • urdhvatech
  • urdhvatech's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Posts: 453
  • Thank you received: 85
  • Karma: 15
Thanks Nick for appreciating and also thanks to pgr!

Cheers!!
Thanks & Regards,
Team Urdhva Tech
Web : www.urdhva-tech.com
Skype : urdhvatech

- Official code partner
- Official Integration partner
The administrator has disabled public write access.
Time to create page: 0.083 seconds
Powered by Kunena Forum