Crontab Settings

[henryjiva]

Hi,

I have been fighting with my crontab settings for almost a week now. I have been to many threads on the forum, but being a newbie, wasn't able to make out the right settings from my server.

When i logged in as root user into my server and tried editing crontab by using the command "crontab -e", i got the following screen:

# 50 * * * * nohup /etc/init.d/mysql restart & > /dev/null 2>&1

* * * * * cd /var/www/sugar; php -f cron.php > /dev/null 2>&1

Is this a normal crontab setting? If yes, then what possible settings do i require more to run my scheduler. I have changed the scheduler settings (since the dates were showing old dates) and saved the settings with current dates. But when I checked the "Job Log" panel, there is nothing, I mean its all blank. One more thing to note is the "Last Successful Run", it says never!!!

Can someone please help me how can I configure this properly for my email campaigns to work....

Thanks in advance.

- HL

[sanjaykatiyar1]

There are two entries in your crontab, first one is commneted and second is active.
By default crontab is empty (in Redhat/Fedora linux, not sure for other systems).
It seems someone has set the crontab entries in your system.

Check the sugar path.
Is sugar installed at this path if not the modify the path here.

Also make sure that status is active in
Schedulers: Run Nightly Mass Email Campaigns

[henryjiva]

Hi Sanjay,

Thanks for the help.

Yes, the sugar is installed at the same path.

as for the two entries in the Crontab, they are there from beginning since i hadn't edited them.

The Scheduler is active but not running, i mean its says "Last Successful Run: Never".

Any idea what is wrong with my system?

- HL

[sanjaykatiyar1]

Have you check advance options settings esp Date & Time Start.

[henryjiva]

Yeah i check that too.

Attached is the view of the settings which I think is ok.

Please check this once and let me know in case I need to change anything here.

- HL

[henryjiva]

I require all the senior and Sugar team member to post a Idiot's Guide to setting schedulers and working with crontab.

This is really not possible without proper guidance.

Thanks in advance

- HL

[henryjiva]

any suggestions???

[bpados]

looks like from other posts as well from my own experience that schelduler in the open source version is a joke and just never worked. you can tweak it all you want but it will just never work. you can search the forums install sugar on win or linux the open source release will remain crippled.
Can anyone confirm that he/she has sugarcrm scheduler working the way they want it to work?

[sugarchris]

1. never run this cronjob as root. Just as a rule, unless you need the permissions, leave root alone.

2. *as root* type "su [apache user]" - for me this is "nobody". Common variations: "apache" "www" "webuser". Once you are acting as the apache user, get the output from "php -m" - this will show us what libraries your CLI version of PHP is using. You may have to tweak the command a little bit passing it bits of info like where your php.ini file is.

3. Establish that the cron.job can run as is: run the command that the crontab is running. From your example:

cd /var/www/sugar; php -f cron.php

Note any error messages as any output at all means that something is wrong.


4. Once you can successfully ping the cron.php file, you can properly set the crontab line with whatever worked for you.

5. There may be issues that you cannot surmount due to technical inexperience or lack of access to the necessary tools. In this case, search these forums for "wget" or "curl" - many users have been in this situation and have found ways around their problems.

[sugarchris]

looks like from other posts as well from my own experience that schelduler in the open source version is a joke and just never worked. you can tweak it all you want but it will just never work. you can search the forums install sugar on win or linux the open source release will remain crippled.
Can anyone confirm that he/she has sugarcrm scheduler working the way they want it to work?

I can. I wrote the mess .

Unfortunately, control over low-level system configurations is way out of the power of PHP/Apache to control. We've gotten the Scheduler and the cron.php working with 99% of the systems we've had to address. Our support team is at 100%.

The biggest hurdle is getting the php CLI binary to actually use the same compiled code that PHP/Apache is using - this is usually cured by passing the "-c" argument when calling php. I.e., if my php.ini file is in /usr/lib/php:

php -c /usr/lib/php/php.ini -f cron.php

HTH,