Re: error Creating Production Orders (Hopefully you have seen before)

[Blurbiness Info]

Dear James,

Have you had a look to ofbiz/runtime/logs/error.log? This may give you more
information.

The error is raised from "createProductionRunsForProductBom"
(ProductionRunServices.java), after calling to "createManufacturingOrders"
(BOMTree.java), which in turn had called to "createManufacturingOrder"
(BOMNode.java). Here, exceptions to calling services are catched and logged
instead of being raised. So more details should be in error.log.

Regards,

El mar., 19 feb. 2019 a las 20:46,  escribió:

> Good afternoon.  I am getting the following error when trying to create
> a production Order.
>
> All the dates on the Production, Product, Routing Tasks, and Routing are
> correct.
>
> "Cannot create production run: No production run is required for product
> with id[1002] in date [2019-02-19  19:35:00.0; please verify validity
> dates of the bill of materials and routing.
>
> I am not sure why we are getting this error.  Hopefully someone as seen
> this before.  Any guidance is appreciated
>
> Thanks,
>
> James
>


-- 
*Blurbiness*
Producción multimedia para su negocio
*www.blurbiness.com* 

error Creating Production Orders (Hopefully you have seen before)

[james]

Good afternoon.  I am getting the following error when trying to create
a production Order.  

All the dates on the Production, Product, Routing Tasks, and Routing are
correct.

"Cannot create production run: No production run is required for product
with id[1002] in date [2019-02-19  19:35:00.0; please verify validity
dates of the bill of materials and routing.

I am not sure why we are getting this error.  Hopefully someone as seen
this before.  Any guidance is appreciated

Thanks,

James

Re: recording lead followup information

[Jacques Le Roux]

I see, makes sense indeed, happy it works for you :)

Maybe you could suggest a change in a Jira?

Jacques

Le 19/02/2019 à 14:16, Rajesh Mallah a écrit :

Hi Jacques ,

Nice to hear from you and the List  ,
Once again i am on  OFBiz for a different project this time and loving it !


nextStepDate is available when we create the sales opportunity.

Many a times the lead needs to be followed up before deciding to convert it
to a
account/contact combination or creating a sales opportunity.

I feel That workflow of followup cannot be captured with the current data
model.

Although i try my best to use existing models , but To deal with this i
created
a new Entity  in a separate schema of my DB ( so as not to pollute ofbiz
entities)

\d contrib.lead_followup
Table "contrib.lead_followup"
  Column |   Type   |   Modifiers
+--+
  party_id   | character varying(20)| not null
  role_type_id   | character varying(20)| not null
  next_step  | text | not null
  next_step_date | timestamp with time zone | not null
  from_date  | timestamp with time zone | not null default now()
  thru_date  | timestamp with time zone |
Foreign-key constraints:
 "lead_followup_party_id_fkey" FOREIGN KEY (party_id, role_type_id)
REFERENCES ofbiz.party_role(party_id, role_type_id)

This serves my current purpose .

regds
Rajesh Kumar Mallah.
redgrape.tech



On Tue, Feb 19, 2019 at 6:14 PM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:


Rajesh,

nextStepDate ?

Jacques

Le 16/02/2019 à 17:24, Rajesh Mallah a écrit :

Hi List,

Before creating a sales opportunity from a lead record in SFA we want to
store the information on the next followup date of a lead.

Is there any related data model or entity for that ?

*I am trying to follow


https://www.shellblack.com/whiteboard/overview-of-leads-account-and-contacts-the-salesforce-data-model/

<

https://www.shellblack.com/whiteboard/overview-of-leads-account-and-contacts-the-salesforce-data-model/

*

regds
mallah.

Re: ofbiz and SSL & apache

[Wolfgang Paul Rauchholz]

That is what I thought I did:
0) shut down ogbiz1) keytool -import -alias  -trustcacerts -file
cert.der -keystore .jks2) keytool -import -alias ofbiz
-trustcacerts -file cert.der -keystore .jks3) cp name.jks to
/usr/local/ofbiz/framework/base/config/4) edit file
/usr/local/ofbiz/framework/catalina/ofbiz-component.xml row
147: row 150: 5) start ofbiz
What am I doing wrong?
Thanks for hwlping. Wolfgang

