Share This:

TrueSight users are aware of the default realm created in TrueSight. The default realm * contains all the BMC created user roles which are associated with authorization profiles for use in TSPS and the default realm. Many TrueSight users take advantage of multiple realms and would like the ability to copy the default roles to the new realms they have created. Currently, this is not an option in the TrueSight GUI, but BMC has created a script which will copy the default realm user roles to a new realm which has already been created!

 

Create a new realm or use an existing realm and then use the script which BMC has created which will create all of the default roles in the * realm to the realm specified in the script.  For default purposes the script targets the "TSOM" realm as the destination realm for the second realm. If you need to create roles in a different realm, simply edit the .sql and replace "TSOM" with the specific realm name:

FAQ on the script:
1) Does this take all the roles from the default realm?

The script was created using the list of default Roles present in the TSPS database for the * realm.  The script is static so if BMC Creates additional Roles they will not be created in alternate Realms/Tenants.


2) What is the syntax for applying the script? How do we apply it? Can you provide details?
If you are using a standalone setup you can directly run the script and restart TSPS. If you are running an HA setup then you have to follow the additional steps provided.

3) Can you explain a bit more about the details of what the script does?

The default roles are copied from the * realm and a duplicate is made within the new realm and the duplicate roles are inserted into the roles table and given the same permission as the roles  in the  * realm.


4) Are there any restrictions or limitations with using this script?
None that we are aware of at the present time.  None were encountered during testing of the script.


5) What is the expected result of the script? Will the user be able to login to the other realm and see all of the roles from the default realm?
All the default roles and permissions from the * realm will be replicated in the TSOM realm.  By creating and adding the roles to the appropriate Authorization profiles the user will have the same access in the TSOM Realm.

 

You will need the following information before proceeding with the following steps:

 

TSPS Postgres Database name: truesight

Postgres Database User name:

Postgres Database Port Number:

 

This information can be found in the following locations:

 

On the TSPS Server navigate to:

 

Windows: drive:Program Files\BMC Software\TrueSightPserver\

Linux: /opt/bmc/TrueSightPServer/

 

Open the TrueSightPServerInstalledConfiguration.xml file:

 

Look for the following entries:

      <name>TrueSight_database_username</name>

      <value>patrol</value>

 

      <name>TrueSight_database_port</name>

      <value>5432</value>

 

Instructions for a standalone environment:

=============================================================

1.    Establish a connection to the TSPS Server either via RDP or SSH depending on OS

2.    Copy the attached sql script file to the tmp directory of the TSPS Server.

          Note: On Linux ensure that the user has the ability to read the file.

3.    Navigate to the following directory on the TSPS Server

          Windows: drive:Program Files\BMC Software\TrueSightPserver\truesightpserver\modules\pgsql\bin

          Linux /opt/bmc/TrueSightPserver/truesightpserver/modules/pgsql/bin

4.    Execute the psql.exe on windows psql on Linux.  On Windows open an elevated command prompt (Run as Administrator)

5.    psql Syntax

          psql -d truesight -U postgres -p 5432 -a -q -f /home/jobs/Desktop/resources/postgresql.sql

Parameter usage:

-h PostgreSQL server IP address

-d database name

-U user name

-p port which PostgreSQL server is listening on

-f path to SQL script

-a Print all nonempty input lines

-q specifies that psql should do its work quietly

 

6.    psql -d truesight -U patrol -p 5432 -a -q -f /tmp/create_roles_tsom_realm_script.sql

7.    You may be prompted to provide the password for the dbuser.

8.    Execute  tssh server start

9.    Wait for the system to become available.  Login to the TSPS console.  Navigate to Administration -> Roles

 

Roles1.png

 

 

 

 

 

Instructions for an HA environment:

=====================================================================

1.    Establish a connection to the secondary TSPS Server either via RDP or SSH depending on OS and execute.

               tssh server stop

2.    Establish a connection to the Primary TSPS Server either via RDP or SSH depending on OS

3.    Copy the attached sql script file to the tmp directory of the TSPS Server.

               Note: On Linux ensure that the user has the ability to read the file.

