You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Bagas Sanjaya <ba...@gmail.com> on 2019/11/12 01:42:46 UTC

Support for Connecting to Remote Database with SSL

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

Re: Support for Connecting to Remote Database with SSL

Posted by Nicolas Malin <ni...@nereide.fr>.
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 <ba...@gmail.com> 
>> 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
>>>
>

Re: Support for Connecting to Remote Database with SSL

Posted by Bagas Sanjaya <ba...@gmail.com>.
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 <ba...@gmail.com> 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

Re: Support for Connecting to Remote Database with SSL

Posted by Rahul Chohal <ra...@hotwaxsystems.com>.
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 <ba...@gmail.com> 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: +91-70214-19423
office: 0731-409-3684
http://www.hotwaxsystems.com