Install ADempiere OSGI in Eclipse
The old information about my first try to install OSGi ADempiere ist still in the Sourceforge Project Wiki:
https://sourceforge.net/p/freibier/wiki/InstallationOSGI/
Some hints I found while trying to install iDempiere:
Use this to create a script to start all needed migration scripts:
ls | egrep '^digit:{3}.*\.sql$' | sort | tail -n +`ls | egrep '^digit:{3}.*\.sql$' | sort | grep -n \`cat ../../../org.adempiere.server-feature/data/seed/LAST_SCRIPT_APPLIED_ON_THIS_SEED | tail -n 1\` | cut -d ':' -f1` | tail -n +2 | perl -pe 's/(.*)/psql -h efg -d idempiere -U adempiere -f $1/' >needed_migrations.sh sh needed_migrations.sh cat ../../processes_post_migration/postgresql/*.sql | psql -h localhost -d idempiere -U adempiere
In a freshly install postgres server you will get many errors like this one (first in 857):
FEHLER: Funktion uuid_generate_v4() existiert nicht
Before running the migration scripts you need to install the extension module uuid-ossp. In debian install the package postgresql-contrib. Then do the following in the iDempiere database:
PostgreSQL 8.4:
# first four lines seems necessary only under Linux: psql -h localhost -d idempiere -U postgres -c "UPDATE pg_language SET lanpltrusted = true WHERE lanname LIKE 'c';" cp /usr/share/postgresql/8.4/contrib/uuid-ossp.sql . joe uuid-ossp.sql # set search_path=adempiere setzen psql -h localhost -d idempiere -U adempiere -f uuid-ossp.sql
PostgreSQL 9.2:
CREATE EXTENSION "uuid-ossp"; ALTER EXTENSION uuid-ossp OWNER TO adempiere;
Upgrade with mercurial
Here is a list of some helpful mercurial commands. See more at http://hgbook.red-bean.com/read/a-tour-of-mercurial-the-basics.html
You can make a backup clone of the source tree with
hg clone idempiere idempiere-backup
You can upgrade the actual respository with:
hg pull https://bitbucket.org/idempiere/idempiere
You can see which revision the actual repository has with:
hg log -l 1
And you can see which files changed between two revisions (M: Modified, A: Added, R: Removed) with:
hg status --rev 7718:2b371e59a63c --rev 8097:a2092d7b985a
after upgrading
After upgrading eventually you have to re-materialize your Eclipse workspace with buckminster again (http://www.globalqss.com/wiki/index.php/IDempiere/Setting_up_Eclipse). This is needed if the updated code created new plugin projects or uses new or updated jar dependencies.
If you wnat to know which migration scripts you have to run you can find out your actual state with
psql -h idempiereserver -p 5432 -U adempiere -d idempiere -c 'SELECT name FROM ad_migrationscript ORDER BY name DESC LIMIT 1'
Then you go to
cd migration/i1.0a-release/postgresql/
and start the newer scripts one by one with
psql -h idempiereserver -p 5432 -U adempiere -d idempiere <XXXXXXXXXXXX_scriptname.sql
Then (do not forget!) you go to
cd migration/processes_post_migration/postgresql cat `ls *.sql` | psql -h idempiereserver -p 5432 -U adempiere -d idempiere