search

oracle / python-oracledb

Python driver for Oracle Database conforming to the Python DB API 2.0 specification. This is the renamed, new major release of cx_Oracle
https://oracle.github.io/python-oracledb
Other
328 stars 66 forks source link

SSL authentication not working for Amazon RDS (using thin model) #139

Closed moxarth-elastic closed 1 year ago

moxarth-elastic commented 1 year ago
  1. What versions are you using?

Give your database version.

Also run Python and show the output of:

import sys
import platform

print("platform.platform:", platform.platform())
print("sys.maxsize > 2**32:", sys.maxsize > 2**32)
print("platform.python_version:", platform.python_version())

And:

import oracledb
print("oracledb.__version__:", oracledb.__version__)

Oracledb Version: 1.2.2 Database Version: Oracle Database 19c Standard Edition 2 (Amazon RDS )

Output of first code:

platform.platform: Linux-5.15.0-57-generic-x86_64-with-glibc2.35
sys.maxsize > 2**32: True
platform.python_version: 3.10.6

Output of second code:

oracledb.__version__: 1.2.2

  1. Is it an error or a hang or a crash? Error

  2. What error(s) or behavior you are seeing?

oracledb.exceptions.OperationalError: DPY-6005: cannot connect to database. Connection failed with "[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:997)"

  1. Does your application call init_oracle_client()? No, I am using thin model