Database Server Installation & Setup
Last updated
Last updated
The 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
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.
It is recommended that you read the 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 - 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
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 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.
Oracle installation is straight forward. Follow the instructions in the Oracle documentation.
SUN JDK
Do the following after installing the above:
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
Move on to .
Move on to .
This section from . He is documenting from Trifon's .
I recommend using
Move on to .
- SF.net thread by Trifon on 2010 & 2011.
by Praneet on Jul 03, 2009.