Discussion in 'Feature Requests' started by boardmain, Aug 4, 2005.

  1. till

    till Super Moderator Staff Member ISPConfig Developer

    To this forum thraed :)
  2. BigMember

    BigMember New Member


    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'?
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    You dont have to modify the installer. Just make sure that you have postgresql, the postgresql client and the postgresql development package from your linux distribution installed.
  4. BigMember

    BigMember New Member

    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
    Last edited: Mar 4, 2007
  5. falko

    falko Super Moderator ISPConfig Developer

    That should work.
  6. BigMember

    BigMember New Member

    rpm check output

    Here is my output

    [root@lexx ~]# rpm -q postgresql
    [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
  7. jnsc

    jnsc rotaredoM Moderator

    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.
    Last edited: Mar 7, 2007
  8. BigMember

    BigMember New Member

    no luck

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

    [root@lexx ~]# rpm -q postgresql
    [root@lexx ~]# rpm -q postgresql-devel
    [root@lexx ~]# rpm -q php-pgsql

    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."
  9. martinfst

    martinfst ISPConfig Developer ISPConfig Developer

    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.
  10. BigMember

    BigMember New Member

    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.
  11. martinfst

    martinfst ISPConfig Developer ISPConfig Developer

    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.
  12. BigMember

    BigMember New Member

    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?
  13. BigMember

    BigMember New Member

    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?
  14. falko

    falko Super Moderator ISPConfig Developer

  15. BigMember

    BigMember New Member

    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:

    cd /home/admispconfig/ispconfig/web/
    rm -rf phppgadmin
    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

    You can now use phppgadmin at http(s)://
    Last edited: Mar 10, 2007
  16. Hans

    Hans Moderator ISPConfig Developer

    Please have a look here. :)
  17. weldpua2008

    weldpua2008 New Member

    request PostgreSQL support for ispconfig 3

Share This Page