PostgreSQL from a different server

Mehr
3 Jahre 5 Tage her #111066 von kingmaker
kingmaker erstellte das Thema PostgreSQL from a different server
Hello, here is the situation :
  • I have a surver called ABC ( say abc.com is the address) and that is where I will have my limeSurvey installed.
  • I have a dedicated Database server called "XYZ" and that is where I want the database to be fetched for my limeSurvey.

Please note that the dabase is of PostgreSQL.

While installing, it does not show PostgreSQL in the pre-installation and Configuration pages :(


I CANNOT change the database typr to PostgreSQl. I can fill in the details like Database location (Hostname which is xyz.com in my case), Database user, Database password, Database name. BUt connection error. Ofcourse that is expected.

The connection to the database server has to be done using port: 5434.

In short, I am not being able to install limeSurvey. How can I resolve this issue.

Bitte Anmelden um der Konversation beizutretten.

Mehr
3 Jahre 4 Tage her #111073 von DenisChenu
DenisChenu antwortete auf das Thema: PostgreSQL from a different server

While installing, it does not show PostgreSQL in the pre-installation and Configuration pages :(

You need pdo_pgsql to connect to a postgre DB.

php.net//manual/en/ref.pdo-pgsql.php

Need to be installed and activated ( aptitude install php5-pgsql for example).

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden um der Konversation beizutretten.

Mehr
3 Jahre 4 Tage her #111112 von kingmaker
kingmaker antwortete auf das Thema: PostgreSQL from a different server
I tried it, now I am being able to see the postGreSQl, but still I am not being able to connect.

Attaching the screenshot.


I have checked the connection to the database server and also the database mentioned using terminal, they are correct and they exist.

Not being able to figure out what has to be done now to get it working.
Anhang:

Bitte Anmelden um der Konversation beizutretten.

Mehr
2 Jahre 11 Monate her #111208 von DenisChenu
DenisChenu antwortete auf das Thema: PostgreSQL from a different server
The port is OK ?

I think you can use DBHOST:port

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden um der Konversation beizutretten.

Haben Sie schon bei unserer Kundenumfrage mitgemacht?

Verpassen Sie nicht Ihre Chance auf tolle Preise.

Klicken sie hier um teilzunehmen:

Jetzt starten

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten