Supabase•5d ago

can't create user

When attempting to create a user from the self-hosted Supabase Studio, the error “Failed to create user: API error happened while trying to communicate with the server.” appears. In Kong, the error “POST /api/platform/auth/default/users HTTP/1.1 400” is displayed, and no logs are output in aut kong:2.8.1 gotrue:v2.180.0 studio:2025.10.01-sha-8460121

15 Replies

mtayoOP•5d ago

response:{"error":{"message":"fetch failed"}}

inder•5d ago

Have you made any changes to default docker-compose.yaml file? Have you checked in dashboard auth logs for the error msg Also, are you using coolify or dokploy?

mtayoOP•5d ago

I'm writing Helm charts based on the default docker-compose and deploying them to Kubernetes. I haven't set up Logflare yet.

inder•5d ago

Can you make sql queries from dashboard?

mtayoOP•5d ago

It's done.

inder•5d ago

do you have any triggers on auth.users table?

mtayoOP•5d ago

SELECT
  tgname AS trigger_name,
  tgrelid::regclass AS table_name,
  tgfoid::regprocedure AS function_name,
  tgenabled AS enabled
FROM pg_trigger
WHERE NOT tgisinternal
  AND tgrelid = 'auth.users'::regclass;

SELECT
  tgname AS trigger_name,
  tgrelid::regclass AS table_name,
  tgfoid::regprocedure AS function_name,
  tgenabled AS enabled
FROM pg_trigger
WHERE NOT tgisinternal
  AND tgrelid = 'auth.users'::regclass;

Success. No rows returned

Success. No rows returned

Could this be the reason?

inder•5d ago

you can take a look at database > triggers

mtayoOP•5d ago

inder•5d ago

hmm this seems to be a network issue. I don't know about k8s but in docker-compose setup, this url https://github.com/supabase/supabase/blob/master/docker/docker-compose.yml#L42 should route to kong container. You need to make sure that this url points to your kong pod

mtayoOP•5d ago

The cause was that the studio side was still referencing kong:8000, even though Kong was running internally on port 8000 and had been converted to port 80 via the service. Thanks for resolving it.

inder•5d ago

oh ok got it I haven't used k8s in a long time but I think you mean that you setup a service which listens on port 80 but routes to port 8000 for this kong pod

mtayoOP•5d ago

yes

inder•5d ago

You've mentioned that you're able to make sql queries but just in case you face any issues in the future because of any config changes: You also need to make sure that this env https://github.com/supabase/supabase/blob/master/docker/docker-compose.yml#L34 url points to meta pod

mtayoOP•5d ago

Got it, thanks for the heads-up! I’ll double-check the PG_META_URL to make sure it correctly points to the meta pod. Appreciate the tip!

Gaming

Programming

can't create user

Did you find this page helpful?