Re: unexpected_message error when connecting to remote postgresql database over ssl

[Bagas Sanjaya]

Aha!

Actually I use custom (internal) CA for doing remote connection.

When trying to add dummy OCSP responder address (I did this for 
testing), I made a typo omitting colon from `http://` scheme.


For PostgreSQL log as you mention, I think the server will log the IP 
address of connecting party instead of the hostname.


Disclaimer: My internal CA "borrow" from Linode (linode.com), so the CA 
isn't affiliated with Linode.


On 11/01/20 05.08, Robert Wynkoop wrote:

Not an expert here.

I see this in your log:

Unparseable AuthorityInfoAccess extension due to
java.io.IOException: URI name must include scheme:http//ocsp.ca.linode.com

I know when doing a secure connection, the serer must return a cert
where the issuer can be validated.

 From your log:

2020-01-09 08:29:14.952 UTC [1893] LOG:  connection received:
host=10.29.106.190 port=60432

I do not believe 10.29.106.190 can be verified as a valid host.

Hope this might help.

Robert Wynkoop


On Thu, Jan 9, 2020 at 2:55 AM Bagas Sanjaya  wrote:


Hello,

I'm trying loading OFBiz demo data (trunk version) to remote PostgreSQL
database.

The system running the database use PostgreSQL 12. I connect to database
using PostgreSQL JDBC 42.2.8.

