Latest revision as of 06:51, 22 February 2008

Database

• For Our application we will install Oracle Database or PostgreSQL Database.
• You can download the database from
  • For Oracle - http://www.oracle.com/index.html
  • Once downloaded, double click on the executable file and follow the steps to install Oracle.
  • For PostgreSQL - http://www.postgresql.org/
  • Once downloaded, follow the instructionsto get your PostgreSQL configure
• Use adempiere as system password.

Java JDK

• For our application we will also need to install Java JDK (1.5.0) or the latest version.
• You can download the file from Sun Microsystems
• Double click on the executable file and follow the instructions to install Java on your machine.
• After installing the Java JDK, set the Java Home.
  • For this, right click on My Computer.
  • Go to Properties.
  • Then go to Advanced tab, in the System Properties.
  • Go to System Variables and say new.
  • Enter in the variable name field JAVA_HOME (in caps letters).
  • Enter in the variable value C:\Progra~1\Java\jdk1.5.0_07 or the folder you have install the Java JDK.

Creating a new database under Oracle

• Go to your command prompt (Run cmd)
• Go to Oracle interface. To do so type dbca in your command prompt.
• Oracle interface will appear.
• Choose create a database
• Give your database a valid name (sid)
• Note that the password used to create databases are always compiere there you give as password adempiere
• Click on next and continue. Leave everything as default.
• Don't forget to record the database name when you create it.

Creating a user under Oracle

• In your command prompt, (cmd) enter the following(Note: the space is required between sqlplus and the slash):
• sqlplus /nolog
• You will be forwarded to sql interface
• Remember that we will use as password adempiere and here the dbname is the name that you recorded when you created you database
• Type in(italic has to be replaced by actual password, dbname and username here adempiere, except for Oracle XE where the dbname is xe):

               connect system/password@dbname

• The system should tell you that it is connected

               create user username identified by password;

• The system should tell you that user has been created

               grant resource, connect, dba to username;

• The system should tell you that resource has been granted
• This done type exit to go back to the console

Importing a database

• Before this procedure make sure you have a dump to import. This is generally available on the server.
• Copy paste the dump in somewhere easy to access (on the desktop for example)
• In the console view type in

               imp username/password@dbname

• Then console will ask you the path of the file to import. Type in the path
• For example if you paste it on the desktop, write desktop/cleandb.dmp
• Press enter.
• Leave all the requests default except Import entire export file where you put yes
• Then Press enter an the file will be imported

PostgreSQL

• If you are using PostgreSQL, follow the instructions at http://www.adempiere.com/wiki/index.php/Adempiere_Install_WinXp

Deploying the Application

• Now that you have imported a database, we are ready to deploy the application.
• You will need the PosteritaAdempiere(version).zip, currently we heve released PosteritaAdempiere315.zip
• Download the zip file and extraxt it under C:
• Rename the PosteritaAdempiere to Adempiere
• Go in C:\Adempiere and run the file RUN_Setup.bat but before deploying make sure that the war on this Application is the one to be install. Normally the war file comes with the PosteritaAdempiere.zip. You have the war file at location C:\Adempiere\jboss\server\adempiere\deploy
• Once the Adempiere Setup Screen is opened, make sure you have enter the required configuration.
• In the Application server field enter the IP of the machine, in the database server enter the IP of the machine. Then choose the database that you have created and don't forget to put the password.
• Then Press the Test button to verify your configuration.
• If something goes wrong, you will be notified where it is wrong. Make necessary changes and test again.
• Once the test is ok. Do Save. This may takes a few minutes.
• Once it is done, then in folder utils you will find RUN_Server2.bat and RUN_Server2Stop.bat. Create shortcuts on the desktop for them and then double click on Start server to start the Application.
• If you have done a DB_Restore from the sample Posterita Database then see Installing Posterita from Zip for login and password.

Replacing a war

• Go to Adempiere Home, for e.g.: c:\Adempiere (in my case it is the c: drive)
• Go to c:\Adempiere\jboss\server\adempiere\deploy
• Replace posterita.war with the new posterita.war
• Then go to C:\Adempiere\jboss\server\adempiere\tmp\deploy
• Delete all the files in this directory
• Then go to C:\Adempiere\jboss\server\adempiere\work\jboss.web\localhost
• Delete all the files in this directory also.
• Now you may start the server.

Replacing your accounting

• Go to Adempiere Home, for e.g.: c:\Adempiere (in my case it is the c: drive)
• Go to c:\Adempiere\jboss\server\adempiere\deploy
• Open posterita.war with winrar
• Go to config\accounting\
• Replace the Accounting.csv with your csv file (It should with the same name, Accounting.csv) by clicking Add
• Then go to C:\Adempiere\jboss\server\adempiere\tmp\deploy
• Delete all the files in this directory
• Then go to C:\Adempiere\jboss\server\adempiere\work\jboss.web\localhost
• Delete all the files in this directory also.
• Now you may start the server.

--shameem 09:41, 10 May 2007 (EDT)

Next Steps

• Database Modifications
• Posterita User Manual

Download Site

• SourceForge for latest PosteritaADempiere binary and ExpDat sample database

Go Back

• Posterita

See Also

De DE/installation debian posterita adempiere in German