Pivotal Knowledge Base

Follow

Installing PivotalVRP - GPDB

PivotalVRP installation manual - version 6.x

 

PivotalVRP 6.0 Installation Manual

 

Contents:

Chapter 1. PivotalVRP Installation Overview 

PivotalVRP Installation Overview

Installation Checklist

Chapter 2. Preparing Greenplum Database for Install

Configuring Privileges on the Database Nodes and Segments 

Chapter 3. Installing the Server

Pre-Installation Tasks

PivotalVRP Server Installation

PivotalVRP UI Manual files installation (legacy & support)

Chapter 4. Installing the Agent 

Installing the Agent

Connecting to the Greenplum

Logging into the PivotalVRP Console for the First time

Post-Installation Tasks 

Chapter 5. Locating your IP Address

Locating your IP Address 

Chapter 6. Setting TLS - Windows Internet Explorer

Setting TLS in Windows Internet Explorer 

Chapter 7. Uninstalling PivotalVRP 

Uninstalling the Repository

Uninstalling PivotalVRP Server

Uninstalling the Agent 

 

Chapter 1 PivotalVRP Installation Overview

Topics:

PivotalVRP Installation Overview

Installation Checklist

 

 

PivotalVRP Installation Overview

The installation process consists of 8 major steps which includes everything, from mapping the environment characteristics through executing the installation process and finishing with a post-installation checklist.

 

Installation Checklist
Here is the checklist that you should follow before, during and after the PivotalVRP installation process.

Step

Task

Remarks

 

1

Send information about the target DB environment to the support team (through Zendesk ticket)

Greenplum Database version Operating system name
Operating system version
Operating system bit level (32/64) CPU type (X86, Itanium, Power4 etc)

 

2

Receive pre-requirements document from Pivotal support team

You will get a pre-requirements document which is specific for the database you intend to install on.

 

3

Send more details about the PivotalVRP server environment to the support team.

IP address
OS name & version OS bit level (32/64) OS service-pack level

 

4

Receive the installer package from the support team

This package includes :
Download package link

 

5

Install the PivotalVRP server

Make sure the environment is ready before installing

 

6

Install the PivotalVRP agent

(on the database server)

 

7

Fill out the checklist and send it back to the support team

Not sending this document may result in delays opening service requests

 

 

Chapter 2 Preparing Greenplum Database for Install

Topics:

Configuring Privileges on the Database Nodes and Segments

 

Configuring Privileges on the Database Nodes and Segments

Prior to the installation of PivotalVRP there are a few server side operations that are necessary in order to connect to the PivotalVRP server.

  1. "postgres" user access rights or any other user with superuser permissions. To create a dedicated user: CREATE ROLE PivotalVRP WITH SUPERUSER
    ALTER ROLE PivotalVRP WITH PASSWORD 'XXXX';
    ALTER ROLE PivotalVRP LOGIN;

  2. Linux/Unix root user access rights on all segment hosts (required for the agent installation phase only)

  3. Open up all segments to allow direct connection from the PivotalVRP server:
    Locate all pg_hba.conf files of all segments and add the following line at the end. X.X.X.X should be the PivotalVRP server IP address (the IP that is on the interconnect network)
    host all all X.X.X.X/32 trust