On Tue, 2019-02-19 at 12:52 +0100, Michael Brohl wrote:
> You will need to store a certificate for the domain you want to use.
> 
> Maybe you should create your own keystore containing only your 
> certificate and point to this file instead of the original.
> 
> Regards,
> 
> Michael
> 
> 
> Am 19.02.19 um 12:22 schrieb Wolfgang Paul Rauchholz:
> > I am trying to get SSL working w/o apache for the time being.
> > I followed your procedure and could sucesfully import. Thanks.
> > Great!
> > I went the into the following
> > file:/usr/local/ofbiz/framework/catalina/ofbiz-component.xml and
> > changed thefollowing two lines:
> >   > name="keystoreFile"value="framework/base/config/ofbiz.jks"/>   
> >   
> > Which seems not to be the right, because firefox still
> > complaintsWhen I call https:
> > www.wo-lar.com:8443/myportal/control/main. I get a"Your connection
> > is not secure". www.wo-lar.com:8443 uses an invalidsecurity
> > certificate.
> > 
> > When I run :8443:/myportal/control/main I get the
> > sameerror message. But I can look at hte certificate and that tells
> > me thatit still points to the wrong certificate:Common name: ofbiz-
> > vm.apache.org
> > Any thoughts?
> > Wolfgang
> > 
> > 
> > 
> > On Tue, 2019-02-19 at 11:53 +0100, Michael Brohl wrote:
> > > Hi Wolfgang,
> > > if you already have a ceritificate, you should skip steps 2 and
> > > 3!
> > > If I understand the steps correctly, with the certreq command
> > > younowhave a certificate request with alias "ssl" in your
> > > keystore. Lateryoutry to import a certificate which is not based
> > > on your certificaterequest under the same alias "ssl".
> > > Just import your certificate with another alias and you should
> > > befine.
> > > Remember: if you use an Apache Webserver before your OFBiz
> > > instance,youdo not need to import the certificate in the
> > > keystore!
> > > Regards,
> > > Michael Brohlecomify GmbHwww.ecomify.de
> > > 
> > > Am 19.02.19 um 11:26 schrieb Wolfgang Paul Rauchholz:
> > > > How does this procedure work in case of an existing
> > > > letsencryptcertificate?
> > > > Because I have an existing certificate, can I skip steps 3?I
> > > > continued directly with step 4, uploading and conveting
> > > > cert.pemtocert.der.
> > > > But importe step 5 throws out an error: keytool
> > > > error:java.lang.Exception: Public keys in reply and keystore
> > > > don't match:
> > > > 
> > > > 1. Run: "keytool -genkey -keyalg RSA -alias ssl -keystore
> > > > [keystorename]"2. Run: "keytool -certreq -alias ssl -keyalg RSA
> > > > -file certreq.csr-keystore [keystore name]"3. Submit the CSR to
> > > > a signing authority (Thawte, Verisign, etc)4. Download your
> > > > certificate from the signing authority. Pleaseremember to
> > > > download the Certificate in PKCS#7 format. If you get
> > > > acertificate in pem format don't convert to PKCS#7/P7B Format
> > > > butderformat5. Import the Certificate into the keystore by
> > > > running:"keytool -import -alias ssl -trustcacerts -file
> > > > mysignedcert.cer-keystore [keystore name]"
> > > > 
> > > > Thanks, Wolfgang
> > > > On Mon, 2019-02-18 at 11:35 +0100, Michael Brohl wrote:
> > > > > You will have to import your certificate to the Java keystore
> > > > > and
> > > > > configure Tomcat to use it [1,2].
> > > > > 
> > > > > The standard way would be to run OFBiz behind an Apache
> > > > > webserver
> > > > > with
> > > > > the virtual hosts configured to use the certificate.
> > > > > 
> > > > > Regards,
> > > > > 
> > > > > Michael Brohl
> > > > > ecomify GmbH
> > > > > www.ecomify.de
> > > > > 
> > > > > [1] https://tomcat.apache.org/tomcat-8.5-doc/ssl-howto.html
> > > > > 
> > > > > [2]
> > > > > 
> > 
> > 
https://cwiki.apache.org/confluence/display/OFBiz/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-SSLCertificateSetup
> > > > > Am 18.02.19 um 10:53 schrieb wp.rauchh...@gmail.com:
> > > > > > Would you please point me to a procedure how to setup ofbiz
> > > > > > to
> > > > > > use
> > > > > > my letsencrypt  certificates?
> > > > > > I don't seem to be able to find one.
> > > > > > 
> > > > > > Is it possible to ruj Ofbiz under Apache webser?
> > > > > > 
> > > > > > 
> > > > > > Thank you, Wolfgang
> > > > > > 
> > > > > > 
> > > > > > 

Re: recording lead followup information

[Rajesh Mallah]

Hi Jacques ,

Nice to hear from you and the List  ,
Once again i am on  OFBiz for a different project this time and loving it !


nextStepDate is available when we create the sales opportunity.

Many a times the lead needs to be followed up before deciding to convert it
to a
account/contact combination or creating a sales opportunity.

I feel That workflow of followup cannot be captured with the current data
model.

Although i try my best to use existing models , but To deal with this i
created
a new Entity  in a separate schema of my DB ( so as not to pollute ofbiz
entities)

\d contrib.lead_followup
   Table "contrib.lead_followup"
 Column |   Type   |   Modifiers
+--+
 party_id   | character varying(20)| not null
 role_type_id   | character varying(20)| not null
 next_step  | text | not null
 next_step_date | timestamp with time zone | not null
 from_date  | timestamp with time zone | not null default now()
 thru_date  | timestamp with time zone |
Foreign-key constraints:
"lead_followup_party_id_fkey" FOREIGN KEY (party_id, role_type_id)
REFERENCES ofbiz.party_role(party_id, role_type_id)

This serves my current purpose .

regds
Rajesh Kumar Mallah.
redgrape.tech



On Tue, Feb 19, 2019 at 6:14 PM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Rajesh,
>
> nextStepDate ?
>
> Jacques
>
> Le 16/02/2019 à 17:24, Rajesh Mallah a écrit :
> > Hi List,
> >
> > Before creating a sales opportunity from a lead record in SFA we want to
> > store the information on the next followup date of a lead.
> >
> > Is there any related data model or entity for that ?
> >
> > *I am trying to follow
> >
> https://www.shellblack.com/whiteboard/overview-of-leads-account-and-contacts-the-salesforce-data-model/
> > <
> https://www.shellblack.com/whiteboard/overview-of-leads-account-and-contacts-the-salesforce-data-model/
> >
> > *
> >
> > regds
> > mallah.
> >
>

