Re: [Puppet Users] CustomFacts: Can we pass the credentials in custom facts in secure way?

[bert hajee]

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? 

https://forge.puppet.com/modules/enterprisemodules/ora_config

The module will take care of securely handling passwords for you.

On Friday, 22 January 2021 at 13:23:23 UTC+1 LinuxDan wrote:

> 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)
>
> On Jan 22, 2021, at 3:02 AM, Vinay Korrapati  wrote:
>
>
> puppet enterprise : 2019.8.1
> Oracle: 12c
>
> On Friday, January 22, 2021 at 1:10:42 PM UTC+5:30 Vinay Korrapati wrote:
>
>> 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
>>
>
> -- 
> 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
>  
> 
> .
>
>
>

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/puppet-users/aca962dd-cee5-4df2-b118-c1c8fd1c80aen%40googlegroups.com.

Re: [Puppet Users] CustomFacts: Can we pass the credentials in custom facts in secure way?

['Dan White' via Puppet Users]

Have you considered “orapwd” ?
https://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN12478
___
Dan White : d_e_wh...@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)

> On Jan 22, 2021, at 3:02 AM, Vinay Korrapati  wrote:
> 
> 
> puppet enterprise : 2019.8.1
> Oracle: 12c
> 
> On Friday, January 22, 2021 at 1:10:42 PM UTC+5:30 Vinay Korrapati wrote:
> 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
> 
> -- 
> 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+unsubscr...@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
>  
> .

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/puppet-users/878F026D-4F0B-4970-8AC1-CDB9086462CF%40icloud.com.

[Puppet Users] CustomFacts: Can we pass the credentials in custom facts in secure way?

[Vinay Korrapati]

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

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/puppet-users/675201a1-0f9f-4d3c-a0c6-35f8f879d341n%40googlegroups.com.