4. Reload postgres configuration (doesn't require a downtime) by running this command on the master node.

gpstop -u

 

Chapter 3 Installing the Server

Topics:

Pre-Installation Tasks
PivotalVRP Server Installation PivotalVRP UI Manual files installation

 

Pre-Installation Tasks

  1. Make sure the environment is ready for installation (by following the pre-requirements document you received from the Pivotal support team).

    Note: Not following the pre-requirements list may result in problems during the installation and operation of PivotalVRP. In addition to that, you will not be able to open a support ticket with the PivotalVRP support team if the pre-requirements have not been met completely.

  2. Download the installer or if already downloaded place it on the PivotalVRP server

  3. Make sure that all the MAC addresses are available – meaning that all network interface are activated. This includes:

    • Wired LAN
    • Wireless LAN  
    • Bluetooth

    PivotalVRP binds itself to the network interfaces available on the PivotalVRP server. If some network interfaces will disappear (deactivate) or change, the PivotalVRP will shut itself down and a new product key will be required.
    Note: This is really important when installing on a laptop, where activating & deactivating network interfaces is a very common thing.

  4. Make sure you are logged on with administrator privileges on the PivotalVRP Windows server.

  5. Go to "Program and Features" and select Turn Windows features on or off and enable the .Net Framework.

 

PivotalVRP Server Installation

The procedure below describes how to install the console for the first time.

Since prior versions of PivotalVRP cannot be upgraded, if you have a previous version, backup important files, uninstall the previous version and follow the steps below.

To install the console:

  1. Download the PivotalVRP setup file from the location provided by Pivotal support.

  2. Save the file on your desktop or in any folder.

  3. Extract PivotalVRP installation file: "PivotalVRP_EE_Setup_v{version}-{database}.zip"

  4. Choose the extraction location.

  5. 3 items will be extracted : the PivotalVRP installer (named "PivotalVRP_EE_Setup_v{version}-{database}.exe"), a "Readme" file and an open source license document.

  6. To start the installation, double click the PivotalVRP installer.

  7. in some cases the installer will ask you to restart the computer, if it does restart the computer and repeat step 6.

  8. The PivotalVRP setup welcome screen will appear. 

    9. Click "Next".

The License Agreement screen is displayed.

        

   10. Click "I Agree".

Note: You must accept the terms of the agreement to install PivotalVRP.

The application destination screen is displayed.       

       

    11. Select the location you wish to install to and click next.

(To install the PivotalVRP repository in the default folder, click "Next", or to install in a different folder, click

"Browse", select another folder, and then click "Next" to continue.)
Note: The default path for the installer is "C:\Program Files\MoreDB" this is where the application will be placed .

       The repository destination screen is displayed

       

Note: The default path for the repository is "C:\Program Files\MoreDB\PostgreSQL" this is where the PivotalVRP repository will be placed in case you have a dedicated location prepared for the repository you should choose that location.

    12. To install the PivotalVRP repository in the default folder, click "Next", or to install in a different folder, click " Browse", select another folder, and then click "Next" to continue.

During the installation you will see the progression and the various components being installed.

       

Various windows may open

  1. The next step in the installation will inform you that the PivotalVRP repository database structure is about to be built. Click "Next" to continue.

    The progress bar will show you how far the process is from completion.

  2. Once the repository is built you will see the following screen.

  3. Click "next" to continue.

  1. Now that all the components have been installed, you will be asked to enter the company name. Once entered you should keep record of the information entered. You will need to enter this every time you log into PivotalVRP. Note, the name cannot contain spaces.

  2. Once you click "next" an information screen with agent information will appear.

  3. Click "next" to continue.

  1. The following screen with basic connection instructions shows up, this information is also contained further on is this guide. You can find it under the Connecting to the Greenplum header.

  2. Click "next" to continue.

  3. The security certificate warning instruction will show up.

  4. Click "next" to continue.

  23. The Completion screen appears.

  24. Click "Finish" to exit the installer.

 

  25. A notepad document called "Runtimelog" will open on your desktop.

  26. The runtimelog is necessary in order to get a license key for PivotalVRP.

To get a license key:
  •  Open a Zendesk ticket with a key request and attach the runtime log file
  •  Send the request (with the runtime log) to support@pivotal.io
  1. Once you have the "MoreDB.key" file place it in the MoreDB folder and open the "services" panel

  2. Find the "MoreVRP Service" and start it.

  3. Once the service is started, log into the PivotalVRP GUI.

    1. The procedure can be done by double clicking the Desktop icon called PivotalVRP_Server

    2. This can also be done from any desktop on the same domain as the PivotalVRP server by entering the IP address of the server as follows:
      https://<PivotalVRP server IP>:9191/MoreVRP.html ie.: https://win-12sa45tstes:9191/MoreVRP.html or https://125.125.125.10:9191/MoreVRP.html

  4. Once the agent installation process is complete and the server side pre-installation tasks are completed, you are ready to proceed with the Connecting to the Greenplum section

Should there be any issues you may be asked to update the UI Files. Below are general instructions on the location and manual UI installation.  (for legacy installation, this step is always necessary)

  1. Open the UI zip file that you've received from the Support team. Extract it to an empty folder.

    (See below an example of how the zip file should look after it unzips).

  2. Copy the entire contents of this folder and paste it into :

    "C:\Program Files\MoreDB\GlassFish\glassfish\domains\MoreVRP\docroot"

    Note: If you installed the Glassfish to a non-default location – choose the appropriate path

    3. Restart "MoreVRP Service" service (through the Windows Services as you did before.) Check that all MoreDB services are up and running:

     The UI installation process should now be complete.

After the MoreVRP service has successfully initiated, login to PivotalVRP using any Web browser. In the URL command line type the link to the PivotalVRP GUI:

4. (Note that the URL is case-sensitive – meaning the link should appear exactly as follows :

https://125.125.12.168:9191/MoreVRP.html

 

Chapter 4 Installing the Agent

Topics:

Installing the Agent
Connecting to the GPDB
Logging into the PivotalVRP Console for the First time Post-Installation Tasks

 

Installing the Agent Unix/Linux Installation

  1. This part of the installation process is usually done by a system administrator.

  2. The agent has to be installed on every single node.

    The agent installer file is located after the installation on the PivotalVRP desktop in a folder called "Agent".

    Note: The agent installation file is called morevrpd

  3. Using an FTP editor, copy the morevrpd file to your remote database server (Unix/Linux) as user root and place it under /bin/morevrpd. If this directory does not exist, then you should create it.

    Here is an example of how to do that :

ftp> open 192.168.10.111Connected to 192.168.10.111.220 hpux FTP server (Revision 1.1 Version wuftpd-2.6.1(PHNE_34306) Mon Mar 13 11:14:17 GMT 2006) ready.User (192.168. 10.111:(none)): root331 Password required for root.Password:XXX230 User root logged in. ftp> cd /tmp250 CWD command successful.ftp> lcd c:\tempLocal directory now C:\temp.ftp> bin200 Type set to I.ftp> put morevrpd200 PORT command successful.150 Opening BINARY mode data connection for morevrpd.226 Transfer complete.ftp: 122562 bytes sent in 3 .57Seconds 34.37Kbytes/sec.ftp> close

Once you copy the file to /tmp (as described in the example), you can move it to the destination Directory by :
mkdir /bin/morevrpd > creating the directory
mv /tmp/morevrpd /bin/morevrpd/ > moving the agent file into it.

Note: Make sure you copy the files while you are in "bin" mode for binary files compatibility.

  1. Make sure the file permissions are OK.

  2. If not, then change them with the following commands :

  3. To start the daemon manually:

# ls -l /bin/morevrpd -rwxr-xr-x 1 root root 112331 Jan 10 14:02 morevrpd

chown root:root morevrpdchmod 755 morevrpd

# cd /bin/morevrpd # ./morevrpd start

   7.   The following output is OK :

Starting morevrpd

ps -ef | grep morevrpd

root 22809 1 1 16:03 ? 00:00:00 ./morevrpd start

root 22812 1 0 16:03 ? 00:00:00 ./morevrpd start

root 22816 1 0 16:03 ? 00:00:00 ./morevrpd start

   8.  When the daemon is started – you should see three processes of morevrpd activated:

If you want the daemon to start automatically in your OS – put into the automatic startup script of your server. (Ask your sysadmin to do that.)

If you wish to shut the daemon down, type:

./morevrpd stop

 

Connecting to the GPDB

  1. Prior to connecting the database, you must install the PivotalVRP agent on the database server. Please follow instructions in the previous section (4.1)

  2. The next step requires you to add an entry into the hosts file on the PivotalVRP server. The file is located at "C:\Windows\System32\drivers\etc".This step is necessary in order for the PivotalVRP server to ping the hostnames that appear in the "select * from gp_segment_configuraton" list.

  3. Make sure you use the PRIVATE IP and not the PUBLIC. And that PivotalVRP can access the PRIVATE IP.

  4. Once this is completed log onto the PivotalVRP GUI and go to the setting tab. In the general settings, click add

  5. Fill out the fields as follows:

Connection Name: Enter whatever you wish to call the master view.

Host Name / IP : x.x.x.x - x.x.x.x is the IP of the master node (it can be the PUBLIC IP) / When adding single segments, the IP of the segment host.

Port : When using the auto connect the master port (default is 5432)/ When adding single segments, the port of the segment.

Username/Password - as defined.

Connection Type : Select Automatic enumeration for connection to the full environment / Single Segment if you wish to connect to a single segment.

Test Connection : Verifies that the setting are correct and that PivotalVRP can communicate with the segments

** in order to add the segments to the list the connection needs to be verified before you can click OK.



You should now see the parents and the segments populating the "Known Server" list. Once they are connected you will notice a small DB Drum icon with a green check-mark on it.
PivotalVRP automatically tries to connect the databases on the "Known Server" list.

The table below details the settings necessary prior to the installation of PivotalVRP:

 

Setting

Action

User Privileges and network configuration the Database nodes and segments :

  1. "postgres" user access rights or any other user with superuser permissions. To create a dedicated user :

    CREATE ROLE PivotalVRP WITH SUPERUSER ALTER ROLE PivotalVRP WITH PASSWORD 'XXXX'; ALTER ROLE PivotalVRP LOGIN;

  2. Linux/Unix root user access rights on all segment hosts (required for the agent installation phase only)

  3. Open up all segments to allow direct connection from the PivotalVRP server :

    Locate all pg_hba.conf files of all segments and add the following line at the end. X.X.X.X should be the PivotalVRP server IP address (the IP that is on the interconnect network)

    host all all X.X.X.X/32 trust

  4. Reload postgres configuration (doesn't require a downtime) by running this command on the master node.

    gpstop -u

6. Select "Dashboard" from the Main Menu on the left pane. Within a few seconds, you should begin to see information from your DB appear in the PivotalVRP dashboard. If not, check the PivotalVRP log file for more details (c:\program files\moredb\runtimelog.log)

If you encounter any problems during the above procedure, contact Pivotal Support via zendesk.

 

Logging into the PivotalVRP Console for the First time

  1. Open your web browser and type in the following URL :

    https://XXX.XXX.XXX.XXX:9191/MoreVRP.html

    Note: The URL is case sensitive. Make sure you type in the URL as it is shown above

    Where XXX is your PivotalVRP server IP address. (NOTE: This is the same IP address you provided tothe PivotalVRP support team earlier.)

    NOTE: If you use Microsoft Internet Explorer and the PivotalVRP Console doesn't appear and you get the following error message saying: "Internet Explorer cannot display the webpage", see Setting TLS in Windows Internet Explorer.
    You should see the following screen :

  2. Please select the radio button "Continue to this website". The message about the security certificate is of no concern and it is perfectly safe.

    The PivotalVRP Dashboard Login screen will appear.

  3. Login to the application:

         Organization name as defined during the setup User Name is: "administrator".
         Default Password is: "Admin2010".
         Note: The password is key-sensitive.

Congratulations, you have completed the PivotalVRP Installation process.

Post-Installation Tasks

Upon completing the installation process, fill out the PivotalVRP checklist to make sure that the software works properly.
Ask our support team for the checklist if needed.

If help is still needed- please contact Pivotal support via Zendesk.

 

Chapter 5 Locating your IP Address

Topics:

Locating your IP Address

 

Locating your IP Address

1. Open the command window (Start > Run > CMD) 2. Type in : IPCONFIG.

3. Your IP address will appear - (Here is an example:)

 

Chapter 6 Setting TLS - Windows Internet Explorer

Topics:

Setting TLS in Windows Internet Explorer

Setting TLS in Windows Internet Explorer

  1. Open your web browser.

  2. Select Tools > Internet Options > Advance TAB > scroll down and check the boxes "Use TLS 1.1" and "Use TLS 1.0"

  3. Click on "OK".

  4. Try to log on using the PivotalVRP URL again.

 

Chapter 7 Uninstalling PivotalVRP

Topics:

Uninstalling the Repository

Uninstalling PivotalVRP Server

Uninstalling the Agent

 

Uninstalling the Repository

If you wish to delete PivotalVRP historical statistics, you should uninstall the PostGres Database.
You may want to uninstall only the PivotalVRP application and keep the historical statistics for future use with new releases of PivotalVRP.
To uninstall the repository :

1. Go to Add/Remove programs from
2. Start > Settings > Control Panel > Add or remove Programs. 3. Chose PostgreSQL 8.3 and Press Remove.

 

Uninstalling PivotalVRP Server

To uninstall the console do the following:

  1. Go to program files > MoreDB > Uninstall

  2. If the uninstall fails or uninstall link doesn't exists, use Add/Remove programs from

    Start > Settings > Control Panel > Add or remove Programs.

    Chose MoreDB and Press Remove.

  3. Go to More directory (default is c:\program files\moredb)

  4. If you want to keep historical repository for future installation, do not delete any subdirectories. Make sure it is empty from files only. If you want to delete it permanently, you can delete the entire MoreDB directory (along with the repository)

 

Uninstalling the Agent On Linux :

1. Login to the database server as root 2. Stop the morevrpd agent :

3. Delete the morevrpd agent file

Cd /bin/morevrpd ./morevrpd stop

 

Comments

Powered by Zendesk