Posted by Jerry Stuckle on 08/28/06 00:47

dburdick@isound.com wrote:
> I was referred to this forum as this may be a php specific problem.
> Some kind of configuration problem maybe.
>
> I have some php files that connect to a mysql database and are run as
> cron jobs.
>
> The scripts work fine when run via the command line as root, but when
> run via the cron they cause a mysql connection error.
>
> Call to undefined function: mysql_pconnect()
>
> I have found some info on this and tried many things but none of them
> are working.
>
> Does this have something to do with setting the appropriate environment
> in php
> script? I read something about that but am not sure how or what to do.
>
> Please help!!!
>
> Thank you!
>

Could be your environment, PHP setup or any of about a dozen different
things.

One big difference is the cron job is probably running under a different
user, with different privileges - both for MySQL and PHP. It could even
be using a different php.ini - depending on the environment set up for
that user.

Did you try asking your sysadmin? That's where I would start -
otherwise you may spend days trying to chase down all the various
possibilities.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]