Support for Connecting to Remote Database with SSL

[Bagas Sanjaya]

Hello,

I would like to set up OFBiz instance, which use remote database.
Connecting to database is done using SSL.

I have some question:

1. Does OFBiz support remote database connection with SSL?

2. If it is supported, how can I configure my instance to use SSL for
connecting to database?

Bagas

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

[Rahul Chohal]

Hello Bagas,

1. *OFBiz* comes with the necessary *SSL *certificate installed to *support* a
generic web browser to web server *SSL* environment

2. Please refer this document

https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide

HTH!

On Tue, 12 Nov 2019 at 7:12 AM, Bagas Sanjaya <[hidden email]> wrote:

> Hello,
>
> I would like to set up OFBiz instance, which use remote database.
> Connecting to database is done using SSL.
>
> I have some question:
>
> 1. Does OFBiz support remote database connection with SSL?
>
> 2. If it is supported, how can I configure my instance to use SSL for
> connecting to database?
>
> Bagas
>
> --
> An old man doll... just what I always wanted! - Clara
>

--
Kind Regards,
Rahul Chohal
Enterprise Software Engineer

*HotWax Systems*
*Enterprise open source experts*
cell: [phone]
office: 0731-409-3684
http://www.hotwaxsystems.com

[Bagas Sanjaya]

Sorry, not the expected answer.

What my question means are: Does OFBiz support connecting to remote
databases over SSL (that is, using SSL for connecting to database)? How
can I configure it?

On 12/11/19 14.44, Rahul Chohal wrote:

> Hello Bagas,
>
> 1. *OFBiz* comes with the necessary *SSL *certificate installed to *support* a
> generic web browser to web server *SSL* environment
>
> 2. Please refer this document
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide
>
> HTH!
>
> On Tue, 12 Nov 2019 at 7:12 AM, Bagas Sanjaya <[hidden email]> wrote:
>
>> Hello,
>>
>> I would like to set up OFBiz instance, which use remote database.
>> Connecting to database is done using SSL.
>>
>> I have some question:
>>
>> 1. Does OFBiz support remote database connection with SSL?
>>
>> 2. If it is supported, how can I configure my instance to use SSL for
>> connecting to database?
>>
>> Bagas
>>
>> --
>> An old man doll... just what I always wanted! - Clara
>>

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

[Nicolas Malin-2]

Hello,

OFBiz use jdbc driver so for postgresql check your ssl configuration [1]
and add ssl=true on your jdbc path
|'jdbc:postgresql://remote-host:5432/database?ssl=true'|

||Nicolas

[1] https://jdbc.postgresql.org/documentation/91/ssl-client.html

On 12/11/2019 09:27, Bagas Sanjaya wrote:

> Sorry, not the expected answer.
>
> What my question means are: Does OFBiz support connecting to remote
> databases over SSL (that is, using SSL for connecting to database)?
> How can I configure it?
>
> On 12/11/19 14.44, Rahul Chohal wrote:
>> Hello Bagas,
>>
>> 1. *OFBiz* comes with the necessary *SSL *certificate installed to
>> *support* a
>> generic web browser to web server *SSL* environment
>>
>> 2. Please refer this document
>>
>> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide 
>>
>>
>> HTH!
>>
>> On Tue, 12 Nov 2019 at 7:12 AM, Bagas Sanjaya <[hidden email]>
>> wrote:
>>
>>> Hello,
>>>
>>> I would like to set up OFBiz instance, which use remote database.
>>> Connecting to database is done using SSL.
>>>
>>> I have some question:
>>>
>>> 1. Does OFBiz support remote database connection with SSL?
>>>
>>> 2. If it is supported, how can I configure my instance to use SSL for
>>> connecting to database?
>>>
>>> Bagas
>>>
>>> --
>>> An old man doll... just what I always wanted! - Clara
>>>
>