Apache PHP != Command Line PHP?

wh33t · 10-23-2007, 12:55 AM

Hello all,

I'm having a weird problem. When I run php from the command line it appears that the whole set of mysql functions are not available to it. I get this.

Code:

root@server:/home/htdocs/system# php movie_update_listings.php

Fatal error: Call to undefined function mysql_connect() in /htdocs/inc/functions.php on line 370

But I know mysql works on my php scripts when I am using them from Apache over the web. Could anyone shed some light on what is going on?

I am using Ubuntu 6.10 fully up to date with the latest apache php and mysql that is available from the apt-get repos.

matthalliday · 10-23-2007, 08:34 PM

In the conf file, make sure that:

extension=mysql.so

is NOT commented out.

wh33t · 10-23-2007, 08:48 PM

Thanks. I will try that.

wh33t · 10-23-2007, 09:21 PM

That totally fixed it thanks.

For anyone else who might have similar problems, be sure to edit the "right" php.ini file. I had two on my ubuntu system, so I changed them both heh and then it worked.