Connecting to Remote Database Question

[Bagas Sanjaya]

Hello all,

How can I connect my OFBiz instance to remote database instance?

Bagas

--
An old man doll... just what I always wanted! - Clara

[Jacques Le Roux]

You have examples in entityengine.xml, just use the DNS or IP address.Look for jdbc-uri= in entityengine.xml. You might also change the port...

Since OFBiz simply covers the JDBC driver you may refer to

https://stackoverflow.com/questions/14657036/how-to-connect-to-a-remote-database-with-jdbc

or

https://vladmihalcea.com/jdbc-driver-connection-url-strings/

HTH

Jacques

Le 12/12/2019 à 12:48, Bagas Sanjaya a écrit :
> Hello all,
>
> How can I connect my OFBiz instance to remote database instance?
>
> Bagas
>

[Bagas Sanjaya]

OK, but I use Postgres instead.

So should I specify DB user name and password in connection URL, or
should they be skipped?

On 12/12/19 19.31, Jacques Le Roux wrote:

> You have examples in entityengine.xml, just use the DNS or IP
> address.Look for jdbc-uri= in entityengine.xml. You might also change
> the port...
>
> Since OFBiz simply covers the JDBC driver you may refer to
>
> https://stackoverflow.com/questions/14657036/how-to-connect-to-a-remote-database-with-jdbc 
>
>
> or
>
> https://vladmihalcea.com/jdbc-driver-connection-url-strings/
>
> HTH
>
> Jacques
>
> Le 12/12/2019 à 12:48, Bagas Sanjaya a écrit :
>> Hello all,
>>
>> How can I connect my OFBiz instance to remote database instance?
>>
>> Bagas
>>

--
An old man doll... just what I always wanted! - Clara

--
An old man doll... just what I always wanted! - Clara

[Rishi Solanki]

Postgres do have example in entityengine.xml. Need to change localhost from
IP address with user name and password.


Best Regards,
--
Rishi Solanki
*CTO, Mindpath Technology*
Intelligent Solutions
cell: [phone]
http://www.mindpathtech.com


On Thu, Dec 12, 2019 at 7:01 PM Bagas Sanjaya <[hidden email]> wrote:

> OK, but I use Postgres instead.
>
> So should I specify DB user name and password in connection URL, or
> should they be skipped?
>
> On 12/12/19 19.31, Jacques Le Roux wrote:
> > You have examples in entityengine.xml, just use the DNS or IP
> > address.Look for jdbc-uri= in entityengine.xml. You might also change
> > the port...
> >
> > Since OFBiz simply covers the JDBC driver you may refer to
> >
> >
> https://stackoverflow.com/questions/14657036/how-to-connect-to-a-remote-database-with-jdbc
> >
> >
> > or
> >
> > https://vladmihalcea.com/jdbc-driver-connection-url-strings/
> >
> > HTH
> >
> > Jacques
> >
> > Le 12/12/2019 à 12:48, Bagas Sanjaya a écrit :
> >> Hello all,
> >>
> >> How can I connect my OFBiz instance to remote database instance?
> >>
> >> Bagas
> >>
>
> --
> An old man doll... just what I always wanted! - Clara
>
> --
> An old man doll... just what I always wanted! - Clara
>

[Bagas Sanjaya]

So should I also specify DB user name and password in JDBC URI/URL?

On 12/12/19 22.40, Rishi Solanki wrote:

> Postgres do have example in entityengine.xml. Need to change localhost from
> IP address with user name and password.
>
>
> Best Regards,
> --
> Rishi Solanki
> *CTO, Mindpath Technology*
> Intelligent Solutions
> cell: [phone]
> http://www.mindpathtech.com
>
>
> On Thu, Dec 12, 2019 at 7:01 PM Bagas Sanjaya <[hidden email]> wrote:
>
>> OK, but I use Postgres instead.
>>
>> So should I specify DB user name and password in connection URL, or
>> should they be skipped?
>>
>> On 12/12/19 19.31, Jacques Le Roux wrote:
>>> You have examples in entityengine.xml, just use the DNS or IP
>>> address.Look for jdbc-uri= in entityengine.xml. You might also change
>>> the port...
>>>
>>> Since OFBiz simply covers the JDBC driver you may refer to
>>>
>>>
>> https://stackoverflow.com/questions/14657036/how-to-connect-to-a-remote-database-with-jdbc
>>>
>>>
>>> or
>>>
>>> https://vladmihalcea.com/jdbc-driver-connection-url-strings/
>>>
>>> HTH
>>>
>>> Jacques
>>>
>>> Le 12/12/2019 à 12:48, Bagas Sanjaya a écrit :
>>>> Hello all,
>>>>
>>>> How can I connect my OFBiz instance to remote database instance?
>>>>
>>>> Bagas
>>>>
>>
>> --
>> An old man doll... just what I always wanted! - Clara
>>
>> --
>> An old man doll... just what I always wanted! - Clara
>>
>

