This tutorial is needed after – iDempiere setup under use of Eclipse Juno 4.2 on Windows/Linux/MacOS. It shows how you can create an iDempiere/ADempiere database on Linux.
1. Postgresql Installation
If you haven’t already installed Postgres, than you can do like this:
Open a terminal and login as root and type: apt-get install postgresql-9.1
After everything has been installed the postgresql server will start automatically.
2. Changing the pg_hba.conf file
For changing the file you have to now where your postgresql/9.1/main/ directory is and that vim is installed. (If vim is not installed just type: apt-get install vim)
Now type: vim /etc/postgresql/9.1/main/pg_hba.conf
Change the file in the way I did it:
For that you use Del to delete the letters and Ins to insert new ones. Than press ESC. And after that write :wq
-
- This terminal window shows the pg_hba.conf after changing with vim
-
- This terminal window shows the settings of the pg_hba.conf after postgresql installation.
-
- This terminal shows the database creation of iDempiere/ADempiere
-
- Table creation iDempiere with Postgresql
Now you need to restart the postgresql server by typing:
/etc/init.d/postgresql restart
3. Create the adempiere User (as well, if the database is for iDempiere)
You should still be root and type:
su – postgres
psql -U postgres -c “CREATE ROLE adempiere SUPERUSER LOGIN PASSWORD ‘adempiere'”
4. Create database
For that type in:
createdb –template=template0 -E UNICODE -O adempiere -U adempiere idempiere
psql -d idempiere -U adempiere -c “ALTER ROLE adempiere SET search_path TO adempiere, pg_catalog”
The Notice, that the schema adempiere doesn’t exist can be ignored
Now you have to navigate to your iDempiere Repository to org.adempiere.server-feature/data/seed with the cd command and than type:
jar xvf Adempiere_pg.jar
or you do it like this and replace idempiere with your directory name:
jar xvf $idempiere/org.adempiere.server-feature/data/seed/Adempiere_pg.jar
This terminal shows the database creation of iDempiere/ADempiere
Now type in:
psql -d idempiere -U adempiere -f Adempiere_pg.dmp
- Table creation iDempiere with Postgresql
After this the database will be created and it takes a while.
This tutorial shows how you can install iReport on you Computer.
1. Download the iReport-4.8.0.tar.gz from http://community.jaspersoft.com/project/ireport-designer.
2. Extract the iReport-4.8.0 directory where ever you want.
3. Open a terminal and go with the command cd to the directory, where your iReport-4.8.0 folder is located now.
This is a terminal window shows, how to run iReport-4.8.0 after download.
4. Type iReport-4.8.0/bin/ireport in the command line and click Enter
That’s it.
At the HASIB 2012 on 13th/14th/15th October I presented in Hat Yai Thailand about, how ADempiere and Machine to Machine communication (M2M) can control the whole Halal food logistic , so that the customer can be sure, that the food he is eating is really Halal.
This tutorial describes how to set up the iDempiere project with Eclipse IEE 4.2 on a Windows 7 machine from scratch.
JAVA DOWNLOAD
Please make sure that you have installed Java JDK 1.6.0_35Update on your computer
and that you can find the jvm.dl file under this path:
Programme Files (x86) > Java > jdk1.6.0_22>bin>client>jvm.dll
If you cannot find it, please look up the following path:
Programme Files (x86) > Java >jdk1.6.0_22>jre>bin>client>jvm.dll
and copy it to the path before. This file is needed for the installation of Eclipse
ECLIPSE DOWNLOAD
Now you can download under Eclipse Downloads the Eclipse IDE for Java Developers.
And open Eclipse after being installed.
PLUGIN INSTALLATION IN ECLIPSE
For setting up iDempiere you need the following plugins
- buckminster core
- buckminster maven
- buckminster pde
Go to Help > Install New Software and enter the following Link:
http://download.eclipse.org/tools/buckminster/updates-4.2
then select Buckminster and Buckminster Source –> Next
Next–> Click Next (Install Details Window) –> Next(Review Lizenses Window) –> I accept –> Next —> Finish
Now this timeline appears:
Then restart your Eclipse.
If Buckminster has been installed successfully, you Eclipse will look something like this:
INTEGRATING THE IDEMPIERE PROJECT VIA MECURIAL
Now download the source code here: http://bitbucket.org/idempiere/idempiere
via Mercurial, but please do NOT use the Mecurial plugin and clone the project, because problems may occur.
How to clone without plugin:
If you did’t use Mecurial before please download it: http://mercurial.selenic.com/
The Tool is called TortoiseHg 2.5.1 and includes Mecurial 2.3.2
Open a TortoiseHg workbench with a right click on the desktop –> hg Workbench
Then create an idempiere folder in your workspace folder
Open a terminal Window and go via cd to your Eclipse workspace\idempiere and type in
hg clone https://bitbucket.org/idempiere/idempiere –> Enter
now the repository will be downloaded in the idempiere directory under your workspace
This will take some minutes!
Here the window after successful download:
CREATING A TARGET PLATFORM
Now go back to Eclipse and click on File –> Switch Workspace –> Others and Browse for the idempiere directory in your workspace
Eclipse will restart.
Now go into the idempiere folder and create an empty “targetPlatform” folder there.
After that go to Eclipse: Window -> References -> Plug-in Development -> Target Platform
and click on Add and follow the next steps:
click on Add…
and type in iDempiere Target Platform
Click on Add…
click on Directory –> Next and Browse for the targetplatform folder and click on Finish
Do the following settings in the Environment and click Finish
Close Target Platform Window with OK.
Now ight click on the Project Explorer and select Import
Click on Buckminster ->Materialize…. -> Next
Now browse for:
C:\Users\<your name>\workspace\idempiere\org.adempiere.sdk-feature\adempiere.cquery
The process starts automaticaly
after that, click Finish and the p2 materializer process will start.
That takes a while!
After that the installing process will start automaticaly and will fill the Project Explorer with folders. Than Buckminster will build a workspace and in the end your eclipse
Presentation for the Opern Source Conference Tokio and the Japan User Group Meeting in September 2012
Agent Monroe's Blog 