Page History

...

• •  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

...

"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.