Skip to content

Windows Integrated Security #142

Closed
@vlad-bezden

Description

@vlad-bezden

I could not find out information how to use Windows Integrated Security with asyncpg. I tried to add Integrated Security to the dictionary, but it did not work.

    SERVER_SETTINGS = {'IntegratedSecurity': 'True'}

    conn = await asyncpg.connect(host=HOST,
                                 port=PORT,
                                 user=USER,
                                 database=DATABASE,
                                 server_settings=SERVER_SETTINGS)

I'm always getting following error back:

Traceback (most recent call last):
  File "c:\DEV\PythonPlayground\testdb.py", line 28, in <module>
    loop.run_until_complete(run())
  File "C:\Users\vbezden\AppData\Local\Programs\Python\Python36-32\lib\asyncio\base_events.py", line 466, in run_until_complete
    return future.result()
  File "c:\DEV\PythonPlayground\testdb.py", line 21, in run
    server_settings=SERVER_SETTINGS)
  File "C:\dev\venv\lib\site-packages\asyncpg\connection.py", line 1187, in connect
    max_cacheable_statement_size=max_cacheable_statement_size)
  File "C:\dev\venv\lib\site-packages\asyncpg\connect_utils.py", line 306, in _connect
    raise last_error
  File "C:\dev\venv\lib\site-packages\asyncpg\connect_utils.py", line 298, in _connect
    connection_class=connection_class)
  File "C:\dev\venv\lib\site-packages\asyncpg\connect_utils.py", line 274, in _connect_addr
    await asyncio.wait_for(connected, loop=loop, timeout=timeout)
  File "C:\Users\abc\AppData\Local\Programs\Python\Python36-32\lib\asyncio\tasks.py", line 356, in wait_for
    raise futures.TimeoutError()
concurrent.futures._base.TimeoutError

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions