In order to run iDempiere you need to have a JDK (not JRE) version of java, and a proper database (PostgreSQL and Oracle are supported).
The examples on this guide are using the following versions:
- Ubuntu 18.04.1 64 bits
- PostgreSQL 9.6.10
- PostgreSQL contrib (for UUID support) - already included after postgresql 10
- OpenJDK 1.8.0_181 for release 5.1 / OpenJDK 10.0.2 for release 6.1
But this guide can be used in other systems (even Windows) taking care of installing the corresponding packages and using corresponding commands.
Please refer to http://www.ubuntu.com/download
Downloaded and installed Ubuntu Server 18.04.1 LTS
Install PostgreSQL 9.6.10
iDempiere can also run with Oracle 11G or 12C, and also with PostgreSQL >= 9.6, for this tutorial we use postgresql 9.6.10 - see http://www.postgresql.org/download/linux/ubuntu/ for details
echo "deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update sudo apt-get install postgresql-9.6 sudo apt-get install postgresql-contrib-9.6 # not required after postgresql 10 sudo service postgresql start sudo update-rc.d postgresql defaults
Assign a password to user postgres
In order to create the database the installer needs to know the password of user postgres, by default this user doesn't have a password in ubuntu (windows installer asks for a password).
In the event that there's no 'postgres' role in your postgres db, you have to create on your own using the following steps:
- Connect to your postgres db instance via psql.
- Create 'postgres' role via "CREATE USER postgres" without the double quote.
- Alter the role and specify what the role suppose to be. EX. "ALTER USER postgres SUPERUSER CREATEDB" without the double quote.
Then you can proceed to the following steps.
Please take note of the password you assign here as it will be required in the setup process:
Steps are (replace your_chosen_password by your preferred):
sudo su - postgres psql -U postgres -c "alter user postgres password 'your_chosen_password'" logout
Install OpenJDK 1.8.0_181 (for release 5.1)
sudo apt-get install openjdk-8-jdk
Install OpenJDK 10.0.2 (for release 6.1)
sudo apt-get install openjdk-10-jdk
Note: By default Ubuntu 18.04 doesn't have openjdk-10-jdk, it was required to add the repository with:
And then edit the file /etc/apt/sources.list.d/openjdk-r-ubuntu-ppa-bionic.list and change the first line to:
deb http://ppa.launchpad.net/openjdk-r/ppa/ubuntu xenial main
And also at the end of the file /etc/apt/sources.list add:
deb http://security.ubuntu.com/ubuntu xenial-security main
Now you have your prerequisites ready to receive the iDempiere installer
Note: on a centos server with minimum version you can get error on home page (by render graph) java.lang.InternalError: java.lang.reflect.InvocationTargetException
sudo apt install fontconfig sudo yum install fontconfig
After installing postgres you must check the correct configuration of /etc/postgresql/9.6/main/pg_hba.conf These two entries must be configured to use password (md5):
local all all md5 host all all 127.0.0.1/32 md5
NOTE that some guides suggest configuring trust - but that creates a security issue on your postgres server.
Most installation problems in Windows are caused by not configured environment variables:
- PATH must be configured to make the commands psql and jar accessible
- JAVA_HOME environment variable must be configured