Support #951
Install OFBiz on FreeBSD
Status:
Closed
Priority:
Normal
Assignee:
Category:
Accounting Server
Target version:
Start date:
11/18/2020
Due date:
% Done:
100%
Estimated time:
Description
- Table of contents
- Prepare the Environment
- Install OFBiz
- Resources
This is a guide on installing a self-hosted OFBiz instance on FreeBSD 12.2-RELEASE.
Prepare the Environment¶
- Make sure the system is up to date:
pkg update && pkg upgrade
- Add ofbiz user:
pw add user -n ofbiz -m -s /bin/sh -c "OFBiz"
- Install the dependencies:
pkg install openjdk8 git gradle
Configure PostgreSQL¶
- Install PostgreSQL:
pkg install postgresql-jdbc postgresql96-server postgresql96-client postgresql96-contrib
- Initialize, start, and enable postgresql at boot:
sysrc postgresql_enable="YES" service postgresql initdb service postgresql start
- Log in to postgresql user account and connect to database:
su - postgres psql -d template1
- Create a user:
CREATE USER ofbiz WITH PASSWORD 'SuperSecretPassword' CREATEDB;
- Create the databases & grant all privileges on database
CREATE DATABASE ofbizdb OWNER ofbiz encoding='UTF8'; CREATE DATABASE ofbizolapdb OWNER ofbiz encoding='UTF8'; CREATE DATABASE ofbiztenantdb OWNER ofbiz encoding='UTF8';
- Create a user:
- Quit the database session
\q exit
Install OFBiz¶
- Download ofbiz:
su - ofbiz git clone -b release18.12 https://github.com/apache/ofbiz-framework cd ofbiz-framework
- Edit the entityengine.xml file:
vi framework/entity/config/entityengine.xml
- And modify the
group-map
section:<delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false"> <group-map group-name="org.apache.ofbiz" datasource-name="localpostgres"/> <group-map group-name="org.apache.ofbiz.olap" datasource-name="localpostgresolap"/> <group-map group-name="org.apache.ofbiz.tenant" datasource-name="localpostgrestenant"/> </delegator> <delegator name="default-no-eca" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" entity-eca-enabled="false distributed-cache-clear-enabled="false"> <group-map group-name="org.apache.ofbiz" datasource-name="localpostgres"/> <group-map group-name="org.apache.ofbiz.olap" datasource-name="localpostgresolap"/> <group-map group-name="org.apache.ofbiz.tenant" datasource-name="localpostgrestenant"/> </delegator> <delegator name="test" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main"> <group-map group-name="org.apache.ofbiz" datasource-name="localpostgres"/> <group-map group-name="org.apache.ofbiz.olap" datasource-name="localpostgresolap"/> <group-map group-name="org.apache.ofbiz.tenant" datasource-name="localpostgrestenant"/> </delegator>
- Also modify the
datasource
section:<datasource name="localpostgres" helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO" schema-name="public" field-type-name="postgres" check-on-start="true" add-missing-on-start="true" use-fk-initially-deferred="false" alias-view-columns="false" join-style="ansi" use-binary-type-for-blob="true" use-order-by-nulls="true" result-fetch-size="50"> <read-data reader-name="tenant"/> <read-data reader-name="seed"/> <read-data reader-name="seed-initial"/> <read-data reader-name="demo"/> <read-data reader-name="ext"/> <read-data reader-name="ext-test"/> <read-data reader-name="ext-demo"/> <inline-jdbc jdbc-driver="org.postgresql.Driver" jdbc-uri="jdbc:postgresql://127.0.0.1:5433/ofbizdb" jdbc-username="ofbiz" jdbc-password="SuperSecretPassword" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250" time-between-eviction-runs-millis="600000"/> </datasource> <datasource name="localpostgresolap" helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO" schema-name="public" field-type-name="postgres" check-on-start="true" add-missing-on-start="true" use-fk-initially-deferred="false" alias-view-columns="false" join-style="ansi" result-fetch-size="50" use-binary-type-for-blob="true" use-order-by-nulls="true"> <read-data reader-name="tenant"/> <read-data reader-name="seed"/> <read-data reader-name="seed-initial"/> <read-data reader-name="demo"/> <read-data reader-name="ext"/> <read-data reader-name="ext-test"/> <read-data reader-name="ext-demo"/> <inline-jdbc jdbc-driver="org.postgresql.Driver" jdbc-uri="jdbc:postgresql://127.0.0.1:5433/ofbizolapdb" jdbc-username="ofbiz" jdbc-password="SuperSecretPassword" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250" time-between-eviction-runs-millis="600000"/> </datasource> <datasource name="localpostgrestenant" helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO" schema-name="public" field-type-name="postgres" check-on-start="true" add-missing-on-start="true" use-fk-initially-deferred="false" alias-view-columns="false" join-style="ansi" result-fetch-size="50" use-binary-type-for-blob="true" use-order-by-nulls="true"> <read-data reader-name="tenant"/> <read-data reader-name="seed"/> <read-data reader-name="seed-initial"/> <read-data reader-name="demo"/> <read-data reader-name="ext"/> <read-data reader-name="ext-test"/> <read-data reader-name="ext-demo"/> <inline-jdbc jdbc-driver="org.postgresql.Driver" jdbc-uri="jdbc:postgresql://127.0.0.1:5433/ofbiztenantdb" jdbc-username="ofbiz" jdbc-password="SuperSecretPassword" isolation-level="ReadCommitted" pool-minsize="2" pool-maxsize="250" time-between-eviction-runs-millis="600000"/> </datasource>
- And modify the
- Edit the build.gradle file:
vi build.gradle
- And insert the postgres jdbc to the end of the compile dependencies:
dependencies { // ofbiz compile libs ... compile 'org.postgresql:postgresql:42.2.18' }
- And insert the postgres jdbc to the end of the compile dependencies:
- Compile ofbiz:
./gradlew cleanAll loadAll
Resources¶
Updated by Daniel Curtis over 4 years ago
- Description updated (diff)
- Status changed from New to In Progress
- % Done changed from 0 to 50
Updated by Daniel Curtis over 4 years ago
- Status changed from In Progress to Resolved
- % Done changed from 50 to 100