Permission denied error with windmill and supabase
Hi everyone, I need some help with Windmill. I'm trying to deploy it on railway using the Dockerfile and connect it to a supabase database. The deployment works fine, but I get this error when I run it and logged in:
Sql error: error returned from database: permission denied to set role "windmill_admin"
Does anyone know what's causing this and how to fix it? Thanks in advance!
8 Replies
Hi, what database are you using ? Can you not create role on that database ?
if it's railway's database, make sure to use a superadmin pg account to connect to the db
I am using Supabase database currently.
However, I tried railway's database, but it doesn't work probably, and I got this error as follows:
Error: Migrating database: while executing migrations: error returned from database: syntax error at or near "TRIGGER"
Caused by:
0: while executing migrations: error returned from database: syntax error at or near "TRIGGER"
1: error returned from database: syntax error at or near "TRIGGER"
2: syntax error at or near "TRIGGER"
ah yeah railway database is of a too old version
you need pg 14
for supabase I suspect you are not using the root connection
Could you elaborate with me more on that as I am quite new to railway 🙂 ?
for the supabase issue, I believe that the database_url you are passing to windmill is one of a postgres role that is not superadmin on your database
seems like you should be able to use postgres 14 on railway: https://github.com/railwayapp-templates/postgres-ssl/pkgs/container/postgres-ssl
That's a nice catch. I totally missed that. I am trying to run a deployment with supabase_admin user. Let's see how it's going. Will keep you posted on this approach
for this approach, I saw they have postgres 14 but not sure how to use it to deploy tho. Do you know ?
I don't sorry
never used railway
Thank you. I will try to figure it out and get back to you 🙂