I follow [JDBC
guide](https://jdbc.postgresql.org/documentation/91/ssl-client.html).

The story short, I got `fatal alert: unexpected message` message, which
cause data loading to fail.

However, when test connect to one of databases with `psql`, the database
can be connected successfully.

On database instance side, the log shows at the time of error:

  > could not accept SSL connection: ccs received early

Full logs are available at:
[1] [PostgreSQL Server Log]http://paste.ubuntu.com/p/4Kn8wYPZDs/
[2] [OFBiz Log, with SSL Debug log until first
fail](http://paste.ubuntu.com/p/WBknj9DKQz/)

Disabling SSL on the server (as well as setting appropriate JDBC
database URI) serve as workaround, unfortunately.

So what's wrong here?

Bagas

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





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

unexpected_message error when connecting to remote postgresql database over ssl

[Bagas Sanjaya]

Hello,

I'm trying loading OFBiz demo data (trunk version) to remote PostgreSQL 
database.


The system running the database use PostgreSQL 12. I connect to database 
using PostgreSQL JDBC 42.2.8.


I follow [JDBC 
guide](https://jdbc.postgresql.org/documentation/91/ssl-client.html).


The story short, I got `fatal alert: unexpected message` message, which 
cause data loading to fail.


However, when test connect to one of databases with `psql`, the database 
can be connected successfully.


On database instance side, the log shows at the time of error:

> could not accept SSL connection: ccs received early

Full logs are available at:
[1] [PostgreSQL Server Log]http://paste.ubuntu.com/p/4Kn8wYPZDs/
[2] [OFBiz Log, with SSL Debug log until first 
fail](http://paste.ubuntu.com/p/WBknj9DKQz/)


Disabling SSL on the server (as well as setting appropriate JDBC 
database URI) serve as workaround, unfortunately.


So what's wrong here?

Bagas

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

Re: Fixed Asset: Disposal

[Bagas Sanjaya]

So how can I create corresponding accounting transaction for EOL'ed asset?

On 23/12/19 17.51, Pierre Smits wrote:

Hi Max,

Per [1] you can set the end of life date of an asset. However, the does not
automatically lead to an accounting transaction. You'll have to add the
associated accounting transaction via [2] by creating a new one.

[1]
https://demo-trunk.ofbiz.apache.org/assetmaint/control/EditFixedAsset?fixedAssetId=DEMO_PROJECTOR
[2]
https://demo-trunk.ofbiz.apache.org/accounting/control/FindAcctgTrans?organizationPartyId=Company

I trust the above gives you an indication how to do this. Should you,
however, have any other questions and/or remarks, please let us know.
Best regards,

Pierre Smits

*Apache Trafodion , Vice President*
*Apache Directory , PMC Member*
Apache Incubator , committer
*Apache OFBiz , contributor (without privileges)
since 2008*
Apache Steve , committer


On Fri, Dec 20, 2019 at 6:56 PM Max Peak  wrote:


Hi all,

In accounting application, how does one dispose (sell, dumpsterize) a
fixed asset? I have not found a way to remove an item from fixed assets.

Thanks






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

Re: Error in trunk E-commerce

[Bagas Sanjaya]

Hi,

Can you please tell us steps to reproduce the issue?

On 16/12/19 14.33, Shrilesh Korgaonkar wrote:

Hi Guys,
https://demo-trunk.ofbiz.apache.org/ecommerce/control/main
I was trying use e-commerce trunk demo to use document upload in profile

I'm getting this is a type of error
The Following Errors Occurred:
No uploaded content found in context


Regards,
Shrilesh K.



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

Re: Fixed Asset: Disposal

[Bagas Sanjaya]

Hi Max,

Currently OFBiz doesn't have fixed asset removal feature.

On 21/12/19 00.56, Max Peak wrote:

Hi all,

In accounting application, how does one dispose (sell, dumpsterize) a 
fixed asset? I have not found a way to remove an item from fixed assets.


Thanks



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

Re: Using Different HTTPS Port

[Bagas Sanjaya]

I just want to change OFBiz ports, while keeping standard HTTP(s) port 
(80 & 443) for use by proxy (NGINX).


Regardless, my url.properties contains (note that I specified 443 
(standard HTTPS port) for OFBiz URLs):

port.https=443
force.https.host=demo.elbiz.enterprise



On 14/12/19 17.20, Jacques Le Roux wrote:

Le 14/12/2019 à 09:57, Bagas Sanjaya a écrit :
But this method only affects landing pages. Subsequent access pages 
use offset port. 
What do you mean? offsetport parameter changes the port for all URLs 
(HTTP and HTTPS). What do you want exactly?
For example, after landing on Webtools landing to login, the URL 
generated to actual login page now point to port 523.
We use it for stable and old demos for years and as you can see we have 
not this problem.


Do you use a proxy (HTTPD, Niginx) ? And If so what is you setting? If 
not, did you change something else in url.properties or elsewhere 
related to HTTPS port?


Jacques




On 13/12/19 20.47, Jacques Le Roux wrote:
With Gradle you don't need to worry about that (the doc needs some 
update).


Simply define the ports to use with "--portoffset myPortNumber"

The official OFBiz demos run on the same VM, you can find the config 
used for the stable release (R16) in


https://github.com/apache/ofbiz-tools/blob/master/demo-backup/stable-manual.sh 



HTH

Jacques

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

Hello all,

I'd like to run two OFBiz instances; one for demo and one for 
production. For production instance, I stick with default HTTPS port 
(8443). For demo, however, I had to choose other port in order to 
avoid conflict with production.


On Technical Production Setup Guide [1], port numbers are defined on 
ofbiz-containers.xml file. Unfortunately, I didn't find the 
mentioned file on my instance (as I use git repo instead). How can I 
define different HTTPS port?


Bagas


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







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

Re: Using Different HTTPS Port

[Bagas Sanjaya]

But this method only affects landing pages. Subsequent access pages use 
offset port. For example, after landing on Webtools landing to login, 
the URL generated to actual login page now point to port 523.


On 13/12/19 20.47, Jacques Le Roux wrote:

With Gradle you don't need to worry about that (the doc needs some update).

Simply define the ports to use with "--portoffset myPortNumber"

The official OFBiz demos run on the same VM, you can find the config 
used for the stable release (R16) in


https://github.com/apache/ofbiz-tools/blob/master/demo-backup/stable-manual.sh 



HTH

Jacques

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

Hello all,

I'd like to run two OFBiz instances; one for demo and one for 
production. For production instance, I stick with default HTTPS port 
(8443). For demo, however, I had to choose other port in order to 
avoid conflict with production.


On Technical Production Setup Guide [1], port numbers are defined on 
ofbiz-containers.xml file. Unfortunately, I didn't find the mentioned 
file on my instance (as I use git repo instead). How can I define 
different HTTPS port?


Bagas


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





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

Using Different HTTPS Port

[Bagas Sanjaya]

Hello all,

I'd like to run two OFBiz instances; one for demo and one for 
production. For production instance, I stick with default HTTPS port 
(8443). For demo, however, I had to choose other port in order to avoid 
conflict with production.


On Technical Production Setup Guide [1], port numbers are defined on 
ofbiz-containers.xml file. Unfortunately, I didn't find the mentioned 
file on my instance (as I use git repo instead). How can I define 
different HTTPS port?


Bagas


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


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

Re: Connecting to Remote Database Question

[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:///"
jdbc-username=""
jdbc-password=""

HTH!



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

Re: Connecting to Remote Database Question

[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: +91-98932-87847
http://www.mindpathtech.com


On Thu, Dec 12, 2019 at 7:01 PM Bagas Sanjaya  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

Re: Connecting to Remote Database Question

[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

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

Re: Setting Up New Company from Scratch

[Bagas Sanjaya]

I'm business user sir, not developer

On 05/12/19 00.25, Rishi Solanki wrote:

Bagas,
Are you developer or business user. Following links helps you to understand
the data model and coding practices.

1) https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=6556307
2)
https://cwiki.apache.org/confluence/display/OFBENDUSER/Key+data+model+reference
3) https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model

To use OFBiz you should know universal data model, there is no straight
forward approach/document know to me which can help you. May be other from
community know that and help.

Not sure, if above details helps you or not. But it will surely give you
more insights.

Best Regards,
--
Rishi Solanki
*CTO, Mindpath Technology*
Intelligent Solutions
cell: +91-98932-87847
http://www.mindpathtech.com


On Wed, Dec 4, 2019 at 5:20 PM Bagas Sanjaya  wrote:


Huh, I'm still quite not sure how I can setup my new company by manually
editing data files (I'm newbie to OFBiz here).

On 03/12/19 12.19, Rishi Solanki wrote:

Dear Bagas,
Please refer AccountingDemoData.xml L1599, Under comment  and partyId as "Company" and related

data.


This would help you to understand how company and its internal

organization

setup in OFBiz.


Best Regards,
--
Rishi Solanki
*CTO, Mindpath Technology*
Intelligent Solutions
cell: +91-98932-87847


On Mon, Dec 2, 2019 at 5:30 PM Bagas Sanjaya 

wrote:



I'm sorry to hear the unresolved ofbizsetup bug from 2015, any

workaround?


On 02/12/19 18.43, Jacques Le Roux wrote:

As I said, it's incomplete:




https://issues.apache.org/jira/issues/?jql=project%20%3D%20OFBIZ%20AND%20status%20in%20(Open%2C%20%22In%20Progress%22%2C%20Reopened)%20AND%20text%20~%20%22ofbizsetup%22



Le 02/12/2019 à 12:38, Jacques Le Roux a écrit :

That's it

Le 02/12/2019 à 12:36, Bagas Sanjaya a écrit :

AHA! Thanks Jacques for helping.

So to set up new company load seed data with `./gradlew "ofbiz
--load-data readers=seed,seed-initial", run OFBiz, and visit the
instance at `http://localhost:8443/ofbizsetup`

<http://localhost:8443/ofbizsetup>

<http://localhost:8443/ofbizsetup>.


On 02/12/19 17.58, Jacques Le Roux wrote:

As I said it appears only when you have ONLY loaded seed data, ie no
demo data.

It's then https://localhost:8443/ofbizsetup

Le 02/12/2019 à 11:30, Bagas Sanjaya a écrit :

So where is ofbizsetup URL as you mentioned?

On 02/12/19 16.23, Jacques Le Roux wrote:

Hi Bagas,

It's not yet complete, but if you load only seed data you will be
able to run ofbizsetup webapp which will help you a bit

HTH

Jacques

Le 02/12/2019 à 08:05, Bagas Sanjaya a écrit :

Sorry I didn't find the mentioned file on my instance (I run
OFBiz from git repo).

Because I'm so new to OFBiz, any step-by-step walkthrough to
create company data?

On 02/12/19 12.19, Pawan Verma wrote:

Hello Bagas,

Thanks for A2A.

You can have a look at the demo data for Organization under
OrganizationDemoData.xml.
If you want to do it from UI, you will be able to create this
data from
partymgr component as well.

HTH!











--
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

Re: Setting Up New Company from Scratch

[Bagas Sanjaya]

Huh, I'm still quite not sure how I can setup my new company by manually 
editing data files (I'm newbie to OFBiz here).


On 03/12/19 12.19, Rishi Solanki wrote:

Dear Bagas,
Please refer AccountingDemoData.xml L1599, Under comment  and partyId as "Company" and related data.

This would help you to understand how company and its internal organization
setup in OFBiz.


Best Regards,
--
Rishi Solanki
*CTO, Mindpath Technology*
Intelligent Solutions
cell: +91-98932-87847


On Mon, Dec 2, 2019 at 5:30 PM Bagas Sanjaya  wrote:


I'm sorry to hear the unresolved ofbizsetup bug from 2015, any workaround?

On 02/12/19 18.43, Jacques Le Roux wrote:

As I said, it's incomplete:


https://issues.apache.org/jira/issues/?jql=project%20%3D%20OFBIZ%20AND%20status%20in%20(Open%2C%20%22In%20Progress%22%2C%20Reopened)%20AND%20text%20~%20%22ofbizsetup%22



Le 02/12/2019 à 12:38, Jacques Le Roux a écrit :

That's it

Le 02/12/2019 à 12:36, Bagas Sanjaya a écrit :

AHA! Thanks Jacques for helping.

So to set up new company load seed data with `./gradlew "ofbiz
--load-data readers=seed,seed-initial", run OFBiz, and visit the
instance at `http://localhost:8443/ofbizsetup`

<http://localhost:8443/ofbizsetup>.


On 02/12/19 17.58, Jacques Le Roux wrote:

As I said it appears only when you have ONLY loaded seed data, ie no
demo data.

It's then https://localhost:8443/ofbizsetup

Le 02/12/2019 à 11:30, Bagas Sanjaya a écrit :

So where is ofbizsetup URL as you mentioned?

On 02/12/19 16.23, Jacques Le Roux wrote:

Hi Bagas,

It's not yet complete, but if you load only seed data you will be
able to run ofbizsetup webapp which will help you a bit

HTH

Jacques

Le 02/12/2019 à 08:05, Bagas Sanjaya a écrit :

Sorry I didn't find the mentioned file on my instance (I run
OFBiz from git repo).

Because I'm so new to OFBiz, any step-by-step walkthrough to
create company data?

On 02/12/19 12.19, Pawan Verma wrote:

Hello Bagas,

Thanks for A2A.

You can have a look at the demo data for Organization under
OrganizationDemoData.xml.
If you want to do it from UI, you will be able to create this
data from
partymgr component as well.

HTH!











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





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

Re: Setting Up New Company from Scratch

[Bagas Sanjaya]

I'm sorry to hear the unresolved ofbizsetup bug from 2015, any workaround?

On 02/12/19 18.43, Jacques Le Roux wrote:
As I said, it's incomplete: 
https://issues.apache.org/jira/issues/?jql=project%20%3D%20OFBIZ%20AND%20status%20in%20(Open%2C%20%22In%20Progress%22%2C%20Reopened)%20AND%20text%20~%20%22ofbizsetup%22 



Le 02/12/2019 à 12:38, Jacques Le Roux a écrit :

That's it

Le 02/12/2019 à 12:36, Bagas Sanjaya a écrit :

AHA! Thanks Jacques for helping.

So to set up new company load seed data with `./gradlew "ofbiz 
--load-data readers=seed,seed-initial", run OFBiz, and visit the 
instance at `http://localhost:8443/ofbizsetup`.


On 02/12/19 17.58, Jacques Le Roux wrote:
As I said it appears only when you have ONLY loaded seed data, ie no 
demo data.


It's then https://localhost:8443/ofbizsetup

Le 02/12/2019 à 11:30, Bagas Sanjaya a écrit :

So where is ofbizsetup URL as you mentioned?

On 02/12/19 16.23, Jacques Le Roux wrote:

Hi Bagas,

It's not yet complete, but if you load only seed data you will be 
able to run ofbizsetup webapp which will help you a bit


HTH

Jacques

Le 02/12/2019 à 08:05, Bagas Sanjaya a écrit :
Sorry I didn't find the mentioned file on my instance (I run 
OFBiz from git repo).


Because I'm so new to OFBiz, any step-by-step walkthrough to 
create company data?


On 02/12/19 12.19, Pawan Verma wrote:

Hello Bagas,

Thanks for A2A.

You can have a look at the demo data for Organization under
OrganizationDemoData.xml.
If you want to do it from UI, you will be able to create this 
data from

partymgr component as well.

HTH!











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

Re: Setting Up New Company from Scratch

[Bagas Sanjaya]

AHA! Thanks Jacques for helping.

So to set up new company load seed data with `./gradlew "ofbiz 
--load-data readers=seed,seed-initial", run OFBiz, and visit the 
instance at `http://localhost:8443/ofbizsetup`.


On 02/12/19 17.58, Jacques Le Roux wrote:
As I said it appears only when you have ONLY loaded seed data, ie no 
demo data.


It's then https://localhost:8443/ofbizsetup

Le 02/12/2019 à 11:30, Bagas Sanjaya a écrit :

So where is ofbizsetup URL as you mentioned?

On 02/12/19 16.23, Jacques Le Roux wrote:

Hi Bagas,

It's not yet complete, but if you load only seed data you will be 
able to run ofbizsetup webapp which will help you a bit


HTH

Jacques

Le 02/12/2019 à 08:05, Bagas Sanjaya a écrit :
Sorry I didn't find the mentioned file on my instance (I run OFBiz 
from git repo).


Because I'm so new to OFBiz, any step-by-step walkthrough to create 
company data?


On 02/12/19 12.19, Pawan Verma wrote:

Hello Bagas,

Thanks for A2A.

You can have a look at the demo data for Organization under
OrganizationDemoData.xml.
If you want to do it from UI, you will be able to create this data 
from

partymgr component as well.

HTH!







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

Re: Setting Up New Company from Scratch

[Bagas Sanjaya]

So where is ofbizsetup URL as you mentioned?

On 02/12/19 16.23, Jacques Le Roux wrote:

Hi Bagas,

It's not yet complete, but if you load only seed data you will be able 
to run ofbizsetup webapp which will help you a bit


HTH

Jacques

Le 02/12/2019 à 08:05, Bagas Sanjaya a écrit :
Sorry I didn't find the mentioned file on my instance (I run OFBiz 
from git repo).


