PHP commands, Crontab and mysql_connect

pugg09 · 12-15-2005, 05:18 PM

Has anyone run into this problem?

I have one machine that holds a database table with two attributes; one is for a message and the other is an email addres.

I then have a second machine that connects to the first machine using mysql_connect command in PHP, reads the row and sends of the message to the appropriate email address.

If I run the scriptfile manually (ex. php myscript.php) as root, it works well. When I put the command in crontab, nothing happens.

One quick note, if I remove only the mysql_connect string and just put in static data, Crontab works.

Does anyone know what's wrong?

12-15-2005, 05:18 PM	#1
pugg09 Green Mole Join Date: Dec 2005 Posts: 1	PHP commands, Crontab and mysql_connect Has anyone run into this problem? I have one machine that holds a database table with two attributes; one is for a message and the other is an email addres. I then have a second machine that connects to the first machine using mysql_connect command in PHP, reads the row and sends of the message to the appropriate email address. If I run the scriptfile manually (ex. php myscript.php) as root, it works well. When I put the command in crontab, nothing happens. One quick note, if I remove only the mysql_connect string and just put in static data, Crontab works. Does anyone know what's wrong?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
White screen - pb with mysql_connect	totobeloeil	Script Installation	3	04-09-2006 12:49 AM
Re-indexing with crontab	ZoRaC	How-to Forum	2	07-28-2004 10:02 PM
Unable to create the content file and crontab not working and ixwebhosting	paullind	Troubleshooting	17	03-06-2004 05:40 AM