Update your ]po[ VM CentOS 3.5 to 4.0

Please note:
  • Major updates require at least some basic SysAdmin skills. In case you are not familiar with the steps below, we'd be happy  to provide professional support.
  • Updating your system from our code repository requires a valid CVS account. Please use our contact form to inquire for one. To update your system from the nightly builds, please refer to this page.

Install AOLServer 4.5

Get AOLServer 4.5 from
http://sourceforge.net/projects/project-open/files/project-open/Support%20Files/aolserver45.tgz/download
and untar it to /usr/local

Adjust your inittab:
ns1:345:respawn:/usr/local/aolserver45/bin/nsd -it /web/projop/etc/config.tcl -u projop -g users

Upgrade PostgreSQL

Dump db:

  • su - projop
  • pg_dumpall > projop.dump

Find postgres packages and de-install them:

  • rpm -qa | grep postgres
postgresql-8.1.11-1.el5_1.1
postgresql-contrib-8.1.11-1.el5_1.1
postgresql-docs-8.1.11-1.el5_1.1
postgresql-server-8.1.11-1.el5_1.1
postgresql-libs-8.1.11-1.el5_1.1
  • rpm -e postgresql-8.1.11-1.el5_1.1 postgresql-contrib-8.1.11-1.el5_1.1 postgresql-docs-8.1.11-1.el5_1.1 postgresql-server-8.1.11-1.el5_1.1 postgresql-libs-8.1.11-1.el5_1.1 --nodeps


Remove db cluster:

  • rm -rf /var/lib/pgsql


get v8.4.x rpm's from  http://yum.pgrpms.org/8.4/redhat/rhel-5-i386/repoview/

  • wget http://.../postgresql-libs-8.4.x-1PGDG.rhel5.i386.rpm
  • wget http://.../postgresql-server-8.4.x-1PGDG.rhel5.i386.rpm
  • wget http://.../postgresql-8.4.x-1PGDG.rhel5.i386.rpm
  • wget http://.../postgresql-contrib-8.4.x-1PGDG.rhel5.i386
... and install them:

  • rpm -ivh postgresql-libs-8.4.x-1PGDG.rhel5.i386.rpm 
  • rpm -ivh postgresql-server-8.4.x-1PGDG.rhel5.i386.rpm
  • rpm -ivh postgresql-8.4.x-1PGDG.rhel5.i386.rpm
  • rpm -ivh postgresql-contrib-8.4.x-1PGDG.rhel5.i386


Initialize db:

  • /sbin/service postgresql initdb


Set "add_missing_from = on" in /var/lib/pgsql/data/postgresql.conf


Set automatic start:

  • chkconfig postgresql on


reboot:

  • reboot


Restore data:

  • chown postgres:postgres /web/projop/filestorage/backup/projop.dump
  • su - postgres
  • /usr/bin/psql -d postgres -f /tmp/projop.dump


Set new AOL Server in ~/etc/config.tcl:
set homedir                   /usr/local/aolserver45

CVS update packages:

  • cd /web/projop/packages
  • # Updating your system from our code repository requires a valid CVS account. Please use our contact form to inquire for one.
    cvs update -dPA


Checkout missing packages (if applicable)

  • cd /web/projop/packages
  • cvs checkout notifications
  • cvs checkout acs-translations
  • cvs checkout attachments  
  • cvs checkout oacs-dav
  • cvs checkout intranet-rest
  • cvs checkout file-storage


Adjust your inittab: 
/usr/local/aolserver45/bin/nsd -it /web/projop/etc/config.tcl -u projop -g users

Go to http://[YOUR_SERVER]/intranet/admin/parameters/ and set SuppressHttpPort to 1


Go to ]po[ Package Manager and update  

  • acs-kernel
  • restart


update packages:

  • Site-Wide Administration 5.6.0
  • Content Repository 5.6.0
  • Search 5.6.0 
  • Authentication 5.6.0 
  • Date and Time Utilities 5.4.3b1

Restart: http://[YOUR_SERVER]/acs-admin/server-restart

update packages:

  • ACS Reference Data 5.6.0     
  • Reference Data - Country 5.6.0     
  • Reference Data - Language 5.6.0     
  • Reference Data - Timezone 5.6.0     
  • Reference Data - US County 0.1d [optional]
  • Reference Data - US State 0.1d [optional]
  • Reference Data - US Zipcode 2.0 [optional]

Restart: http://[YOUR_SERVER]/acs-admin/server-restart

update packages:

  • Notifications
  • Localization 5.6.0

Restart: http://[YOUR_SERVER]/acs-admin/server-restart

update packages:

  • Bulk Mail 0.5.1d6     
  • Chat 5.0d1
  • RSS Support 
  • webDAV Support 1.2.0

Restart: http://[YOUR_SERVER]/acs-admin/server-restart

install package:

  • Categories 1.1.2d4
    Ignore any SQL errors during installation, go back and uncheck create script when running the script a second time

Restart: http://[YOUR_SERVER]/acs-admin/server-restart

update packages:

  • Subsite 5.6.0
  • API Browser

Restart: http://[YOUR_SERVER]/acs-admin/server-restart

update packages:

  •     Automated Testing 5.6.0
  •     Documentation 5.6.0     
  •     Developer Support 5.6.0d1     
  •     Messaging 5.6.0     

Restart: http://[YOUR_SERVER]/acs-admin/server-restart

install package:

  • Attachments
  • File Storage 5.4.0d5
    Ignore any SQL errors during installation, go back and uncheck create script when running the script a second time
    Manually execute the scripts called at the end of "file-storage-create.sql"
    ?? remove comments from "create table fs_root_folders" ??
Restart: http://[YOUR_SERVER]/acs-admin/server-restart

update package:

  • Calendar 2.5.0

Restart: http://[YOUR_SERVER]/acs-admin/server-restart

update package:

  • intranet-core

Restart: http://[YOUR_SERVER]/acs-admin/server-restart

update package:

  • intranet-filestorage

Restart: http://[YOUR_SERVER]/acs-admin/server-restart

update packages:
     ... all other ]po[ packages  

----------------------------------------------------------
Install XOWIKI: 

a) Get xowiki and xotcl-core from OpenACS repository:
export CVSROOT=":pserver:anonymous@cvs.openacs.org:/home/cvsroot"
export CVSREAD="yes"
export CVS_RSH="ssh"
export CVSREAD CVSROOT CVS_RSH

cvs -d :pserver:anonymous@cvs.openacs.org:/cvsroot -r checkout xotcl-core
cvs -d :pserver:anonymous@cvs.openacs.org:/cvsroot -r checkout xowiki

b) Go to OpenACS Package Manger and install both packages
http://[YOUR_SERVER]/acs-admin/apm/packages-install

c) SQL script the following:

alter table cr_text disable trigger cr_text_tr;
delete from cr_text;
insert into cr_text (text_data) values ('');
alter table cr_text enable trigger cr_text_tr; 

The wiki should be available at http://[YOUR_SERVER]/xowiki  

 

 

  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

08902 Hospitalet de Llobregat (Barcelona)

Spain

 Tel Europe: +34 609 953 751
 Tel US: +1 415 200 2465
 Mail: info@project-open.com