cron not working when calling php script with mysql on linux box

[dburdick]

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!

[Jerry Stuckle]

db******@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.
js*******@attglobal.net
==================

[dburdick]

db******@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!

[Jerry Stuckle]

db******@isound.com wrote:

db******@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.
js*******@attglobal.net
==================