Re: recording lead followup information

[Jacques Le Roux]

Rajesh,

nextStepDate ?

Jacques

Le 16/02/2019 à 17:24, Rajesh Mallah a écrit :

Hi List,

Before creating a sales opportunity from a lead record in SFA we want to
store the information on the next followup date of a lead.

Is there any related data model or entity for that ?

*I am trying to follow
https://www.shellblack.com/whiteboard/overview-of-leads-account-and-contacts-the-salesforce-data-model/

*

regds
mallah.

Re: fkey on data_source_id of sales_opportunity

[Jacques Le Roux]

Hi Rajesh,

Yes makes sense indeed, I see no reason to no have it as it's in all other 
cases. A Jira fits.

Thanks

Jacques

Le 18/02/2019 à 20:00, Rajesh Mallah a écrit :

Hi ,

Looks like the FKEY on data_source_id in relation sales_opportunity
to data_source is missing.

Am i missing something obvious ?

regds
mallah.



  Table "ofbiz.sales_opportunity"
 Column |   Type   | Modifiers
---+--+---
  sales_opportunity_id  | character varying(20)| not null
  opportunity_name  | character varying(100)   |
  description   | text |
  next_step | text |
  next_step_date| timestamp with time zone |
  estimated_amount  | numeric(18,2)|
  estimated_probability | numeric(18,6)|
  currency_uom_id   | character varying(20)|
  marketing_campaign_id | character varying(20)|
  *data_source_id| character varying(20)| *
  estimated_close_date  | timestamp with time zone |
  opportunity_stage_id  | character varying(20)|
  type_enum_id  | character varying(20)|
  created_by_user_login | character varying(255)   |
  last_updated_stamp| timestamp with time zone |
  last_updated_tx_stamp | timestamp with time zone |
  created_stamp | timestamp with time zone |
  created_tx_stamp  | timestamp with time zone |
Indexes:
 "pk_sales_opportunity" PRIMARY KEY, btree (sales_opportunity_id)
 "sls_opprtnt_txcrts" btree (created_tx_stamp)
 "sls_opprtnt_txstmp" btree (last_updated_tx_stamp)
 "slsopp_crncy_uom" btree (currency_uom_id)
 "slsopp_mktgcmpg" btree (marketing_campaign_id)
 "slsopp_stage" btree (opportunity_stage_id)
 "slsopp_typ_enum" btree (type_enum_id)
 "slsopp_usrlgn" btree (created_by_user_login)
Foreign-key constraints:
 "slsopp_crncy_uom" FOREIGN KEY (currency_uom_id) REFERENCES
ofbiz.uom(uom_id)
 "slsopp_mktgcmpg" FOREIGN KEY (marketing_campaign_id) REFERENCES
ofbiz.marketing_campaign(marketing_campaign_id)
 "slsopp_stage" FOREIGN KEY (opportunity_stage_id) REFERENCES
ofbiz.sales_opportunity_stage(opportunity_stage_id)
 "slsopp_typ_enum" FOREIGN KEY (type_enum_id) REFERENCES
ofbiz.enumeration(enum_id)
 "slsopp_usrlgn" FOREIGN KEY (created_by_user_login) REFERENCES
ofbiz.user_login(user_login_id)

Re: ofbiz and SSL & apache

[Michael Brohl]

You will need to store a certificate for the domain you want to use.

Maybe you should create your own keystore containing only your 
certificate and point to this file instead of the original.


Regards,

Michael


Am 19.02.19 um 12:22 schrieb Wolfgang Paul Rauchholz:

I am trying to get SSL working w/o apache for the time being.

I followed your procedure and could sucesfully import. Thanks. Great!

I went the into the following file:
/usr/local/ofbiz/framework/catalina/ofbiz-component.xml and changed the
following two lines:

 
 

Which seems not to be the right, because firefox still complaints
When I call https:www.wo-lar.com:8443/myportal/control/main. I get a
"Your connection is not secure". www.wo-lar.com:8443 uses an invalid
security certificate.


When I run :8443:/myportal/control/main I get the same
error message. But I can look at hte certificate and that tells me that
it still points to the wrong certificate:
Common name: ofbiz-vm.apache.org

Any thoughts?

Wolfgang




On Tue, 2019-02-19 at 11:53 +0100, Michael Brohl wrote:

Hi Wolfgang,

if you already have a ceritificate, you should skip steps 2 and 3!

If I understand the steps correctly, with the certreq command you
now
have a certificate request with alias "ssl" in your keystore. Later
you
try to import a certificate which is not based on your certificate
request under the same alias "ssl".

Just import your certificate with another alias and you should be
fine.

Remember: if you use an Apache Webserver before your OFBiz instance,
you
do not need to import the certificate in the keystore!

Regards,

Michael Brohl
ecomify GmbH
www.ecomify.de


Am 19.02.19 um 11:26 schrieb Wolfgang Paul Rauchholz:

How does this procedure work in case of an existing letsencrypt
certificate?

Because I have an existing certificate, can I skip steps 3?
I continued directly with step 4, uploading and conveting cert.pem
to
cert.der.

But importe step 5 throws out an error: keytool error:
java.lang.Exception: Public keys in reply and keystore don't match:


