Installing PHP with PGSQL Support on Mandrake?

majolee

Hello All,

We are developing a modular system for a dairy.

We are trying to use PostgreSql for first time with php.

We have installed Linux Mandrake Distribution and PostgreSQl latest version with php 4.3.2

But it seems to be not working well when trying to call db connection functions from php.

We tried to install all over again but still can not manage to compile php with extension support for pgsql.

Please help.

Thanks.

Majolee InfoTech.

Sxooter

Are you using RPMs or source tar balls?

If you mix and match, it can be a little tough.

I just download all three (PHP,Apache,Postgresql) and build them like this:

Postgresql first:

cd /usr/local/src
tar xvzf /dir/to/tgz/postgresql-7.3.4.tar.gz
cd postgresql-7.3.4
./configure --with-maxbackends=256
make
make install
cd /etc
echo "/usr/local/pgsql/lib" >>ld.so.conf
ldconfig
cd /usr/local/src/
tar xvzf /dir/to/tgz/apache-1.3.28.tar.gz
cd apache-1.3.28
./configure --enable-module=most --enable-shared=max
make
make install
cd /usr/local/src/
tar xvzf /dir/to/tgz/php-4.3.2.tar.gz
cd php-4.3.2
./configure --with-pgsql
make
make install

then edit /use/local/apache/conf/httpd.conf and uncomment the addhandler line for php and you're set.

majolee

Hello,

Thanks for the help..

We downloaded all the three.. and tried what you said..

It failed when we reached "make" of apache1.3.28..this is what last few lines says:

d_auth_dbm.c && mv mod_auth_dbm.o mod_auth_dbm.lo
mod_auth_dbm.c:84:18: ndbm.h: No such file or directory
mod_auth_dbm.c: In function get_dbm_pw': mod_auth_dbm.c:152:DBM' undeclared (first use in this function)
mod_auth_dbm.c:152: (Each undeclared identifier is reported only once
mod_auth_dbm.c:152: for each function it appears in.)
mod_auth_dbm.c:152: f' undeclared (first use in this function) mod_auth_dbm.c:153:datum' undeclared (first use in this function)
mod_auth_dbm.c:153: parse error before "d"
mod_auth_dbm.c:156: q' undeclared (first use in this function) mod_auth_dbm.c:170:d' undeclared (first use in this function)
make[4]: [mod_auth_dbm.so] Error 1
make[3]: [all] Error 1
make[2]: [subdirs] Error 1
make[2]: Leaving directory /home/majolee/apache_1.3.28/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory/home/majolee/apache_1.3.28'
make: [build] Error 2

Any idea why this happens..?

Thanks

Sxooter

You need to find and install the rpm file that provides ndbm, or, remove the module most / max lines and just do a simple ./configure on apache.

I gave up on Mandrake as a server OS long ago because of issues like this. Suse, Debian, or RedHat are much better choices for a server.

majolee

Hello,

Thanks for your help..

Finally we managed to run all togather..

So the project has finally got a startup..

Will ask you if anything comes again!!

We are good at Web Designing .. if you need any help from us we will be very happy to assist you.

Bye