PostgreSQL

[boardmain]

i'have created the update package for install
phppgadmin

but when i try to launch it i have the errore message becouse
php isn't copiled with --with-pgsql
this error if related to apache of ispconfig webserver or system apache?

how i can solve it?

(the request is for a official postgresql release :P )

[till]

Originally Posted by boardmain

i'have created the update package for install
phppgadmin

but when i try to launch it i have the errore message becouse
php isn't copiled with --with-pgsql
this error if related to apache of ispconfig webserver or system apache?

how i can solve it?

(the request is for a official postgresql release :P )

This is related to the PHP / apache of ISPConfig.

To compile the ISPConfig PHP with postgres:

1) Download the ISPConfig installer tar.gz and unpack it.
2) cd istall_ispconfig/compile_aps
3) Edit the script "compile" in the compile_aps folder and add the
--with-pgsql directive in the PHP configure statement (line 85)
4) Stop ISPConfig: /etc/init.d/ispconfig_server stop
5) Run the compile script ( ./compile)
4) Start ISPConfig: /etc/init.d/ispconfig_server start

Remark: This is untested

May you send the phppgadmin package to dev [at] ispconfig [dot] org
when everything is working? Then we can put it on the downloads page.

[falko]

Originally Posted by till

To compile the ISPConfig PHP with postgres:

1) Download the ISPConfig installer tar.gz and unpack it.
2) cd istall_ispconfig/compile_aps
3) Edit the script "compile" in the compile_aps folder and add the
--with-pgsql directive in the PHP configure statement (line 85)
4) Stop ISPConfig: /etc/init.d/ispconfig_server stop
5) Run the compile script ( ./compile)
4) Start ISPConfig: /etc/init.d/ispconfig_server start

Remark: This is untested

This won't work!
You must unpack the ISPConfig sources again, edit install_ispconfig/compile_aps/compile and change the PHP configure statement (add --with-pgsql) and then re-install ISPConfig (yes, you can install it over an existing installation)!

[boardmain]

ok i have reinstalled (if u compile after installation.. the dir ispconfig is deleted :/.... )

but now it works

i'have sended it on dev@ispconfig.org

bye

Samuele Coppedč.

[Tribal-Dolphin]

It can be interesting to add supprot of PostgreSQL to ISPConfig otherwise this plugin will have that can of interest

[till]

Originally Posted by Tribal-Dolphin

It can be interesting to add supprot of PostgreSQL to ISPConfig otherwise this plugin will have that can of interest

We are working on a patch for the installer, that PHP will be compiled with postgresql support if the setup script finds an postgres server. We will add the postgres Addon to the dowloads page, when postgres support is available.

[Tribal-Dolphin]

Originally Posted by till

We are working on a patch for the installer, that PHP will be compiled with postgresql support if the setup script finds an postgres server. We will add the postgres Addon to the dowloads page, when postgres support is available.

Great
We can add this to the roadmap ?

[till]

Originally Posted by Tribal-Dolphin

Great
We can add this to the roadmap ?

I've added it to the roadmap

[hkaiser]

Hi,

I installed php from the begining with all option, so I would need the prostgresql support now for our hosted websites. Especially I would need to make Hostingpackages where I can giv e the maximum databases in PostgreSql and if a postgresql database will be addes to the hosting packages or not. Is it possible to get the code for this addon now? Is it possible to have a look to the SVN without downloading the whole source code?

hkaiser

[till]

Originally Posted by hkaiser

Hi,

I installed php from the begining with all option, so I would need the prostgresql support now for our hosted websites. Especially I would need to make Hostingpackages where I can giv e the maximum databases in PostgreSql and if a postgresql database will be addes to the hosting packages or not. Is it possible to get the code for this addon now? Is it possible to have a look to the SVN without downloading the whole source code?

hkaiser

The things you need are not part of the addon currently developed. The addon includes only the possibility to run phppgadmin, nothing more.

I will put the phppgadmin online on the download page, but you can use it only with a reinstallation of ISPConfig and the steps perfomed in the thread above.