Talk:ADempiere Install Linux&PostgreSQL
From AdempiereWiki
The screenshot at http://www.adempiere.com/wiki/index.php/Image:Install08.jpg included on http://www.adempiere.com/wiki/index.php/ADempiere_Install uses a hostname. Also the setup program's help from the menu bar tells us to use Hostname rather than localhost/ip in the Application Server field.
When I use a hostname and try to browse from another machine, I cannot connect. (NOT a firewall issue!) When I re-run setup and enter the IP address, the page loads correctly.
In resolving this, it's better if the app would work like the doc.
--Russf 13:13, 29 June 2007 (EDT)
This has been my experience so far attempting to install Adempiere on Linux. So far I have tried on Solaris 10, slackware 12 and now Ubuntu 6.06. As I have written in my other posts the problem seems to revolve around compiling pljava, the achilles heal of Adempiere, in my opinion.
To install Adempiere 3.3 on Ubuntu 6.06 (Dapper Drake)
August 22, 2007
Created folder /home/accounts and 'cd /home/accounts Note: The cvs and svn commands might not work from behind a firewall Running all this as root from the command line except where instructed otherwise.
1.Downloaded and installed CVS and Subversion (SVN) 2.svn co http://adempiere.svn.sourceforge.net/svnroot/adempiere/trunk adempiere Stalled at A adempiere/db/CRModel/Logical.dtd 3.Aborted and retried. Completed ok 4.cd adempiere 5.svn co http://adempiere.svn.sourceforge.net/svnroot/adempiere/branches/libero libero 6.Edited libero/patch_core/patchfiles.sh to ADEMPIERE_SOURCE = /home/accounts/adempiere 7.chmod a+x libero/patch_core/patchfiles.sh 8.Applied patches: libero/patch_core/patchfiles.sh 9.cd ../ (/home/accounts/) 10.cvs -d :pserver:anonymous@gborg.postgresql.org:/usr/local/cvsroot/pljava login password is anonymous (If you are behind a firewall you might get a message saying “connection refused” after you enter the pasword and hit enter.) 11.cvs -d :pserver:anonymous@gborg.postgresql.org:/usr/local/cvsroot/pljava co org.postgresql.pljava 12.cd org.postgresql.pljava 13.Downloaded and installed make and gcc – (apparently not installed by default) 14.make 15.Got error message: 'javac: command not found' 16.installed javacc and build-essential – (not installed by default) 17.Downloaded and installed sun JDK 5 with netbeans The Ubuntu package manager Synaptic has JDK 6 as does the Sun Download site. However, the instructions insist on JDK 5 so you have to search for it.
August 23, 2007
1.created directory jdk1.5 in /home/accounts/ 2.Pasted downloaded JDK 5 binary 3.cd /home/accounts/jdk1.5 4.chmod a+x jdk—1_5_0_12-nb-5_5.1-linux-ml-bin 5../jdk—1_5_0_12-nb-5_5.1-linux-ml-bin This loaded its own installation wizard and installed to /opt Installed OK 6.cd /home/accounts/org.postgresql.pljava 7.make Same error as before: 'javac: command not found' 8.export PATH=/opt/jdk1.5.0_12/bin:$PATH error message: must set java home 9.export JAVA_HOME=/opt/jdk1.5.0_12 10.make appeared to run ok – no errors 11.Downloaded postgresql 8.2.4 from the Postgresql website (Downloaded the full package tarball) 12.useradd -d /home/postgres -m postgres 13.chown -R postgres /home/postgres 14.passwd postgres 15.extracted postgres tarball (postgresql-8.2.4) to /opt 16.cd /opt/postgresql-8.2.4 17../configure (Failed on readline) 18.Installed via synaptic: flex and bison (readline installed but it did not find it) 19.Downloaded zlib-1.2.3 and extracted to /opt 20.cd /opt/zlib-1.2.3 (./configure, make, make install) 21.cd /opt/postgresql-8.2.4 22../configure - -without-readline (no space between the dashes) 23.make 24.make install 25.chown -R postgres /usr/local/psql 26.mkdir /usr/local/pqsl/data 27.su – postgres 28.cd /usr/local/pqsl/data 29./usr/local/pqsl/bin/initdb -D /usr/local/pqsl/data [message to the effect that the server can be started with
/usr/local/pqsl/bin/initdb -D /usr/local/pqsl/data]
(Installation and initialization ok) 30.cd cd /usr/local/pqsl/ 31.ln -s data var (symlink pointing var to data) (you will need this is you want to use Webmin to handle the server) 32.cd /home/accounts/org.postgresql.pljava 33.export PATH=/usr/local/pgsql/bin:$PATH 34.make 35.make install (no error on make or make install!!) 36.Downloaded postgresql-8.2-506.jdbc2.jar The instructions said postgresql-8.2-504.jdbc2.jar but I could not find it. Interedtingly Postgres' download website recommended jdbc3 for jdk 1.5 (which is the JDK I downloaded and installed earlier.) 37.export CLASSPATH=/home/accounts/org.postgresql.pljava/build/deploy.jar:/home/accounts/postgresql-8.2-506.jdbc2.jar://home/accounts/org.postgresql.pljava/build/examples.jar (The instructions said '://home/accounts/org.postgresql.pljava/build/test.jar' for the last entry but there was no test.jar in the /home/accounts/org.postgresql.pljava/build/ directory.
[ I asked xp_prg the IRC handle of the writer of the instrcutions and he said he thought that the changes should be ok. The test files are only needed if the tests will be run, the writer said.]
38. edited postgresql as below:
- - Connection Settings -
listen_addresses = 'localhost' # what IP address(es) to listen on; dynamic_library_path = '$libdir:/usr/local/pgsql/lib' custom_variable_classes = 'pljava' # list of custom variable class names pljava.classpath = '/usr/local/pgsql/lib/pljava.jar'
There is no /usr/lib/pgsql as in the instructions
August 24, 2007
39.Started postgres /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 & 40.su – postgres (from root) 41.export PATH=/usr/local/pgsql/bin:$PATH 42.createuser adempiere (superuser y) 43.createdb adempiere - - encoding=unicode 44.psql adempiere (brought up postgres interactive) 45.alter user adempiere with password adempiere; 46.\q (quit postgres interactice and return to the command line) 47.exit to get back to root
This next instruction:
22.java org.postgresql/pljava.deploy.Deployer -install -user adempiere -password adempiere -host 172.16.1.43 -database adempiere (use your ip address)
unfortunately failed complaining that it could not find pljava.jar even though I verified that it was in the /usr/local/pgsql/lib directory, as set in the postgresql.conf file, and also complained about 'libjvm.so'.
I discussed this with xp_prg who supspected that I had not run 'ldconfig'. I hadn't because it was not in these instructions. xp_prg, however, could not say definitely whether all I needed to do was to run ldconfig and run the instructions again. This is where I stopped.
--Lawrence 00:58, 29 August 2007 (EDT)
