VAT setup in ofbiz

[wp . rauchholz]

Is this the latest and accurate guide to setup VAT in ofbiz?

Show prices with VAT included in eCommerce (B2C)

For that you must :

In your store, set the field "Show Prices With Vat Tax"=Y
Set the field "Vat Tax Auth Geo Id" with the corresponding VAT Geo (it's a 
default value, remember the VAT is applied in function of the client Geo)
Set the field "Vat Tax Auth Party Id" with a correctly set Tax Authority 
(see below how to set it in accouting)
In accouting, set your Tax Authority (and any you will need)
"Include Tax In Price"=Y
Create the "Categories" that will include products with VAT included 
(this is not mandatory, it allows to limit the scope)
Set the "Product Rates" you need. Note that you can Tax Promotions and 
Shipping if needed

I followed this guide, but VAT is not shown in ecommerce.

Wolfgang

Need help: SPANISH GENERAL ACCOUNTING PLAN (SPC)

[wp . rauchholz]

I like to accomplish the following:
1 - setup spanish accounting plan in Ofbiz
2 - make it in form of xml files available to community

Problem: I am not a finance person.

Ask: a volunteer I can meet with on e.g. Skype to complete the task

Current status: I do have EXCEL version of  accounting plan in Spanish and 
English and started to map tthat to ofbiz, but due to lack finance skills, I 
cannot complete.


Thanks for getting in touch with me.

Wolfgang

 

Translating UOMs

[wp . rauchholz]

Is there a possibility to translate UOMs so this it shows in the language as 
chosen by the user?
I could not find it in  WebTools > Label Manager.

Thanks, Wolfgang

Different VAT product / transportation

[wp . rauchholz]

I setup the tax authorities such that an VAT of 10% is applied.
But transportation should be taxed at 21%. How can I set this up?

Thanks, Wolfgang

Error message when creating sales order

[wp . rauchholz]

I am testing  ofbiz 7.12 on a derby database.
I entered through ecomseo an order. When checking out a creating the order I 
get the following error message:



The Following Errors Occurred:

Problems reading the database, please try again.ERROR: Could not create order 
(problem invoking the service: 
org.apache.ofbiz.entity.transaction.GenericTransactionException: The current 
transaction is marked for rollback, not beginning a new transaction and 
aborting current operation; the rollbackOnly was caused by: rollback called in 
Entity Engine SQLProcessorjava.lang.Exception: Current Location Stack (Current 
Location Stack) (The current transaction is marked for rollback, not beginning 
a new transaction and aborting current operation; the rollbackOnly was caused 
by: rollback called in Entity Engine SQLProcessorjava.lang.Exception: Current 
Location Stack (Current Location Stack)))

Is this a bug?

Re: Tax authority is not availble for provided Tax Authority Party and Tax Authority Geo.

[wp . rauchholz]

Never mind... just fixed it. Just for hre ones who run into the same problem. I 
made a mistake when creating up the tax authority in 
Accounting > Tax Authority.
Field Geo refers to the Regional tax authority [ES-B]. I had set [ES] for Spain.

Wolfgang

On 2019/03/22 09:56:22, wp.rauchh...@gmail.com  wrote: 
> I am having trouble to assign tax info to a supplier. I get the error message 
> as in Subject line.
> That id what I did:
> (1) I setup tax authority Spain  ESP_AT and assigned its role as tax authority
> (2) I setup a supplier and assigned its role as supplier
> (3) whn in tab 'TAX INFO' of the supplier, I chose from the drop-down windows
>  Tax Auth Geo ID: Province: [ES-B] Barcelona
>  Tax Authority Party; ESP_AT
> Is exempt; No
> Is Nexus: No
> 
> And then this error message pops up: Tax authority is not availble for 
> provided Tax Authority Party and Tax Authority Geo.
> 
> What am I missing?
> 
> Thanks, Wolfgang
> 
> 
> 
> 