1. Run: "keytool -genkey -keyalg RSA -alias ssl -keystore [keystore
name]"
2. Run: "keytool -certreq -alias ssl -keyalg RSA -file certreq.csr
-keystore [keystore name]"
3. Submit the CSR to a signing authority (Thawte, Verisign, etc)
4. Download your certificate from the signing authority. Please
remember to download the Certificate in PKCS#7 format. If you get a
certificate in pem format don't convert to PKCS#7/P7B Format but
der
format
5. Import the Certificate into the keystore by running:
"keytool -import -alias ssl -trustcacerts -file mysignedcert.cer
-keystore [keystore name]"


Thanks, Wolfgang

On Mon, 2019-02-18 at 11:35 +0100, Michael Brohl wrote:

You will have to import your certificate to the Java keystore and
configure Tomcat to use it [1,2].

The standard way would be to run OFBiz behind an Apache webserver
with
the virtual hosts configured to use the certificate.

Regards,

Michael Brohl
ecomify GmbH
www.ecomify.de

[1] https://tomcat.apache.org/tomcat-8.5-doc/ssl-howto.html

[2]




https://cwiki.apache.org/confluence/display/OFBiz/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-SSLCertificateSetup

Am 18.02.19 um 10:53 schrieb wp.rauchh...@gmail.com:

Would you please point me to a procedure how to setup ofbiz to
use
my letsencrypt  certificates?
I don't seem to be able to find one.

Is it possible to ruj Ofbiz under Apache webser?


Thank you, Wolfgang









smime.p7s
Description: S/MIME Cryptographic Signature

Re: ofbiz and SSL & apache

[Wolfgang Paul Rauchholz]

I am trying to get SSL working w/o apache for the time being.

I followed your procedure and could sucesfully import. Thanks. Great!

I went the into the following file:
/usr/local/ofbiz/framework/catalina/ofbiz-component.xml and changed the
following two lines:




Which seems not to be the right, because firefox still complaints
When I call https:www.wo-lar.com:8443/myportal/control/main. I get a
"Your connection is not secure". www.wo-lar.com:8443 uses an invalid
security certificate.


When I run :8443:/myportal/control/main I get the same
error message. But I can look at hte certificate and that tells me that
it still points to the wrong certificate:
Common name: ofbiz-vm.apache.org

Any thoughts?

Wolfgang




On Tue, 2019-02-19 at 11:53 +0100, Michael Brohl wrote:
> Hi Wolfgang,
> 
> if you already have a ceritificate, you should skip steps 2 and 3!
> 
> If I understand the steps correctly, with the certreq command you
> now 
> have a certificate request with alias "ssl" in your keystore. Later
> you 
> try to import a certificate which is not based on your certificate 
> request under the same alias "ssl".
> 
> Just import your certificate with another alias and you should be
> fine.
> 
> Remember: if you use an Apache Webserver before your OFBiz instance,
> you 
> do not need to import the certificate in the keystore!
> 
> Regards,
> 
> Michael Brohl
> ecomify GmbH
> www.ecomify.de
> 
> 
> Am 19.02.19 um 11:26 schrieb Wolfgang Paul Rauchholz:
> > How does this procedure work in case of an existing letsencrypt
> > certificate?
> > 
> > Because I have an existing certificate, can I skip steps 3?
> > I continued directly with step 4, uploading and conveting cert.pem
> > to
> > cert.der.
> > 
> > But importe step 5 throws out an error: keytool error:
> > java.lang.Exception: Public keys in reply and keystore don't match:
> > 
> > 
> > 1. Run: "keytool -genkey -keyalg RSA -alias ssl -keystore [keystore
> > name]"
> > 2. Run: "keytool -certreq -alias ssl -keyalg RSA -file certreq.csr
> > -keystore [keystore name]"
> > 3. Submit the CSR to a signing authority (Thawte, Verisign, etc)
> > 4. Download your certificate from the signing authority. Please
> > remember to download the Certificate in PKCS#7 format. If you get a
> > certificate in pem format don't convert to PKCS#7/P7B Format but
> > der
> > format
> > 5. Import the Certificate into the keystore by running:
> > "keytool -import -alias ssl -trustcacerts -file mysignedcert.cer
> > -keystore [keystore name]"
> > 
> > 
> > Thanks, Wolfgang
> > 
> > On Mon, 2019-02-18 at 11:35 +0100, Michael Brohl wrote:
> > > You will have to import your certificate to the Java keystore and
> > > configure Tomcat to use it [1,2].
> > > 
> > > The standard way would be to run OFBiz behind an Apache webserver
> > > with
> > > the virtual hosts configured to use the certificate.
> > > 
> > > Regards,
> > > 
> > > Michael Brohl
> > > ecomify GmbH
> > > www.ecomify.de
> > > 
> > > [1] https://tomcat.apache.org/tomcat-8.5-doc/ssl-howto.html
> > > 
> > > [2]
> > > 
> > 
> > 
https://cwiki.apache.org/confluence/display/OFBiz/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-SSLCertificateSetup
> > > 
> > > Am 18.02.19 um 10:53 schrieb wp.rauchh...@gmail.com:
> > > > Would you please point me to a procedure how to setup ofbiz to
> > > > use
> > > > my letsencrypt  certificates?
> > > > I don't seem to be able to find one.
> > > > 
> > > > Is it possible to ruj Ofbiz under Apache webser?
> > > > 
> > > > 
> > > > Thank you, Wolfgang
> > > > 
> > > > 
> > > > 
> 
> 

