IBM Support

How to Update Your Expiring TM1 SSL Certificates - Manual Steps - TM1 9.5.X

Fix readme


Abstract

*This document is applicable to all TM1 9.5.X releases (and earlier), regardless of FixPack or InterimFix level.*

If you have already implemented Custom SSL Certificates across all TM1 Components - then no action is required. It is still suggested that you roll your test environment clock to a date beyond November 24th 2016 - and verify that all connectivity/components functions as expected.

If you are using default TM1 SSL Certificates, they will expire November 24th 2016. If you use TM1 9.5.X or earlier, follow these steps to ensure you do not experience an outage! Failure to take action will result in your TM1 Environment being completely inaccessible November 24 2016.

Content

BEFORE YOU BEGIN:

-Please ensure that you have already reviewed all of the relevant detail on the following page before you proceed: IBM Cognos TM1 SSL Expiration - Manual Fix Approach - Landing Page
http://www-01.ibm.com/support/docview.wss?uid=swg21991653

-Do NOT confuse having custom certificates in your WebTier, as the solution. It is very possible that your WebTier had been configured for custom FRONT END / WEB certificates - and is still relying on the default TM1/APPLIX certificates for TM1 Server communication

-If your IBM Cognos TM1 environment uses a custom application server (such as Websphere), you will want to ensure you inquire with your AppServer Administrator to ensure all keystores are updated accordingly.

-If your IBM Cognos TM1 environment is distributed (server components residing on different servers), be sure to follow the appropriate steps for the appropriate components.

-All steps assume you are using a 64bit architecture. If you are using a 32bit installation of TM1, substitute all \bin64\ references, for \bin\

-It is advised that all customers verify not only that these steps work in a test environment (prior to any production changes), but that the server clocks be rolled ahead past November 24th 2016 to ensure that the product behaves as expected post expiration date.

-If you have questions, please log a service request with TM1 Support so that the problem can be addressed.

  1. Download the updated TM1 SSL Certificates from the following location: http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FCognos+TM1&fixids=BA-CTM1-SSL-ZIP-IF001
  2. Stop all IBM Cognos TM1 Services in the environment you are updating
  3. Extract the downloaded file/archive and extract it to any directory. For the purpose of this document, our files will be extracted in to <tm1_install_dir>\tm1\NewSSLCerts\
  4. After extracting the files, look inside of your extracted folder <tm1_install_dir>\tm1\NewSSLCerts\ . The following files should be present.
    • applixca.der
    • applixca.pem
    • applixcacrl.p7b
    • applixcacrl.pem
    • tm1admsvrcert.pem
    • tm1store
    • tm1svrcert.pem
  5. Back up the following directories in your <tm1_install_dir>
    • <tm1_install_dir>\tm1\bin\ssl
    • <tm1_install_dir>\tm1\bin64\ssl
    • <tomcat_install_dir>\webapps\pmpsvc\WEB-INF\bin64\ssl
  6. Copy the contents of the folder you extracted earlier <tm1_install_dir>\tm1\NewSSLCerts\ , and place them inside of the 3 directories listed above in Step 4. During this process, you will be required to REPLACE all conflicting files as we must replace the old certificate files with new ones.

    If you are on UNIX - skip to Step 10
  7. After all files have been copied successfully, navigate to <tm1_install_dir>\tm1\bin64\ssl\ using Windows Command Prompt
  8. Execute the following command to uninstall old keys from the Windows Keystore
    • importsslcert.exe -remove
  9. Execute the following command to install the new keys in to the Windows Keystore
    • importsslcert.exe
  10. Start your IBM Cognos TM1 Services


At this stage, all IBM Cognos TM1 Server-side components have been updated to use the new TM1 Certificates - and are no longer are risk of ticket expiration. If you wish to confirm, you may roll ahead your computer date/time, and recycle your TM1 Services - to know for sure that you are able to function on a date post November 24 2016.

Document information

More support for: Cognos TM1
TM1

Software version: 9.5, 9.5.1, 9.5.2

Operating system(s): Windows

Software edition: All Editions

Reference #: 1991655

Modified date: 09 November 2016


Translate this page: