PHP, MySQL, cron

[Pig]

I am trying to get a PHP script running via cron. I added the shebang line, and I can get it to execute from the command prompt. However, when I run the same command (with full paths) via cron, the database connection fails. In the past I have used dl('mysql.so');, but everything is statically linked and there is no mysql.so file on the server. Is there a way to make this work without recompiling MySQL?

TIA

[devinemke]

i found that on my server (powweb.com) i have to call the CLI executable to get crons to work. something like:

/path/to/php5-cli /path/to/script.php >/path/to/output.txt 2>/path/to/error.txt

[Pig]

Hmm... Good thought. I don't appear to have a CLI binary. I have been calling the main php binary from the command line.

[Pig]

Bah. I ran php -v on the binary I have been using, and it claims to be "PHP 5.2.0 (cli)", so i guess I am already using the CLI. Thanks anyway. I'll keep looking.

[Pig]

Bah again. Sorry for waisting your time. Looks like it was a separate failing database connection to Oracle, and not MySQL.