Compiere Installation on PostgreSQL in a Single-Node UNIX/Linux Environment

Document Authored by Jonah H. Harris <jonah.harris@gmail.com>
Compiere Libero Written and Maintained by e-Evolution, S.C.

Document Contents

  1. Introduction
  2. Assumptions
  3. Requirements
  4. Preinstallation Tasks
  5. Installation Procedure
  6. Known Issues and Workarounds
  7. Acknowledgements
  8. Disclaimer
  9. Attached Documents/Scripts

Introduction

This document is designed to cover a step-by-step installation of Compiere 2.5.2b
on PostgreSQL 8.0.3 in a Linux or UNIX environment. While this procedure may not work
in all situations, it has been tested on the following environments:

  • Red Hat Enterprise Linux (RHEL) Advanced Server 2.1, 3.0, and 4.0
  • Red Hat 9.0
  • Mandrake 10.0
  • SuSE SLES 9.2
  • Solaris 8
  • Solaris 9

At this time, ComPiere, Inc. does not officially certify or support PostgreSQL
as a backend database. Similarly, this is not recommended for production use at this time.

For free support, please post questions on the “Database Independence”
forum for Compiere on SourceForge. If you want to run this in a production
environment, I strongly suggest that you get a paid support agreement
(hourly or contract), by contacting me at jonah.harris@gmail.com.

Assumptions

I assume that you are familiar with PostgreSQL 8.0.3, Compiere, and Java.
Additionally, I assume that you are familiar with building packages on
the UNIX or Linux operating system. Likewise, all scripts and examples
contained in this document may require significant modifications to run
under your version of UNIX or Linux.

Scripts and examples in this document assume the following:

  • PostgreSQL and Compiere will be installed on the same machine.
  • The PostgreSQL Release is 8.0.3
  • The Compiere Release is 2.5.2b
  • The name of the PostgreSQL server is “coyote”.
  • The location of PostgreSQL on disk is “/u01/app/pgsql8/”.
  • The location of Compiere on disk is “/u01/app/pgsql8/Compiere/”.
  • The name of the Compiere database is “cptest”.
  • The name of the PostgreSQL UNIX and database user account is “pgsql8”.
  • The name of the Compiere database user account is “compiere”.

You may need to make changes to these settings in order to make these
scripts and examples work in your environment.

Requirements

The following software is required to run Compiere on PostgreSQL:

The following permissions are required to install Compiere and PostgreSQL:

  • Access to the root account or system administrator
    (for creating users/mountpoints)

Preinstallation Tasks

The following are general tasks which must be performed in order to use the software.

Create Application Directories

You need to add a directory where the PostgreSQL and Compiere files will reside.
We’re going to use an Oracle-like format.

As the root user, execute the following:

$ mkdir -p /u01/app/

Create the PostgreSQL User

You need to add a user account under which PostgreSQL and Compiere will run.
Though there is no standard user, we will use pgsql8.

As the root user, execute the following:

$ useradd -d /u01/app/pgsql8 -m pgsql8
$ passwd pgsql8

NOTE: After creating the PostgreSQL user account, setting the password,
and logging in as the PostgreSQL user, you can download and
run the Enterprise PostgreSQL build script which will complete
the remaining pre-installation tasks for you as-well-as some of the
installation tasks. If you use this script, you can skip to Configuring
Compiere under the Installation Procedure category.

Create Subdirectories

Login as the pgsql8 user and run the following commands:

$ mkdir -p product/8.0.3
$ mkdir -p product/8.0.3/jdbc/lib
$ mkdir -p product/8.0.3/rdbms/log
$ mkdir -p product/src/pkg
$ mkdir -p product/src/bld
$ export PG_HOME=`pwd`/product/8.0.3

Download Software

You now need to download the software. I have provided links to the
downloads earlier in the document.

Installation Procedure

After building the software, the procedure for installing PostgreSQL and Compiere
requires just a couple more steps.

Initialize PostgreSQL Database

Now that PostgreSQL has been built and installed, you need build
PostgreSQL’s template database. You can do this by executing the following:

Install PL/Java

Now that PostgreSQL has been built and installed, you need build
PostgreSQL’s template database. You can do this by executing the following:

Create the Compiere Database User

Now that PostgreSQL has been built and installed, you need build
PostgreSQL’s template database. You can do this by executing the following:

Configure Compiere

Now that PostgreSQL has been built and installed, you need build PostgreSQL’s template database. You can do this by executing the following:

Start Compiere

Now that PostgreSQL has been built and installed, you need build
PostgreSQL’s template database. You can do this by executing the following:

Known Issues and Workarounds

  • ISSUE: During the PostgreSQL import of Compiere’s seed database, you
    may see several errors regarding duplicates of items within the SQLJ schema.
    WORKAROUND: These errors can be disregarded.
  • ISSUE: After installation, I’m running Compiere and it seems slow to respond.
    WORKAROUND: Tune PostgreSQL. The default installation is not tuned to
    a modern machine, however, it may be easier for you to tune it by hand
    than have me guess your system capabilities.

Acknowledgements

We’d like to thank the following people, groups, and companies for their
support both directly and indirectly.

The PostgreSQL Global Development Group
For their continuing hard work developing the most advanced open
source database.

Victor Perez and e-Evolution, S.C.
For the initial release of Compiere Libero.

Jorg Janke and ComPiere, Inc.
For the most intelligently designed open source ERP system in the world.

Thomas Hallgren
For his work on PostgreSQL’s PL/Java.

Disclaimer

Each environment has its own specific set of differences and requirements.
The author makes no guarantee that the results presented in this document
will work as expected on all platforms. This document was designed
to assist in the research and troubleshooting that may be required in
a particular case and serve as a checklist of items to be aware of. Under no
circumstances and under no legal theory, whether in tort (including negligence),
contract, or otherwise, shall the author be liable to any person for any direct,
indirect, special, incidental, or consequential damages of any character
arising as a result of this documentation including, without limitation,
damages for loss of goodwill, work stoppage, computer failure or
malfunction, or any and all other commercial damages or losses.

Please forward any errors, omissions, differences, new discoveries,
and comments about this paper to jonah.harris@gmail.com.

Attached Documents/Scripts

The following documents and/or scripts have been attached to this document:

Tentang Oka Wirasatha

Focus, Mandiri dan Konsisten
Pos ini dipublikasikan di ERP dan tag . Tandai permalink.

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s