Database Server Installation and Setup

Things to Think About

he ADempiere scripts will need to find the database command line utilities, so set your path to point to the "bin" directory of the database install. You can do this in the same way JAVA_HOME was used above. Create an environment variable such as DATABASE_HOME set to the database install directory, and add DATABASE_HOME/bin to your path according to the methods for your system

Note

The ADempiere application utility scripts need access to the database binary commands from the application server machine. You may need to install an empty version of database on the ADempiere application server or, at least, a copy of the necessary binary executable files.

Note

If for some twisted reason you also have Oracle running on the same machine as PostgreSQL, be aware that the two databases include some executables with the same name. If you have both POSTGRES_HOME and the equivalent ORACLE_HOME on the path, you might have errors when running some of the ADempiere scripts. Try to keep the path pointing to one or the other database at a time and switch between the two as required.

PostgreSQL Installation & Setup

It is recommended that you read the PostgreSQL Manuals carefully. There are many useful tips and tricks in the documentation and user comments.

If you use the Postgres Windows Installer, many of the following steps will be done for you by the installer but you will have to pay attention to the security settings.

The following is from the PostgreSQL installation guide after the software has been built and installed from source.

Create a unpriviledged user on the database server computer that is unique to the PostgreSQL installation and has sole access to/ownership of the data the database creates but little else. Don't use this user to install the software but ensure the PostgreSQL server daemon runs under this account. The user "postgres" is a common choice.

Log in as the "postgres" user and create the database cluster - a group of databases. This is done by defining the location where the databases will be stored. This can be anywhere on the file system. The cluster is created with the command initdb which comes with PostgreSQL. The format is

$ initdb -D /usr/local/pgsql/data

where /usr/local/pgsql/data is the location of the database cluster. As an alternative to the -D option, the environment variable PGDATA can be defined.

Note

If the postgres user is unpriviledged, the initdb command may not be able to create the data directory if it doesn't already exists. In that case, log in as root/administrator and create the data directory before you run the command as the postgres user. The initdb command will remove all access permissions to the data directory for everyone but the postgres user. See the PostgreSQL manuals for additional security settings.

It is important to properly set up the pg_hba.conf file to ensure the ADempiere application server can talk with the database. Remote TCP/IP connections will not be possible until this file is modified since the default behavior is to listen for TCP/IP connections only on the local loopback address "localhost". When the application server and the database server are separate machines, the pg_hba.conf file must be set to allow connections from the application server. For security, use as restrictive a connection as possible.

Follow the instructions to start the database server.

Move on to Application Server Installation & Setup.

Oracle Installation & Setup

Note

The Oracle XE version (Express Edition) is available for free but there are limitations on its use in terms of maximum database size, number of running instances allowed, amount of RAM used, number of CPUs used to process queries (only 1 used) and a lack of https support. While these limitations are acceptable for demonstrations and development, use in production and multi-user environments is not recommended. Please review the Oracle Database Express Edition documentation on Licensing Restrictions prior to making your choice. If you require Oracle, consider purchasing licenses for the Standard Editions.

Oracle installation is straight forward. Follow the instructions in the Oracle documentation.

Move on to Application Server Installation & Setup.

MySQL Installation & Setup

Note

ADempiere integration with MySQL requires developer support. Please verify in the repository and forums if MySQL is supported by the version of ADempiere you wish to use.

This section is from Naquib13. He is documenting from Trifon's SF thread.

SUN JDK

• MySQL 5.x (I recommend using Workbench)

Do the following after installing the above:

1. Change my.cnf file.
   • Set tables names to be lower case.
   • Enable recursive stored procedures.
   • Enable MySQL ANSI mode.

     $ sudo vim /etc/mysql/my.cnf
     lower_case_table_names=1
     max_sp_recursion_depth=128
     sql_mode='ANSI'
     

2. Restart MySQL server.

   $ sudo /etc/init.d/mysql restart
   
   

• Create "adempiere" database.

$ mysql -u root -p
mysql> create database adempiere DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_bin;

• Create "adempiere" MySQL DB user.

$ mysql -u root -p
mysql> GRANT ALL ON adempiere.* TO 'adempiere'@'localhost' IDENTIFIED BY 'adempiere';

• Import Initial MySQL DB Seed (ADempiere version 3.6.0LTS).

$ mysql -u adempiere -p -h localhost adempiere < <ADEMPIERE_HOME>/data/Adempiere_mysql.dmp

• Follow the standard ADempiere installation process.

$ <ADEMPIERE_HOME>/RUN_setup.sh

• Start ADempiere Server.

$ <ADEMPIERE_HOME>/utils/RUN_Server2.sh

• Start ADempiere Swing client.

$ <ADEMPIERE_HOME>/RUN_Adempiere.sh

Move on to Application Server Installation & Setup.

Links

• ADempiere on MySQL- SF.net thread by Trifon on 2010 & 2011.

• Running ADempiere on MySQL by Praneet on Jul 03, 2009.

• MySQL Download