PostgreSQL

Patched?

When installing from ISPConfig-2.2.10 do I need to add --with-pgsql to the compile file, or does the new ispconfig versions have this 'patch for the installer'?

 

How do I make sure these are installed? Would it be correct to type these commands to check or not? I am using Fedora Core 6 The Perfect Setup Installing a Lamp Server.

rpm -q postgresql-devel
rpm -q postgresql

 

That should work.

 

rpm check output

Here is my output

[root@lexx ~]# rpm -q postgresql
postgresql-8.1.4-1.1
[root@lexx ~]# rpm -q postgresql-devel
package postgresql-devel is not installed
[root@lexx ~]# rpm -q postgresql-dev
package postgresql-dev is not installed
[root@lexx ~]# rpm -q php-pgsql
php-pgsql-5.1.6-3.4.fc6

 

So you need to install postgresql-dev or postgresql-devel. I don't know fedora well, but I think you can use yum to install them.

 

no luck

I installed postgresql-devel with yum. I did these commands

[root@lexx ~]# rpm -q postgresql
postgresql-8.1.8-1.fc6
[root@lexx ~]# rpm -q postgresql-devel
postgresql-devel-8.1.8-1.fc6
[root@lexx ~]# rpm -q php-pgsql
php-pgsql-5.1.6-3.4.fc6

I upagraded my ispconfig to newest version, and installed the phppgadmin addon package.

When I access the phppgadmin webpage on port 81 it gives me a login screen, and when I try to login, it says in my web browser "Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option."

 

Before starting the installation of ISPConfig you need to modify (in the extracted directory) the makefiles for php used by ISPConfig. So the steps to do would be:

1. extract the installation tar file
2. find the php source directory
3. locate the makefile for php
4. change the makefile (probably the Makefile.PL) to add the --with-pgsql flag
5. change to the top installation directory
6. start the install script

This is all untested.

 

i don't get it

1. How am i supposed to find the php source directory?
2. I cannot locate a makefile for php
3. I cannot find a file that is PROBABLY named Makefile.PL

Which suggestion is right since they contradict each other? Do I need to modify the installer or not?

postgresql and postgresql-devel were installed before installing ispconfig, and the phppgadmin addon package.

 

If you don't know how to do these steps, I suggest you use the standard installation with MySQL. Changing MySQL for Postgress and dealing with all possible issues might be too much.

 

auto detection of postgresql?

I edited the compile file install_ispconfig/compile_aps/compile to look like the following for the php section:

cd ../${PHP}
./configure --with-apxs=${INSTALL_ROOT}/httpd/bin/apxs --enable-track-vars --enable-sockets --enable-mbstring=all --with-config-file-path=${INSTALL_ROOT}/php --enable-ftp --prefix=${INSTALL_ROOT}/php ${WITH_OPENSSL} ${WITH_MYSQL} --disable-libxml --disable-dom --disable-xml ${WITH_ZLIB_DIR} --disable-xmlreader --disable-xmlwriter --disable-simplexml --without-pear --with-pgsql || error "Could not configure PHP"
make || error "Could not make PHP"
make install || error "Could not install PHP"
ln -s ${INSTALL_ROOT}/php/bin/php ${INSTALL_ROOT}/php/php

I re ./setup ispconfig. phppgadmin appears to work now.

Can future versions of ispconfig installation routines auto detect postgresql and postgresql-devel and compile --with-pgsql?

 

username and password

I don't remember being asked for a postgresql superuser username and password, what is the postgresql superuser username and password to login now from phppgadmin?

 

Maybe this link helps you: http://archives.postgresql.org/pgsql-general/2006-10/msg01330.php

 

phppgadmin addon package no longer works

The ispconfig addon package for phppgadmin no longer works with the current versions of PHP, tested with PostgreSQL 8.1.8 on PHP5.2.1.

To UPDATE your existing addon package perform the following commands:

Code:

cd /home/admispconfig/ispconfig/web/
rm -rf phppgadmin
wget http://umn.dl.sourceforge.net/sourceforge/phppgadmin/phpPgAdmin-4.1.tar.gz
tar zxvf phpPgAdmin-4.1.tar.gz
mv phpPgAdmin-4.1 phppgadmin
chown -R admispconfig:admispconfig phppgadmin

*Note: you can substitute any download server you want instead of sourceforge.net

You can now use phppgadmin at http(s)://server1.example.com:81/phppgadmin/

 

Please have a look here.

 

request PostgreSQL support for ispconfig 3