Re: ofbiz and SSL & apache

[Michael Brohl]

Hi Wolfgang,

if you already have a ceritificate, you should skip steps 2 and 3!

If I understand the steps correctly, with the certreq command you now 
have a certificate request with alias "ssl" in your keystore. Later you 
try to import a certificate which is not based on your certificate 
request under the same alias "ssl".


Just import your certificate with another alias and you should be fine.

Remember: if you use an Apache Webserver before your OFBiz instance, you 
do not need to import the certificate in the keystore!


Regards,

Michael Brohl
ecomify GmbH
www.ecomify.de


Am 19.02.19 um 11:26 schrieb Wolfgang Paul Rauchholz:

How does this procedure work in case of an existing letsencrypt
certificate?

Because I have an existing certificate, can I skip steps 3?
I continued directly with step 4, uploading and conveting cert.pem to
cert.der.

But importe step 5 throws out an error: keytool error:
java.lang.Exception: Public keys in reply and keystore don't match:


1. Run: "keytool -genkey -keyalg RSA -alias ssl -keystore [keystore
name]"
2. Run: "keytool -certreq -alias ssl -keyalg RSA -file certreq.csr
-keystore [keystore name]"
3. Submit the CSR to a signing authority (Thawte, Verisign, etc)
4. Download your certificate from the signing authority. Please
remember to download the Certificate in PKCS#7 format. If you get a
certificate in pem format don't convert to PKCS#7/P7B Format but der
format
5. Import the Certificate into the keystore by running:
"keytool -import -alias ssl -trustcacerts -file mysignedcert.cer
-keystore [keystore name]"


Thanks, Wolfgang

On Mon, 2019-02-18 at 11:35 +0100, Michael Brohl wrote:

You will have to import your certificate to the Java keystore and
configure Tomcat to use it [1,2].

The standard way would be to run OFBiz behind an Apache webserver
with
the virtual hosts configured to use the certificate.

Regards,

Michael Brohl
ecomify GmbH
www.ecomify.de

[1] https://tomcat.apache.org/tomcat-8.5-doc/ssl-howto.html

[2]


https://cwiki.apache.org/confluence/display/OFBiz/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-SSLCertificateSetup


Am 18.02.19 um 10:53 schrieb wp.rauchh...@gmail.com:

Would you please point me to a procedure how to setup ofbiz to use
my letsencrypt  certificates?
I don't seem to be able to find one.

Is it possible to ruj Ofbiz under Apache webser?


Thank you, Wolfgang









smime.p7s
Description: S/MIME Cryptographic Signature

Re: ofbiz and SSL & apache

[Wolfgang Paul Rauchholz]

How does this procedure work in case of an existing letsencrypt
certificate?

Because I have an existing certificate, can I skip steps 3?
I continued directly with step 4, uploading and conveting cert.pem to
cert.der.

But importe step 5 throws out an error: keytool error:
java.lang.Exception: Public keys in reply and keystore don't match:


1. Run: "keytool -genkey -keyalg RSA -alias ssl -keystore [keystore
name]"
2. Run: "keytool -certreq -alias ssl -keyalg RSA -file certreq.csr
-keystore [keystore name]"
3. Submit the CSR to a signing authority (Thawte, Verisign, etc)
4. Download your certificate from the signing authority. Please
remember to download the Certificate in PKCS#7 format. If you get a
certificate in pem format don't convert to PKCS#7/P7B Format but der
format
5. Import the Certificate into the keystore by running:
"keytool -import -alias ssl -trustcacerts -file mysignedcert.cer
-keystore [keystore name]"


Thanks, Wolfgang

On Mon, 2019-02-18 at 11:35 +0100, Michael Brohl wrote:
> You will have to import your certificate to the Java keystore and 
> configure Tomcat to use it [1,2].
> 
> The standard way would be to run OFBiz behind an Apache webserver
> with 
> the virtual hosts configured to use the certificate.
> 
> Regards,
> 
> Michael Brohl
> ecomify GmbH
> www.ecomify.de
> 
> [1] https://tomcat.apache.org/tomcat-8.5-doc/ssl-howto.html
> 
> [2] 
> 
https://cwiki.apache.org/confluence/display/OFBiz/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-SSLCertificateSetup
> 
> 
> Am 18.02.19 um 10:53 schrieb wp.rauchh...@gmail.com:
> > Would you please point me to a procedure how to setup ofbiz to use
> > my letsencrypt  certificates?
> > I don't seem to be able to find one.
> > 
> > Is it possible to ruj Ofbiz under Apache webser?
> > 
> > 
> > Thank you, Wolfgang
> > 
> > 
> > 
> 
> 

Re: how to fix this :ofbiz --load-data FAILED in windows 10 (URGENT)

[Shi Jinghai]

I'm using OFBiz on Windows 10 without any problem.

I guess it's a DNS problem which causes the user cannot fetch the artifacts 
successfully. This happens in our Beijing office, and our developers there have 
to use mobile phone to access jcenter.


-邮件原件-
发件人: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
发送时间: 2019年2月19日 16:23
收件人: user@ofbiz.apache.org
主题: Re: how to fix this :ofbiz --load-data FAILED in windows 10 (URGENT)

