Pyodbc ssl configuration

1

I’m installing mssql drivers through a Dockerfile, but pyodbc throws the following error after when compiling the app:

pyodbc.OperationalError: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol] (-1) (SQLDriverConnect)')

Searching online I found that one of the possible solutions is changing the /etc/ssl/openssl.cnf file with the following code:

[default_conf]
ssl_conf = ssl_sect

[ssl_sect]
system_default = system_default_sect

[system_default_sect]
MinProtocol = TLSv1.0
CipherString = DEFAULT@SECLEVEL=1

I added the folders and file to my root, but it didn’t seem to have any effect.
For the record, my database version is Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64).

2

Hi there,

How much we can assist you here is a little limited - how does it behave building the Dockerfile locally - I suspect it would be the same error there, I’m just trying to isolate whether this is a Render build issue or something more fundamental here,

Regards,

John B

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.