PhpDig.net - View Single Post

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?