Hi chhokershaab.com,

There are no issues running on Windows 7 (I use it mostly) not sure about 
Windows 10 but I guess there are no problems either.

Anyway, I saw you used the last R16 version before, you should better use that 
even if it's not related to your problem. When you will get it working 
(hopefully) you will be safe, previous versions have security issues

Jacques

Le 19/02/2019 à 08:38, Rajesh Mallah a écrit :
> Hello chhokershaab.com,
>
> pls write reply on top of thread instead of bottom. Please do not make
> the process of helping tedious.
>
> Also a signature allows people to know whom they
> are interacting with.
>
> I am not sure about windows but getting OFBiz working on
> linux boxes is pretty straightforward.
>
> I am not saying it should be difficult on windows , but i just do not
> have experience there.
>
> regds
> Rajesh mallah
>
> (redgrape.tech)
>
> On Tue, Feb 19, 2019 at 12:14 PM chhokershaab@gmail.com <
> chhokershaab@gmail.com> wrote:
>
>>
>> On 2019/02/19 06:04:14, Paul Foxworthy  wrote:
>>> Hi,
>>>
>>> As others have said, it appears Gradle is not downloading the
>> dependencies
>>> you need.
>>>
>>> org.apache.commons.cli.ParseException is nothing special, a class in the
>>> Apache Commons library. If you are missing that, you may be missing
>> plenty
>>> of other things as well. Perhaps there was a timeout while gradle was
>>> downloading dependencies, and perhaps your build computer can't connect
>> to
>>> the Internet at all at the moment - which is why the question about
>> proxies.
>>> Try this:
>>>
>>> gradlew build --refresh-dependencies
>>>
>>> (on Linux, ./gradlew build --refresh-dependencies).
>>>
>>> Gradle should download many dependencies. If that seems to work, try
>>> your gradlew
>>> cleanAll loadDefault again.
>>>
>>> Hope that helps.
>>>
>>> Paul Foxworthy
>>>
>>> On Tue, 19 Feb 2019 at 16:17, chhokershaab@gmail.com <
>>> chhokershaab@gmail.com> wrote:
>>>

 On 2019/02/18 10:20:20, Michael Brohl 
>> wrote:
> Fix what?
>
> Are you behind a proxy?
>
> regards,
>
> Michael
>
>
> Am 18.02.19 um 10:07 schrieb chhokershaab@gmail.com:
>> On 2019/02/18 07:20:29, Michael Brohl 
 wrote:
>>> It seems that the dependencies are not automatically downloaded
>> during
>>> the Gradle build.
>>>
>>> Do you have internet access from the machine running OFBiz?
>>>
>>> You may have to set up proxy settings if you are behind a proxy.
>>>
>>> Regards,
>>>
>>> Michael
>>>
>> could you please tell me how to fix this?
>>
>>> Am 18.02.19 um 07:24 schrieb chhokershaab@gmail.com:
 On 2019/02/15 13:04:56, Ashish Pandey <
 ashish.pan...@hotwaxsystems.com> wrote:
> Hii,
>
> Did you try setting environment variables for JAVA_HOME and
 OFBIZ_HOME?
> https://www.mkyong.com/java/how-to-set-java_home-on-windows-10/
>
> Follow the instructions in the above link:
>
> JAVA_HOME = C:\Program Files\Java\jdk1.8.0_151
>
> OFBIZ_HOME = C:\apache-ofbiz-16.11.03
>
> Make sure the bin folder is in the root of C:\Program
> Files\Java\jdk1.8.0_151.
>
> On Fri, Feb 15, 2019 at 3:47 PM chhokershaab@gmail.com <
> chhokershaab@gmail.com> wrote:
>
>> I am facing this issue during installation of the Apache Ofbiz
>>
>>
>> C:\apache-ofbiz-16.11.05>gradlew cleanAll loadDefault
>> :clean UP-TO-DATE
>> :cleanAnt
>> :cleanCatalina
>> :cleanData
>> :cleanDownloads
>> :cleanEclipseClasspath UP-TO-DATE
>> :cleanEclipseJdt UP-TO-DATE
>> :cleanEclipseProject UP-TO-DATE
>> :cleanEclipse UP-TO-DATE
>> :cleanFooterFiles
>> :cleanGradle
>> :cleanIndexes
>> :cleanLogs
>> :cleanOutput
>> :cleanTempfiles
>> :cleanUploads
>> :cleanXtra
>> :cleanAll
>> :compileJava
>> Note: Some input files use unchecked or unsafe operations.
>> Note: Recompile with -Xlint:unchecked for details.
>> :processResources
>> :classes
>> :jar
>> :assemble
>> :compileTestJava
>> :processTestResources UP-TO-DATE
>> :testClasses
>> :test
>> :check
>> :build
>> :ofbiz --load-data
>> Exception in thread "main" 

Re: how to fix this :ofbiz --load-data FAILED in windows 10 (URGENT)

[Jacques Le Roux]

Hi chhokershaab.com,

There are no issues running on Windows 7 (I use it mostly) not sure about 
Windows 10 but I guess there are no problems either.

Anyway, I saw you used the last R16 version before, you should better use that even if it's not related to your problem. When you will get it working 
(hopefully) you will be safe, previous versions have security issues


Jacques

Le 19/02/2019 à 08:38, Rajesh Mallah a écrit :

Hello chhokershaab.com,

pls write reply on top of thread instead of bottom. Please do not make
the process of helping tedious.

Also a signature allows people to know whom they
are interacting with.

I am not sure about windows but getting OFBiz working on
linux boxes is pretty straightforward.

I am not saying it should be difficult on windows , but i just do not
have experience there.

regds
Rajesh mallah

(redgrape.tech)

On Tue, Feb 19, 2019 at 12:14 PM chhokershaab@gmail.com <
chhokershaab@gmail.com> wrote:



On 2019/02/19 06:04:14, Paul Foxworthy  wrote:

Hi,

As others have said, it appears Gradle is not downloading the

dependencies

you need.

org.apache.commons.cli.ParseException is nothing special, a class in the
Apache Commons library. If you are missing that, you may be missing

plenty

of other things as well. Perhaps there was a timeout while gradle was
downloading dependencies, and perhaps your build computer can't connect

to

the Internet at all at the moment - which is why the question about

proxies.

Try this:

gradlew build --refresh-dependencies

(on Linux, ./gradlew build --refresh-dependencies).

Gradle should download many dependencies. If that seems to work, try
your gradlew
cleanAll loadDefault again.

Hope that helps.

Paul Foxworthy

On Tue, 19 Feb 2019 at 16:17, chhokershaab@gmail.com <
chhokershaab@gmail.com> wrote:



On 2019/02/18 10:20:20, Michael Brohl 

wrote:

Fix what?

Are you behind a proxy?

regards,

Michael


Am 18.02.19 um 10:07 schrieb chhokershaab@gmail.com:

On 2019/02/18 07:20:29, Michael Brohl 

wrote:

It seems that the dependencies are not automatically downloaded

during

the Gradle build.

Do you have internet access from the machine running OFBiz?

You may have to set up proxy settings if you are behind a proxy.

Regards,

Michael


could you please tell me how to fix this?


Am 18.02.19 um 07:24 schrieb chhokershaab@gmail.com:

On 2019/02/15 13:04:56, Ashish Pandey <

ashish.pan...@hotwaxsystems.com> wrote:

Hii,

Did you try setting environment variables for JAVA_HOME and

OFBIZ_HOME?

https://www.mkyong.com/java/how-to-set-java_home-on-windows-10/

Follow the instructions in the above link:

JAVA_HOME = C:\Program Files\Java\jdk1.8.0_151

OFBIZ_HOME = C:\apache-ofbiz-16.11.03

Make sure the bin folder is in the root of C:\Program
Files\Java\jdk1.8.0_151.

On Fri, Feb 15, 2019 at 3:47 PM chhokershaab@gmail.com <
chhokershaab@gmail.com> wrote:


I am facing this issue during installation of the Apache Ofbiz


C:\apache-ofbiz-16.11.05>gradlew cleanAll loadDefault
:clean UP-TO-DATE
:cleanAnt
:cleanCatalina
:cleanData
:cleanDownloads
:cleanEclipseClasspath UP-TO-DATE
:cleanEclipseJdt UP-TO-DATE
:cleanEclipseProject UP-TO-DATE
:cleanEclipse UP-TO-DATE
:cleanFooterFiles
:cleanGradle
:cleanIndexes
:cleanLogs
:cleanOutput
:cleanTempfiles
:cleanUploads
:cleanXtra
:cleanAll
:compileJava
Note: Some input files use unchecked or unsafe operations.
Note: Recompile with -Xlint:unchecked for details.
:processResources
:classes
:jar
:assemble
:compileTestJava
:processTestResources UP-TO-DATE
:testClasses
:test
:check
:build
:ofbiz --load-data
Exception in thread "main" java.lang.NoClassDefFoundError:
org/apache/commons/cli/ParseException
   at

org.apache.ofbiz.base.start.Start.main(Start.java:60)

Caused by: java.lang.ClassNotFoundException:
org.apache.commons.cli.ParseException
   at

java.net.URLClassLoader.findClass(URLClassLoader.java:382)

   at

java.lang.ClassLoader.loadClass(ClassLoader.java:424)

   at

sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)

   at

java.lang.ClassLoader.loadClass(ClassLoader.java:357)

   ... 1 more
:ofbiz --load-data FAILED

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':ofbiz --load-data'.

Process 'command 'C:\Program

Files\Java\jdk1.8.0_201\bin\java.exe''

finished with non-zero exit value 1

* Try:
Run with --stacktrace option to get the stack trace. Run with

--info or

--debug option to get more log output.

BUILD FAILED

Total time: 4 mins 13.648 secs

i tried so many solutions but nothing happens!
please help!


--
Best Regards,
Ashish Kumar Pandey
HotWax Systems
m: +91 9172388455
e: ashish.pan...@hotwaxsystems.com

yeah, I have already set up the environment variable also...

still

facing the same issue!

no i m not using any kind of proxy!!

how to fix this load data failed error?



--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192

Re: how to fix this :ofbiz --load-data FAILED in windows 10 (URGENT)

[Rajesh Mallah]

Hello chhokershaab.com,

pls write reply on top of thread instead of bottom. Please do not make
the process of helping tedious.

Also a signature allows people to know whom they
are interacting with.

I am not sure about windows but getting OFBiz working on
linux boxes is pretty straightforward.

I am not saying it should be difficult on windows , but i just do not
have experience there.

