Upgrading Presto Admin - Presto on Teradata Appliance for Hadoop

Presto on Teradata Appliance for Hadoop 6 Installation, Configuration, and Upgrade Guide

Product
Presto on Teradata Appliance for Hadoop
Release Number
157t
Published
February 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
jpl1484678832656.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
jpl1484678832656
Product Category
Open Source
Presto 157t uses the Presto Admin version 2.1 configuration files located in /home/prestoadmin/.prestoadmin. When upgrading to Presto 157t, you must preserve the 152t configuration files located at /etc/opt/prestoadmin.
  1. Stop Presto. (See Stopping Presto).
  2. Delete the /opt/prestoadmin directory. rm -rf /opt/prestoadmin
  3. If upgrading from 152t, do the following to preserve the 152t configuration files.
    1. Rename the connector configuration directory. mv /etc/opt/prestoadmin/connectors /etc/opt/prestoadmin/catalog
    2. Copy the files to the new configuration directory. mkdir /home/prestoadmin/.prestoadmin mv /etc/opt/prestoadmin/* /home/prestoadmin/.prestoadmin/
  4. Change the owner and file permissions only for the root user and the prestoadmin group.
    1. chmod 660 /home/prestoadmin/.prestoadmin/config.json
    2. chgrp prestoadmin /home/prestoadmin/.prestoadmin/config.json
  5. Change the permissions on the /home/prestoadmin/.prestoadmin subdirectories. chmod 660 `find /home/prestoadmin/.prestoadmin -type f`
  6. Log in to the prestoadmin node as prestoadmin.
  7. Install Presto Admin.
    1. cd /opt/prestoadmin
    2. ./install-prestoadmin.sh Something similar to the following displays.
      virtualenv-12.0.7
      /virtualenv-12.0.7/AUTHORS.txt
      virtualenv-12.0.7/bin/
      virtualenv-12.0.7/bin/rebuild-script.py
      virtualenv-12.0.7/docs/
      ...
      Successfully installed argparse-1.4.0 ecdsa-0.13 fabric-1.10.1 flake8-2.5.4 mccabe-0.4.0 
      overrides-0.5 paramiko-1.15.3 pep8-1.7.0 pip-7.1.2 prestoadmin-1.3 py-1.4.31 pycrypto-2.6.1 
      pyflakes-1.0.0 requests-2.7.0 retrying-1.3.3 setuptools-20.1.1 six-1.10.0 tox-1.9.2 virtualenv-15.0.1 wheel-0.23.0
  8. Prevent other users from executing the presto-admin command.
    1. sudo chown -R prestoadmin:prestoadmin /opt/prestoadmin/
    2. chmod 750 /opt/prestoadmin/presto-admin
  9. Allow only root and users belonging to the prestoadmin group access to the /home/prestoadmin/.prestoadmin/ directory and its subdirectories. chmod -R 770 /home/prestoadmin/.prestoadmin/
  10. Set up the prestoadmin log directory in the /var/opt/teradata file system. The presto-admin.log file is created in the /home/prestoadmin/.prestoadmin/log directory.
    1. chmod 750 /home/prestoadmin/.prestoadmin/log
    2. sudo mkdir -p /var/opt/teradata/log/prestoadmin
    3. sudo mv /home/prestoadmin/.prestoadmin/log /var/opt/teradata/log/prestoadmin
    4. sudo ln -s /var/opt/teradata/log/prestoadmin/log /home/prestoadmin/.prestoadmin/log
    5. sudo chown -R prestoadmin:prestoadmin /var/opt/teradata/log/prestoadmin/
    6. sudo chown -R prestoadmin:prestoadmin /home/prestoadmin/.prestoadmin
  11. [Optional] View the newly created /home/prestoadmin/.prestoadmin directory and its subdirectories.
    1. ls -1d /home/prestoadmin/.prestoadmin
    2. ls -1R /home/prestoadmin/.prestoadmin
    3. ls -lR /home/prestoadmin/.prestoadmin/log
    4. ls -l /home/prestoadmin/.prestoadmin/log | grep prestoadmin
    5. ls -l /var/opt/teradata/log/prestoadmin | grep prestoadmin
    6. ls -lRH /home/prestoadmin/.prestoadmin/log
  12. Change the permissions on the /home/prestoadmin/.prestoadmin subdirectories. chmod 660 `find /home/prestoadmin/.prestoadmin -type f`
  13. [Optional] View the new permissions for the /home/prestoadmin/.prestoadmin subdirectories. ls -lR /home/prestoadmin/.prestoadmin
    /home/prestoadmin/.prestoadmin:
    total 16
    -rw-rw---- 1 prestoadmin prestoadmin 233 Aug 30 08:14 config.json
    drwxr-xr-x 2 prestoadmin prestoadmin 4096 Aug 30 08:18 connectors
    drwxr-xr-x 2 prestoadmin prestoadmin 4096 Aug 30 08:18 coordinator
    drwxr-xr-x 2 prestoadmin prestoadmin 4096 Aug 30 08:18 workers
    
    /home/prestoadmin/.prestoadmin/catalog:
    total 4
    -rw-rw---- 1 prestoadmin prestoadmin 19 Aug 30 08:18 tpch.properties
    
    /home/prestoadmin/.prestoadmin/coordinator:
    total 12
    -rw-rw---- 1 prestoadmin prestoadmin 210 Aug 30 08:18 config.properties
    -rw-rw---- 1 prestoadmin prestoadmin 228 Aug 30 08:18 jvm.config
    -rw-rw---- 1 prestoadmin prestoadmin 235 Aug 30 08:18 node.properties
    
    /home/prestoadmin/.prestoadmin/workers:
    total 12
    -rw-rw---- 1 prestoadmin prestoadmin 140 Aug 30 08:18 config.properties
    -rw-rw---- 1 prestoadmin prestoadmin 228 Aug 30 08:18 jvm.config
    -rw-rw---- 1 prestoadmin prestoadmin 235 Aug 30 08:18 node.properties 
    
  14. Verify that Presto Admin is installed. /opt/prestoadmin/presto-admin --help
    Usage: presto-admin [options] <command> [arg]
    
    Options: 
       --version             show program's version number and exit  
       -h, --help            show this help message and exit  
    ...
    Commands:    
       collect logs
       collect query_info
       collect system_info
    ...
       server uninstall
       server upgrade
       topology show
  15. Verify the Presto Admin version. sudo /opt/prestoadmin/presto-admin --version