Python on Azure Function error is "OperationalError: (psycopg2.OperationalError) could not translate host name "Mypassword@database_ip" to address" [duplicate]

Question

I have a python function that connects to Azure Postgresql and selects query some rows. In local run without problem. When I published on Azure and run it I received the below error:

OperationalError: (psycopg2.OperationalError) could not translate host name "Mypassword@database_ip" to address

I don't know why to change connection format to db_password@db_ip, as you see on screenshot.

My function is:

def get_engine(database='db_name', username='username', password='@password', host='ip', port=5432):
    engine_string = f"postgresql+psycopg2://{username}:{password}@{host}:{port}/{database}"
    engine = sqlalchemy.create_engine(engine_string)
    print("Database connection done!")
    return engine

On line after engine_string = ... do print(engine_string) to see what you are actually building. Post result as update to your question. — Adrian Klaver
– Adrian Klaver, Commented Jun 9, 2021 at 21:16

Gord Thompson · Accepted Answer · 2021-06-09 21:41:19Z

2

Rather than using plain string formatting you can use engine.URL.create to protect yourself against "special characters" in the username, password, etc.:

import sqlalchemy as sa

# …

url = sa.engine.URL.create(
    drivername="postgresql+psycopg2",
    username="username",
    password="@password",
    host="ip",
    port=5432,
    database="database",
)
print(url)  # postgresql+psycopg2://username:%40password@ip:5432/database
engine = sa.create_engine(url)
``

edited Jun 9, 2021 at 21:41

answered Jun 9, 2021 at 21:29

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ilja Everilä Over a year ago

I think that this would be really useful to have in the linked dupe target as well.

jjanes · Accepted Answer · 2021-06-09 21:15:54Z

0

The literal @ in your password needs to be URI encoded.

answered Jun 9, 2021 at 21:15

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

Collectives™ on Stack Overflow

Python on Azure Function error is "OperationalError: (psycopg2.OperationalError) could not translate host name "Mypassword@database_ip" to address" [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related