Cron jobs not working

[hypersonic]

I have been struggling with this problem for some time now and have not found a solution. I have searched these forums and found similar, but not identical problems. My cron jobs are simply not working. My website is based on Joomla using J!WHMCS Integrator3 to connect with my WHMCS installation.

Technical details:

PHP: 5.3.26

CPanel: 11.40

WHMCS: 5.3.7

 

WHMCS is installed in a sub-directory of the main domain. When cron.php is invoked by crontab, the only result is an email with a "Critical Error" that says, "Could not connect to the database", I get nothing from domainsync.php at all.

I can invoke cron.php from my browser and this produces the expected result, including an email reporting the work and another with my daily database backup. However, invoking domainsync.php produces no result at all. Entries in the activity log show cron.php starting and completing; domainsync.php starts but does not complete.

 

Can anyone help with this?

[WHMCS Sam]

Hello,

 

In most of the cases where we've seen this, it's due to the user that the crons run as not having access to MySQL in their shell. You can confirm this by logging into shell as the cPanel user and running the mysql command.

 

Every time we've seen this, it was resolved by changing the cPanel user's shell to "default."

 

If this does not resolve the issue, please submit a ticket so that we may take a closer look.

[hypersonic]

Thanks for the info. It is pretty much what I had been led to beleive some time ago but it has been a struggle getting my supplier to understand it. Yesterday we made some progress and I started getting more reasonable results from cron.php.

 

Thanks again for the help,

 

Paul Andreassen