I'm continuing to get this Prisma initialization e...
# orm-help
m
I'm continuing to get this Prisma initialization error - "Prisma can't connect to db at <ip>:<port>". I'm now following this URL string name as best as I can - from the Prisma docs: https://www.prisma.io/docs/concepts/database-connectors/postgresql#connecting-via-sockets With one exception. for the host param, I'm percent-encoding the slashes. So I'm putting in:
<postgresql://MYUSER:MYPW@localhost/MYDB?host=%2Fcloudsql%2FMY_CLOUD_SQL_INSTANCE_CONNECTION_NAME%2F>
I tried it with and without the trailing slash, but I haven't tried it yet with removing the percent encodings. I just would really love to hear from a Prisma team member that this is up-to-date information so I can rule one thing out and focus elsewhere.
1
n
Hi Michael! The documentation seems up to date. Did you had a look at this conversation on related GitHub Issue: #11171 It looks like they were facing the same issue and it worked for them when they passed the URL in the format specified in this comment
m
@Nurul Thanks for that link. The part about including the instance name quieted down a concern that I was having about including that part. That's how I'm doing it, which really seems to indicate it's a permissioning thing across the instances themselves. Thanks again.
🙌 1
@Nurul We're up!! For people with a little less experiencing configuring the DB strings, it may be worth noting in the reference I linked that URL paths for the host should NOT be percent-encoded.
🙌 1
n
I am glad to hear! 🙌