Encrypted password in databaseConnection.xml

Posted by Paul Radbone on 21-Sep-2015 03:44

Hi,

I am writing an ANT script to automatically insert user passwords into a large databaseConnection.xml file.  Could someone point me in the right direction of what method to use to encrypt the password after the user has input the password into the ANT dialogue screen?

Openedge 11.5 Developer Studio

Regards,

Paul Radbone.

Posted by Paul Radbone on 21-Sep-2015 10:04

I found the answer.  If I store the password as plain text or use 'oech1::' + AUDIT-POLICY:ENCRYPT-AUDIT-MAC-KEY("password"), it works and then dev studio encrypts the password further if the connection is re-saved in the database dialog.

Cheers,

Paul.

All Replies

Posted by Matt Baker on 21-Sep-2015 09:54

The database connection passwords in that file are protected by an internal password + salted and encrypted and base64 encoded.

Posted by Paul Radbone on 21-Sep-2015 10:04

I found the answer.  If I store the password as plain text or use 'oech1::' + AUDIT-POLICY:ENCRYPT-AUDIT-MAC-KEY("password"), it works and then dev studio encrypts the password further if the connection is re-saved in the database dialog.

Cheers,

Paul.

This thread is closed