PRODUCT DOCUMENTATION
PivotalVRP
Version 6.0
Installation Guide
Rev: A01 – June 10, 2014
© 2014 Pivotal Software, Inc.
PivotalVRP
PivotalVRP 6.0 Installation Manual
Copyright
Copyright © 2014 Pivotal Software, Inc. All Rights reserved.
Pivotal Software, Inc. believes the information in this publication is accurate as of
its publication date. The information is subject to change without notice. THE
INFORMATION IN THIS PUBLICATION IS PROVIDED "AS IS." Pivotal
Software, Inc. ("Pivotal") MAKES NO REPRESENTATIONS OR WARRANTIES
OF ANY KIND WITH RESPECT TO THE INFORMATION IN THIS
PUBLICATION, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF
MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.
Use, copying, and distribution of any Pivotal software described in this
publication requires an applicable software license.
All trademarks used herein are the property of Pivotal or their respective owners.
Use of Open Source
This product may be distributed with open source code, licensed to you in
accordance with the applicable open source license. If you would like a copy of
any such source code, Pivotal will provide a copy of the source code that is
required to be made available in accordance with the applicable open source
license. Pivotal may charge reasonable shipping and handling charges for such
distribution.
About Pivotal Software, Inc.
Greenplum transitioned to a new corporate identity (Pivotal, Inc.) in 2013. As a
result of this transition, there will be some legacy instances of our former
corporate identity (Greenplum) appearing in our products and documentation. If
you have any questions or concerns, please do not hesitate to contact us
through our web site: http://gopivotal.com/about-pivotal/support.
2
PivotalVRP
PivotalVRP 6.0 Installation Manual
Contents
Chapter 1. PivotalVRP Installation Overview
____________________________________ 4
PivotalVRP Installation Overview ________________________________________________________________ 5
Installation Checklist __________________________________________________________________________ 6
Chapter 2. Preparing Greenplum Database for Install
_____________________________ 7
Configuring Privileges on the Database Nodes and Segments __________________________________________ 8
Chapter 3. Installing the Server
______________________________________________ 9
Pre-Installation Tasks ________________________________________________________________________ 10
PivotalVRP Server Installation __________________________________________________________________ 11
PivotalVRP UI Manual files installation ___________________________________________________________ 20
Chapter 4. Installing the Agent
______________________________________________ 22
Installing the Agent __________________________________________________________________________ 23
Connecting to the Greenplum __________________________________________________________________ 25
Logging into the PivotalVRP Console for the First time _______________________________________________ 28
Post-Installation Tasks ________________________________________________________________________ 30
Chapter 5. Locating your IP Address
_________________________________________ 31
Locating your IP Address ______________________________________________________________________ 32
Chapter 6. Setting TLS - Windows Internet Explorer
_____________________________ 33
Setting TLS in Windows Internet Explorer _________________________________________________________ 34
Chapter 7. Uninstalling PivotalVRP
__________________________________________ 35
Uninstalling the Repository ____________________________________________________________________ 36
Uninstalling PivotalVRP Server _________________________________________________________________ 37
Uninstalling the Agent ________________________________________________________________________ 38
3
PivotalVRP
PivotalVRP 6.0 Installation Manual
Chapter 1 PivotalVRP Installation Overview
Topics:
PivotalVRP Installation Overview
Installation Checklist
4
PivotalVRP
PivotalVRP 6.0 Installation Manual
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.
5
PivotalVRP
PivotalVRP 6.0 Installation Manual
Installation Checklist
Here is the checklist that you should follow before, during and after the PivotalVRP installation process.
Step Task
1
Send information about the target DB environment to the
support team ([email protected])
Remarks
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 PivotalVRP
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
IP address
environment to the support team (
[email protected])
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 link for the PivotalVRP server
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
6
PivotalVRP
PivotalVRP 6.0 Installation Manual
Chapter 2 Preparing Greenplum Database for Install
Topics:
Configuring Privileges on the Database Nodes and Segments
7
PivotalVRP
PivotalVRP 6.0 Installation Manual
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
8
PivotalVRP
PivotalVRP 6.0 Installation Manual
Chapter 3 Installing the Server
Topics:
Pre-Installation Tasks
PivotalVRP Server Installation
PivotalVRP UI Manual files installation
9
PivotalVRP
PivotalVRP 6.0 Installation Manual
Pre-Installation Tasks
1. Make sure the environment is ready for installation (by following the pre-requirements document you
received from the PivotalVRP 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.
10
PivotalVRP
PivotalVRP 6.0 Installation Manual
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 PivotalVRP 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.
11
PivotalVRP
PivotalVRP 6.0 Installation Manual
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.
12
PivotalVRP
PivotalVRP 6.0 Installation Manual
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.
13
PivotalVRP
PivotalVRP 6.0 Installation Manual
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
14
PivotalVRP
PivotalVRP 6.0 Installation Manual
13. 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.
14. Once the repository is built you will see the following screen.
15. Click "next" to continue.
15
PivotalVRP
PivotalVRP 6.0 Installation Manual
16. 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.
17. Once you click "next" an information screen with agent information will appear.
18. Click "next" to continue.
16
PivotalVRP
PivotalVRP 6.0 Installation Manual
19. 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.
20. Click "next" to continue.
21. The security certificate warning instruction will show up.
22. Click "next" to continue.
17
PivotalVRP
PivotalVRP 6.0 Installation Manual
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.
18
PivotalVRP
PivotalVRP 6.0 Installation Manual
27. There are 2 ways to get a license key:
a. If you are on the EMC network, you can use the web key generator.
i. Go to : https://10.110.127.39:8181/
ii. Use as credentials, Username: gpsales Password: Wa3%838pso
b. You can send the runtime log to : [email protected] , a key will be emailed back to you.
(In case you closed the document it is located in the MoreDB folder on the server)
28. Once you have the "MoreDB.key" file place it in the MoreDB folder and open the "services" panel
29. Find the "MoreVRP Service" and start it.
30. Once the service is started, log into the PivotalVRP GUI.
a. The procedure can be done by double clicking the Desktop icon called PivotalVRP_Server
b. 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
31. 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
19
PivotalVRP
PivotalVRP 6.0 Installation Manual
PivotalVRP UI Manual files installation
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.
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
20
PivotalVRP
PivotalVRP 6.0 Installation Manual
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.
4. 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:
(Note that the URL is case-sensitive – meaning the link should appear exactly as follows :
https://125.125.12.168:9191/MoreVRP.html
21
PivotalVRP
PivotalVRP 6.0 Installation Manual
Chapter 4 Installing the Agent
Topics:
Installing the Agent
Connecting to the Greenplum
Logging into the PivotalVRP Console for the First time
Post-Installation Tasks
22
PivotalVRP
PivotalVRP 6.0 Installation Manual
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.
4. Make sure the file permissions are OK.
# ls -l /bin/morevrpd -rwxr-xr-x 1 root root 112331 Jan 10 14:02 morevrpd
5. If not, then change them with the following commands :
chown root:root morevrpdchmod 755 morevrpd
6. To start the daemon manually:
# cd /bin/morevrpd # ./morevrpd start
23
PivotalVRP
PivotalVRP 6.0 Installation Manual
7. The following output is OK :
Starting morevrpd
When the daemon is started – you should see three processes of morevrpd activated:
ps -ef | grep morevrpdroot 22809 1 1 16:03 ? 00:00:00 ./morevrpd startroot 22812 1 0 16:03
? 00:00:00 ./morevrpd startroot 22816 1 0 16:03 ? 00:00:00 ./morevrpd start
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.)
8. If you wish to shut the daemon down, type:
./morevrpd stop
24
PivotalVRP
PivotalVRP 6.0 Installation Manual
Connecting to the Greenplum
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
segmentTest 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.
25
PivotalVRP
PivotalVRP 6.0 Installation Manual
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 More:
26
PivotalVRP
PivotalVRP 6.0 Installation Manual
Setting
Action
User Privileges and network
configuration the Database
nodes and segments :
a. "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;
b. Linux/Unix root user access rights on all segment hosts (required for the
agent installation phase only)
c. 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
d. 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 PivotalVRP Support via:
[email protected]
27
PivotalVRP
PivotalVRP 6.0 Installation Manual
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:
28
PivotalVRP
PivotalVRP 6.0 Installation Manual
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.
29
PivotalVRP
PivotalVRP 6.0 Installation Manual
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 our support via e-mail to [email protected].
30
PivotalVRP
PivotalVRP 6.0 Installation Manual
Chapter 5 Locating your IP Address
Topics:
Locating your IP Address
31
PivotalVRP
PivotalVRP 6.0 Installation Manual
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:)
32
PivotalVRP
PivotalVRP 6.0 Installation Manual
Chapter 6 Setting TLS - Windows Internet Explorer
Topics:
Setting TLS in Windows Internet Explorer
33
PivotalVRP
PivotalVRP 6.0 Installation Manual
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.
34
PivotalVRP
PivotalVRP 6.0 Installation Manual
Chapter 7 Uninstalling PivotalVRP
Topics:
Uninstalling the Repository
Uninstalling PivotalVRP Server
Uninstalling the Agent
35
PivotalVRP
PivotalVRP 6.0 Installation Manual
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.
36
PivotalVRP
PivotalVRP 6.0 Installation Manual
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)
37
PivotalVRP
PivotalVRP 6.0 Installation Manual
Uninstalling the Agent
On Linux :
1. Login to the database server as root
2. Stop the morevrpd agent :
Cd /bin/morevrpd ./morevrpd stop
3. Delete the morevrpd agent file
38