Greenplum Command Center 1.3.0.1 Release Notes

Greenplum Command Center 1.3.0.1 Release Notes

About Pivotal Greenplum Command Center

Pivotal Greenplum Command Center is a management tool for Pivotal's Greenplum Database. Pivotal Greenplum Command Center monitors system performance metrics, system health, and also provides administrators the ability to perform management tasks such as start, stop, and recovery of systems for Greenplum Database. Pivotal Greenplum Command Center is an interactive graphical web application that can be installed on a web server on the master host, and used to view and interact with the collected system data from Greenplum Database and optionally from EMC's Data Computing Appliance (DCA).

Pivotal Greenplum Command Center is comprised of data collection agents that run on the Greenplum Database master host and each segment host. The agents collect data about queries and system utilization and send it to the database's master host at regular intervals. Pivotal Greenplum Command Center stores its data and metrics in a dedicated Greenplum database (the gpperfmon database) whose information is distributed among the master host and segment hosts, like any other Greenplum Database. The data stored in the gpperfmon database can be accessed through the web application or through SQL queries.

Greenplum Database is a requirement for operating Command Center (Command Center stores its information in a Greenplum database).

Supported Platforms

Red Hat Enterprise Linux 5 and 6
Note: For Greenplum Command Center 1.3:
  • OpenSSL version is 1.0.1o.
  • lighttpd web server version is 1.4.35

Greenplum Command Center Compatibility

Pivotal Greenplum Command Center is currently certified for the EMC Data Computing Appliance (DCA) and Greenplum Database software-only environments. Command Center monitors the following for each environment:

Greenplum Data Computing Appliance

  • Greenplum Database Module 4.3.x
  • Greenplum Data Integration Accelerator (DIA) Module
  • Greenplum Data Computing Appliance Hardware (V1.2.x and V2.x)

If you have been using Greenplum's earlier monitoring tool, Performance Monitor, with an older DCA release, we recommend you upgrade to a supported version of DCA.

Greenplum Database (Software-Only Environments)

  • Greenplum Database 4.3.x

About Pivotal Command Center 1.3

Product Enhancements in Release 1.3.0.1

Release 1.3.0.1 is a maintenance release. See Resolved Issues for a list of issues that are fixed in this release.

The following are enhancements and changes in release 1.3.0.1:

Assigning the Operator Role to a Group

In previous releases, the gpcc_operator role could only be assigned to individual users. It is now possible to assign gpcc_operator to a group role and add multiple users to the group. See the Pivotal Greenplum Command Center Administrator Guide for instructions and examples.

Users with "trust" Authentication May Not Log into Command Center

The gpadmin and any user configured with trust authentication in the pg_hba.conf file on the host that runs the Command Center web server may no longer log in to the Command Center.

The gpmon user must be configured in pg_hba.conf with access to all databases that will be monitored with Command Center.

See "Configuring Authentication for the Command Center" in the Greenplum Command Center Administrator Guide for instructions for setting up Command Center users.

OpenSSL Upgrade

The OpenSSL library included with Greenplum Command Center has been upgraded to version 1.0.1o. See https://www.openssl.org for information about the changes in this release.

Upgrading Greenplum Command Center

New upgrade instructions have been added to the Pivotal Greenplum Command Center Administrator Guide. The current upgrade procedure includes instructions for installing a new release distribution. However, it is currently necessary to recreate Command Center instances after the new release is installed.

Installation and Upgrade Instructions

Note: Greenplum Command Center requires Adobe Flash Player version 11 or higher. If this requirement is not met, you see the following screen:

Greenplum Data Computing Appliance

Pivotal Greenplum Command Center is already installed on the appliance (versions 1.2.x and 2.x).

For more information about setting up, upgrading, and configuring Pivotal Greenplum Command Center on an EMC Greenplum DCA, refer to the appropriate versions of the Greenplum Data Computing Appliance Software Upgrade Guide and Greenplum Data Computing Appliance Installation and Configuration Guide.

Greenplum Database Software-only

Instructions for installing, configuring, and upgrading your system for Pivotal Greenplum Command Center are provided in the latest Pivotal Greenplum Command Center 1.3 Administrator Guide (see Pivotal Greenplum Command Center 1.3 Documentation for availability).

Pivotal Greenplum Command Center replaced a monitoring tool called Greenplum Performance Monitor. You are not required to upgrade to Pivotal Greenplum Command Center; you can continue using Performance Monitor as before. To continue running Performance Monitor, do not setup Command Center. You will not be able to access new monitoring features if you decide not to upgrade. You may also run Performance Monitor and Command Center in parallel (for example, to compare functionality before upgrading). For parallel operations, assign a different port number to Command Center during setup.

Accessing Command Center

For enhanced security, beginning with Greenplum Command Center release 1.3.0.1, the gpadmin user is not permitted to log in to the Command Center. The Command Center does not accept logins from any user on the host running GPCC configured with trust authentication in the pg_hba.conf file.

You should create new administrative, operator, and regular Command Center users for Command Center. To create a new Command Center user, first you create a Greenplum Database role, then edit the pg_hba.conf file to give that user access to Command Center. An example of this procedure is provided in the Pivotal Greenplum Command Center Administrator Guide and more detailed information can be found in the Pivotal Greenplum Database Administration Guide.

Resolved Issues

The following table lists issues that were resolved in Pivotal Greenplum Command Center (Command Center) 1.3.

For issues resolved in earlier GPCC releases, refer to their release notes, available on our website at http://docs.pivotal.io/.

Issue Description Fix Version
CMDR-283 Alert messages 'password authentication failed' are generated for every login. Before attempting authentication with the entered password, GPCC tested whether the logged in user was trusted and the allow_trusted_login parameter in the web application configuration file was set to true. The authentication failure alert was generated during this initial phase of the authentication. The allow_trusted_login option has been removed. 1.3.0.0
CMDR-1833 Large amount of connection errors to hadoop nodes were being generated even though there were no hadoop nodes in the cluster. 1.3.0.0
CMDR-1861 Errors were displayed when a non-superuser logged into GPCC that prevented some of the data from being displayed in the UI. 1.3.0.0
CMDR-1763 All special characters are now supported in the Greenplum Command Center user login name. 1.3.0.0
CMDR-1928 In response to OpenSSL Security Advisory [15 Oct 2014] (see https://www.openssl.org/news/secadv_20141015.txt), OpenSSL has been upgraded to 1.0.1j.

See http://www.pivotal.io/security for more information regarding security vulnerabilities in Pivotal products.

1.3.0.0
CMDR-1938, CMDR-1960, CMDR-1971 The GPCC release notes reference upgrade instructions in the GPCC Administration Guide. However, there are no upgrade instructions in the guide. 1.3.0.1
CMDR-1940 GPCC did not work properly with reverse proxy. 1.3.0.0
CMDR-1933 Filtering of users in the Resource Queue view has been improved. 1.3.0.0
CMDR-1904 The application name is now displayed for GPCC queries. 1.3.0.0
CMDR-1622 The EXPLAIN plan displayed in GPCC has been enhanced. 1.3.0.0
CMDR-1788 GPCC 1.3.0.0 supports the new user type Operator. GPCC users who are members of this group have access to more functionality in the GPCC user interface than regular users, but do not have to be a Greenplum Database superuser. 1.3.0.0
CMDR-1932 GPCC supports encryption of Command Center sessions with self-signed certificates and OpenSSL encryption. 1.3.0.0
CMDR-1970 Running a Web application scanner tool uncovered a vulnerability in the GPCC Web GUI: "It is possible to steal or manipulate customer session and cookies, which might be used to impersonate a legitimate user, allowing the hacker to view or alter user records, and to perform transactions as that user." 1.3.0.1
CMDR-1974 It should be possible to assign operator_role to a group. 1.3.0.1
MPP-25485 The gpmmon process hangs during startup if the gpmon user cannot log into the gpperfmon database. 1.3.0.1
CMDR-1976 Command Center does not correctly display CPU usage for any query that is initially blocked from executing. 1.3.0.1
CMDR-1977 The gpadmin user could log in to Greenplum Command Center with an incorrect password or no password. 1.3.0.1
95101952 After a user logs in, the Command Center performs some background processing before clearing the login screen, which gives the appearance that the login has hung. 1.3.0.1
95101954 An Operator user logged in with a non-superuser role could not view the explain plan for another user's query because they did not have access to the underlying database objects. 1.3.0.1
96895590 Upon logging in to the Command Center, the user's name and password were passed to the web server in URL parameters. 1.3.0.1

Known Issues

This section lists the known issues in Pivotal Greenplum Command Center 1.3. A work-around is provided where applicable.

Issue Description
CMDR-297

Heavy workload on the Greenplum Database can affect responsiveness.

The refresh rate of the Command Center user interface can be adversely affected by simultaneous heavy workload on the underlying Greenplum Database.

PT-87736724 The Command Center installer does not have support to upgrade existing Command Center instances when upgrading to a new release.

Pivotal Documentation

The following Pivotal Greenplum Command Center and related documentation is available on our website at http://gpcc.docs.pivotal.io/.

Title Revision
Pivotal Greenplum Command Center 1.3 Administrator Guide A05
Pivotal Greenplum Command Center 1.3.0.1 Release Notes (this document) A01

Additionally, we provide end user information via online help. To launch the online help, click the Help button at the top right of the GPCC user interface.