regds
Rajesh mallah

(redgrape.tech)

On Tue, Feb 19, 2019 at 12:14 PM chhokershaab@gmail.com <
chhokershaab@gmail.com> wrote:

>
>
> On 2019/02/19 06:04:14, Paul Foxworthy  wrote:
> > Hi,
> >
> > As others have said, it appears Gradle is not downloading the
> dependencies
> > you need.
> >
> > org.apache.commons.cli.ParseException is nothing special, a class in the
> > Apache Commons library. If you are missing that, you may be missing
> plenty
> > of other things as well. Perhaps there was a timeout while gradle was
> > downloading dependencies, and perhaps your build computer can't connect
> to
> > the Internet at all at the moment - which is why the question about
> proxies.
> >
> > Try this:
> >
> > gradlew build --refresh-dependencies
> >
> > (on Linux, ./gradlew build --refresh-dependencies).
> >
> > Gradle should download many dependencies. If that seems to work, try
> > your gradlew
> > cleanAll loadDefault again.
> >
> > Hope that helps.
> >
> > Paul Foxworthy
> >
> > On Tue, 19 Feb 2019 at 16:17, chhokershaab@gmail.com <
> > chhokershaab@gmail.com> wrote:
> >
> > >
> > >
> > > On 2019/02/18 10:20:20, Michael Brohl 
> wrote:
> > > > Fix what?
> > > >
> > > > Are you behind a proxy?
> > > >
> > > > regards,
> > > >
> > > > Michael
> > > >
> > > >
> > > > Am 18.02.19 um 10:07 schrieb chhokershaab@gmail.com:
> > > > >
> > > > > On 2019/02/18 07:20:29, Michael Brohl 
> > > wrote:
> > > > >> It seems that the dependencies are not automatically downloaded
> during
> > > > >> the Gradle build.
> > > > >>
> > > > >> Do you have internet access from the machine running OFBiz?
> > > > >>
> > > > >> You may have to set up proxy settings if you are behind a proxy.
> > > > >>
> > > > >> Regards,
> > > > >>
> > > > >> Michael
> > > > >>
> > > > > could you please tell me how to fix this?
> > > > >
> > > > >> Am 18.02.19 um 07:24 schrieb chhokershaab@gmail.com:
> > > > >>> On 2019/02/15 13:04:56, Ashish Pandey <
> > > ashish.pan...@hotwaxsystems.com> wrote:
> > > >  Hii,
> > > > 
> > > >  Did you try setting environment variables for JAVA_HOME and
> > > OFBIZ_HOME?
> > > > 
> > > >  https://www.mkyong.com/java/how-to-set-java_home-on-windows-10/
> > > > 
> > > >  Follow the instructions in the above link:
> > > > 
> > > >  JAVA_HOME = C:\Program Files\Java\jdk1.8.0_151
> > > > 
> > > >  OFBIZ_HOME = C:\apache-ofbiz-16.11.03
> > > > 
> > > >  Make sure the bin folder is in the root of C:\Program
> > > >  Files\Java\jdk1.8.0_151.
> > > > 
> > > >  On Fri, Feb 15, 2019 at 3:47 PM chhokershaab@gmail.com <
> > > >  chhokershaab@gmail.com> wrote:
> > > > 
> > > > > I am facing this issue during installation of the Apache Ofbiz
> > > > >
> > > > >
> > > > > C:\apache-ofbiz-16.11.05>gradlew cleanAll loadDefault
> > > > > :clean UP-TO-DATE
> > > > > :cleanAnt
> > > > > :cleanCatalina
> > > > > :cleanData
> > > > > :cleanDownloads
> > > > > :cleanEclipseClasspath UP-TO-DATE
> > > > > :cleanEclipseJdt UP-TO-DATE
> > > > > :cleanEclipseProject UP-TO-DATE
> > > > > :cleanEclipse UP-TO-DATE
> > > > > :cleanFooterFiles
> > > > > :cleanGradle
> > > > > :cleanIndexes
> > > > > :cleanLogs
> > > > > :cleanOutput
> > > > > :cleanTempfiles
> > > > > :cleanUploads
> > > > > :cleanXtra
> > > > > :cleanAll
> > > > > :compileJava
> > > > > Note: Some input files use unchecked or unsafe operations.
> > > > > Note: Recompile with -Xlint:unchecked for details.
> > > > > :processResources
> > > > > :classes
> > > > > :jar
> > > > > :assemble
> > > > > :compileTestJava
> > > > > :processTestResources UP-TO-DATE
> > > > > :testClasses
> > > > > :test
> > > > > :check
> > > > > :build
> > > > > :ofbiz --load-data
> > > > > Exception in thread "main" java.lang.NoClassDefFoundError:
> > > > > org/apache/commons/cli/ParseException
> > > > >   at
> org.apache.ofbiz.base.start.Start.main(Start.java:60)
> > > > > Caused by: java.lang.ClassNotFoundException:
> > > > > org.apache.commons.cli.ParseException
> > > > >   at
> > > java.net.URLClassLoader.findClass(URLClassLoader.java:382)
> > > > >   at
> java.lang.ClassLoader.loadClass(ClassLoader.java:424)
> > > > >   at
> > > sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
> > > > >   at
> java.lang.ClassLoader.loadClass(ClassLoader.java:357)
> > > > >   ... 1 more
> > > >