Accessing Oracle via encrypted password

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Accessing Oracle via encrypted password
# 1  
Old 05-20-2009
Accessing Oracle via encrypted password

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.
# 2  
Old 05-25-2009
Provide more info, please: The Database systems, the shell script you are working with, any connecting libraries involved.
# 3  
Old 05-27-2009
Accessing Encrypted content of the xml file

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.
# 4  
Old 05-27-2009
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?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to list users without MD5 encrypted password?

Hi, As a security measure, we need to force all the users to use MD5 encryped passwords. For that we need to list users whose encrypted password is not MD5. I understand all MD5 encrypted passwords start with $1$ and a sample entry in /etc/shadow would be ... (4 Replies)
Discussion started by: magnus29
4 Replies

2. Cybersecurity

Is TLS encrypted password safe?

Hello, on my android device my app autosaves my password and it encrypts by TLS im not politically exposed person, just regular entrepreneur. Should i worry if i loose my phone with TLS encrypted password? Or regular mortals or casual hackers are not able to crack it? (4 Replies)
Discussion started by: postcd
4 Replies

3. Shell Programming and Scripting

Encrypted password in script

How to keep encrypted password in a shell script.? I have the file which has the following: a.sh ----- username=abc password=abc I will be using this username and password in another script. But I don't want to reveal the password in the script. How to keep the password... (3 Replies)
Discussion started by: sanvel
3 Replies

4. Shell Programming and Scripting

Password Expiry while accessing Oracle table

Hi All, I am not able to access an oracle table even if the table is present. After initial analysis, found that there is a password warning for the specified oracle user. Can you please help me in ignoring the password expiry and access the oracle table ? However, the log file does not store the... (4 Replies)
Discussion started by: tapan8984
4 Replies

5. UNIX for Dummies Questions & Answers

Using the encrypted password of the shadow file

i have an application that uses the encrypted password that's in the /etc/shadow file. i copied the line for the particular username i was interested it in from shadow file and i pasted it into the password file of the application. the application is nagios. this application allowed that... (5 Replies)
Discussion started by: SkySmart
5 Replies

6. UNIX for Advanced & Expert Users

/etc/shadow encrypted password

Hi I wonder whether is possible to generate enrypted passwd for some user and paste it into /etc/shadow file ? What kind of encryption is used in /etc/shadow file ? ths for help. (1 Reply)
Discussion started by: presul
1 Replies

7. Shell Programming and Scripting

To decrypt encrypted password

Hi folks, What will be the easy way to decrypt encrypted passwords on MySQL table. Googling brought me many suggestions on crypt/decrypt running scripts. Please advise. TIA Remark: I think the encrypt function of MySQL uses the Unix crypt command to encrypt B.R. satimis (1 Reply)
Discussion started by: satimis
1 Replies

8. Linux

Interpreting the encrypted shadow password?

We are currently using a script to copy the same encrypted password between our HP-UX and Solaris servers editing the trusted and shadow files directly. The encrypted password is only 13 characters long on both servers and decrypts the same way. Is there a way to copy this same string to Linux... (5 Replies)
Discussion started by: keelba
5 Replies

9. UNIX for Dummies Questions & Answers

Change password by pushing encrypted password to systems

I'm tasked to change a user's password on multiple Linux systems (RH v3). I though copying the encrypted password from one Linux /etc/shadow file to another would work but I was wrong. The long term solution is to establish an openLDAP Directory service, but for now I'm stuck with a manual... (1 Reply)
Discussion started by: benq70
1 Replies

10. UNIX for Advanced & Expert Users

netrc file encrypted password

Hi, I do not want the plaintext password to appear in the netrc file. So I want to encrypt the password. Is there a way to encrypt the password and still make ftp to use the netrc ? Thanks in advance. -Gow:confused: (2 Replies)
Discussion started by: ggowrish
2 Replies
Login or Register to Ask a Question