pedro.fmoreira asked a question.
How to encrypt the Oracle database user password to put in the agent configuration file?
I need to generate a configuration file with the password for accessing the Oracle database encrypted. I saw the article in the link: https://community.flexera.com/s/article/How-ToGenerateEncryptedOraclePassword-v2
who explained the step by step very well, but the encrypted password that is being generated has 460 characters, it doesn't seem correct to me.
I am identifying the error message in the log: java.security.NoSuchAlgorithmException: Can't decrypt this kind of password.
Has anyone experienced this and can tell if in version 6.9.0 of inventory there is any problem generating the configuration file with the encrypted password?
Hi @Pedro Moreira​ I recommend you to check the issue with Snow Support. Regards Siggi
Hi @Pedro Moreira​ facing the same issue. What was the solution for you in the end? Thanks a lot!
This topic is fascinating! I’ve struggled with securely storing database credentials before. Can anyone share specific tools or methods they've found effective for encrypting passwords in the configuration file? Also, how do you manage access control around this process to ensure it remains secure? @geometry dash lite
Hi @mariophillips​ due to the age of the original thread I am looping in @liamLittlemore​ and @SamuelBaughan​ in case they have any insights to share
I just tried from the Inventory v.26 console and it worked fine:
you can import and export snowagent.config files in the Configurations view | Snow Inventory Server Documentation
Once you have done that, you can edit these configurations in the "Snow Inventory Server Admin Console". There is a section "Oracle" and you can type in the password there. "Save" will write the encrypted password into the config file, when ypu export it again. The encrypted string can also be copied to another config.
Yeah, this is what I did (as described in the KB that @pedro.fmoreira referenced, nice research mate! 💯), and it worked, as I wrote above.
Kudos BTW for the nice explanation and the well-phrased question! It's always nice to see that the user asking the question actually went to some good research himself before asking the community, we all benefit 😉