Installing cx_Oracle on 1.10.10-buster-onbuild

Hello, again.

I am running astronomerinc/ap-airflow:1.10.10-buster-onbuild via the CLI.

First - it looks like the Debian based builds don’t come with packages like cx_Oracle already installed. I thought the alpine builds had it already.

Second - when I try to install it to my image myself I am running into issues. If I add it to requirements.txt and start my instance with astro airflow start it doesn’t try to rebuild the image. I assume I’m missing something there. Also, if I try to pip install manually within the running container the install fails:

Could not fetch URL https://pypi.org/simple/cx-oracle/: There was a problem confirming the ssl certificate: HTTPSConnectionPool(host=‘pypi.org’, port=443): Max retries exceeded with url: /simple/cx-oracle/ (Caused by SSLError(SSLError(“bad handshake: Error([(‘SSL routines’, ‘tls_process_server_certificate’, ‘certificate verify failed’)])”))) - skipping

Could not fetch URL https://pip.astronomer.io/simple/cx-oracle/: There was a problem confirming the ssl certificate: HTTPSConnectionPool(host=‘pip.astronomer.io’, port=443): Max retries exceeded with url: /simple/cx-oracle/ (Caused by SSLError(SSLError(“bad handshake: Error([(‘SSL routines’, ‘tls_process_server_certificate’, ‘certificate verify failed’)])”))) - skipping

Any ideas what I can do to get cx_Oracle installed?

Thanks.

Just wanted to share that to get around the issue I download the tar.gz for the right version of cx_Oracle and installed it via pip as part of my Dockerfile build.

I think I know what is causing the certificate issue as well.