Skip to content

[BUG] Login into supabase cmd #25

@lucasfuelling

Description

@lucasfuelling

Description

cannot login into supabase cmd psql

Steps to Reproduce

  1. after fresh install:
  2. sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
    wget -qO- https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo tee /etc/apt/trusted.gpg.d/pgdg.asc &>/dev/null
    sudo apt update
    sudo apt install postgresql-client-18
  3. Then login to supabase through cmd
  4. psql 'postgres://postgres.:@supabase.yourdomain.com:5432/postgres'
  5. it will show login failed.

Expected Behavior

login will fail due to "Wrong" tenant_id / passwort

Possible Solution

start_services.py must be updated with POOLER_TENANT_ID as following to SOLVE the problem:

new_lines = []
for line in lines:
    if line.startswith("POSTGRES_PASSWORD="):
        new_lines.append(f"POSTGRES_PASSWORD={postgres_password}\n")
    elif line.startswith("JWT_SECRET="):
        jwt_secret = root_env.get("JWT_SECRET", "")
        new_lines.append(f"JWT_SECRET={jwt_secret}\n")
    elif line.startswith("ANON_KEY="):
        anon_key = root_env.get("ANON_KEY", "")
        new_lines.append(f"ANON_KEY={anon_key}\n")
    elif line.startswith("SERVICE_ROLE_KEY="):
        service_key = root_env.get("SERVICE_ROLE_KEY", "")
        new_lines.append(f"SERVICE_ROLE_KEY={service_key}\n")
    elif line.startswith("DASHBOARD_USERNAME="):
        dashboard_user = root_env.get("DASHBOARD_USERNAME", "supabase")
        new_lines.append(f"DASHBOARD_USERNAME={dashboard_user}\n")
    elif line.startswith("DASHBOARD_PASSWORD="):
        dashboard_pass = root_env.get("DASHBOARD_PASSWORD", "")
        new_lines.append(f"DASHBOARD_PASSWORD={dashboard_pass}\n")
    elif line.startswith("POOLER_TENANT_ID="):
        tenant_id = root_env.get("POOLER_TENANT_ID", "")
        new_lines.append(f"POOLER_TENANT_ID={tenant_id}\n")
    else:
        new_lines.append(line)

Metadata

Metadata

Labels

bugSomething isn't working

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions