sqldeveloperpassworddecryptor icon indicating copy to clipboard operation
sqldeveloperpassworddecryptor copied to clipboard

Support v23.1 password encryption

Open ueffel opened this issue 2 years ago • 10 comments

It seems that oracle yet again changed the encryption algorithm for stored password. This pull request adds support for this.

ueffel avatar May 03 '23 19:05 ueffel

Thank you, I will look at it !

maaaaz avatar May 03 '23 19:05 maaaaz

👀

ueffel avatar Jun 06 '23 17:06 ueffel

@maaaaz Hi Thomas, can we please merge this PR?

cheTesta avatar Oct 19 '23 09:10 cheTesta

Soon !

maaaaz avatar Oct 20 '23 18:10 maaaaz

Hi ueffel, would be nice to have an encryption version. This would be useful to create a JSON connection file. I currently use the oracle java jars and classes for this with V23. But a python version with Cryptodomex should be faster. What do you think about it?

mike5x3 avatar Nov 20 '23 20:11 mike5x3

@mike5x3 Do you frequently generate connections files for SQLDev? I don't, not really seeing the use case here 😅 Maybe a python version would be a faster than a java version if it's using some C libraries under the hood, but probably not by much, and I don't think is performance critical here. But again: I don't see the use case. If you got some working java version, I would stick to it.

ueffel avatar Nov 20 '23 21:11 ueffel

@mike5x3 Do you frequently generate connections files for SQLDev? I don't, not really seeing the use case here 😅 Maybe a python version would be a faster than a java version if it's using some C libraries under the hood, but probably not by much, and I don't think is performance critical here. But again: I don't see the use case. If you got some working java version, I would stick to it.

My use case: I'm working in a team for a customer who frequently changes hostnames, passwords, etc for a lot of connections. Currently the JSON connection file is distributed "on-the-fly" via an internal web page request. That's it why performance matters ;-) But of course there might be other ways to distribute it. What's the use case of the python version for decryption instead of using the java version?

mike5x3 avatar Nov 20 '23 21:11 mike5x3

What's the use case of the python version for decryption instead of using the java version?

Python is easier to write, especially for small scripts like this project :)

But we're drifting off course. This PR is about getting V23 merged ;)

ueffel avatar Nov 20 '23 22:11 ueffel

Soon !

👀 How about it? 😃

Ubunfu avatar Jan 19 '24 16:01 Ubunfu

Thank you for this patch. It saved me today and I couldn't find anything else for v23.

roberto-mansfield avatar Jul 22 '24 19:07 roberto-mansfield