Re: PHP + Postgresql + Linux = Frustration

Mike Dichiappari wrote:

Hello, I am rather new to Linux but an old timer at software development. I am investigating alternate platforms for future development for my company. Linux is at the top of the list. I am trying to get a server setup with a db (PostgreSQL), web server (Apache), and some sort of web scripting language (PHP). I can not make everything work together. PHP4 won't work out-of-the-box with PostgreSQL because PHP doesn't have support for PosgreSQL built in at compile time (why not just build everything into when it was initially built?).

The manual page for PostgreSQL did not exaplain about --with-pgsql option just like most modules' manual pages didn't :) However, I think install section explains how to selectively install modules.

So I get the sources to PHP and try to build. However, it wants the sources (header files) for Apache.

It *MUST* be there, if you want Apache SAPI. It's the way should be.

At this point I don't want to go any further. Eventually, I'll probably need the sources for everything.

If you follow installation instruction closely (PostgreSQL, Apache, PHP) there would be no problems. Make sure you build/install them with this order. PostgreSQL->Apache->PHP.

Is there an easy way to do this sort of stuff on Linux or is it better to just buy off the shelf products that work?

Install from RPM or like, they should work out of box. BTW, do not cross post :) -- Yasuo Ohgaki Please CC me when you reply to news/list messages. Do not reply only to me :)