admintools install_package

kulkeez

Hi,
Have the following packages available in our Development Vertica instance:
[dbadmin@nbodev ~]$ cd /opt/vertica/packages/
[dbadmin@nbodev packages]$ ll
total 24
drwxr-xr-x 5 root root 4096 Nov 3 2015 approximate
-rw-r--r-- 1 root root 0 Aug 28 2015 build.ts
drwxr-xr-x 5 root root 4096 Nov 3 2015 flextable
drwxr-xr-x 4 root root 4096 Nov 3 2015 geospatial
drwxr-xr-x 6 root root 4096 Nov 3 2015 hcat
drwxr-xr-x 5 root root 4096 Nov 3 2015 pload
drwxr-xr-x 5 root root 4096 Nov 3 2015 txtindex
[dbadmin@nbodev packages]$
[dbadmin@nbodev packages]$ admintools -t list_packages
Package Description
approximate Probabilistic/Approximate Aggregation Functions
txtindex Common string-manipulation functions
pload
hcat Java/HCatalog data load and query
geospatial
flextable Flexible Tables Data Load and Query
[dbadmin@nbodev packages]$

dbadmin=> select lib_name, lib_version from user_libraries;
lib_name | lib_version
--------------------------+-------------
decisionTree_mab_lib |
ApproximateLib | 1.0
TxtIndexLib |
FlexTableLib | 1.0.0
DTPredLib_fact |
DTTrainLib |

Now, upon attempting to force reinstall packages using admintools, get this error:

[dbadmin@nbodev packages]$ admintools -t install_package -d DATABASE -p PASSWORD --package all --force-reinstall
Usage: install_package [options]

install_package: error: no such option: --force-reinstall
[dbadmin@nbodev packages]$
I was referring to documentation here:
https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/InstallationGuide/InstallingVertica/UpgradingandReinstallingPackages.htm

Also tried uninstalling and reinstalling a particular package 'approximate' but get an error as below:
[dbadmin@nbodev packages]$ admintools -t uninstall_package -d DATABASE -p PASSWORD --package approximate
WARNING: Current version of package approximate is not installed, attempting to uninstall it anyways
Uninstalling package approximate
...Success!
You have new mail in /var/spool/mail/root
[dbadmin@nbodev packages]$ admintools -t install_package -d PASSWORD -p PASSWORD --package approximate
Installing package approximate...
Failed to install package approximate
[dbadmin@nbodev packages]$

This machine has an active internet connection. Am I missing something?

Jim_Knicely

Hi,

Can you verify which version of Vertica you are using? The "--force-reinstall" option was introduced in Vertica 7.2.2.

See:
https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/NewFeatures/7.2/7.2.2/usingadmintoolsForceReinstallOption.htm

As far as the "Failed to install package approximate" error, can you take a peak at the /opt/vertica/log/adminTools.log file? There should be an indication of what went wrong in there!