opensearch-project / opensearch-project/sql-odbc
[BUG] ODBC driver doesn't work properly when SSL is used
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 10
- Forks
- 25
- PR merge metrics
- No merged PRs in 30d
Description
Describe the bug
I detected that ODBC driver refers to ODFE when SSL is activated. Maybe it is not a reason, but just a coincidence.
To Reproduce
Steps to reproduce the behavior:
- I started a local cluster with security plugin on port 9300 instead of 9200 (opensearch-docker.zip).
- Configured a DSN as shown on the picture
- Tried to test the connection
- Connection fails, SSL wasn't actually used (HTTP traffic is not encrypted).
See also ODBC log: mylog_odbcad32_22088.log
I also tried the same test with an AWS instance and it also failed. Despite of local one, it has valid SSL certificates.
Perhaps, it also affects AWS_SIGv4 authentication.
Host/Environment (please complete the following information):
- OS: [e.g. iOS] Win 10 + Docker on WSL2
- Version [e.g. 22] ODBC v.1.2.0, OS v.1.2.0
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the connection failure with ODBC v1.2.0 against the local OpenSearch cluster described in the issue, then inspect the attached ODBC log and compare it with the AWS test. Done means the driver establishes an encrypted SSL connection and, if affected, handles AWS_SIGv4 authentication correctly.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sql
- Domain
- database, security
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100