Odd behavior with PHP postgres functions

[ShadowBlade]

I have a large project that I'm converting from a fully working mysql setup to use pgSQL. I've installed PostgreSQL version 8.3.3 and rebuilt PHP using the following config:

./configure --with-pgsql=/usr/local/pgsql

After everything appeared to successfully install, I went to test my project and all of my pg_ functions return:

Fatal error: Call to undefined function pg_*() in....

(obviously where * is the rest of the function - its the same for all of
them)

However, I tried to run a pg function from the command line using php -r and they work as expected (i.e. php -r "pg_connect('host=localhost');" returns an error saying there is no password, rather than an undefined function)

I've tried several php snapshots and they all have similar or equal behavior. (my current one is still the release of 5.2.6 as stated)

Any help would be appreciated.

 

[sourceninja]

I've never compiled php myself, but on my server I have to php.ini files. One for the console and one for the web. I have to make sure the modules are enabled in both php.ini files.

 

[ShadowBlade]

Ok, so I have the line to load the extension in every php.ini file (I have three) and when I restart apache, it tells me twice that " [warn] module php5_module is already loaded, skipping "
And it still doesn't work.

 

[Crusty]

There really shouldn't be any need to have to compile php to include a database module, any modern Linux distribution will have a package for it and it should configure it for you as well.

What OS are you running?

 

[ShadowBlade]

Ubuntu 8.04

 

[sourceninja]

We simply use the default ubuntu php5. I have yet to find anything I need that was not included.

aptitude install php5 php5-cli and whatever modules you need.

 

[Crusty]

Yep, just use aptitude or synaptic to install the php5 packages you need. Ubuntu automatically configures Apache2 for you if you install everything through it's package management system.

 

[ShadowBlade]

Wow, now I feel stupid
Thanks a lot for the tip.

 

[Crusty]

Originally posted by: ShadowBlade
Wow, now I feel stupid
Thanks a lot for the tip.

Don't feel stupid, I would have done the same thing if I didn't know about aptitude