Actually in my application there is an XML file. The password and the user name for the database that I need to access the development box is stored there.
But using some UNIX command I am able to access the raw content of the file and not the decrypted code for that password. When I am applying this content to access the database it is showing me the error.

content of the XML file
----------------------
<ODBC DB=somename>
<usr>MyName</usr>
<password encrypted=yes>xxxxxxxx</password>
</ODBC>

I want to go to the section that contains the database name and connect to that database using the user id and password mentioned there.

But as the password I find is in encrypted form and thus my shell script only generate me that encrypted raw string for the password and my connection fails.

Can anyone suggest me the way to read that encrypted password and use it in establishing the connection to the database?

Thanks and Regards
Nandu Mishra.

Provide more info, please: The Database systems, the shell script you are working with, any connecting libraries involved.

The data in the .xml file is being encrypted using the "blowfish" encryption of the "OpenSSL".

I want to access it in the UNIX shell script as :-

sqlplus -s <user_id>/<decrypted_password_from_.xml_file>@<some_script> << <MARKER>
do the things here
do the things here
do the things here
do the things here
<MARKER>

I do not know how to use it to get the decrypted password.

That's fine. What database are you working with? Ok, sqlplus would indicate Oracle. Moving to Oracle forum. If i'm wrong, please reply here.

-----Post Update-----

What does "Blowfish" encryption and OpenSSL have anything to do with sqlplus or ODBC?

-----Post Update-----

What does "Blowfish" encryption and OpenSSL have anything to do with sqlplus or ODBC?