Index: openacs-4/packages/acs-core-docs/www/xml/install-guide/database-maintenance.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/xml/install-guide/database-maintenance.xml,v diff -u -r1.2.2.3 -r1.2.2.4 --- openacs-4/packages/acs-core-docs/www/xml/install-guide/database-maintenance.xml 15 Dec 2003 14:29:16 -0000 1.2.2.3 +++ openacs-4/packages/acs-core-docs/www/xml/install-guide/database-maintenance.xml 15 Dec 2003 17:17:52 -0000 1.2.2.4 @@ -29,7 +29,7 @@ Change the OpenACS service's configuration file to point to the remote database. Edit - /web/service0/etc/config.tcl + /var/lib/aolserver/service0/etc/config.tcl and change to @@ -54,20 +54,17 @@ option. This command will drop the user and every database object the user owns. - -SVRMGR> drop user service0 cascade; + SVRMGR> drop user service0 cascade; If this does not work because svrmgrl "cannot drop a user that is currently connected", make sure to kill the AOLserver using this user. If it still does not work, do: - -SVRMGR> select username, sid, serial# from v$session where lower(username)='service0'; + SVRMGR> select username, sid, serial# from v$session where lower(username)='service0'; and then - -SVRMGR> alter system kill session 'sid,serial#'; + SVRMGR> alter system kill session 'sid, serial#'; where sid and serial# are @@ -78,8 +75,7 @@ If you feel the need to delete everything related to the service, you can also issue the following: - -SVRMGR> drop tablespace service0 including contents cascade constraints; + SVRMGR> drop tablespace service0 including contents cascade constraints; @@ -97,7 +93,7 @@ Then, to drop the db, just do: -[service0 ~]$ dropdb service0 +[service0 ~]$ dropdb service0 DROP DATABASE @@ -119,13 +115,12 @@ Edit your crontab: - -[joeuser ~]$ crontab -e + [joeuser ~]$ crontab -e We'll set vacuum up to run nightly at 1 AM. Add the following line: -0 1 * * * /usr/local/pgsql/bin/vacuumdb birdnotes +0 1 * * * /usr/local/pgsql/bin/vacuumdb service0 ($Id$) Index: openacs-4/packages/acs-core-docs/www/xml/install-guide/openacs.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/xml/install-guide/openacs.xml,v diff -u -r1.15.2.6 -r1.15.2.7 --- openacs-4/packages/acs-core-docs/www/xml/install-guide/openacs.xml 15 Dec 2003 14:29:16 -0000 1.15.2.6 +++ openacs-4/packages/acs-core-docs/www/xml/install-guide/openacs.xml 15 Dec 2003 17:17:52 -0000 1.15.2.7 @@ -124,7 +124,6 @@ drwx------ 7 service0 web 1024 Jan 6 14:36 service0 [service0 aolserver]$ exit logout - [root root]# su - service0 cd /var/lib/aolserver @@ -155,23 +154,20 @@ Verify membership by typing groups when you login: - -service0:~$ groups + [service0 ~]$ groups dba web If you do not see these groups, take the following action: - -service0:~$ su - + [service0 ~]$ su - Password: ************ -[root ~]# adduser service0 dba +[root ~]# adduser service0 dba If you get an error about an undefined group, then add that group manually: - -[root ~]# groupadd dba -[root ~]# groupadd web +[root ~]# groupadd dba +[root ~]# groupadd web Make sure to logout as root when you are finished with this step and log back in as @@ -182,22 +178,17 @@ Connect to Oracle using svrmgrl and login: - -service0:~$ svrmgrl - -SVRMGR> connect internal + [service0 ~]$ svrmgrl +SVRMGR> connect internal Connected. Determine where the system tablespaces are stored: - -SVRMGR> select file_name from dba_data_files; + SVRMGR> select file_name from dba_data_files; Example results: - - -/ora8/m01/app/oracle/oradata/ora8/system01.dbf + /ora8/m01/app/oracle/oradata/ora8/system01.dbf /ora8/m01/app/oracle/oradata/ora8/tools01.dbf /ora8/m01/app/oracle/oradata/ora8/rbs01.dbf /ora8/m01/app/oracle/oradata/ora8/temp01.dbf @@ -230,14 +221,14 @@ root for this step: -SVRMGR> exit -service0:~$ su - +SVRMGR> exit +[service0 ~]$ su - Password: ************ -[root ~]# mkdir -p /ora8/m02/oradata/ora8/ -[root ~]# chown service0.web /ora8/m02/oradata/ora8 -[root ~]# chmod 775 /ora8/m02/oradata/ora8 -[root ~]# exit -service0:~$ +[root ~]# mkdir -p /ora8/m02/oradata/ora8/ +[root ~]# chown service0:web /ora8/m02/oradata/ora8 +[root ~]# chmod 775 /ora8/m02/oradata/ora8 +[root ~]# exit +[service0 ~]$ @@ -252,41 +243,40 @@ tablespace. - -service0:~$ svrmgrl - -SVRMGR> connect internal; -SVRMGR> create tablespace service0 - datafile '/ora8/m02/oradata/ora8/service001.dbf' - size 50M - autoextend on - next 10M - maxsize 300M - extent management local - uniform size 32K; + [service0 ~]$ svrmgrl +SVRMGR> connect internal; +SVRMGR> create tablespace service0 + datafile '/ora8/m02/oradata/ora8/service001.dbf' + size 50M + autoextend on + next 10M + maxsize 300M + extent management local + uniform size 32K; Create a database user for this service. Give the user access to the tablespace and rights to connect. We'll use - service0password as our password. + service0password as our password. - Write down what you specify as service_name - (i.e. service0) and - database_password - (i.e. service0password). You - will need this information for configuring exports and - AOLserver. + Write down what you specify as + service_name + (i.e. service0) + and database_password + (i.e. service0password). You + will need this information for configuring exports + and AOLserver. -SVRMGR> create user service0 identified by service0password default tablespace service0 -temporary tablespace temp quota unlimited on service0; -SVRMGR> grant connect, resource, ctxapp, javasyspriv, query rewrite to service0; -SVRMGR> revoke unlimited tablespace from service0; -SVRMGR> alter user service0 quota unlimited on service0; -SVRMGR> exit; +SVRMGR> create user service0 identified by service0password default tablespace service0 + temporary tablespace temp quota unlimited on service0; +SVRMGR> grant connect, resource, ctxapp, javasyspriv, query rewrite to service0; +SVRMGR> revoke unlimited tablespace from service0; +SVRMGR> alter user service0 quota unlimited on service0; +SVRMGR> exit; Your table space is now ready. In case you are trying to delete a @@ -298,16 +288,13 @@ Make sure that you can login to Oracle using your service_name account: - -service0:~$ sqlplus service0/service0password -SQL> select sysdate from dual; - + [service0 ~]$ sqlplus service0/service0password +SQL> select sysdate from dual; SYSDATE ---------- 2001-12-20 +SQL> exit; -SQL> exit - You should see today's date in a format 'YYYY-MM-DD.' If you can't login, try redoing step 1 again. If the date is @@ -332,7 +319,6 @@ CREATE USER [postgres pgsql]$ exit logout - [root root]# @@ -359,10 +345,7 @@ Add Full Text Search Support (OPTIONAL) - [service0 service0]$ exit -logout - -[root root]# + At this point the database should be ready for installing OpenACS. @@ -671,30 +654,29 @@ [service0 service0]$ exit logout [root src]# su - service0 -[postgres pgsql]$ env | grep PATH +[service0 ~]$ env For PostgreSQL, you should see: -LD_LIBRARY_PATH=LD_LIBRARY_PATH=:/usr/local/pgsql/lib -PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin:/usr/local/pgsql/bin:/usr/local/pgsql/bin +LD_LIBRARY_PATH=:/usr/local/pgsql/lib +PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:\ + /root/bin:/usr/local/pgsql/bin:/usr/local/pgsql/bin For Oracle: ORACLE_BASE=/ora8/m01/app/oracle ORACLE_HOME=/ora8/m01/app/oracle/product/8.1.7 -PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin:/ora8/m01/app/oracle/product/8.1.7/bin +PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:\ + /root/bin:/ora8/m01/app/oracle/product/8.1.7/bin LD_LIBRARY_PATH=/ora8/m01/app/oracle/product/8.1.7/lib:/lib:/usr/lib ORACLE_SID=ora8 ORACLE_TERM=vt100 ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data - [service0 service0]$ exit -logout -[root root]# Test your backup and recovery procedure. Index: openacs-4/packages/acs-core-docs/www/xml/install-guide/upgrade.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/xml/install-guide/upgrade.xml,v diff -u -r1.6.2.5 -r1.6.2.6 --- openacs-4/packages/acs-core-docs/www/xml/install-guide/upgrade.xml 15 Dec 2003 16:29:01 -0000 1.6.2.5 +++ openacs-4/packages/acs-core-docs/www/xml/install-guide/upgrade.xml 15 Dec 2003 17:17:52 -0000 1.6.2.6 @@ -22,9 +22,8 @@ in a new tarball include database upgrade scripts. To start the upgrade, replace your existing files with the new files and then browse to the APM, which will detect the new packages and offer to run the appropriate database upgrade scripts. After restarting the server again, the upgrade is complete. -
+ Assumptions in this section - @@ -45,8 +44,7 @@ - - +
Upgrading 4.6.3 to 5.0