{ "info": { "author": "Thomas D.", "author_email": "tdebize@mail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Information Technology", "License :: OSI Approved :: GNU Library or Lesser General Public License (LGPL)", "Programming Language :: Python :: 2 :: Only", "Topic :: Security" ], "description": "SQL Developer password decryptor\n================================\n\nDescription\n-----------\nA simple script to decrypt stored passwords from the Oracle SQL Developer IDE.\n\nFeatures\n--------\n* Support old v3 and current v4 passwords\n* Comes in 2 flavors: a Jython and a Python script\n\nPrerequisites\n-----\n#### Version 3\nPasswords are stored encrypted in the `connections.xml` file in those locations:\n* Windows: `C:\\Users\\\\AppData\\Roaming\\SQL Developer\\system\\o.jdeveloper.db.connection.\\connections.xml`\n* Linux: `~/.sqldeveloper/system/o.jdeveloper.db.connection./connections.xml`\n\n#### Version 4\nPasswords are stored encrypted in the aforementioned `connections.xml` file but the encryption key by default uses a machine-unique value `db.system.id` in the `product-preferences.xml` file accessible here:\n* Windows: `C:\\Users\\\\AppData\\Roaming\\SQL Developer\\system\\o.sqldeveloper.\\product-preferences.xml`\n* Linux: `~/.sqldeveloper/system/o.sqldeveloper./product-preferences.xml` \n \nWhen exporting one or more connections in **version 4**, the user is asked to type a password: **that password is then used as a key to encrypt the entries instead of the `db.system.id` value.**\n\nOptions\n-------\n```\n$ python sqldeveloperpassworddecryptor.py -h\nUsage: sqldeveloperpassworddecryptor.py [options]\nVersion: 1.1\n\nOptions:\n -h, --help show this help message and exit\n\n v3 and v4 parameters:\n -p ENCRYPTED_PASSWORD, --encrypted-password=ENCRYPTED_PASSWORD\n (mandatory): password that you want to decrypt. Ex. -p\n 054D4844D8549C0DB78EE1A98FE4E085B8A484D20A81F7DCF8\n\n v4 specific parameters:\n -d DB_SYSTEM_ID_VALUE, --db-system-id-value=DB_SYSTEM_ID_VALUE\n (mandatory for v4): machine-unique value of\n \"db.system.id\" attribute in the \"product-\n preferences.xml\" file, or the export file encryption\n key. Ex: -d 6b2f64b2-e83e-49a5-9abf-cb2cd7e3a9ee\n```\n\nExamples\n--------\n#### v3 password\n```\n$ jython sqldeveloperpassworddecryptor.jy -p 054D4844D8549C0DB78EE1A98FE4E085B8A484D20A81F7DCF8\n[+] encrypted password: 054D4844D8549C0DB78EE1A98FE4E085B8A484D20A81F7DCF8\n\n[+] decrypted password: password\n```\n\n#### v4 password\n```\n$ python sqldeveloperpassworddecryptor.py -d 6b2f64b2-e83e-49a5-9abf-cb2cd7e3a9ee -p Shz0tQgqkuAfLy65s21gTVD7wacDYwG6\n[+] encrypted password: Shz0tQgqkuAfLy65s21gTVD7wacDYwG6\n[+] db.system.id value: 6b2f64b2-e83e-49a5-9abf-cb2cd7e3a9ee\n\n[+] decrypted password: s4gswagswaag!5465636MP\n```\n\nDependencies and installation\n-----------------------------\n* For the `Jython` version: well, only Jython (`apt-get install jython` or download it [here](http://www.jython.org/downloads.html))\n* For the `Python` version:\n * The **easiest way** to setup everything: `pip install sqldeveloperpassworddecryptor` and then directly use `$ sqldeveloperpassworddecryptor`\n * Or manually install PyCryptodome: `pip install pycryptodomex`\n\nChangelog\n---------\n* version 1.2 - 07/14/2017: replacing PyCrypto by PyCryptodomex for [these reasons](https://blog.sqreen.io/stop-using-pycrypto-use-pycryptodome/)\n* version 1.1 - 05/30/2017: shebang addition\n* version 1.0 - 07/23/2014: Initial commit\n\nCopyright and license\n---------------------\nsqldeveloperpassworddecryptor is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.\n\nsqldeveloperpassworddecryptor is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. \n\nSee the GNU Lesser General Public License for more details.\n\nYou should have received a copy of the GNU Lesser General Public License along with sqldeveloperpassworddecryptor. \nIf not, see http://www.gnu.org/licenses/.\n\nGreetings\n---------\n* ajokela for its [Java snippet for v3](https://gist.github.com/ajokela/1846191)\n* AlessandroZ for its [Python snippet for v4](https://raw.githubusercontent.com/AlessandroZ/LaZagne/master/Linux/src/softwares/databases/sqldeveloper.py)\n\nContact\n-------\n* Thomas Debize < tdebize at mail d0t com >", "description_content_type": "text/markdown; charset=UTF-8;", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/maaaaz/sqldeveloperpassworddecryptor", "keywords": "oracle sqldeveloper password decryptor", "license": "LGPL", "maintainer": "", "maintainer_email": "", "name": "sqldeveloperpassworddecryptor", "package_url": "https://pypi.org/project/sqldeveloperpassworddecryptor/", "platform": "", "project_url": "https://pypi.org/project/sqldeveloperpassworddecryptor/", "project_urls": { "Homepage": "https://github.com/maaaaz/sqldeveloperpassworddecryptor" }, "release_url": "https://pypi.org/project/sqldeveloperpassworddecryptor/1.22/", "requires_dist": null, "requires_python": "<3", "summary": "A simple script to decrypt stored passwords from the Oracle SQL Developer IDE", "version": "1.22" }, "last_serial": 4166278, "releases": { "1.2": [ { "comment_text": "", "digests": { "md5": "55109bf54f346074a678253d184fb369", "sha256": "40ca282b41f06186d4267aee6315c340d9d56612fafc5602d705a9c1e4f75c55" }, "downloads": -1, "filename": "sqldeveloperpassworddecryptor-1.2.tar.gz", "has_sig": false, "md5_digest": "55109bf54f346074a678253d184fb369", "packagetype": "sdist", "python_version": "source", "requires_python": "<3", "size": 4606, "upload_time": "2017-07-14T12:13:59", "url": "https://files.pythonhosted.org/packages/93/4b/3f997741d26ad13ac8e6fe4f99b615d18d824a52bc01f0383d2fcec4d72a/sqldeveloperpassworddecryptor-1.2.tar.gz" } ], "1.21": [ { "comment_text": "", "digests": { "md5": "ce7f0b568c666158558087ef487cbfcd", "sha256": "4c310ea798361888b87f41810b7eb30c9bced9d9a220610b440c195941df382b" }, "downloads": -1, "filename": "sqldeveloperpassworddecryptor-1.21.tar.gz", "has_sig": false, "md5_digest": "ce7f0b568c666158558087ef487cbfcd", "packagetype": "sdist", "python_version": "source", "requires_python": "<3", "size": 4862, "upload_time": "2017-07-14T12:18:40", "url": "https://files.pythonhosted.org/packages/04/75/c1c4af505c10f9e8ee7c5705ecffb682723036f751b862c003e067a647e7/sqldeveloperpassworddecryptor-1.21.tar.gz" } ], "1.22": [ { "comment_text": "", "digests": { "md5": "82afe034ea3c768f70d34294813373dc", "sha256": "b2461cb6d99905258f583fddac1af9d7e011b8cd88bdaa67a3c18005f748e863" }, "downloads": -1, "filename": "sqldeveloperpassworddecryptor-1.22.tar.gz", "has_sig": false, "md5_digest": "82afe034ea3c768f70d34294813373dc", "packagetype": "sdist", "python_version": "source", "requires_python": "<3", "size": 4925, "upload_time": "2018-08-13T17:03:19", "url": "https://files.pythonhosted.org/packages/6e/e7/348e2f70cfe0124ea257428220d33375eb272ef76107b7f235c717767eb8/sqldeveloperpassworddecryptor-1.22.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "82afe034ea3c768f70d34294813373dc", "sha256": "b2461cb6d99905258f583fddac1af9d7e011b8cd88bdaa67a3c18005f748e863" }, "downloads": -1, "filename": "sqldeveloperpassworddecryptor-1.22.tar.gz", "has_sig": false, "md5_digest": "82afe034ea3c768f70d34294813373dc", "packagetype": "sdist", "python_version": "source", "requires_python": "<3", "size": 4925, "upload_time": "2018-08-13T17:03:19", "url": "https://files.pythonhosted.org/packages/6e/e7/348e2f70cfe0124ea257428220d33375eb272ef76107b7f235c717767eb8/sqldeveloperpassworddecryptor-1.22.tar.gz" } ] }