Tuesday, January 12, 2010

Upgrade checks

Check on these things:

Tomcat:
  1. Whether a resource defined for mail/Session is required anywhere in code. Answer: Yes

Tomcat upgrade

See: Newer post about Tomcat upgrade to 5.5.28
As part of 7.6 upgrade, upgrade tomcat to 5.5.26 (before proceeding with DPM upgrade steps)
  1. Copy the webapps from /opt/tomcat/webapps to 5.5.26 webapps folder
  2. copy conf/Catalina/localhost config xml files to corresponding 5.5.26 folder
  3. Copy config from server.xml from /opt/tomcat/conf to corresponding 5.5.26 folder
  4. Copy workers.properties file
  5. Change link to new tomcat

Content types to index (after 7.6 upgrade, replace vcm server name)

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_CHANNEL_EXTENSION

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_COMPARE_GROUP

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_DEALER_SHOWCASE

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_DEALER_SHOWCASE_IMAGE

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_DEALER

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_EVENT

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_FAQ

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_FILE

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_FREE_HTML

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_IMAGE

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_LINK_SET

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_ARTICLE

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_TEASER_TWO

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_PRODUCT_V2

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_VIDEO

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_PRESS_RELEASE

./vgncontentindex -h pbs-lnxvcmdev:27110 -u vgnadmin -p pi0neer -w /opt/Vignette/vcm/inst-vgninst/ -z 300 -c PIO_PROMOTION

Tuesday, December 22, 2009

Backups for QA and Prod before starting 7.6 upgrades

