Update your ]po[ VM (CentOS) to 4.0 alpha

­
!! DEVELOPER ONLY !!

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 deinstall 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.2.x rpm's from  http://yum.pgrpms.org/8.2/redhat/rhel-5-i386/repoview/

• wget http://.../postgresql-libs-8.2.x-1PGDG.rhel5.i386.rpm
• wget http://.../postgresql-server-8.2.x-1PGDG.rhel5.i386.rpm
• wget http://.../postgresql-8.2.x-1PGDG.rhel5.i386.rpm
• wget http://.../postgresql-contrib-8.2.x-1PGDG.rhel5.i386

• rpm -ivh postgresql-libs-8.2.x-1PGDG.rhel5.i386.rpm 
• rpm -ivh postgresql-server-8.2.x-1PGDG.rhel5.i386.rpm
• rpm -ivh postgresql-8.2.x-1PGDG.rhel5.i386.rpm
• rpm -ivh postgresql-contrib-8.2.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
• 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" ??
  

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