VMware Cloud Community
DavoudTeimouri
Virtuoso
Virtuoso

Encrypt Database Password

Hi,

Is there any way to encrypt database password on vcdb.properties?

BR

-------------------------------------------------------------------------------------
Davoud Teimouri - https://www.teimouri.net - Twitter: @davoud_teimouri Facebook: https://www.facebook.com/teimouri.net/
Reply
0 Kudos
3 Replies
NathanosBlightc
Commander
Commander

Hi,

Please have a look at the following links. I didn't really test this matter on VCSA vPostgres database personally, but maybe they give you a useful hint to achieve this:

Storing Passwords Securely With PostgreSQL and Pgcrypto

https://stackoverflow.com/questions/18656528/how-do-i-encrypt-passwords-with-postgresql

Please mark my comment as the Correct Answer if this solution resolved your problem
Reply
0 Kudos
Nawals
Expert
Expert

Provide an encrypted password in vcdb.properties and use password.encrypted = true.

  1. Copy the password entry in HKEY_LOCAL_MACHINE\software\VMware Inc\VMware Virtual Center\DB\3.
  2. Open vcdb.properties using a text editor.
  3. Add the line password.encrypted = true.
  4. Paste the password copied in Step 1 to the line starting with password=.
    For example, vcdb.properties should appear similar to:
    url = jdbc:sqlserver://<name of the SQL Server>\\<instance name>:<sql server port>;databaseName=vCenter; integratedSecurity = falsedriver = com.microsoft.sqlserver.jdbc.SQLServerDriverdbtype = mssqlusername = xxxxpassword=*OqKveFNzKbK7w9maM/Si1f4k6frYWxi5pFwqYNvHGkO/xztAF4fdkguM4hLgG9qiuXca3UgHMotDlKPpkEPeX/Kh1fJo+CtojXjM+
    wh7AzW/YXPfB/Y0kx+hsc4+ujGyFKUBwWmbHIWy27GX9Iq0DqEzenG5oWjMA9SuKHJZFZk+RDe6y9jkZGZ37xMQeEtPoacFfTXgxXtL9Du3x3cA
    +ZE0w+UHB+J34R+hnEBqkr1l3Hct3ZJzZC/7dAwUEjH9YPQvOOc5Qp364ju6lnWv3jmUxfoTEewdGV+KytgG4dKAtBbysdCaILZUTd8t08xox5i
    6Sfixl9Gj+HDTaoDfPQ==password.encrypted = true
  5. Restart the VMware VirtualCenter Webservices Service.
NKS Please Mark Helpful/correct if my answer resolve your query.
Reply
0 Kudos
DavoudTeimouri
Virtuoso
Virtuoso

Thank you all for your answer, but VMware mentioned that the password will be stored as plain text. I knew that but I'm looking for even unofficial solution.

-------------------------------------------------------------------------------------
Davoud Teimouri - https://www.teimouri.net - Twitter: @davoud_teimouri Facebook: https://www.facebook.com/teimouri.net/
Reply
0 Kudos