Welcome, Guest
Username: Password: Remember me

TOPIC: No conection to remote PostgreSQL server.

No conection to remote PostgreSQL server. 3 years 11 months ago #52019

  • mbbsm
  • mbbsm's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
Hi.

I have 2 instances instaled, the instance 1 in a computer with PostgreSQL server and the instance 2 in a computer conected to remote PostgreSQL server.

The instance 1 works fine, the instance 2 is not started, the only diference between 2 instances is the next config.php configuration:

Instance 1: $databaselocation = 'localhost';
Instance 2: $databaselocation = '192.168.1.1';

The error what appears in the instance 2 during try started is the next: Can't connect to LimeSurvey database. Reason: Database connection failed. I suspect that the syntax for adding a remote address is not correct.

Thanks in advanced and greetings.
The administrator has disabled public write access.

Re:No conection to remote PostgreSQL server. 3 years 11 months ago #52093

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6429
  • Thank you received: 840
  • Karma: 249
I think configuration are OK, but:
did the postgresql here at * or only at localhost ?
did the firewall are opened ?

:)
The administrator has disabled public write access.

Re:No conection to remote PostgreSQL server. 3 years 11 months ago #52120

  • mbbsm
  • mbbsm's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
Hi Shnoulle.

I have others applications running with that configuration (remote PostgreSQL server).

Thanks.
The administrator has disabled public write access.

Re:No conection to remote PostgreSQL server. 3 years 11 months ago #52131

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6429
  • Thank you received: 840
  • Karma: 249
Do you have some connection log on the postgresql server ?

Please switch on debug mode by adding the following line to your config.php file:
$debug = '1';

And look if there are more detail .
The administrator has disabled public write access.

Re:No conection to remote PostgreSQL server. 3 years 11 months ago #52144

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5331
  • Thank you received: 296
  • Karma: 249
Please search the forum for postgres problems, you might have to change some configuration setting.

Are both PCs within the same network? Becaue the IP you set as $databaselocation seems to belong to a local network. If trying to reach that DB-server from the web, that will fail.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.164 seconds
Donation Image