Database Server Installation & Setup
From ADempiere ERP Wiki
ADempiere can work with a number of databases. Install the database according to its own instructions. The following sections provide hints and tips on configuring the database to work with ADempiere.
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.
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
The setup script have been changed to use the EZCONNECT naming method instead of TNSNAMES. Open your Oracle Net Manager, under profile -> Naming, make sure EZCONNECT is one of the selected methods. Alternatively, verify that the SQLNET.ORA file have the following entries: NAMES.DIRECTORY_PATH = (EZCONNECT,TNSNAMES)
MySQL Installation & Setup
- 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'
- 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 standard ADempiere installation process $ <ADEMPIERE_HOME>/RUN_setup.sh
- Start ADempiere Server $ <ADEMPIERE_HOME>/utils/RUN_Server2.sh
- Start ADempeire Swing client $ <ADEMPIERE_HOME>/RUN_Adempiere.sh