Problem running php script via crond

Question

Problem running php script via crond

development

I'm trying to run a PHP script from crond and I keep getting the following error:

Fatal error: Call to undefined function mysql_connect() in /path/to/script on line 45

I can run the script fine from a superuser bash prompt via ssh by literally copying and pasting the command from my crontab to the prompt and hitting enter, but if I set it to run through crond I always get this error. I thought the script might be running as a user that does not have permissions to access the mysql module, but I'm fairly certain the script is running as root as I have installed the cron entry in /etc/crontab as the root user (I'm running CentOS with php 5.2.x).

Any help would be greatly appreciated.

2 Replies

forum:OverlordQ · Answer 1 · Jan. 22, 2010, 9:56 p.m.

forum:OverlordQ 14 years, 10 months ago

Make sure the PHP it's running through cron is configured to load the mysql module. Use which to see what you're running when it works and use that path in your scripts shebang.

forum:oliakaoil · Answer 2 · Jan. 23, 2010, 2:42 p.m.

forum:oliakaoil 14 years, 10 months ago

Wow you're right, apparently there's a slightly earlier version of the cli in my /usr/bin and my most recent version elsewhere. Specifying the full path to the php cli I actually want in my crontab did the trick. Was working on this for a looong time. You're the man!

Compute

Storage

Networking

Databases

Services

Developer Tools

Industries

Pricing

Community

Engage With Us

Problem running php script via crond

2 Replies

Reply

Tips: