waffel’s Weblog

Oktober 2, 2009

Howto upgrade ]project-open[ 3.1 to vmware 3.2 version

Einsortiert unter: administration — Thomas Wabner @ 12:05 nachmittags
Tags: , , , ,

We have a self compiled version of ]project-open[ version 3.1 running on our intranet server. Because there is no more support for this version and there is also no more any documentation about this version out there we have decided to switch to the ]project-open[ vmware 3.2 version. There are some steps required to get all data from 3.1 into the 3.2 installation.

First of all: Make a backup of your database!

  1. Login as admin into your 3.1 web interface and make a postges backup http://%5BYOUR_SERVER%5D/intranet/admin/backup/
  2. The backup data is now on your 3.1 machine under /web/projop/filesystemstorage/backup/[YOUR_BACKUP_FILE].sql .
  3. Download the ]project-open[ vmware image from sourceforge. Because we use virtualbox instead of vmware we mount the vmware image into our virtualbox.
  4. In virtualbox you have to select SCSI:1 as your harddisk interface because the vmware installation tries to mount /dev/sda1 as your root.
  5. after success start of the virtualbox you have to login as root (default password is root)
  6. Now you have to switch your runlevel to S (single user mode) with init S.
  7. In this runlevel you have to restart postgres with /etc/init.d/postgesql restart.
  8. Switch now from root to postgres with su - postgres.
  9. Connect to the postgresql master database template1 with psql template1
  10. Drop the projop database drop database projop;
  11. Now you can leave the postgresql shell with \q
  12. Create a new projop database createdb projop --owner projop
  13. Set postgres dialect for the database createlang plpqsql projop
  14. Import the tsearch2 tablees psql projop -f /web/projop/packages/intranet-search-pg/postgresql/tsearch2.sql
  15. Import your backup from the 3.1 system (copy the data from your 3.1 machine first) psql projop -f /web/projop/filesystemstorage/backup/[YOUR_BACKUP_FILE].sql
  16. Run the post patch psql projop -f /web/projop/preconf/poall.post-patch.sql
  17. Switch back to root exit
  18. Switch back to the runlevel 5 init 5
  19. Restart the postgresql system /etc/init.d/postgresql restart
  20. In you web browser you should now be able to login as administator (username and password from your old 3.1 system!)
  21. Update all enabled packages http://%5BYOUR_SERVER%5D/acs-admin/apm/packages-install?update_only_p=1
  22. Select on the page all packages which should be upgraded and start the update procedure (this may take any time)
  23. Restart the projop web server with http://%5BYOUR_SERVER%5D/acs-admin/server-restart

I hope thats all and your system is now running with ]project-open[ 3.2.

About these ads

2 Kommentare »

  1. Hi Thomas,

    Maybe you want to post this in the Open Discussions forum at http://www.sourceforge.net/projects/project-open/ ? Even more interesting: Would you be interested to contribute a short review or experience report about ]po[? We’re launching V3.4 at the moment and are looking for such material.

    Cheers!
    Frank

    mailto:frank_dot_bergmann at project_dash_open.com

    Kommentar von Frank Bergmann — Oktober 2, 2009 @ 8:03 nachmittags | Antwort

  2. Hi Thomas,
    tx for posting this, I’ll link to your page from our documentation WIKI http://www.project-open.org/documentation/

    As a developer yourself you should be fine upgrading to V3.4 from CVS HEAD which I’d regard at this point in time even more stable than 3.2.
    We will release officially on 31/10/2009 in case you want to be on the safe side

    Greetings from BCN
    Klaus

    Kommentar von Klaus Hofeditz — Oktober 2, 2009 @ 8:04 nachmittags | Antwort


RSS-Feed für Kommentare zu diesem Beitrag. TrackBack URI

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

WordPress.com-Logo

Du kommentierst mit Deinem WordPress.com-Konto. Abmelden / Ändern )

Twitter-Bild

Du kommentierst mit Deinem Twitter-Konto. Abmelden / Ändern )

Facebook-Foto

Du kommentierst mit Deinem Facebook-Konto. Abmelden / Ändern )

Google+ photo

Du kommentierst mit Deinem Google+-Konto. Abmelden / Ändern )

Verbinde mit %s

The Rubric Theme Bloggen Sie auf WordPress.com.

Follow

Erhalte jeden neuen Beitrag in deinen Posteingang.

Schließe dich 28 Followern an

%d Bloggern gefällt das: