oracle / oracle/python-oracledb

Using create_pool() with Kerberos

Open
#381 6 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement
Dominant language
Python
Stars
451
Forks
119
PR merge metrics
No merged PRs in 30d

Description

  1. What versions are you using?
    oracledb.version: 2.2.1
    platform.platform: Windows-2016Server-10.0.14393-SP0
    sys.maxsize > 2**32: True
    platform.python_version: 3.12.4
    database version: 19.22.0.0
  1. Is it an error or a hang or a crash?
    Error, same as issue #36 but for Kerberos this time

  2. What error(s) or behavior you are seeing?
    When trying to create a connection pool with externalauth=True (Kerberos in this case) there is an exception complaining about null or missing username.
    File "src\oracledb\impl/thick/pool.pyx", line 152, in oracledb.thick_impl.ThickPoolImpl.init
    File "src\oracledb\impl/thick/utils.pyx", line 446, in oracledb.thick_impl._raise_from_info
    oracledb.exceptions.DatabaseError: ORA-24415: Missing or null username.

  1. Does your application call init_oracle_client()?
    Yes
  1. Include a runnable Python script that shows the problem.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the create_pool() path after init_oracle_client(), then read src/oracledb/impl/thick/pool.pyx and src/oracledb/impl/thick/utils.pyx around the reported lines. Reproduce on the listed Python, platform, driver, and database versions with externalauth=True and Kerberos. Done means the pool no longer raises ORA-24415 for this authentication path.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.