Openbravo Forum End of Life Notice

Dear Openbravo Forum User,

Because of continued very low usage we decided to stop the forums on 31st of August 2017

In case of questions: webmaster "at" openbravo.com

How to access remote database

<<

joul lighter

Posts: 1

Joined: Thu Mar 29, 2012 4:28 am

Post Thu Mar 29, 2012 4:49 am

How to access remote database

I had installed the OBPOS in two computer, I want to access the database remotely , but when I configure the database in OBPOS , the system can not find the database, My database is postgres, and I want to access database like this: jdbc:postgresql://192.168.1.100:5432/openbravopos.I do not know why? Can anyone help me?
<<

Jamie Johnstone

Posts: 3

Joined: Mon Mar 26, 2012 4:08 pm

Post Wed Apr 04, 2012 10:46 pm

Re: How to access remote database

Hi there.

Have you made sure that postgresql is listening on all connections. in postgresql.conf there will be a line for "listen_addresses = "localhost" "
This may be commented out. Uncomment and change localhost to * this will make Postgre listen on all interfaces.

then you need to make sure it will allow your remote machine to access it. edit pg_hba.conf, scroll to the bottom and add
"host all all 192.168.1.***/32 md5" Where *** is your remote machines IP address.

This should sort out connection issues to postgresql.

Return to Questions

Who is online

Users browsing this forum: No registered users and 1 guest

Website Terms


Designed by ST Software for PTF.