Tax authority is not availble for provided Tax Authority Party and Tax Authority Geo.

[wp . rauchholz]

I am having trouble to assign tax info to a supplier. I get the error message 
as in Subject line.
That id what I did:
(1) I setup tax authority Spain  ESP_AT and assigned its role as tax authority
(2) I setup a supplier and assigned its role as supplier
(3) whn in tab 'TAX INFO' of the supplier, I chose from the drop-down windows
 Tax Auth Geo ID: Province: [ES-B] Barcelona
 Tax Authority Party; ESP_AT
Is exempt; No
Is Nexus: No

And then this error message pops up: Tax authority is not availble for provided 
Tax Authority Party and Tax Authority Geo.

What am I missing?

Thanks, Wolfgang

Updating ofbiz 16.11

[wp . rauchholz]

I currently run ofbiz 16.11 that I installed as

svn co http://svn.apache.org/repos/asf/ofbiz/branches/release16.11 ofbiz.16.11

I tried to update executing 'svn up' from home office /usr/local/ofbiz.
The only thing that happened was a 'Restore' of plugins in specialpurpose I had 
previously removed, but no further update.
How do I correctly update ofbiz?

Wolfgang

Error message price list

[wp . rauchholz]

I made a fresh install of latest 16.11  stable.
When entering a new price I get hte following error message: 
java.lang.ClassCastException: Incompatible class: java.sql.Timestamp
A price record through is was created.

When deleting a reord, I get he dollowing message:
java.lang.ClassCastException: Incompatible class: java.math.BigDecimal

Thanks, Wolfgang

myportal config.

[wp . rauchholz]

