DPY-6005 ssl connectivity issue

[rajir8]

Hey All, we get the below error inspite of passing correct wallet location and pem file in the connection params. anyone else faced a similar issue and knows the fix?
sqlalchemy.exc.OperationalError: (oracledb.exceptions.OperationalError) DPY-6005: cannot connect to database (CONNECTION_ID=''). │
│ [SSL: UNEXPECTED_EOF_WHILE_READING] EOF occurred in violation of protocol (_ssl.c:1010) │
│ (Background on this error at: https://sqlalche.me/e/20/e3q8)

[anthony-tuininga]

That suggests the server is dropping the connection unexpectedly. Are you using a proxy? Try using python-oracledb directly without the use of SQLAlchemy. Post (or e-mail me) the output of your script when setting the environment variable PYO_DEBUG_PACKETS to any value.

[rajir8]

Hi Anthony, we dont have a proxy. will try the debug environment variable and get back to you with the output.

[cjbj]

@rajir8 what version of python-oracledb are you using? Try with both 2.5.1 and 3.0.0.