Tomathy
Tomathy
Explore posts from servers
PPrismaDTDrizzle Team
PostsComments
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
i figured out the problem... I was reaching for the wrong port on supabase. Since im not in a serverless enviornment i should reach for the session mode which uses a different port than the transaction mode in supabase. I changed the port and everything worked fine -_- Thanks for all the help anyways
18 replies
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
I put the cert in the ./prisma folder, to be as straight forward as possible "sslcert=dbcert.crt" on the URl, but all im gettingis a connection not establishing (the terminal gets stuck at this): 
Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "<HOST>:6543"
Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "<HOST>:6543"
18 replies
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
wow, thanks that makes sense. Thank you for the answers ❤️
18 replies
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
ah fair, thought the connection used the cert as an encryption key for sending the credentials.
18 replies
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
thank you! Would i need any more arguments in the url than those? Or are those enough? Cause i see that there are options for sslidentity=<PATH> and sslpassword=<PASSWORD> and im not sure if those are required to establish a sll connection
18 replies
PPrisma
Created by Tomathy on 10/23/2024 in #help-and-questions
SSL connection to supabase
No sorry, Im figuring out things as I go so I'm a bit lost here 😅 . Basically what's happening is I want to connect top my supabase database with SSL. I wasn't able to do it before, basically when i ran, say "db push" it attempted to connect to the database but would just continuously run without connecting and nothing would happen. Since then I have read the documentation and downloaded the certificate from supabase, but I'm still having difficulties figuring out what is needed and what isn't needed in the connection URL to always establish a SSL connection. currently my string is looking like this: postgresql://USER:PASSWORD@HOST:6543/postgres?pgbouncer=true&connection_limit=1&sslcert=../certificates/dbcert.crt with the correct values where appropriate
18 replies