Implementation In this section we will implement ADempiere on Windows. We used a simple machine running Win XP Professional.
Run file 'RUN_Setup.bat' which bring up 'Adempiere Server Setup' window. Make appropriate changes like Database Type from oracleXE to PostgreSQL, database name from XE to adempiere, Database Password to adempiere and System Password.
To start with we will need the latest version of ADempiere. A pre-requisite of this solution is that the system should have Sun Java 1.6.0_10 JDK. First install SDK on your system. For this one needs to set the environment variables. Right click on 'My Computer' icon on your desktop and go to the 'Advanced' tab. Here click on 'Environment Variables.' Add two new environment variables with the following settings:
Variable Name: JAVA_HOME Variable Value: C:\Program File\Java\jdk1.6.0_10 Variable Name: JRE_HOME Variable Value: C:\Program File\Java\jre6
Next step is to set the path variable as:
C:\Program Files\Java\jdk1.6.0_10\bin; C:\Program Files\Java\jre6\bin\client;C:\Program Files\PostgreSQL\8.2\bin
One also needs a database. We installed Postgresql in this implementation. Oracle 10g/11g/XE is also supported by ADempiere. The following settings need to be changed while installing postgresql. Change from 'C' to your local language and instead of SQL-ANSI select UTF8. Make sure Postgresql is installed as a service. The programming language should be chosen by checking the box in front of PL/pgsql and PL/Java. Now that the database has been installed, we need to add database 'adempiere.' At start up, click on 'PostgreSQL>pgAdmin III'. Connect to postgresql. At the bottom you will find 'postgres'. Right click on Login Roles and create a new user "adempiere" with password "adempiere". Check superuser rights plus all boxes below superuser rights.
Connect to PostgreSQL. At the bottom you will find 'postgres'. Right click on Login Roles and create a new user "adempiere" with password "adempiere". After setting user rights, right click database on top and add 'adempiere'.
Now right click database on top and add 'adempiere' both as name and owner with encoding as 'UTF8'. In the 'Adempiere' folder (at C:\Adempiere) run file 'RUN_Setup.bat.' This will bring up 'Adempiere Server Setup' window. Make appropriate changes like database type from oracleXE to postgresql, Database Name from xe to adempiere, Database Password to adempiere and System Password. Also change the database server to local host. Click on 'Test' button at bottom to check setting; if settings are correct it will show check mark in front of settings.
Click on 'Save' button to save settings. Move to 'c:\Adempiere\utils' folder and run 'RUN_Server2.bat'. Now while server is running, go to 'c:\Adempiere' and run 'RUN_Adempiere'. A login window will pop up, click on red area in front of 'Server'.
On the next window that pops up, change the application host to the IP address of the machine and click on 'Test Application Server'. A green tick means that it is working properly. Now click on 'Test Database' (again look for a green tick). Login using 'System' as both username and password. Click on Ok and we are done.
Get most out of your technology infrastructure investments with Dell
About CIOL | Media Kit | Site Map | Contact Us | Help | Write to us | Jobs@CyberMedia | Privacy Policy
Copyright © CyberMedia India Online Ltd. All rights reserved. Usage of content from web site is subject to Terms and Conditions.