4.    Navigate to the following directory on the TSPS Server

               Windows: drive:Program Files\BMC Software\TrueSightPserver\truesightpserver\modules\pgsql\bin

               Linux /opt/bmc/TrueSightPserver/truesightpserver/modules/pgsql/bin

5.    Execute the psql.exe on windows psql on Linux.  On Windows open an elevated command prompt (Run as Administrator)

6.    psql Syntax

               psql -d truesight -U postgres -p 5432 -a -q -f /home/jobs/Desktop/resources/postgresql.sql

Parameter usage:

-h PostgreSQL server IP address

-d database name

-U user name

-p port which PostgreSQL server is listening on

-f path to SQL script

-a Print all nonempty input lines

-q specifies that psql should do its work quietly

 

7.    psql -d truesight -U patrol -p 5432 -a -q -f /tmp/create_roles_tsom_realm_script.sql

8.    You may be prompted to provide the password for the dbuser.

9.    Execute tssh server start on the Primary TSPS server

10.  Execute tssh server start on the Primary TSPS server

11.  Wait for the system to become available.  Login to the TSPS console.  Navigate to Administration -> Roles

 

Roles1.png

 

If you have any questions or need assistance with this script, please open a Support ticket and the team will be glad to help. The script was tested on 11.3.01 only at this time.

 

Please do let us know if these types of scripts and enhancements are useful to you or what you would like to see added to TrueSight!

AMIGO.jpg

The BMC Assisted MIGration Offering, or AMIGO, is a program designed to assist our customers in planning and preparing for product upgrades from an older, to a newer supported version.  By engaging with BMC Technical Support Analysts, you will be provided with materials containing guidelines and best practices to aid in compiling your own upgrade plan. An upgrade expert will then review your plan, and offer advice and suggestions to ensure success through proper planning and testing.

The AMIGO program consists of a Starter Phase and a Review Phase.  Each phase is initiated by opening a support case, and ends when the case is closed.

In the Starter Phase, an AMIGO Starter case is opened.  Reference material will be provided and a call with a Technical Support Analyst will take place to discuss the details of your upgrade, and address any questions you may have.  The AMIGO Starter case will be closed, and the next step will be for you to prepare a documented upgrade plan.

In the Review Phase, an AMIGO Review case is opened preferably two weeks prior to a set upgrade date.  A call will be scheduled with an upgrade expert to review your detailed plan, providing feedback and recommendations, along with answers to any outstanding questions.  As needed, a follow up discussion with a Technical Support Analyst may take place for feedback after the upgrade is performed.

The AMIGO program includes:

» A “Question and Answer” session before you upgrade

» A review of your upgrade plan with Customer Support

» An upgrade checklist

» Helpful tips and tricks for upgrade success from previous customer upgrades

» A follow-up session with Customer Support to let them know how it went. This will help BMC to enhance the process.

 

To get started, please review the details here:

https://docs.bmc.com/docs/TSOperations/113/amigo-checklist-for-truesight-operations-management-814553031.html

 

Then open a BMC Support issue containing your environment information (product, version, OS, etc.) and the planned date of the installation, if known. We will contact you promptly, and work with you to ensure a successful and timely outcome.

 

 

 

 

Computer.png

 

New Knowledge Added over the last month:

Check out some of the latest knowledge articles added to our Support knowledge base!

 

000168894 BPPM 9.6 compatibility with RedHat Linux 7.6

 

000169052 Download of 11.3.02 TSIM Administration Console package from TSPS failed to install

 

000169132 How to monitor latest log files with a single Log file instance

 

000169202 How to set a Global Table View as my default view when I login to TSPS

 

000169267 ITDA - Console Server Fails to Start/License Key Error “Error while decoding licence key”, Post ITDA 11.3.02 Upgrade from ITDA 11.3.01

 

000169628 TrueSight Report Engine Error ORA-04025

 

000169629 TrueSight Report Engine Error in populating

 

000169685 TrueSight Smart Reporting - Launching Smart Reporting Failed

 

000169709 tssh event reinitialize failed with a NoClassDefFoundError exception

         

000170227 Is it possible to download solution packages from the TrueSight Presentation Server directly via the API?