Hello Jacques, Thank you very much for the clarification and for sharing your experience. That was really helpful and reassuring to know that multiple OFBiz instances can run side by side without conflict.
I am currently working with *OFBiz 18.12.19* and am now trying to connect it to a *MySQL database*. I wanted to ask for your guidance, as I am running into a persistent issue during startup. Here is what I have done so far: - Added the MySQL JDBC connector (version *9.2.0*) under framework/entity/lib - Updated entityengine.xml to map the default, OLAP, and tenant entity groups to MySQL datasources - Created three separate MySQL databases: ofbiz, ofbizolap, and ofbiztenant - Configured the MySQL datasources with the MySQL driver ( com.mysql.cj.jdbc.Driver), InnoDB tables, UTF-8 charset, and enabled check-on-start and add-missing-on-start - I am running OFBiz with *JDK 11* Despite this, OFBiz consistently fails during startup while trying to create database tables. The failure always occurs on the *PAYMENTS* table, and no tables are created successfully. I have tried multiple clean runs, but the issue persists every time. I wanted to ask: - Is there any known issue with MySQL (or newer MySQL connectors) on OFBiz 18.12.19? - Are there specific settings, connector versions, or MySQL server versions you would recommend for this OFBiz release? - Is there anything specific about the PAYMENTS entity that could commonly cause this failure? Any pointers or suggestions would be greatly appreciated. Thanks again for your time and support. Best regards, Ilma Masroor On Thu, Jan 22, 2026 at 1:28 AM Jacques Le Roux < [email protected]> wrote: > Le 21/01/2026 à 17:56, Jacques Le Roux a écrit : > > For instance using --portoffset 10000 mean that the backend port is > actually 10000+8443=10000+8443 > > For instance using --portoffset 10000 mean that the backend port is > actually 10000+8443 > > Sorry wrong C/P :) > >
