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

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.