Database:
  • Perform exports of schemas VCMMGMT, VCMLIVE, VAPSYSPREV, VAPSYSLIVE (does export work with db shutdown? Otherwise make sure all processes are stopped.
Ideal is save an image onto VM and have it available for files etc.

VCM Server:
  • /opt/Vignette
  • /opt/SAP-JCo
  • ~/Vignette
  • ~/vpd.properties
  • /usr/local/tomcat
  • /etc/profile.d/tomcat.sh
  • Apache config files from /etc/apache2/ (httpd.conf and files under vhosts.d)
  • JDK dir?
  • /etc/apache2 (whole directory, including SSL certs)
  • /etc/sysconfig/apache2 (file)
  • see if anything needs to be backed up in /srv folder
  • Copy over entier /home/vgnadmin (esp Export-Import folder with ant scripts for export import of objects)

Web Servers:
  • /opt/Vignette
  • /opt/SAP-JCo
  • ~/Vignette
  • ~/vpd.properties
  • /usr/local/tomcat
  • /etc/profile.d/tomcat.sh
  • /srv/www/vhosts
  • Apache config files
  • JDK dir?
  • /etc/apache2 (whole directory, including SSL certs)
  • /etc/sysconfig/apache2 (file)

Autonomy server:
  • /opt/Vignette
  • ~/Vignette
  • ~/vpd.properties

Tuesday, December 8, 2009

Create Channel

public Channel createSubChannel(Channel parentChannel, String channelName)
throws AuthorizationException, ApplicationException,
ValidationException {

// Create a new channel
Channel channel = new Channel();

// Configure the channel as requested
ChannelData channelData = channel.getData();

channelData.setParentChannelRef(new ChannelRef(parentChannel));
channelData.setName(channelName);

// Save the channel
channel.commit();

// Return the channel
return channel;
}
==============================
System.out.println("Creating SubChannel " + name + "...");

//Create sub channels for Home Channel
Channel homeChannel = newSite.getHomeChannel();
ChannelRef parent = new ChannelRef( mHomeChannel );
ChannelData subChannelData = new ChannelData();

subChannelData.setName("mysubchannel");
subChannelData.setDescription("This is a subchannel of the Home Channel");
subChannelData.setOrderAsSibling(sibOrder);
subChannelData.setParentChannelRef(parent);

Channel subChannel = new Channel();

subChannel.setData(subData);
//Approve the channel
subChannel.setStatus("approved");
subChannel.commit();
System.out.println("Created SubChannel " + name);


//Associate the content instance to the mysubchannel
ChannelContentAssociationData ciTestAssocData = new
ChannelContentAssociationData();
ci = (ContentInstance)ContentInstance.findByContentManagementId( mgmtId );
ciTestAssocData.setContentRef(ci.getContentManagementId());
subChannelData.addContentAssociations(ciTestAssocData);
subChannel.commit();

Thursday, November 5, 2009

Upgrade 7.6

Before starting upgrade:
  1. Patch portal to 7.3.5 on dev, qa and live (11/9 - 11/10)
  2. Test with the patch before starting upgrade (11/11 - 11/12)
  3. Change oracle driver class name in vcm config and tomcat conf to oracle.jdbc.driver.OracleDriver
Timeline for upgrade:
  1. Dev: 5 days
  2. QA: 5 days
  3. QA: migration to 64bit - 5 days (on VM and use QA hardware for Prod 64bit?)
  4. Load testing: 5 days
  5. Prod: 10 days
  6. Prod migration to 64bit - 5 days
Follow the Upgrade guide
Order of servers upgrade QA/Prod:
  1. VCM
  2. Autonomy
  3. QA1 & QA2, should be upgrade together, so requires downtime, writedown each step before continuing (Estimate downtime: 8 hrs)
Rough roadmap for VCM upgrade:
  1. Uninstall CCE
  2. Backup Autonomy
  3. Uninstall Autonomy
  4. Stop endpoints
  5. Stop services
  6. install 7.6
  7. run vgnupgrade
  8. Rename old Contnent/7_3_1 directory
  9. Upgrade Autonomy
  10. Post upgrade stuff from ch7
  11. Custom CMA and other apps deployments
  12. DPM deployments, config changes
  13. FURL config
  14. Fixes on Presentation templates and Query Components
  15. Thorough Testing
  16. Patch VCM to 7.6 SP1
  17. Another round of testing

Load Testing QA
  1. Use earlier scripts with webload
  2. Ask for the load tester desktop from Mark, that has all the scripts
  3. Will need to do it off hours


Post Upgrade:
  1. Upgrade to Portal 8.0?
Notes:
------
FURL
  1. Configure FURL
  2. Remove FURL listener in config (Events>Pre create and update)
  3. set furl.exclude.sitename=false
  4. set linkprinter.impl

DPM Menu classes customization in vgn-ext-templating generic resource, rollback component and item region menu to use pre 7.4 classes

PIOCDA
  1. Include Michael's fixes to JSPs (Product detail etc.)
  2. Checkin changes in VSS

V7.6 Upgrade Migration to 64bit

Backup
  1. Database schemas (DEVVCMMGMT, DEVVCMLIVE, DEVVAPPREV, DEVVAPLIVE)
  2. Take 32bit snapshot
On Mgmt stage:

Copy the following folders/files:
  1. /opt/Vignette
  2. /opt/SAP-JCo
  3. ~/Vignette
  4. ~/vpd.properties
  5. /usr/local/apache/tomcat - upgrade to 6 after testing
  6. /etc/profile.d/tomcat.sh
  7. Create symbolic links for doctoor, /srv/www/vhosts/non-secured + secured
  8. Copy apache config files
  9. Update loaded modules
  10. Java 1.5 32bit
Install:
  1. 64bit JDK 1.6 (1.5?)
  2. Recompile delivery apps with JDK 6?
  3. Tomcat 6
Set environment variables for
  1. JAVA_HOME
  2. PATH
  3. LD_LIBRARY_PATH
Deploy Apps:
  1. piocda
  2. portal
  3. vgn-ext-templating
  4. furl
  5. vgn-tas
On delivery stage:

copy the following folders:
  1. /opt/Vignette
  2. /opt/SAP-JCo
  3. ~/Vignette
  4. ~/vpd.properties
  5. /usr/local/apache/tomcat - upgrade to 6 after testing
  6. /etc/profile.d/tomcat.sh
  7. /srv/www/vhosts/non-secured + secured
  8. Copy apache config files (ssl cert etc.)
  9. Update loaded modules
  10. Java 1.5 32bit
Install:

  1. 64bit JDK 1.6 (1.5?)
  2. Recompile delivery apps with JDK 6?

Set environment variables for:
  1. JAVA_HOME
  2. PATH
  3. LD_LIBRARY_PATH

Deploy Apps:
  1. piocda - use war file
  2. portal - copy folder
  3. vgn-ext-templating - use war file
  4. furl - copy folder