How to keep password out of the log?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
bicap
Premium Member
Premium Member
Posts: 95
Joined: Mon May 03, 2010 10:22 pm
Location: India
Contact:

How to keep password out of the log?

Post by bicap »

If a unix script is called from an execute command activity, is there any way to not display the password in the director log?

My script is
sh /data/basel2dev/integration/scripts/displaysysdate.sh #Integration.$PrmDBIntgUser# "File Validation Script" "E004" "Unmatched file count with trailer record" "testfile" #Integration.$PrmDBIntgPwd# #Integration.$PrmDBIntgSchema#

the value of #Integration.$PrmDBIntgPwd# should not be displayed as clear text in the director log
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Note: split from this topic.
Last edited by chulett on Mon Jan 09, 2012 7:44 am, edited 1 time in total.
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You'd have to write your own routine, as noted in the linked post, that did not log that information. Note, however, that since you are passing the password to the script on the command line, it will still be visible to anything looking at the running process.
-craig

"You can never have too many knives" -- Logan Nine Fingers
eph
Premium Member
Premium Member
Posts: 110
Joined: Mon Oct 18, 2010 10:25 am

Post by eph »

Hi,

Is the content of the command line (except passwords) mandatory in the log?

If not, you can use the /NOLOG/ option in the EC activity.

Regards,
Eric
bicap
Premium Member
Premium Member
Posts: 95
Joined: Mon May 03, 2010 10:22 pm
Location: India
Contact:

Post by bicap »

Thanks Eric, this is helpful for my requirement
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Ah yes, did this actually get documented anywhere? It goes at the beginning of the Parameter property according to the 3 posts here that mention that little secret. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
eph
Premium Member
Premium Member
Posts: 110
Joined: Mon Oct 18, 2010 10:25 am

Post by eph »

The first time I saw it was on dsxchange :)

Then I found it in a pdf, but I can't recall its name (one about job sequence).

You can find more info on IBM' website

Regards,
Eric
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Interesting feature. New to me!

The PDF is noted at the bottom of the web page on the link you provided:

IBM InfoSphere DataStage and QualityStage Designer Client Guide
Choose a job you love, and you will never have to work a day in your life. - Confucius
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

Good learning!! :D
pandeeswaran
Post Reply