unknown db scheme?

Anonymous

PROOP

10 months ago

i'm using a tortoise orm with a fastapi app, and it works perfectly with the postgres public url but i get an saying that the db scheme wasn't recognized when i use the internal url

Solved$10 Bounty

44 Replies

medim

MODERATOR

10 months ago

Are you using the internal url in a local environment?

medim

MODERATOR

10 months ago

Or on your deployed app

Anonymous

PROOP

10 months ago

deployed app

Anonymous

PROOP

10 months ago

https://canary.discord.com/channels/713503345364697088/1212267176812355645/1212267176812355645

Anonymous

PROOP

10 months ago

someone's raised this before but it looks like they didn't get a solution

medim

MODERATOR

10 months ago

Instead of using the URL to connect, can you define individual values? Like Host, User, Password, Port, DB...

medim

MODERATOR

10 months ago

my guess is that tortoise is malformatting the internal URL, but I'm not sure

Anonymous

PROOP

10 months ago

okay ill try that

medim

MODERATOR

10 months ago

Another thing that you could try is joining #🚅｜priority-boarding and enabling the IPv4 Feature Flag

fra

HOBBY

10 months ago

are you using the right db name? if you say the schema is not recognised, it seems like you can connect to a db, maybe you are just connected to the wrong db?

medim

MODERATOR

10 months ago

@shiv any update on this?

Anonymous

PROOP

10 months ago

hey no that's not working

Anonymous

PROOP

10 months ago

TORTOISE_ORM = {
    "connections": {
        "default": {
            "engine": "tortoise.backends.asyncpg",
            "credentials": {
                "host": os.getenv("DB_HOST"),
                "port": int(os.getenv("DB_PORT", 5432)),
                "user": os.getenv("DB_USER"),
                "password": os.getenv("DB_PASSWORD"),
                "database": os.getenv("DB_NAME"),
            }
        }
    },
    "apps": {
        "models": {
            "models": ["core.models", "aerich.models"],
            "default_connection": "default",
        }
    },
}```

Anonymous

PROOP

10 months ago

File "/usr/local/lib/python3.12/socket.py", line 978, in getaddrinfo

for res in _socket.getaddrinfo(host, port, family, type, proto, flags):

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

socket.gaierror: [Errno -2] Name or service not known

Anonymous

PROOP

10 months ago

asyncpg fails

Anonymous

PROOP

10 months ago

1428606366729371668

Anonymous

PROOP

10 months ago

i've joined priority boarding but i don't see the ipv4 flag?

brody

EMPLOYEE

10 months ago

It's been GA'd now so it is automatically enabled on all new environments.

Anonymous

PROOP

10 months ago

hm okay

Anonymous

PROOP

10 months ago

but im still getting the same error

Anonymous

PROOP

10 months ago

so i'm running this via a dockerfile which runs a run.sh and that has a migration command

Anonymous

PROOP

10 months ago

which is where it seems to be failing

Anonymous

PROOP

10 months ago

FROM python:3.12-slim

WORKDIR /app

# Install build dependencies for packages with C extensions
RUN apt-get update && apt-get install -y \
    gcc \
    g++ \
    && rm -rf /var/lib/apt/lists/*

# Install uv
COPY --from=ghcr.io/astral-sh/uv:latest /uv /usr/local/bin/uv

# Copy dependency files
COPY pyproject.toml uv.lock* ./

# Install dependencies using system Python
RUN uv sync --frozen --no-dev --python $(which python3)

# Copy application code
COPY . .

# Make startup script executable
RUN chmod +x run.sh

CMD ["./run.sh"]```

brody

EMPLOYEE

10 months ago

I'll let the community assist with that.

Anonymous

PROOP

10 months ago

also how do i use the priority support that comes with the pro plan

Anonymous

PROOP

10 months ago

1428617576170389574