Because I'm so new to OFBiz, any step-by-step walkthrough to create 
company data?


On 02/12/19 12.19, Pawan Verma wrote:

Hello Bagas,

Thanks for A2A.

You can have a look at the demo data for Organization under
OrganizationDemoData.xml.
If you want to do it from UI, you will be able to create this data from
partymgr component as well.

HTH!





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

Re: Setting Up New Company from Scratch

[Bagas Sanjaya]

Sorry I didn't find the mentioned file on my instance (I run OFBiz from 
git repo).


Because I'm so new to OFBiz, any step-by-step walkthrough to create 
company data?


On 02/12/19 12.19, Pawan Verma wrote:

Hello Bagas,

Thanks for A2A.

You can have a look at the demo data for Organization under
OrganizationDemoData.xml.
If you want to do it from UI, you will be able to create this data from
partymgr component as well.

HTH!



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

Setting Up New Company from Scratch

[Bagas Sanjaya]

Hello,

I'd like to use OFBiz for testing. Currently, starting OFBiz loads demo 
data for demo company. But I'd like to set up new data for my new 
(fictional) company from scratch (that is, blank data). How can I 
achieve it?


Bagas

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

Adding Additional JVM Arguments (only for ofbiz task)

[Bagas Sanjaya]

Hello,

