CustomFacts: Can we pass the credentials in custom facts in secure way?

Vinay Korrapati

unread,

Jan 22, 2021, 7:40:42 AM1/22/21

to Puppet Users

Hi Team,

Can we pass the credentials in custom facts in secure way?

Use case : I have to write a fact which , executes a Query on Oracle DB's and returns the output.

To execute the query it requires the credentials ($oralogin).

Eg:

$OracleUserName="username"

$OraclePassword="password"

$OraLogin = "$OracleUserName/$OraclePassword@" + $oraInstance + " as sysdba"

$Query | sqlplus -silent $OraLogin

Any thoughts/suggestions to pass the credentials in secure way ?

Regards

Vinay

Vinay Korrapati

unread,

Jan 22, 2021, 8:02:18 AM1/22/21

to Puppet Users

puppet enterprise : 2019.8.1

Oracle: 12c

Dan White

unread,

Jan 22, 2021, 12:23:23 PM1/22/21

to Puppet Users Mailing List

Have you considered “orapwd” ?

https://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN12478

_______________________________________________________

Dan White : d_e_...@icloud.com

“Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us.”
Bill Waterson (Calvin & Hobbes)

--
You received this message because you are subscribed to the Google Groups "Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/149bea7f-2cf8-4e38-8fd6-225b34e90912n%40googlegroups.com.

bert hajee

unread,

Jan 23, 2021, 11:17:32 AM1/23/21

to Puppet Users

Did you know that, amongst others, you can easily make custom facts from any data in your oracle database with the ora_config puppet module?