--
An old man doll... just what I always wanted! - Clara

[Pawan Verma]

Hello Bagas,

In entityengine.xml file, select data source as per your desired database,
in your case it is postgres. You have to mention JDBC URI/URL,
database name, user name and password to connect to the database.

Example:
jdbc-uri="jdbc:postgresql://<URL>/<DBNAME>"
jdbc-username="<DB_USERNAME>"
jdbc-password="<DB_PASSWORD>"

HTH!
--
Thanks & Regards
Pawan Verma
Technical Consultant
*HotWax Systems*
*Enterprise open source experts*
http://www.hotwaxsystems.com


On Fri, Dec 13, 2019 at 12:48 PM Bagas Sanjaya <[hidden email]> wrote:

> So should I also specify DB user name and password in JDBC URI/URL?
>
> On 12/12/19 22.40, Rishi Solanki wrote:
> > Postgres do have example in entityengine.xml. Need to change localhost
> from
> > IP address with user name and password.
> >
> >
> > Best Regards,
> > --
> > Rishi Solanki
> > *CTO, Mindpath Technology*
> > Intelligent Solutions
> > cell: [phone]
> > http://www.mindpathtech.com
> >
> >
> > On Thu, Dec 12, 2019 at 7:01 PM Bagas Sanjaya <[hidden email]>
> wrote:
> >
> >> OK, but I use Postgres instead.
> >>
> >> So should I specify DB user name and password in connection URL, or
> >> should they be skipped?
> >>
> >> On 12/12/19 19.31, Jacques Le Roux wrote:
> >>> You have examples in entityengine.xml, just use the DNS or IP
> >>> address.Look for jdbc-uri= in entityengine.xml. You might also change
> >>> the port...
> >>>
> >>> Since OFBiz simply covers the JDBC driver you may refer to
> >>>
> >>>
> >>
> https://stackoverflow.com/questions/14657036/how-to-connect-to-a-remote-database-with-jdbc
> >>>
> >>>
> >>> or
> >>>
> >>> https://vladmihalcea.com/jdbc-driver-connection-url-strings/
> >>>
> >>> HTH
> >>>
> >>> Jacques
> >>>
> >>> Le 12/12/2019 à 12:48, Bagas Sanjaya a écrit :
> >>>> Hello all,
> >>>>
> >>>> How can I connect my OFBiz instance to remote database instance?
> >>>>
> >>>> Bagas
> >>>>
> >>
> >> --
> >> An old man doll... just what I always wanted! - Clara
> >>
> >> --
> >> An old man doll... just what I always wanted! - Clara
> >>
> >
>
> --
> An old man doll... just what I always wanted! - Clara
>

[Bagas Sanjaya]

But can DB username and password be specified also on connection URL?

On 13/12/19 14.48, Pawan Verma wrote:

> Hello Bagas,
>
> In entityengine.xml file, select data source as per your desired database,
> in your case it is postgres. You have to mention JDBC URI/URL,
> database name, user name and password to connect to the database.
>
> Example:
> jdbc-uri="jdbc:postgresql://<URL>/<DBNAME>"
> jdbc-username="<DB_USERNAME>"
> jdbc-password="<DB_PASSWORD>"
>
> HTH!
>

--
An old man doll... just what I always wanted! - Clara

[Jacques Le Roux]

Why would you want to do that?

I don't know if it's possible. In general, passing parameters in URL is not recommended for security reason

Jacques

Le 13/12/2019 à 09:49, Bagas Sanjaya a écrit :

> But can DB username and password be specified also on connection URL?
>
> On 13/12/19 14.48, Pawan Verma wrote:
>> Hello Bagas,
>>
>> In entityengine.xml file, select data source as per your desired database,
>> in your case it is postgres. You have to mention JDBC URI/URL,
>> database name, user name and password to connect to the database.
>>
>> Example:
>> jdbc-uri="jdbc:postgresql://<URL>/<DBNAME>"
>> jdbc-username="<DB_USERNAME>"
>> jdbc-password="<DB_PASSWORD>"
>>
>> HTH!
>>
>