/usr/bin/php

toshog

hi,
i have a script that's run by cron... it's supposed to use an xml parsing class and needs to talk to mysql
the same script and class work fine when called with a browser. but when i run the script on the command line i get this:

./meLoop.php

Fatal error: Call to undefined function: mysql_connect() in ~/meLoop.php on line 4

how do i "define" that function?
please help...

thanks...

toshog

please help me with this - it's the last piece of a very large project.... i need it for tomorrow, monday....

do i have to recompile?! php is 4.3.0 runing on a RH8.0 box . i have the php compiled with mysql and the function mysql_connect works fine if it's called through the browser but it doesn't work in a scipt from the command line.....

please help....

thank you

maybl8r03

Not an expert with PHP in CLI mode (but I think it should read /etc/php.ini to find where the modules are placed). One possibility is that in command line mode, the UID running php may be pointing to a stale PHP.

Try using the sudo command as root to find if the UID is pointint to the right php executable. First try to see where apache is pointing to first. Here I am assuming apache as the UID for your apache process (you will have to do this as an su/root)

sudo -u apache which php

On my system it points to /usr/bin/php

Then, look at your cron process. Is this particular cron process a user cron process or a daemon/root cron job?

sudo -u whoeverrunscron which php

And see if it is pointing to a stale copy of php or the same one as apache is using.

On my default RH9 install (with PHP 4.2.2) /usr/lib/php4 contains the .so files and it's owned by root and allows everyone to read and execute.

toshog

thanks maybl8r03,

well the output of all sudos is the same:
/usr/bin/php
i'm in as root so i can test root too and the cron user for this script is root....
apache is 4.3.0 - i had to go back to it because there was a bug with fopen through https in 4.3.1 at the time (march 03)...

mine /usr/lib/php4 are the same...

i did a test with the same command - different username and password - on a 4.6 bsd box with the same php version and an older version of mysql - that one worked fine...

any other ideas?

thanks...

maybl8r03

Are you RPM'ing it or compiling it? If you are RPM'ing it point me to the RPM package you installed and I'll try and see if I can get it up on my system (no guarantees)

toshog

ok you were correct about apache using different php. it's actually the one under /usr/local/bin/php
i remember geting the 4.3.0 after the original install

still not working thought...
now all i have in the script is this:
#!/usr/local/bin/php -q

mysql_connect(localhost, 'user', 'pass');

when i run this i get:

./LL.php

./tLL.php: line 5: syntax error near unexpected token localhost,' ./LL.php: line 5:mysql_connect(localhost, 'user', 'pass');'

it works fine with apache....

thanks...