All Forums Tools
indra91 16 posts Joined 06/16
14 Jul 2016
Encryted Password File for FastExport

I wanted to know if there is a way to store the .logon  username/Password in a separate File and include it while calling the Fastexport script.Also is there any option to encrypt the password file which can be read only by the Fastexport script?I tried to set the DataEncryption option to ON but could not find  any difference in the log.?

feinholz 1234 posts Joined 05/08
14 Jul 2016

Check out the .RUN FILE command in the documentation.
You cannot encrypt the contents, but you can restrict its usage through access rights settings.
DataEncryption is for the data going across the wire from FastExport to Teradata.
 

--SteveF

M.Saeed Khurram 544 posts Joined 09/12
15 Jul 2016

You can use teradata Wallet if it is available. It stores encrypted password, and you will not write the password directly in script.
Khurram

Khurram

indra91 16 posts Joined 06/16
15 Jul 2016

But if I use Teradata Wallet will it be possible to call it from the FastExport Script?I mean in Fast Export we provide in username and password in the .LOGON command as .LOGON IP/USERNM,PASSWORD. Where would the encrypted password  file fit in such a script?

M.Saeed Khurram 544 posts Joined 09/12
15 Jul 2016

Here is an example you can follow:
https://forums.teradata.com/forum/tools/teradata-wallet-0
 
Khurram

Khurram

randy.dycus2 3 posts Joined 05/14
18 Jul 2016

We have found that we have to reenter Wallet entries after a reboot (AIX environment).  Is this normal?  
Thanks in advance,
Randy

M.Saeed Khurram 544 posts Joined 09/12
18 Jul 2016

What do you mean by reenter? 
If you have tdwallet installed, simply run the tdwallet, add entries and use them in script as given in the example.
 

Khurram

randy.dycus2 3 posts Joined 05/14
18 Jul 2016

I mean that after a reboot of the AIX server, calls to the Wallet that worked before are no longer working.
 
 *** CLI error: CLI2: TDWALLETERROR(543): Teradata Wallet error. The wallet does not contain an item named "sysdba_dev".
 *** Return code from CLI is: 543
 *** Error: Logon failed!

M.Saeed Khurram 544 posts Joined 09/12
18 Jul 2016

Have you made any update to AIX ?

Khurram

awenny 4 posts Joined 09/10
18 Jul 2016

On Unix systems, there are two different modes of storing passwords.
One is with a passphrase, you have to unlock always manually after you restart the server.
The other one is without the requirement of always unlocking your wallet (it's called "saved-key").
Which way is used to store your entries is determined by the command you use to add an item. You have very likely used the command "add" to add your entries. But if you use the command "addsk", you will not have to reenter your wallets passphrase every time again after a restart to be able to use it.
This "addsk" is not available on Windows or Mac.

awenny 4 posts Joined 09/10
18 Jul 2016

After running a test, the error message shown with items added via "add" after a reboot is:

 *** CLI error: CLI2: TDWALLETERROR(543): Teradata Wallet error. The wallet password has not been supplied.
 *** Return code from CLI is: 543
 *** Error: Logon failed!

It appears, randy.dycus2, your issue is maybe different. But I don't have an AIX so I've tested on SLES11. The return code is same as yours, but message is different.

randy.dycus2 3 posts Joined 05/14
19 Jul 2016

Andreas,
Thank you very much.  I have not had a chance to test yet (reboot the server), but I fully expect this to be the answer I was looking for.  
Thanks again for taking to time to help someone out.
Have a great day!
Randy

You must sign in to leave a comment.