Posted by Jerry Stuckle on 08/28/06 12:39

dburdick@isound.com wrote:
> 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!
>
>
>
> I believe i have narrowed this down.
>
> I ran the same identical script with phpinfo() in it from 2 different
> locations.
>
> 1 I ran from the command line and 1 I ran from the crontab.
>
> The one that i ran from the crontab didn't not have mysql support
> enabled.
>
> Looks like that is the problem!
>
> Why are these different?
> How do i compile that php version with mysql support?
>
> I believe this should solve this issue.
>
> Thanks!
>

Which php.ini file is each one using? The version of PHP? Perhaps you
have two copies of php on your system.

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

[Back to original message]