Database private url not working

import asyncpg

from afw_bot.ext.utils.loggers import log_message


class Database:
    def __init__(self, dsn):
        self.dsn = dsn

    async def connect(self):
        try:
            self.pool = await asyncpg.create_pool(dsn=self.dsn)
            log_message(log_level="INFO", message="DATABASE Successfully connected")
        except Exception as e:
            log_message(
                log_level="WARNING", message=f"Failed to connect to the database: {e}"
            )
            self.pool = None  # Ensure pool is set to None on failure

    async def create_tables(self):
        if not self.pool:
            raise RuntimeError("Database pool is not initialized")
        async with self.pool.acquire() as conn:
            await conn.execute(
                """
                CREATE TABLE IF NOT EXISTS audit (
                    thread_id BIGINT PRIMARY KEY,
                    clan_tag TEXT UNIQUE NOT NULL,
                    war_status TEXT NOT NULL,
                    applicant_id BIGINT NOT NULL,
                    war_end_timestamp BIGINT NOT NULL
                );
            """
            )

    async def close(self):
        if self.pool:
            await self.pool.close()

import asyncpg

from afw_bot.ext.utils.loggers import log_message


class Database:
    def __init__(self, dsn):
        self.dsn = dsn

    async def connect(self):
        try:
            self.pool = await asyncpg.create_pool(dsn=self.dsn)
            log_message(log_level="INFO", message="DATABASE Successfully connected")
        except Exception as e:
            log_message(
                log_level="WARNING", message=f"Failed to connect to the database: {e}"
            )
            self.pool = None  # Ensure pool is set to None on failure

    async def create_tables(self):
        if not self.pool:
            raise RuntimeError("Database pool is not initialized")
        async with self.pool.acquire() as conn:
            await conn.execute(
                """
                CREATE TABLE IF NOT EXISTS audit (
                    thread_id BIGINT PRIMARY KEY,
                    clan_tag TEXT UNIQUE NOT NULL,
                    war_status TEXT NOT NULL,
                    applicant_id BIGINT NOT NULL,
                    war_end_timestamp BIGINT NOT NULL
                );
            """
            )

    async def close(self):
        if self.pool:
            await self.pool.close()

2024-08-12 20:37:38.877 | WARNING  | afw_bot.ext.utils.database:connect:16 - 2024-08-12 20:37:38 Failed to connect to the database: Multiple exceptions: [Errno 111] Connect call failed ('::1', 5432, 0, 0), [Errno 111] Connect call failed ('127.0.0.1', 5432)

2024-08-12 20:37:38.877 | WARNING  | afw_bot.ext.utils.database:connect:16 - 2024-08-12 20:37:38 Failed to connect to the database: Multiple exceptions: [Errno 111] Connect call failed ('::1', 5432, 0, 0), [Errno 111] Connect call failed ('127.0.0.1', 5432)

class Database:
    def __init__(self, dsn):
        self.dsn = dsn

    async def connect(self):
        await asyncio.sleep(5)
        try:
            self.pool = await asyncpg.create_pool(dsn=self.dsn)
            log_message(log_level="INFO", message="DATABASE Successfully connected")
        except Exception as e:
            log_message(
                log_level="WARNING", message=f"Failed to connect to the database: {e}"
            )
            self.pool = None  # Ensure pool is set to None on failure

class Database:
    def __init__(self, dsn):
        self.dsn = dsn

    async def connect(self):
        await asyncio.sleep(5)
        try:
            self.pool = await asyncpg.create_pool(dsn=self.dsn)
            log_message(log_level="INFO", message="DATABASE Successfully connected")
        except Exception as e:
            log_message(
                log_level="WARNING", message=f"Failed to connect to the database: {e}"
            )
            self.pool = None  # Ensure pool is set to None on failure

class MyBot(commands.Bot):

    def __init__(self, *, intents: discord.Intents):
        super().__init__(
            command_prefix="supersecretjutsu",
            help_command=None,
            intents=intents,
            tree_cls=CommandErrorHandler,
        )

    async def setup_hook(self):
        coc_client = coc.EventsClient(key_names=DevCreds.DEV_TOKEN_NAME)
        await coc_client.login(
            email=DevCreds.DEV_SITE_EMAIL, password=DevCreds.DEV_SITE_PASSWORD
        )
        self.coc_client: coc.Client = coc_client

        self.db = Database(dsn=Core.DATABSE_URL)
        await self.db.connect()

class MyBot(commands.Bot):

    def __init__(self, *, intents: discord.Intents):
        super().__init__(
            command_prefix="supersecretjutsu",
            help_command=None,
            intents=intents,
            tree_cls=CommandErrorHandler,
        )

    async def setup_hook(self):
        coc_client = coc.EventsClient(key_names=DevCreds.DEV_TOKEN_NAME)
        await coc_client.login(
            email=DevCreds.DEV_SITE_EMAIL, password=DevCreds.DEV_SITE_PASSWORD
        )
        self.coc_client: coc.Client = coc_client

        self.db = Database(dsn=Core.DATABSE_URL)
        await self.db.connect()

${{Postgres.DATABASE_URL}}

${{Postgres.DATABASE_URL}}

2024-08-13 02:18:24 INFO     discord.client logging in using static token
2024-08-13 02:19:04.516 | INFO     | afw_bot.ext.utils.database:connect:12 - 2024-08-13 02:19:04 DATABASE Successfully connected

2024-08-13 02:18:24 INFO     discord.client logging in using static token
2024-08-13 02:19:04.516 | INFO     | afw_bot.ext.utils.database:connect:12 - 2024-08-13 02:19:04 DATABASE Successfully connected

postgresql://postgres:[email protected]:40317/railway

postgresql://postgres:[email protected]:40317/railway