mysql_connect() problems with crontab

[Anon]

Hi,

I have written a mailingilst script that uses mySQL which works perfectly when run from the command line.

However, when run from the crontab, I get the following errors:

PHP Warning: Unable to load dynamic library '/usr/lib/php4/mysql.so' - libmysqlclient.so.10: cannot open shared object file: No such file or directory in Unknown on line 0

and:

<b>Fatal error</b>: Call to undefined function: mysql_connect() in <b>/web/htdocs/breaking/breakingnews.php</b> on line <b>470</b><br>

Does anyone have any ideas what is causing these errors and how to stop them?

PHP is compiled with MySQL support, and as I say, it works perfectly when not running on crontab. The crontab is running as root.

Any help much appreciated.

Len

[Anon]

I assume that usr/lib/php4/ is there, I really dont have a good guess but maybe add that to your /etc/ld.so.conf and then type ldconfig at the command prompt.

If you aren't using linux trye adding it the the evn var $LD_LIBRARY_PATH on the shell.

On Solaris 8 try crle

I would also add /usr/local/lib/mysql(or real path).
no clue if that will help but worth a try.