Page History

...

NOTE: this is the technical setup guide for OFBiz, for the business oriented one, look here. 

...

Tools Installation

1. Java SDK
   Please see System Requirements for details of the correct Java JDK version required for each OFBiz version.
   
   
2. Check/install SVN client

   Expert Recommendation: If you intend to only install a release version of OFBiz you will not need the SVN client. But normally you would want to have the svn client in order to be able to upgrade easily.

...

1. If you decide not to use the embedded Derby database, check/install your database of choice. See below for some information that may help with using or installing OFBiz with alternative databases
   
   Changing from Derby to MySQL Database
   OFBiz and Oracle
   Connecting OFBiz to PostGIS spatially enabled database
   Switching from a Derby database to another
   
   
2. If necessary, put the correct JDBC driver in the following directory:
   
   
   1. ${ofbiz install dir}/framework/entity/lib/jdbc (NOTE: download the last mySQL jdbc driver)
   2. Replace the old or incorrect version of the driver (i.e. copy in with same name to avoid problems with update restoring the old driver later)
      
      
3. To setup the Entity Engine to use a different database from the default Derby database.
   In the: ${ofbiz install dir}/framework/entity/config/entityengine.xml file:

• •  Modify the "localpostgres" (or  "localmysql", etc.) datasources elements to connect to your database.
  •  Modify the "default" delegator element:

        Change
            <group-map group-name="org.apache.ofbiz" datasource-name="localpostgreslocalderby"/>
        to
            <group-map group-name="org.apache.ofbiz" datasource-name="localpostgreslocalpostgres"/>

  •     The OLAP and Tenant data sources will still use Derby. If you want to change those to use PostgreSQL also, then:

    • Modify the "localpostgresolap" datasource element to connect to your OLAP database.

    • Modify the "localpostgrestenant" datasource element to connect to your Tenant database.

  • Modify the "default" delegator element:

        Change
            <group-map group-name="org.apache.ofbiz.olap" datasource-name="localderbyolap"/>
        to
            <group-map group-name="org.apache.ofbiz.olap" datasource-name="localpostgresolap"/>
        Change
            <group-map group-name="org.apache.ofbiz.tenant" datasource-name="localderbytenant"/>
        to
            <group-map group-name="org.apache.ofbiz.tenant" datasource-name="localpostgrestenant"/>

  • Modify an existing datasource (near the bottom of the file) or create a new one by copying one of the sample datasources already there and giving it a new unique name

...

...

Security Settings

${ofbiz install dir}/framework/security/config/security.properties

...

• To ease development (Out Of The Box, OFBiz is configured in development mode) the compressHTML properties in general.properties if OFF. If you prefer to strip unnecessary whitespace from HTML output you can set it on ON (uncomment the line "#compress.HTML=true"). Note that , non html output screens like for example tab delimited exports can be then messed up. Note also that it is NOT the same thing as gzipped HTTP 1.1 compression.

• For the same reason (development mode) the line "widget.verbose=true" is uncommented. If you do not want to see any informations about widget boundaries in the generated HTLM code, you should comment this line.

Ports, Default Values

• Admin Port - 10523
  • Configured in: start.properties File
  • Referenced in: Config.java File
• HTTP - 8080
  
  • Configured in: ofbiz-containers XML File
  • Referenced in: Service Engine XML File, Client Browser (if running direct), URL Properties File
• HTTPS - 8443
  • Configured in: ofbiz-containers XML File
  • Referenced in: Client Browser (if running direct)
• AJP13 - 8009
  • Configured in: ofbiz-containers XML File
  • Referenced in: Apache mod_jk plugin configuration
• JRMP (JNDI, RMI, etc) - 1099
  • Configured in: Carol Properties (carol.jrmp.url)
  • Referenced in: Containers XML File, JNDI Properties File, Service Engine XML File
• BSH Client - 9989, 9990 (this should generally be disabled or at least protected by a firewall)
  • Configured in: ofbiz-containers XML File
• Multicast ports - 45564, etc. (Tomcat clustering)
  • Configured in: ofbiz-containers XML File

...

"keytool -import -alias ssl -trustcacerts -file mysignedcert.cer -keystore [keystore name]"

6. Configure the the framework\catalina\ofbiz-containerscomponent.xml file to point to your new keystore and password:

...

If you are having trouble getting OFBiz to connect to your mail server, try disabling your anti-virus software (temporarily) as it may block attempts to send emails from unknown applications because it thinks they are being sent by a virus.

Another possible issue is the presence in database of SystemProperty data that could overload general.properties configuration. Be sure to check the absence of mail property in SystemProperty table.

Mounting a Root WebApp

It is often desirable to have one of the webapps mounted on the root. This is often either the ecommerce webapp or your own web site, which is created as a webapp in an OFBiz component would be setup the same way.

...

Database Intensive Operations
The comments above on memory settings, caches, etc. are for category browsing pages and such where just about everything should be cached. For database intensive operations, like the product searching, it's much better to focus on how the database is managing with the queries.