You can translate the question and the replies:

Run the Import.sh script without implicitly stating the Username and Password

I am calling the "import.sh" script inside a Linux (bash) shell script. In normal circumstances we supply the username and password as part of the parameters (the USERNAME and PASSWD values) import.sh -su -f $VQL_FILE_HOME/$FN_NAME.vql -pf $CONFIG_FILE_NAME -h $SERVER:$PORTNUMBER/$VDBNAME?$USERNAME@$PASSWD However, can we call the "import.sh" script without having to explicitly supply the Username and Password and have those values implitily passed to the import.sh script? (as shown below) import.sh -su -f $VQL_FILE_HOME/$FN_NAME.vql -pf $CONFIG_FILE_NAME -h $SERVER:$PORTNUMBER/$VDBNAME
user
21-03-2017 00:02:34 -0400
code

1 Answer

Hello, I want to inform you that as per the syntax of 'import.sh' script, it is mandatory to mention the USERNAME and PASSWORD in the server URI. Without this you will not able to run the import.sh script as it will try to login into your VDP server to import the VQL file. On the other hand you can use 'encrypt_password.sh' script to pass the encrypted password in the server URI. For example, If you run the below command, you will get the encrypted password generated: ``` ./encrypt_password.sh <your password> ``` You can use this encrypted password in the server URI as: ``` import.sh -su -f $VQL_FILE_HOME/$FN_NAME.vql -pf $CONFIG_FILE_NAME -h $SERVER:$PORTNUMBER/$VDBNAME?USERNAME@ENCRYPTED:<ENCRYTPED_PASSWORD> ``` You can refer to sections "Import Scripts" and "Importing the Metadata from a Single VQL File" of the VDP Administration Guide to know more about how to work with import and encrypt password scripts. Hope this helps!!
Denodo Team
22-03-2017 08:03:28 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here