According to PostgreSQL JDBC documentation [1], I had to start JVM with 
additional arguments that specify custom keystore:


java -Djavax.net.ssl.trustStore=mystore 
-Djavax.net.ssl.trustStorePassword=mypassword com.mycompany.MyApp


The problem is, how can I add such arguments to JVM using gradlew script 
(not as applicationDefaultJvmArgs, but as additional arguments for

`ofbiz` task)?

Bagas

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

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

Increasing JVM Memory

[Bagas Sanjaya]

Hello,

How can I increase memory allocated for JVM from gradlew script?

Bagas

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

Re: Support for Connecting to Remote Database with SSL

[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  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

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

Updating Plugins

[Bagas Sanjaya]

Hello,

Is there a way to update plugins installed on an OFBiz instance? If 
there is the case, how can I update all installed plugins?


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

404 Error on Scrum Charts

[Bagas Sanjaya]

Hello All,

I had installed OFBiz with Scrum plugin. When I visited Scrum component 
from browser, the chart functionality (such as backlog status chart) 
returned 404 error.


However, on demo-trunk.ofbiz.apache.org, the charts displayed correctly.

The full log of my instance can be found here[1].

I run OFBiz behind NGINX (reverse proxy), with following configuration:

server {
listen 80;
listen [::]:80;
server_name elbiz.enterprise;

access_log /var/nginx/logs/elbiz/access.log;
error_log  /var/nginx/logs/elbiz/error.log;

return 301 https://elbiz.enterprise$request_uri;
}

server {
listen 443 ssl;
listen [::]:443 ssl;
server_name elbiz.enterprise;

access_log /var/nginx/logs/elbiz/access.log;
error_log  /var/nginx/logs/elbiz/error.log;

location @ofbiz {
proxy_pass https://127.0.0.1:8443;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded_For $proxy_add_x_forwarded_for;
}

location ~* \.(js|css|png|jpg|jpeg|gif|ico)$ {
root /opt/ofbiz-framework/themes/common-theme/webapp/images;
try_files $uri $uri/ @ofbiz;
expires 3d;
}

location / {
root /opt/ofbiz-framework/themes/common-theme/webapp/images;
try_files $uri $uri/ @ofbiz;
}
}

Is there something wrong on my NGINX config? Or OFBiz? What can I do to 
make scrum charts working?



Bagas

[1]: https://paste.ubuntu.com/p/DvMnVpbN4y/
--
An old man doll... just what I always wanted! - Clara

OFBiz Contributor Request

[Bagas Sanjaya]

I'd like to become Apache OFBiz contributor, in order to be given full 
wiki access to add/edit pages.


My Confluence ID details:
- Full Name: Bagas Sanjaya
- Username: bagasdotme
- Email: bagasdo...@gmail.com
- Location: Tangerang, Indonesia

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

Re: systemd unit for OFBiz with Oracle JDK

[Bagas Sanjaya]

Thanks for your book suggestions sir.

On 13/08/19 01.37, OFBiz wrote:

Bagas,

Yep.  That's why I replied.  And again.  The unspoken assumption here is 
that you're running on GNU/Linux.  You are well served by schooling 
yourself on the basics of the Unix/Linux environment, especially bash. I 
can tell you here an now where you've made at least one mistake, but I'm 
not going to, because you need to learn how quoting works in 
Unix/Linux.  It is really basic stuff, stuff that is requisite to the 
job of administrating OFBiz.  Requisite to, not a part of running OFBiz.


Clear advice: get and learn a book on Linux.  I used O'Reilly's "Running 
Linux" as an introductory book, in college, suitable for an exposing my 
classes to the vast resources of GNU/Linux.  If you are going to be a 
legitimate system administrator, then grab "Learning the bash Shell" 
too, also by O'Reilly.  None of this stuff is hard, yet none of it is 
possible without familiarity. Which I think is where you're at, at this 
point.  Enjoy the ride!


David

On 8/12/19 4:22 AM, Bagas Sanjaya wrote:

Sorry if I'm still new to sysadmin world and asking such dumb question.

PS: I'm not sure whether I send this to legit-questionable email.

On 11/08/19 20.14, OFBiz wrote:
No.  This is a system administration issue, not an OFBiz issue. Learn 
your quotes.


David

On 8/11/19 2:57 AM, Bagas Sanjaya wrote:

Alright, so I write the following successful snippet:

[Unit]
Description=OFBiz service
Requires=nginx.service
After=nginx.service

[Service]
Type=simple
Environment="JAVA_HOME=/opt/jdk1.8.0_201"
Environment="PATH=/opt/jdk1.8.0_201/bin:/bin:/sbin:/usr/bin:/usr/sbin"
User=ofbiz
WorkingDirectory=/opt/apache-ofbiz-16.11.05
ExecStart=/opt/apache-ofbiz-16.11.05/gradlew ofbiz
ExecStop=/opt/apache-ofbiz-16.11.05/gradlew 'ofbiz --shutdown'

[Install]
WantedBy=multi-user.target

From above snippet, I noted:
- when quoting arguments for Environment= option, anything inside 
quote will be interpreted literally, so "$PATH:foo" will be just 
$PATH:foo. Thus I have to hard-code PATH.
- systemd requires write out full path to the executable for 
ExecStart= and ExecStop= (which is gradlew wrapper in OFBiz 
directory in this case), although WorkingDirectory is set to path of 
OFBiz.
- since I installed JDK to /opt, JAVA_HOME is set to JDK path, in 
order for OFBiz to function.


On 10/08/19 18.59, Taher Alkhateeb wrote:

Hello,

I would say this is mostly a systemd question on how to setup 
environment

variables, not an OFBiz specific question.

The answer is probably not simple because there are many ways. One 
way for
example is to use Environment= or EnvironmentFile=. Alternatively 
you can
do something like systemctl edit ofbiz-service and then edit the 
conf file.

Check [1] for more info.

[1]
https://www.freedesktop.org/software/systemd/man/systemd.service.html#Command%20lines 



On Sat, Aug 10, 2019, 2:05 PM Bagas Sanjaya  
wrote:



Hello,

I'd like to create systemd unit for my OFBiz setup which run with 
JDK from

Oracle.

However, I don't know how to set environment variables required 
(JAVA_HOME

and PATH). How can I set them correctly?

I installed Oracle JDK to /opt/jdk1.8.0_201 and OFBiz to
/opt/apache-ofbiz-16.11.05.

Kind regards, Bagas

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










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

Re: systemd unit for OFBiz with Oracle JDK

[Bagas Sanjaya]

Sorry if I'm still new to sysadmin world and asking such dumb question.

PS: I'm not sure whether I send this to legit-questionable email.

On 11/08/19 20.14, OFBiz wrote:
No.  This is a system administration issue, not an OFBiz issue. Learn 
your quotes.


David

On 8/11/19 2:57 AM, Bagas Sanjaya wrote:

Alright, so I write the following successful snippet:

[Unit]
Description=OFBiz service
Requires=nginx.service
After=nginx.service

[Service]
Type=simple
Environment="JAVA_HOME=/opt/jdk1.8.0_201"
Environment="PATH=/opt/jdk1.8.0_201/bin:/bin:/sbin:/usr/bin:/usr/sbin"
User=ofbiz
WorkingDirectory=/opt/apache-ofbiz-16.11.05
ExecStart=/opt/apache-ofbiz-16.11.05/gradlew ofbiz
ExecStop=/opt/apache-ofbiz-16.11.05/gradlew 'ofbiz --shutdown'

[Install]
WantedBy=multi-user.target

From above snippet, I noted:
- when quoting arguments for Environment= option, anything inside 
quote will be interpreted literally, so "$PATH:foo" will be just 
$PATH:foo. Thus I have to hard-code PATH.
- systemd requires write out full path to the executable for 
ExecStart= and ExecStop= (which is gradlew wrapper in OFBiz directory 
in this case), although WorkingDirectory is set to path of OFBiz.
- since I installed JDK to /opt, JAVA_HOME is set to JDK path, in 
order for OFBiz to function.


On 10/08/19 18.59, Taher Alkhateeb wrote:

Hello,

I would say this is mostly a systemd question on how to setup 
environment

variables, not an OFBiz specific question.

The answer is probably not simple because there are many ways. One 
way for
example is to use Environment= or EnvironmentFile=. Alternatively you 
can
do something like systemctl edit ofbiz-service and then edit the conf 
file.

Check [1] for more info.

[1]
https://www.freedesktop.org/software/systemd/man/systemd.service.html#Command%20lines 



On Sat, Aug 10, 2019, 2:05 PM Bagas Sanjaya  
wrote:



Hello,

I'd like to create systemd unit for my OFBiz setup which run with 
JDK from

Oracle.

However, I don't know how to set environment variables required 
(JAVA_HOME

and PATH). How can I set them correctly?

I installed Oracle JDK to /opt/jdk1.8.0_201 and OFBiz to
/opt/apache-ofbiz-16.11.05.

Kind regards, Bagas

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








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

Re: systemd unit for OFBiz with Oracle JDK

[Bagas Sanjaya]

Alright, so I write the following successful snippet:

[Unit]
Description=OFBiz service
Requires=nginx.service
After=nginx.service

[Service]
Type=simple
Environment="JAVA_HOME=/opt/jdk1.8.0_201"
Environment="PATH=/opt/jdk1.8.0_201/bin:/bin:/sbin:/usr/bin:/usr/sbin"
User=ofbiz
WorkingDirectory=/opt/apache-ofbiz-16.11.05
ExecStart=/opt/apache-ofbiz-16.11.05/gradlew ofbiz
ExecStop=/opt/apache-ofbiz-16.11.05/gradlew 'ofbiz --shutdown'

[Install]
WantedBy=multi-user.target

From above snippet, I noted:
- when quoting arguments for Environment= option, anything inside quote 
will be interpreted literally, so "$PATH:foo" will be just $PATH:foo. 
Thus I have to hard-code PATH.
- systemd requires write out full path to the executable for ExecStart= 
and ExecStop= (which is gradlew wrapper in OFBiz directory in this 
case), although WorkingDirectory is set to path of OFBiz.
- since I installed JDK to /opt, JAVA_HOME is set to JDK path, in order 
for OFBiz to function.


On 10/08/19 18.59, Taher Alkhateeb wrote:

Hello,

I would say this is mostly a systemd question on how to setup environment
variables, not an OFBiz specific question.

The answer is probably not simple because there are many ways. One way for
example is to use Environment= or EnvironmentFile=. Alternatively you can
do something like systemctl edit ofbiz-service and then edit the conf file.
Check [1] for more info.

[1]
https://www.freedesktop.org/software/systemd/man/systemd.service.html#Command%20lines

On Sat, Aug 10, 2019, 2:05 PM Bagas Sanjaya  wrote:


Hello,

I'd like to create systemd unit for my OFBiz setup which run with JDK from
Oracle.

However, I don't know how to set environment variables required (JAVA_HOME
and PATH). How can I set them correctly?

I installed Oracle JDK to /opt/jdk1.8.0_201 and OFBiz to
/opt/apache-ofbiz-16.11.05.

Kind regards, Bagas

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






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

systemd unit for OFBiz with Oracle JDK

[Bagas Sanjaya]

Hello,

I'd like to create systemd unit for my OFBiz setup which run with JDK from 
Oracle.

However, I don't know how to set environment variables required (JAVA_HOME and 
PATH). How can I set them correctly?

I installed Oracle JDK to /opt/jdk1.8.0_201 and OFBiz to 
/opt/apache-ofbiz-16.11.05.

Kind regards, Bagas

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