This chapter provides brief, high level instructions for the installation and upgrade of Collaboration, and is intended to quickly guide experienced administrators through the installation or upgrade procedure.
This chapter is divided into two major sections:
Installation. This section covers installing the Collaboration components, scripting the database, and starting and verifying the installation. The organization of this section maps directly to detailed instructions in Installation.
Upgrade. This section covers upgrading Collaboration to the latest version. The organization of this section maps directly to detailed instructions in Upgrade.
Installation
This section describes how to install Collaboration.
Creating the Collaboration Database
Refer to the section that applies to your database vendor.
Creating and Configuring the Collaboration Database on Microsoft SQL Server
To create the Collaboration database and database user:
Configure the SQL Server instance to use SQL Server and Windows Authentication mode.
Create the Collaboration database with the Collaboration database name you designated when you completed the worksheets provided in the Installation and Configuration Worksheets for BEA AquaLogic Collaboration 4.5.
Create the Collaboration database user login with the login name and password you designated when you completed the worksheet provided in the Installation and Configuration Worksheets for BEA AquaLogic Collaboration 4.5.
Configure the Collaboration database user login to use SQL Server Authentication.
Set the Collaboration database user login’s default database to the Collaboration database.
Grant the Collaboration database user login the db_owner role for the Collaboration database.
Create a schema for the Collaboration database with the schema name you designated when you completed the worksheets provided in the Installation and Configuration Worksheets for BEA AquaLogic Collaboration 4.5. This name must be the same as the Collaboration database user name.
In the Collaboration database user’s login properties, navigate to the User Mapping page.
Set the default schema of the Collaboration database user login to the new schema of the same name.
Configuring an Oracle Database for Collaboration
The Collaboration schema is added to the existing Oracle database that contains the portal schema. Confirm that the open_cursors parameter in the Oracle initialization file is set to greater than 1000. This parameter should have been set correctly during the portal database set up.
Installing the Collaboration Components
To install Collaboration, launch the Collaboration installer as a local administrator:
On a UNIX/Linux host the installer is ALICollaboration_v4-5_mp1.
On a Windows host the installer is ALICollaboration_v4-5.exe_mp1.
The Notification Service that was previously included in the Collaboration installer has been replaced by the AquaLogic Notification Service. Collaboration uses the AquaLogic Notification Service to send emails from Collaboration to end users and to serve RSS feeds if that feature has been enabled. The AquaLogic Notification Service is included with the AquaLogic Interaction installer and is a required component of AquaLogic Interaction. The AquaLogic Notification Service should be installed and configured as part of your AquaLogic Interaction installation.
Deploying Collaboration on WebLogic Server
The Collaboration installer automatically deploys Collaboration on the Embedded Servlet Engine. You can choose to deploy Collaboration on WebLogic Server instead of the Embedded Servlet Engine.
Important: If you choose to deploy Collaboration on WebLogic Server, you should disable the BEA ALI Collaboration Service that is installed by the installer on Windows machines. You will not be able to start and stop Collaboration using Configuration Manager.
To deploy Collaboration on WebLogic Server:
Identify a domain on which to deploy Collaboration, or create a new domain. Refer to your WebLogic Server documentation for details on creating a new domain.
In the portal’s config.xml file for the domain on which the portal is deployed, add the following line at the end of the <security-configuration> tag:
This disables basic authentication for the domain, and is necessary for WebDAV to work properly.
Note:
The <enforce-valid-basic-auth-credentials> line must be the last entry in the <security-configuration> tag for the setting to take effect.
Add the following text to the setDomainEnv.sh or setDomainEnv.cmd file of the domain:
On UNIX/Linux, add the following to setDomainEnv.sh. You must add this as one line of code:
JAVA_OPTIONS="${SAVE_JAVA_OPTIONS}
-Dbid.application.config=PT_HOME/settings
-Dplumtree.application.config=PT_HOME/settings
-Dbid.application=PT_HOME/ptcollab/4.5
-Dplumtree.application=PT_HOME
On Windows, add the following to setDomainEnv.cmd. You must add this as one line of code:
set JAVA_OPTIONS=%SAVE_JAVA_OPTIONS%
-Dbid.application.config=PT_HOME\settings
-Dplumtree.application.config=PT_HOME\settings
-Dbid.application=PT_HOME\ptcollab\4.5
-Dplumtree.application=PT_HOME
Enter the actual value of PT_HOME in the file. PT_HOME is the same value as install_dir. By default, the value for install_dir is /opt/bea/alui on UNIX/Linux and C:\bea\alui on Windows.
Start the WebLogic domain.
Deploy collab.ear, located in the following location, as an application in the WebLogic domain:
UNIX/Linux: install_dir/ptcollab/4.5/webapp/
Windows: install_dir\ptcollab\4.5\webapp\
Refer to your WebLogic Server documentation for details on how to deploy an application.
Update the Collaboration application settings in Configuration Manager to reflect the correct port numbers for the Collaboration UI:
Launch Configuration Manager.
In the application list on the left, under Collaboration, click Application Settings.
Update the values of HTTP port and HTTPS port with the port numbers used by the Collaboration domain in WebLogic.
Click SAVE.
Update the URL of the Collaboration remote server:
Log in to the portal.
Navigate to the Collaboration remote server object in the Admin Object Directory and open it for editing.
On the Main Settings page, set the port number of the Base URL to the port number of the Collaboration application in WebLogic.
Click Finish.
In Collaboration’s config.xml file for the domain on which Collaboration is deployed, add the following line at the end of the <security-configuration> tag:
This disables basic authentication for the domain, and is necessary for WebDAV and Collaboration RSS Feeds to work properly.
Note:
The <enforce-valid-basic-auth-credentials> line must be the last entry in the <security-configuration> tag for the setting to take effect.
Scripting the Collaboration and Portal Databases
Refer to the section that is appropriate to your database vendor.
Scripting the Databases on Microsoft SQL Server
This section describes how to create and configure the Collaboration database schema, as well as configure the portal database schema for Collaboration.
To script the databases on Microsoft SQL Server:
Run the following database scripts as the Collaboration database user on the Collaboration database:
This section describes how to create and configure the Collaboration database schema, as well as configure the portal database schema for Collaboration.
To script the database on Oracle:
Locate the versions of the database scripts appropriate to your database platform:
install_dir/ptcollab/4.5/sql/oracle/unix/
install_dir\ptcollab\4.5\sql\oracle\windows\
Run the following database scripts as the system user on the portal database:
collaboration-server-create-table-space.sql
collaboration-server-create-user.sql
Run the following database scripts as the Collaboration database user on the portal database:
collaboration-server-create-tables.sql
collaboration-server-data.sql
collaboration-server-portal-role-grant.sql
Run the following database scripts as the portal database user on the portal database:
Scripting a DB2 Database on UNIX for Collaboration
This topic describes how to script a DB2 database for use with Collaboration.
Note:
For this release, BEA does not support scripting a DB2 database on Windows for Collaboration.
Before scripting a DB2 database for Collaboration:
Ensure that the data for the AquaLogic Interaction and ALUI Directory applications is stored in distinct schemas on the same DB2 database.
Create a distinct schema for the Collaboration database on the same DB2 database that contains the schemas for the AquaLogic Interaction and ALUI Directory applications.
Have your DB2 database administrator examine and, if necessary, customize the SQL scripts before you use them. Each SQL file contains comments that describe the customizations that might be necessary.
Note:
The Collaboration SQL scripts for DB2 include hard-coded schema names for the Collaboration and portal databases. In the collaboration-server-create-tables.sql, collaboration-server-data.sql, and collaboration-server-portal-role-grant.sql scripts, the hard-coded name for the Collaboration schema is COLLAB. If you updated the Collaboration schema name to anything other than COLLAB, you must navigate to Configuration Manager, Collaboration application, Collaboration Database component, and update the Schema Name setting to match the updated Collaboration schema name.
Note:
In the portal-collaboration-server-role-grant.sql and portal-collaboration-server-data.sql scripts, the hard-coded name for the portal schema is ALUI. If you updated the portal schema name to anything other than ALUI, you must update these scripts to match the updated portal schema name. Additionally, you must navigate to Configuration Manager, Collaboration application, Collaboration Settings component, and update the Linked database alias setting to match the updated portal schema name. Make sure to add .dbo. to the end of the portal schema name. For example, if the portal schema name is alidbuser, the value that you type into the Linked database alias setting should be alidbuser.dbo.
Use the DB2 command line processor to run the SQL scripts against your DB2 database. Comments in the header of each SQL file contain recommended syntax for the DB2 command line processor.
To script a DB2 database for Collaboration:
Copy SQL scripts from the Collaboration installation directory to your DB2 database server.
The scripts are located in:install_dir/ptcollab/4.5/sql/db2
As a user with administrative privileges, run the these scripts in the following order:
This section provides brief, high level instructions for the process of upgrading previous versions of Collaboration to the latest version.
Upgrade Paths
This section provides the paths that are available to upgrade to Collaboration 4.5 MP1.
Note:
All upgrade paths are between two systems of the same operating system brand, but not necessarily the same operating system version. Check current hardware and software requirements and make any required upgrades to operating system or database software prior to proceeding with the portal upgrade.
Upgrade Path
Upgrade References
Collaboration 4.2, 4.2 MP1 to Collaboration 4.5 MP1
Collaboration 4.1, 4.1 SP1, 4.1 SP2 to Collaboration 4.5 MP1
Upgrading from Collaboration 4.x to Collaboration 4.5 MP1
This section describes how to upgrade from Collaboration 4.x to Collaboration 4.5 MP1.
To upgrade from Collaboration 4.x to Collaboration 4.5 MP1:
Stop Collaboration.
If you have an existing Notification Service from your previous installation of Collaboration, disable or uninstall it. The Notification Service that was previously included in the Collaboration installer has been replaced by the AquaLogic Notification Service and is included in the AquaLogic Interaction installer. The AquaLogic Notification Service is a required component of AquaLogic Interaction and should be installed and configured as part of your AquaLogic Interaction installation.
Stop the Search Server, Automation Service, and Document Repository Service.
Back up the portal database, Collaboration database, and Document Repository.
Clear the Embedded Servlet Engine’s work directory.
(Optional) Deploy Collaboration on WebLogic Server. By default, Collaboration is deployed on the Embedded Servlet Engine. You only need to perform this step if you want to deploy Collaboration on WebLogic Server instead of the Embedded Servlet Engine. For details, see Deploying Collaboration on WebLogic Server.
Upgrading from Collaboration Server 3.x to Collaboration 4.5 MP1
This section describes how to upgrade from Collaboration Server 3.x to Collaboration 4.5 MP1.
If you are currently running Collaboration Server 3.x, you must first upgrade to Collaboration Server 4.0.2. Refer to the Installation Guide for Plumtree Collaboration Server 4.0.2 for information on this upgrade path.
Upgrading from Collaboration Server 2.x to Collaboration 4.5 MP1
This section describes how to upgrade from Collaboration Server 2.x to Collaboration 4.5 MP1.
If you are currently running Collaboration Server version 2.x, you must first upgrade to Collaboration Server 3.0.2. Refer to the Installation Guide for Plumtree Collaboration Server 3.0 for information on this upgrade path.
After upgrading to Collaboration Server 3.0.2, you must upgrade to Collaboration Server 4.0.2. Refer to the Installation Guide for Plumtree Collaboration Server 4.0.2 for information on this upgrade path.
UNIX/Linux users - Collaboration 3.x was released only on Windows. The installation of 3.0.2 must take place on a Windows machine.
Upgrading the Portal and Collaboration Databases
This section describes how to upgrade the portal and Collaboration databases.
Note:
If you are upgrading Oracle from 10.1.x to 10.2.x or SQL Server from 2000 to 2005, you should perform the Oracle or SQL Server upgrade before upgrading the databases.
Run the upgrade scripts appropriate to your database platform. The upgrade scripts are located in:
Microsoft SQL Server:
install_dir\ptcollab\4.5\sql\mssql
Oracle:
install_dir\ptcollab\sql\oracle\unix
install_dir\ptcollab\4.5\sql\oracle \windows
Follow the database upgrade instructions appropriate to your previous version of Collaboration, as described in the following table:
Upgrade Path
Database Upgrade Instructions
4.2 MP1 to 4.5 MP1
4.2 to 4.5 MP1
As the Collaboration database user, run the following script on the Collaboration database:
collaboration-server-4.2.0-to-4.5.0-upgrade.sql
As the portal database user, run the following script on the portal database:
portal-collaboration-server-upgrade.sql
4.1 SP2 to 4.5 MP1
As the Collaboration database user, run the following scripts in sequential order on the Collaboration database:
collaboration-server-4.1.2-to-4.2.0-upgrade.sql
collaboration-server-4.2.0-to-4.5.0-upgrade.sql
As the portal database user, run the following script on the portal database:
portal-collaboration-server-upgrade.sql
4.1 SP1 to 4.5 MP1
4.1 to 4.5 MP1
As the Collaboration database user, run the following scripts in sequential order on the Collaboration database:
collaboration-server-4.1.1-to-4.1.2-upgrade.sql
collaboration-server-4.1.2-to-4.2.0-upgrade.sql
collaboration-server-4.2.0-to-4.5.0-upgrade.sql
As the portal database user, run the following script on the portal database:
portal-collaboration-server-upgrade.sql
4.0.2 to 4.5 MP1
As the Collaboration database user, run the following scripts in sequential order on the Collaboration database:
collaboration-server-4.0.2-to-4.1.1-upgrade.sql
collaboration-server-4.1.1-to-4.1.2-upgrade.sql
collaboration-server-4.1.2-to-4.2.0-upgrade.sql
collaboration-server-4.2.0-to-4.5.0-upgrade.sql
As the portal database user, run the following script on the portal database: