unknown db scheme?

Anonymous

PROOP

8 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

8 months ago

Are you using the internal url in a local environment?

medim

MODERATOR

8 months ago

Or on your deployed app

Anonymous

PROOP

8 months ago

deployed app

Anonymous

PROOP

8 months ago

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

Anonymous

PROOP

8 months ago

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

medim

MODERATOR

8 months ago

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

medim

MODERATOR

8 months ago

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

Anonymous

PROOP

8 months ago

okay ill try that

medim

MODERATOR

8 months ago

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

fra

HOBBY

8 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

8 months ago

@shiv any update on this?

Anonymous

PROOP

8 months ago

hey no that's not working

Anonymous

PROOP

8 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

8 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

8 months ago

asyncpg fails

Anonymous

PROOP

8 months ago

1428606366729371668

Anonymous

PROOP

8 months ago

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

brody

EMPLOYEE

8 months ago

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

Anonymous

PROOP

8 months ago

hm okay

Anonymous

PROOP

8 months ago

but im still getting the same error

Anonymous

PROOP

8 months ago

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

Anonymous

PROOP

8 months ago

which is where it seems to be failing

Anonymous

PROOP

8 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

8 months ago

I'll let the community assist with that.

Anonymous

PROOP

8 months ago

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

Anonymous

PROOP

8 months ago

1428617576170389574