Creating a response file for a load balancer upgrade (GUI mode)

Note: The installer does not support changing a standalone deployment to a load balancer deployment during an upgrade, or vice versa. To make such a change, you would need to uninstall the server and then reinstall it. See Uninstalling Hybrid Data Pipeline server and Installing the Hybrid Data Pipeline server for details.

After copying the product installation file to a temporary directory, take the following steps to generate a response file for a load balancer upgrade using the GUI installer.

1. From a command-line prompt, navigate to the directory where you saved the product file. Alternatively, place the product file directory on your path before proceeding to the next step.

The product file has the format PROGRESS_DATADIRECT_HDP_SERVER_nn_LINUX_64_INSTALL.bin, where nn is the version of the product.

2. Make the file an executable using the chmod command. Then, press ENTER. For example:

3. At a command-line prompt, type the following command where response_file is the path and file name of the response file you want to create. You must specify an absolute path.

The following example creates a response file named pipeline.response in the /home/users/johndoe directory.

4. The License Agreement window appears. Make sure that you read and understand the license agreement. To continue with the installation, select the I accept the terms in the License Agreement option; then, click Next.

Note: You can exit the installation program at any time by clicking Cancel or return to the previous window by clicking Previous.

5. Choose the destination directory for the installation. Click Next to accept the default installation directory, or select Choose... to browse to a different directory, then click Next.

6. Choose whether you want to upgrade with an evaluation or licensed version of the product. Licensed installations require a valid License Key.

Evaluation. Select this option to upgrade with an evaluation version that is fully functional for 30 days. Then, click Next.

Licensed. Select this option if you purchased a licensed version of the product. Type the license key, including any dashes, and then click Next.

7. Accept or enter the fully qualified hostname of the machine that will host the Hybrid Data Pipeline server. By default, the installer suggests the name of the current machine.

If you enter a hostname different than the hostname of the current machine, the installer will fail to validate the hostname. You are then prompted to reenter the hostname or skip validation. If you are planning on using the response file to install the product on a different machine, you should opt to skip validation.

Before using the response file to install the product on another machine, the response file must have the SKIP_HOSTNAME_VALIDATION and SKIP_PORT_VALIDATION properties set to true. For example:

Running an installation in silent mode with a response file containing these settings allows the silent installation to continue even if hostname or port validation fail. When the validation fails during the silent installation process, the installer generates the file SilentInstallInfo.log in the user's home directory but completes a full installation.

8. Select how you want to continue the upgrade.

Select Express to persist previously established values. Then, click Next and continue at Step 22.

Note: The following elements of an installation cannot be modified when performing an upgrade of a load balancer installation: key location, load balancer hostname, and On-Premises Connector enablement.

9. Select the desired Java configuration.

Note: Further steps are required to integrate an external JRE. See External JRE support and integration for details.

Select Java home directory and provide the path to an external JRE if you will be using a JRE not installed with the server.

10. Select whether you want to enable FIPS on the Hybrid Data Pipeline server.

Important: To enable FIPS, your hardware must support secure random, or you must have a secure random daemon installed.

Important: When you enable FIPS during an upgrade, the environment uses the encryption key for the system database that was generated during the original installation of the server. This encryption key, while generated with a FIPS compliant algorithm, was not generated with a FIPS certified implementation of the algorithm.

11. Depending on your environment, provide the appropriate SSL certificate information.

Select Certificate file to specify the SSL certificate file to be used with the Hybrid Data Pipeline server. The specified file must be the root certificate used to sign the certificate for the load balancer server. PEM, DER, and Base64 encodings are supported. Type the full path to the certificate file, or click Choose... to browse to the location of the SSL certificate file. Then, click Next.

Select Use existing Certificate to use the SSL certificate specified in the previous installation or bypass the specification of an SSL certificate. Then, click Next.

12. Select MySQL Community Edition if you plan to use MySQL Community Edition as an external system database or as a data source. Hybrid Data Pipeline does not provide a driver for MySQL Community Edition. However, you can use the MySQL Connector/J driver to use MySQL Community Edition as an external system database or as a data source. If you select MySQL Community Edition, enter the name and location of the MySQL Connector/J jar file in the Jar Path field. Then, click Next to continue.

Note: For more information on the MySQL Connector/J driver, refer to the MySQL developer website at https://dev.mysql.com/.

13. Select the type of external database you want to use to store system information from the drop down box. Then, click Next.

14. Provide the Oracle connection information.

If you connect using the Oracle System Identifier (SID), select Connect using SID, then type the SID.

Select Connect using Service Name, then type the database service name that specifies the database that is used for the connection. The service name is a string that is the global database name. The global database name typically comprises the database name and domain name.

d. Optionally, in the Advanced Options field, specify additional connection parameters and their values to be included the connection url. Values should be entered as a semicolon-separated list of parameter=value. For example, you may enter to following options to configure SSL:

encryptionLevel=Required;encryptionTypes=(AES256);
dataIntegrityLevel=Required;dataIntegrityTypes=(SHA1);
encryptionMethod=SSL;keyStore=/common/Oracle/trustStore.jks;
keyStorePassword=secret;serverType=dedicated;authenticationMethod=ntlm;
hostNameInCertificate=oracle;editionName=hybrid

15. Provide connection information for the MySQL Community Edition external database.

d. Optionally, in the Advanced Options field, specify additional connection parameters and their values to be included the connection url. Values should be entered as an ampersand-separated list of parameter=value.

16. Provide the SQL Server connection information.

e. Optionally, in the Advanced Options field, specify additional connection parameters and their values to be included in the connection URL. Values should be entered as a semicolon-separated list of parameter=value.

17. Provide the PostgreSQL connection information.

d. Optionally, in the Advanced Options field, specify additional connection parameters and their values to be included in the connection URL. Values should be entered as a semicolon-separated list of parameter=value.

18. Provide the external database credential information.

In the Admin Username field, type the administrator user name. The administrator user must have certain privileges that are specific to the database vendor. For a list of required privileges, see External system databases.

In the Username field, type a user name. For a list of required privileges, see External system databases.

Administrator credentials are only required at install time to create the database schema. Administrator credentials are not used by the product at run time.

Passwords for an external database implementation are not persisted. These values must be specified in the response file with the D2C_DB_ADMIN_PASSWORD and D2C_DB_USER_PASSWORD options before running a silent install.

The installer attempts to validate the database. If the installer is unable to validate, you are prompted to reenter credentials or skip validation. If you skip validation, the response file must have the SKIP_DATABASE_VALIDATION property set to true. During a silent upgrade, the installer will complete the upgrade even when the database validation fails.

19. Review the Server Access Port. The Server Access Port must be opened for the load balancer. The default is 8080.

20. Take the appropriate action depending on whether you are using the On-Premises Connector.

If you are using the On-Premises Connector, review the On-Premises Access Ports. The On-Premises Access Port and the TCP Notification Server Port must be opened for the load balancer.

Important: If you changed any values for On-Premises Access Ports during an upgrade, you will need to reconfigure the load balancer to use the new ports.

Table 35. On-Premises Access Ports
Name	Default	Description
On-Premises Port	40501	Port for the On-Premises Connector
TCP Port	11280	Port for the Notification Server
Message Queue Port	8282	Port for the message queue

21. Review the Server Internal Ports. The Internal API Port and the Shutdown Port must be opened.

Important: As a matter of best practice, the Shutdown Port should not be available outside the firewall of any Hybrid Data Pipeline instance.

Table 36. Server Internal Ports
Name	Default	Description
Internal API Port	8190	Non-SSL port for the Internal API
Shutdown Port	8005	Shutdown port

22. Review the upgrade summary. If you are satisfied with your choices, press ENTER to generate the response file.

23. After the response files has been generated, press ENTER to exit the installer.

24. Confirm that a response file has been generated by navigating to the response file directory you specified in Step 3 and opening the response file.