p1000 authentication failed against database server

[alucardu]

I'm trying to use docker, postgres and prisma together but I'm running into an error.

I have a docker-compose.yml file:

version: '3.8'
services:
  postgres:
    image: postgres:13
    restart: always
    environment:
      POSTGRES_HOST_AUTH_METHOD: trust
      POSTGRES_DB: college_db
    volumes:
      - postgres:/var/lib/postgresql/data
    ports:
      - '5432:5432'
volumes:
    postgres:

A .env file:

DATABASE_URL="postgresql://postgres@localhost:5432/college_db"

And a Prisma schema:

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

When I run a prisma command npx prisma db pull I get an error:

But when I checkout my postgres database I can login the college_db database without any issue using the postgres superuser:

I'm using Windows 10 and the latest docker installation.

[ryands17]

@alucardu 👋

Why doesn't your Postgres URL have a password? It's probably why Prisma can't connect. I can successfully connect my local Docker setup with Prisma and my URL looks something like this:

DB_URL="postgresql://postgres:password@localhost:5432/database"

[ryands17]

@janpio is this a Windows issue?

[janpio]

No idea. Many people are using Postgres and Docker successfully on Windows, so this should be possible.

Will reply more in the related issue.

[janpio]

See #8927 (comment)

[ameyalambat128]

I fixed the issue by removing Postgres locally from my windows machine.

[ArturM-S]

GOD

[alucardu]

Even in the most basic form (https://hub.docker.com/_/postgres?tab=description) I can't connect:

docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres

.env file:

DATABASE_URL="postgresql://postgres:mysecretpassword@localhost:5432/postgres"

Please make sure to provide valid database credentials for the database server at localhost.

[ryands17]

Try exposing the ports in the above command and check?

[alucardu]

Sorry @ryands17 could you expand on that? I'm very new to docker.

[alucardu]

Issue is resolved > #8927

[elielton1-alt]

what was the error? I have the same problem

[alucardu]

For me it was that i had installed MySQL locally and in the docker instance. So i removed the locally installed docker and that resolved my issue.

[Naji-moradi]

for me in mysql connection i just removed the keyword password and left it empty then worked like bellow
DATABASE_URL="mysql://root:@localhost:3306/prisma"

[RoylerMarichal]

Work for me

[NycolasSM]

it happened to me because I had forgotten to stop the service that was running with pm2 on the old server, so I stopped the service and started it on the new server, I don't know but it could be your problem

[marcosillvestre]

how d you stop the another services ?

[RoylerMarichal]

I don't understand your question... This is the flow I use... In the client application, I have a widget that sends the image from the client to imagekit, gets the url and saves that url to the DB... To For this widget to work on behalf of the client, I must prepare a url in my backend to authenticate against imagekit... This authentication is what fails when generating the signature and token, as I show in the previous email El vie, 12 may 2023 a las 16:37, Marcos ***@***.***>) escribió:

…

how d you stop the another services ? — Reply to this email directly, view it on GitHub <#8925 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AMO6GA4PGCYBAOROHWUYTX3XF2NRPANCNFSM5CZE4N4Q> . You are receiving this because you commented.Message ID: ***@***.***>

-- *CluzStudio S.U.R.L . Bayamo, Granma, Cuba* Desarrollo de plataformas webs/móviles avanzadas +55 41 999568376 cluzstudio.com

[williamtran-tech]

What-a-mistaka-to-make. I had postgres installed locally on my Windows machine. So it was using that instance of postgres instead of the one on my docker environment. I removed the windows postgres installation and everything is working as expected. #8927

I have fixed it by this solution in Stackoverflow

[Ajmal0197]

I had to do this as my PostgreSQL was running in background:

https://dev.to/sylwiavargas/how-to-properly-close-a-port-2p36