I'd appreciate a hint form the community in what I am doing wrong with the 
myportal setup. I get a long error message when accessing: 
org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen 
[component://common.

That is what I did:
I added a new security group MYPORTAL_EMPLOYEE (as in demo).
In permissions I added amongst others:  MYPORTALBASE_ADMIN ALL MyPortal base 
operations  and 
I created then a new Portal Page ID added as  'Owner User Login ID' my own 
login, set the  Security Group Id  to MYPORTAL_EMPLOYEE and added portlets.

But still not working, what am I missing?
What I notices is that - in contrast to the demo version - when I go to 
Preferences part in MyPortal, I only can create a new Portal Page, the the ones 
created do not show up there.

Thanks, WOlfgang

Web analytics

[wp . rauchholz]

I do have a few  questions around ofbiz and web analytics:

* Where can I find document on how to setup it up in orbiz?
* Does ifbiz has reporting on board I did not find?
* From your experience which other tools than google webanalytics can be used 
to drive in-depth reports? I'd rather prefer an open source tool than big 
brother google.


Thanks, Wolfgang 

ofbiz and SSL & apache

[wp . rauchholz]

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

Food nutrition database

[wp . rauchholz]

Good day.

we want to use ofbiz for a food related business.
For tyhat we need to setup a database of ingredients and their nutritional 
properties.
Is this best done hrough the 'Attributes' in the item master or is there a 
better way?
Underneath an example of the data model for an apple.

Component Value UnitSource
Proximales  
alcohol (ethanol) 0 g   310
fat, total (total lipid)trace   g   258
protein, total  0.3 g   258
water (moisture)85.7g   258
Hidratos de Carbono 
carbohydrate12g 258
sucrose 2.4   g 341
fibre, total dietary2 g 258

Thanks, Wolfgang

Delivery schedules for product categories

[wp . rauchholz]

After testing with ofbiz, I need advice from experts if the following is 
possible.

Background:
We need to show in e-Commerce a schedule of parts in weekly buckets for the 
next six weeks. I use categories for this. Example
•   Product Category Name: Products week 42: 15/10 – 21/10
•   Product Category Name: Products week 43: 22/10 – 28/10
•   Product Category Name: Products week 44: 29/10 – 4/11
•   Product Category Name: Products week 45: 5/11 – 11/11

The customer can order products in any of these weeks; but these will also be 
delivered only in that same week.
I set the THROUGH DATE in Category Roll-up to the end of each corresponding 
week (21/10, 28/10, etc..). The category will disappear once this date is 
passed. This is what we need.

Challenge:
I have not been able to define for product categories delivery valid dates from 
– to. If a customer enters an order e.g. for wk 44, he/she can enter a deliver 
for another week.

Thanks for your insight. Wolfgang

Credit Card payment service

[wp . rauchholz]

I found these providers are in the manual. Are they all tested and all working 
with ofbiz?
CyberSource
ClearCommerce.
PCCharge.
RiTA
Verisign PayFlo Pro
ValueLink (gift cards) 

Are there others?

Wolfgang

Make-to-Order / Drop-ship only

[wp . rauchholz]

(1) Does ofbiz have a functionality on board that allows to create back-to-back 
purchase orders from e-Commerce sales orders (single sales orders with multiple 
lines back to back into a single purchase order with the same lines.), skipping 
requirements all together.
In my case I work with a single source of supply who is doing kitting for us.

(2) How exactly works the parameter 'Drop-ship only' set in item master / 
inventory?

Thanks, Wolfgang

Re: Error when receiving purchase order

[wp . rauchholz]

Sorry for re-sending this email, but I cannot get past this error.

Thanks for helping.

I set the tax account in GL ACCOUNT DEFAULTS..
Would you please help me to fix this one. Thank you. Wolfgang

The Following Errors Occurred:
Error trying to begin transaction, could not process method: The current 
transaction is marked for rollback, not beginning a new transaction and 
aborting current operation; the rollbackOnly was caused by: Error in 
simple-method [Post a AcctgTrans
[file:/usr/local/ofbiz.17.12/applications/accounting/minilang/ledger/AcctgTransServices.xml#postAcctgTrans]]:
[Gl account id is not set for 2 or mapping not found for account type
Gl account id is not set for 3 or mapping not found for account type 
TAX_ACCOUNT]


Wolfgang

Error when receiving purchase order

[wp . rauchholz]

I started a fresh ofbiz install (no demo data).
I also setup GL chart of Account and reporting periods. I did not setup any 
accounts on part number level though (tab accounts) 
I can enter the PO with no problem, but when receiving I get error 
message.Which points to a problem with GL account setup. But I cannot figure 
out what it is.
Thanks for your help. Wolfgang


Error:Error trying to begin transaction, could not process method: The 
current transaction is marked for rollback, not beginning a new transaction and 
aborting current operation; the rollbackOnly was caused by: Error in 
simple-method [Post a AcctgTrans 
[file:/usr/local/ofbiz.17.12/applications/accounting/minilang/ledger/AcctgTransServices.xml#postAcctgTrans]]:
 ; [Gl account id is not set for 1 or mapping not found for account type 
UNINVOICED_SHIP_RCPT, Gl account id is not set for 2 or mapping not found 
for account type INVENTORY_ACCOUNT]

OFbiz on LAMP server

[wp . rauchholz]

I like to integrate OFbiz on my LAMP server and run it through Apache web 
server.
I googled quite a bit but can;t find anything.
Would you please point me to a how too other resources for this purpose.

Thanks, Wolfgang

Re: Missing State/Province

[wp . rauchholz]

On 2018/10/05 15:15:09, Pierre Smits  wrote: 
> Hi Wolfgang,
> 
> Please open a JIRA ticket.
> 
> On Fri, 5 Oct 2018 at 16:46 wp.rauchh...@gmail.com 
> wrote:
> 
> > The State/Provinces for Spain are missing.
> > When entering a new address the system shows "No States/Provinces exist"
> > I like to add a list of the autonomous regions in several languages to
> > standard ofibz.
> > How is this been done?
> >
> > Thanks, Wolfgang
> >
> >
> > --
> Sent from my phone
> 
JIRA ticket along with communities in several languages submitted.

Wolfgang

Missing State/Province

[wp . rauchholz]

The State/Provinces for Spain are missing.
When entering a new address the system shows "No States/Provinces exist"
I like to add a list of the autonomous regions in several languages to standard 
ofibz. 
How is this been done?

Thanks, Wolfgang

Creating product packs

[wp . rauchholz]

How to best setup a pack in ofbiz?
With pack I mean a product (e.g. a pack for 7 days of food servings) that 
includes in this example 7 individual servings. Each of these servings could be 
sold individually too.
The price is set for the pack, but the Customer should have the possibility on 
e-Commerce to open the pack and see what is inside.
The pack is either defined or can be configured.
Is this a case where 'Marketing Package' is used?

Thanks, Wolfgang

How to manage recepies through content functionality

[wp . rauchholz]

Good day!

Background:
We are in the process of setting up a food service business. We decided to go 
with ofbiz as it allows us to contain investment-$ initially. We are trying in 
phase 1 to use ofbiz standard. (maybe with exception ofeComemrce page)
We tested different scenarios and are left with a few questions we were not 
able to resolve. 


Problem descriptions

(1) BOM UOM.
Ingrediens in different UOMs (ml, gr, kg, pcs, etc..).
When defining BOM, UOM cannot be defined. Where can I set the UOM for the BOM?


(2) For each dish we need to upload its recipe along with pictures of the 
different cooking phases (either as an online text or downloadable pdf). 
Example: https://www.bbcgoodfood.com/recipes/2089/spiced-carrot-and-lentil-soup

We were testing with the Content page of the part itself as well as the Content 
menu (Forum, Blog, Content, etc..). Unfortunately, we were not able to achieve 
that a recipe is shown on the eCommerce page along with the dish, or to define 
a link that refers to that recipe and then being opened in a separate window.
Is this something ofbiz offers as functionality and where can I find a Howto?

Thanks for your help, Wolfgang

Re: Can't close Job Shop > missing: [IN] [productCostPercentageFormula.baseCost]

[wp . rauchholz]

On 2018/06/26 17:03:37, wp.rauchh...@gmail.com  wrote: 
> Problem statement. When trying to closr a Job shop I get an error message.
> Error calling event: org.apache.ofbiz.webapp.event.EventHandlerException: 
> Service invocation error (Could not commit transaction for service 
> [quickChangeProductionRunStatus] call: Roll back error, could not commit 
> transaction, was rolled back instead because of: Service 
> [productCostPercentageFormula] threw an unexpected 
> exception/errororg.apache.ofbiz.service.ServiceValidationException: The 
> following required parameter is missing: [IN] 
> [productCostPercentageFormula.baseCost]
> 
> My parts are setup accorig to the books.
> BOMs, Routings, Fixed Assets, Std costs etc.. ae setup.
> 'Auto-Calculate Costs' function works properly.
> I ran MRP tp explode BOMs and to create work orders and PO requisitions.
> I can open and confirm Job Shop and also reprot labor hours and material 
> consumption. But when trying to close the job shop with "Quick Complete", 
> Ofbiz throws out above message.
> I chcked my setup against setup demo ofbiz setup 
> "https://demo-trunk-ofbiz.apache.org;, but cannot find any difference.
> 
> What is missing? Thanks for your help. Wolfgang
> As an additional information. I looked up in 'Entity Data Maintenance' all 
> Entities that have 'Cost Comp' included and compared to de same tables in the 
> demo version. I still can't find an explanation as to why I get htis error 
> message. Thanks gain for helping. Wolfgang

Can't close Job Shop > missing: [IN] [productCostPercentageFormula.baseCost]

[wp . rauchholz]

Problem statement. When trying to closr a Job shop I get an error message.
Error calling event: org.apache.ofbiz.webapp.event.EventHandlerException: 
Service invocation error (Could not commit transaction for service 
[quickChangeProductionRunStatus] call: Roll back error, could not commit 
transaction, was rolled back instead because of: Service 
[productCostPercentageFormula] threw an unexpected 
exception/errororg.apache.ofbiz.service.ServiceValidationException: The 
following required parameter is missing: [IN] 
[productCostPercentageFormula.baseCost]

My parts are setup accorig to the books.
BOMs, Routings, Fixed Assets, Std costs etc.. ae setup.
'Auto-Calculate Costs' function works properly.
I ran MRP tp explode BOMs and to create work orders and PO requisitions.
I can open and confirm Job Shop and also reprot labor hours and material 
consumption. But when trying to close the job shop with "Quick Complete", Ofbiz 
throws out above message.
I chcked my setup against setup demo ofbiz setup 
"https://demo-trunk-ofbiz.apache.org;, but cannot find any difference.

What is missing? Thanks for your help. Wolfgang

ofbizsetup procedure

[wp . rauchholz]

Still playing with ofbiz. Now setting it up using the script ofbizsetup: 
https://10.5.2.1:8443/ofbizsetup/control/main

Observations:
Tab ‘PRODUCT STORE’; does not allow to set a currency. Ofbiz assumes USD.
Tab ‘First CUSTOMER’; missing password field under ‘User name’ on screen causes 
error message: Work-around; open a new ofbiz session and enter a customer 
before continuing with ofbizsetup procedure
Tab ‘First PRODUCT’; does not allow to set a currency. Ofbiz assumes USD.
This procedure ends up with ‘Internal Accounting Organizations’ in USD. The 
eCommerce page shows sales prices in USD too

I changed/added to BRL currency in the following screens:
•   Party > ‘Preferred Currency Uom Id’: set to BRL
•   Deleted / added standard/list price and avg cost for product to BRL
•   Store > Localization >Default Currency Uom Id’ Set to BRL
Problem: eCommerce page does not show prices in BRL. It Shows ‘Your Price: 
$0.00’

Questions:
(1) How can I change currency of ‘Internal Accounting Organizations’ to BRL?
(2) How to show prices in Brasilian Reais?

Thanks, Wolfgang

A Product Store has not been defined for this ecommerce site.

[wp . rauchholz]

I am setting up a data model starting with an empty database.

I am getting above message when trying to open the eCommerce page.
That is what I setup:
* Catalog + 2 categories (Promotion and Browse Root). Both categories have 
Products defined. 
* Store, and within the store a Website, facility, etc..

I basically replicated the way it is setup in the demo system.

What is missing?

Wolfgang

Error messages when uploading xml files

[wp . rauchholz]

I am trying to upload xml data that I had exported previously form ofbiz. Some 
of the files fail to load. But it does not give an error message.

Got 1 entities from CostComponentCalc.xml
Got 1 entities from WorkEffortCostCalc.xml
Got 1 entities from FacilityParty.xml
Failed GlAccountOrganization.xml adding to retry list for next pass
Failed GlAccountTypeDefault.xml adding to retry list for next pass
Got 1 entities from WorkEffortPartyAssignment.xml

Pass 1 complete

Failed PaymentGatewayClearCommerce.xml adding to retry list for next pass
Failed PaymentGatewayOrbital.xml adding to retry list for next pass
Failed PaymentGatewayPayflowPro.xml adding to retry list for next pass
Failed PaymentGatewaySecurePay.xml adding to retry list for next pass
Failed PaymentGatewayiDEAL.xml adding to retry list for next pass
Failed ShipmentGatewayDhl.xml adding to retry list for next pass
Failed ShipmentGatewayUps.xml adding to retry list for next pass
Failed ShipmentGatewayUsps.xml adding to retry list for next pass
Failed GlAccount.xml adding to retry list for next pass
Failed GlAccountOrganization.xml adding to retry list for next pass
Failed GlAccountTypeDefault.xml adding to retry list for next pass

Pass 2 complete

---
Succeeded: 254 of 265
Failed: 11 of 265
---

Failed Files:
/home/wp.rauchholz/ofbiz/PaymentGatewayClearCommerce.xml
/home/wp.rauchholz/ofbiz/PaymentGatewayOrbital.xml
/home/wp.rauchholz/ofbiz/PaymentGatewayPayflowPro.xml
/home/wp.rauchholz/ofbiz/PaymentGatewaySecurePay.xml
/home/wp.rauchholz/ofbiz/PaymentGatewayiDEAL.xml
/home/wp.rauchholz/ofbiz/ShipmentGatewayDhl.xml
/home/wp.rauchholz/ofbiz/ShipmentGatewayUps.xml
/home/wp.rauchholz/ofbiz/ShipmentGatewayUsps.xml
/home/wp.rauchholz/ofbiz/GlAccount.xml
/home/wp.rauchholz/ofbiz/GlAccountOrganization.xml
/home/wp.rauchholz/ofbiz/GlAccountTypeDefault.xml

Any suggestions?

Thanks for your help, WOlfgang

Re: OFBiz MRP & Manufacturing: subcontract-work

[wp . rauchholz]

On 2018/02/15 16:38:14, Yashwant Dhakad  
wrote: 
> Hi Giulio,
> 
> You can also setup multi-level BOM for contract manufacturing product. When
> you create job and the dependent production run automatically created for
> contract manufacturing product. You can issue materials into dependent
> production run and once the dependent production run completed. New
> inventory produced from dependent production run and which would be used in
> its parent job.
> 
> Thanks & Regards
> --
> Yashwant Dhakad
> HotWax Systems
> http://www.hotwaxsystems.com/
> 
> On Tue, Feb 13, 2018 at 2:48 PM, Giulio Speri - MpStyle Srl <
> giulio.sp...@mpstyle.it> wrote:
> 
> > Hello everyone!
> >
> > I'm writing because I would need some clarifications about MRP and
> > Manufacturing, in particular with the process of subcontract-working.
> >
> > I read Sharan's book on the argument, it's really well made, but I would
> > need some extra details.
> >
> > Reading the book I understood that, in the process of manufacturing a
> > finished good (a table for example), a list of task can be set up, each
> > representing a specific step required to make the finished good.
> > Now, I am focused on that tasks that can be subcontracted to an external
> > worker.
> >
> > Using the example of building a table:
> > one of the tasks of the process, could be my company X that supplies wood
> > to an external worker Y, that cut it and give back to me the finished
> > wooden board.
> > Then my company can proceed with the other manufacturing tasks.
> > At the end, the external worker Y should bill the total cost of his working
> > process to my company X.
> >
> > Is that correct or I missed something?
> > Has anybody had to handle sub-contract work with an external supplier with
> > OFBiz in a similar scenario?
> >
> > Thanks in advance to all for help,
> >
> > Kind Regards,
> >
> > Giulio
> >
> > --
> > Giulio Speri
> >
> > *Mp Styl**e Srl*
> > via Antonio Meucci, 37
> > 41019 Limidi di Soliera (MO)
> > T 059/684916
> > M 334/3779851
> >
> > www.mpstyle.it
> >
>
Following up on you discussion of sub-contracting. I am testing too.
I defined the BOM and routing task with type Subcontracting. This routing task 
was assigned a routing and all components that go to the subcontractor were 
added using 'EDIT ROUTING PRODUCT LINK'.
When releasing a work order, the system does not seem to create a PO 
automatically.
This PO should have the components attached and move the material from their 
inventory to the sub-contractor facility. By receiving the PO back, the task in 
work order should close too.
Am I missing something or does this functionality not exist?

How do I do a BOM / routing cost roll-up over the standard BOM/routing to set 
the standard cost?

Thanks, Wolfgang

Getting to know ofbiz

[wp . rauchholz]

I started testing ofbiz by configuring en empty database to build a data model 
from scratch. I do have first question (more to come I guess):
(1) How can I update exchange rates and unit of measure conversions?
(2) How can I create / delete FX rates and units of measures?
(3) I created  the admin user using the following command: ./gradlew 
loadAdminUserLogin -PuserLoginId=MyUserName
This allows me to log into ofbiz. I created now an employee and wanted to 
connect this employee with the   MyUserName. This creates an error saying the 
user name already exists. Is there a workaround for this?
(4) I cannot find a howto to configure BIRT. Please point me to one
(5) When logging in, ofbiz goes to my portal poage and opens with a very long 
error message. This message does not prevent me from working, but still 
:ERROR MESSAGE:
org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen 
[component://common/widget/PortalPageScreens.xml#showPortalPage]:...


Thank you.

Wolfgang

Contributing to testing / documenation

[wp . rauchholz]

What is the way / with wehom do I need to talk to become a contributor to the 
project?

Wolfgang

Problems setting up eCommerce

[wp . rauchholz]

Problem statement: Not able to see sub-categories and their products together 
on the on the eCommerce page.

Configuration:
Catalog > Browse Root Catalog   > Sub-category 1 > Products
 > Sub-category 2 > Products

I added the Browse Root Category to the Catalog (Browse Root One)
I linked both Subcategories to Browse Root Category as “Primary Parent 
Category” and created products in each of these Sub-Categories


Results:
(1) When I am in Browse Root Catalog and hit the “CATEGORY PAGE”, ofbiz opens 
an empty (no sub-categories, no products) eCommerce screen with the following 
message: There are no products in this category
(2) When I am in the Sub-category 1 and hit the button “CATEGORY PAGE”, it 
opens the eCommerce page of this sub-category and its products.
When hitting the button “Main” the group and the products disappear. No link to 
the sub-category is available o go back.
Same happens when I am in Sub-category 1.

What am I doing wrong?


Wolfgang

Re: Fwd: MODERATE for user@ofbiz.apache.org

[wp . rauchholz]

I am trying to install ofbiz in a CENTOS 7 server with mariadb.
Ofbiz runs fine with derby database, but I am not getting mariadb up and running
This is what I did so far
created databases in mariadb
the following connector is installed: mysql-connector-java-5.1.25-3.el7.noarch
I added the following line to the build.gradle  file:

...
dependencies {
// ofbiz compile libs

pluginLibsRuntime "mysql:mysql-connector-java:5.1.25-3"

compile 'apache-xerces:xercesImpl:2.9.1'
compile 'com.google.zxing:core:3.2.1'
..


* What went wrong:
A problem occurred evaluating root project 'ofbiz'.
> Could not find method pluginLibsRuntime() for arguments 
> [mysql:mysql-connector-java:5.1.25-3] on root project 'ofbiz'.


What am I doing wrong? Thanks for your help. Wolfgang



On 2018/05/08 16:40:15, Deepak Dixit  wrote: 
> Hi wp.rauchholz,
> 
> Your email has been moderated, Please subscribe mailing list
> http://ofbiz.apache.org/mailing-lists.html
> 
> 
> Thanks & Regards
> --
> Deepak Dixit
> 
> 
> -- Forwarded message --
> From: "wp.rauchh...@gmail.com" 
> To: 
> Cc:
> Bcc:
> Date: Tue, 08 May 2018 15:10:52 -
> Subject: Connect to mariadb
> Good day,
> 
> would you please confirm that the procedure referenced underneath is still
> up to date to connect to mariadb? I can't make it happen. Is there a better
> procedure out there?
> 
> java -jar ofbiz.jar -install: throws out a message that -install is unknown
> option
> 
> https://cwiki.apache.org/confluence/display/OFBIZ/How+
> to+migrate+OFBiz+from+Derby+to+MySQL+database
> 
> 
> Thank you for your help, Wolfgang
>