Prisma + Mongo DB Railway

miguedev1047HOBBY

8 months ago

I am trying to connect to the database using the URL provided by Railway. I have a .env file where I have the environment variable where I establish that URL (which railway gives me) but it doesn't connect me and I don't really understand why

0 Replies

8 months ago

You're using the internal url


8 months ago

That one is used for communication between service INSIDE the railway private network


miguedev1047HOBBY

8 months ago

I also try to use the public one but I get the same error

1293283702779940900


8 months ago

does the URL follows the same pattern stated in the prisma docs?
https://www.prisma.io/docs/orm/reference/connection-urls#mongodb


miguedev1047HOBBY

8 months ago

Sorry, I'm not used to this problem, I normally used MySQL or PostgreSQL and this error is new for me


8 months ago

No problems, just check if your db url follows this pattern:
"mongodb+srv://root:@[cluster0.ab1cd.mongodb.net/myDatabase?retryWrites=true&w=majority](cluster0.ab1cd.mongodb.net/myDatabase?retryWrites=true&w=majority)"


miguedev1047HOBBY

8 months ago

Oh I see, I should adapt the url that railway gives me


8 months ago

Does your URL string starts with
mongodb+srv://?

Did you put the database at the end?
/your-db-here


miguedev1047HOBBY

8 months ago

||mongodb://mongo:pjUxJYpgWlNcrSAqefuZgyjYAUWRtMZT@autorack.proxy.rlwy.net:39175||

I am trying to adapt this url according to the prisma documentation but I don't know very well how.


miguedev1047HOBBY

8 months ago

<:catsad:1111008884820279408>


8 months ago

er uhm


8 months ago

delete it


8 months ago

u just showed me your creds


8 months ago

<:kekw:788259314607325204>


miguedev1047HOBBY

8 months ago

Don't worry, just create a test one


8 months ago

ok.


8 months ago

mongodb://mongo:pjUxJYpgWlNcrSAqefuZgyjYAUWRtMZT@autorack.proxy.rlwy.net:39175/railway?retryWrites=true&w=majority


8 months ago

in the prisma docs they also include this ?retryWrites=true&w=majority at the end, probably some connection config that it needs


miguedev1047HOBBY

8 months ago

Coincidentally, I tried it like this without the last one, but it still doesn't work. <:sad_hamster:1280780987504267328>


8 months ago

mongodb://mongo:pjUxJYpgWlNcrSAqefuZgyjYAUWRtMZT@autorack.proxy.rlwy.net:39175/railway?retryWrites=true&w=majority


8 months ago

try without the +srv


miguedev1047HOBBY

8 months ago

thank very much, but… can't work


miguedev1047HOBBY

8 months ago

ehhh


8 months ago

<:cryingman:786867299553378324>


miguedev1047HOBBY

8 months ago

i will see if they allow me to change databases, this problem is only happening to me in mongo db, in the other databases I have not had this problem