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?
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?