sangle69
sangle69•14mo ago

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
rubenf
rubenf•14mo ago
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
sangle69
sangle69OP•14mo ago
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"
rubenf
rubenf•14mo ago
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
sangle69
sangle69OP•14mo ago
Could you elaborate with me more on that as I am quite new to railway 🙂 ?
rubenf
rubenf•14mo ago
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
sangle69
sangle69OP•14mo ago
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 ?
rubenf
rubenf•14mo ago
I don't sorry never used railway
sangle69
sangle69OP•14mo ago
Thank you. I will try to figure it out and get back to you 🙂