Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Extend OBR sqlexecutor to return to StdOut

Extend OBR sqlexecutor to return to StdOut

Brief Description
OBR's sqlexecutor command is a nice feature to run sql-scripts against the OBR Vertica PMDB, without having to enter a password.
Unfortunately it does not return the output to StdOut (anymore). So it can not be used for "select" SLQ statements - just create/update/delete SQL.
The request is to bring back the output to screen/StdOut for sqlexecutor.

Benefits / Value
- Often scripts to query and manage OBR data are needed on command-line
- scripts need a secure and passwordless access to Vertica PMDB
- vsql is not a option as the password is visible / needs to be specified
- This used to work in earlier versions of OBR/SHR

Design Details
- Show the output of sql statements (as in previous OBR/SHR versions or as mgmtsqlexecutor does)
- Alternatively, provide other ways to run passwordless SQL code on Vertica PMDB from the OBR server.

2 Comments
Trusted Contributor.. jjhopkins Trusted Contributor..
Trusted Contributor..

Is sqlexecutor's password coming from $PMDB_HOME/data/config.prp?

Is creating and using additional vertica database users with the minimum required permissions for the select queries a better option than using the dbadmin account via sqlexecutor?

Micro Focus Contributor
Micro Focus Contributor
Status changed to: Waiting for Votes
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.