Adempiere/Libero Linux install from binary
Tim at [1] has created a binary package and database seed for Adempiere/Libero. This greatly speeds up the testing of Libero for new users.
Prerequisites
- A Linux box (I am using Suse 10.0)
- Postgresql (I am usng 8.2.5, your mileage may vary)
- Java (Best version is 1.5)
Assumptions
Installation will be to /root/Adempiere You have set up the postgresql user adempiere with password adempiere
The installation
change to root user
su - mkdir /root/Adempiere cd /root/Adempiere
Download the binary from graysconsulting
wget http://www.graysonconsulting.biz/download/binaryreleaselibero.tar.bz2
Extract the archives
bunzip2 binaryreleaselibero.tar.bz2 tar -xvf binaryreleaselibero.tar
This will leave you with:
binaryreleaselibero/ binaryreleaselibero/Adempiere.tar binaryreleaselibero/sqlj.jar binaryreleaselibero/adempiereliberodbdump.sql
Change directory and extract Adempiere.tar
cd binaryreleaselibero tar -xvf Adempiere.tar
Now we overwrite the standard Adempiere seed file
cp adempiereliberodbdump.sql Adempiere/data/Adempiere_pg.dmp
Edit AdempiereEnv.properties to reflect your setup. As a minimum, the following lines will need to be checked or edited
ADEMPIERE_MAIL_SERVER=wgheath.com ADEMPIERE_DB_NAME=adempiere ADEMPIERE_HOME=/root/work/adempiere/adempiere/Adempiere ADEMPIERE_HOME=/home/john/Adempiere/binaryreleaselibero/Adempiere ADEMPIERE_FTP_PASSWORD=user@host.com ADEMPIERE_APPS_SERVER=wgheath.com ADEMPIERE_DB_PORT=5422 ADEMPIERE_WEB_ALIAS=wgheath.com ADEMPIERE_WEB_PORT=80 ADEMPIERE_DB_URL=jdbc\:postgresql\://localhost\:5422/adempiere ADEMPIERE_APPS_DEPLOY=/root/work/adempiere/adempiere/Adempiere/jboss/server/adempiere/deploy ADEMPIERE_KEYSTORE=/root/work/adempiere/adempiere/Adempiere/keystore/myKeystore JAVA_HOME=/usr/local/bin/jdk1.5.0_09
my values were:
ADEMPIERE_MAIL_SERVER=<my mail server> ADEMPIERE_DB_NAME=adempiere ADEMPIERE_HOME=/root/Adempiere/binaryreleaselibero/Adempiere ADEMPIERE_FTP_PASSWORD=user@example.com ADEMPIERE_APPS_SERVER=linuxdesktop ADEMPIERE_DB_PORT=5432 #note port number change ADEMPIERE_WEB_ALIAS=linuxdesktop ADEMPIERE_WEB_PORT=81 #if (like me) you are running another webserver on the same machine you can change the port ADEMPIERE_DB_URL=jdbc\:postgresql\://localhost\:5432/adempiere.libero ADEMPIERE_APPS_DEPLOY=/root/Adempiere/binaryreleaselibero/Adempiere/jboss/server/adempiere/deploy ADEMPIERE_KEYSTORE=/root/Adempiere/binaryreleaselibero/Adempiere/keystore/myKeystore JAVA_HOME=/usr/java/jdk1.5.0_13 #check the location of your java jre
Run the setup program for Adempiere
./RUN_silentsetup.sh
Now setup the database
utils/RUN_ImportAdempiere.sh
We now need to install PLJava. You need to add the jdbc and PLJava jar files to your CLASSPATH
export CLASSPATH=/root/postgresql-8.2-505.jdbc2.jar:/root/org.postgresql.pljava/build/deploy.jar java org.postgresql/pljava.deploy.Deployer -install -user adempiere adempiere -password adempiere -host localhost:5432 -database adempiere
Just lookup how to install pljava as there are some other changes you must make to your postgresql.conf as well. A good place to start to figure out how to setup pljava is: Adempiere/Libero_Linux_install_from_subversion_head
One file setupPLJava.sql is (currently) missing from the binary distro:
set search_path = 'adempiere';
alter role postgres set search_path = 'adempiere';
select sqlj.install_jar('file:/var/lib/pgsql/sqlj.jar','sqlj',true);
SELECT sqlj.set_classpath('adempiere', 'sqlj');
select * from c_bpartner_location where c_bpartner_id = 118;
We now need to install sqlj.jar into the database
cp sqlj.jar /var/lib/pgsql/sqlj.jar psql -U adempiere -d adempiere -f setupPLJava.sql
You should now be set to start the Adempiere Server
cd <Adempiere directory> utils/RUN_Server2.sh
