getting this error in my pyhon code psycopg2.OperationalError: fe_sendauth: no password supplied

huangapple
go评论99阅读模式
英文:

getting this error in my pyhon code psycopg2.OperationalError: fe_sendauth: no password supplied

问题

I try to run python app with docker-compose and the app using postgres as container, but when i run docker-compose up the Database run successfully but the app allways getting error "psycopg2.OperationalError: fe_sendauth: no password supplied".

The setting of the postgres using a init.sql file that i've been created and copy to the container in a directory that run this file automatically.

  1. import psycopg2
  2. import psycopg2.extras
  3. import os
  4. from dotenv import load_dotenv
  6. dotenv_path = os.path.join(os.path.dirname(__file__), '..', '.env')
  7. load_dotenv(dotenv_path)
  9. db_username = os.environ.get('POSTGRES_USER')
  10. db_password = os.environ.get('POSTGRES_PASSWORD')
  11. postgres_port = os.environ.get('POSTGRES_PORT')
  12. database_name = os.environ.get('POSTGRES_DB')
  14. # Connect to the PostgreSQL database
  15. conn = psycopg2.connect(
  16.     host="db",
  17.     port=postgres_port,
  18.     database=database_name,
  19.     user=db_username,
  20.     password=db_password    
  21. )
  23. # get the data from the DB in json format
  24. cur = conn.cursor(cursor_factory=psycopg2.extras.RealDictCursor)
  26. # select data from DB
  27. def get_data(query):
  28.     try:
  29.         cur.execute(query)
  30.         data = cur.fetchall()
  31.         return data
  32.     except Exception as error:
  33.         print(error)
  34.         
  35. # update the DB        
  36. def set_data(query):
  37.     try:
  38.         cur.execute(query)
  39.         conn.commit()
  40.         return "Database was updated"
  41.     except Exception as error:
  42.         print(error)
  1. version: "3.8"
  2. services:
  3.   db:
  4.     build: ./database/
  5.     container_name: todo-db
  6.     environment:
  7.       POSTGRES_USER: ${POSTGRES_USER}
  8.       POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
  9.       POSTGRES_DB: ${POSTGRES_DB}
  10.     restart: always
  11.     ports:
  12.       - 5432:5432
  13.     volumes:
  14.       - ./database/data:/var/lib/postgresql/data
  15.     
  16.   app :
  17.     build: ./app/
  18.     container_name: todo-app
  19.     ports: 
  20.       - 8002:8000
  21.     links:
  22.       - db
  23.     depends_on:
  24.       - db  
  26.   pgadmin:
  27.     container_name: pgadmin4_container
  28.     image: dpage/pgadmin4
  29.     restart: always
  30.     environment:
  31.       PGADMIN_DEFAULT_EMAIL: ${PGADMIN_EMAIL}
  32.       PGADMIN_DEFAULT_PASSWORD: ${PGADMIN_PASSWORD}
  33.     ports:
  34.       - "5050:80"

Dockerfile of the python app:

  1. FROM python:3.9
  3. WORKDIR /code
  5. COPY ./requirements.txt /code/requirements.txt
  7. RUN pip install --no-cache-dir --upgrade -r /code/requirements.txt
  9. COPY . /code
  11. CMD ["uvicorn", "main:app", "--host", "0.0.0.0", "--port", "8000"]

Dockerfile of the postgres DB:

  1. FROM postgres:latest
  3. WORKDIR /app
  5. COPY init.sql /docker-entrypoint-initdb.d/init.sql
  7. EXPOSE 5432
  9. CMD [ "postgres" ]

init.sql file:

  1. CREATE USER IF NOT EXISTS todo_user WITH PASSWORD '${POSTGRES_PASSWORD}';
  3. CREATE DATABASE todo_db WITH OWNER todo_user;
  5. GRANT ALL PRIVILEGES ON DATABASE todo_db TO todo_user;
  7. \c todo_db todo_user;
  9. CREATE TABLE tasks(
  10.    id SERIAL PRIMARY KEY,
  11.    task VARCHAR NOT NULL,
  12.    ststus VARCHAR NOT NULL
  13. );

.env file:

  1. POSTGRES_USER = todo_user
  2. POSTGRES_PASSWORD = Aa123456
  3. POSTGRES_DB = todo_db
  4. POSTGRES_PORT = 5432

I tried in the connection string in the app to set the default username and password of postgres database and it's working i successfully connect to database but when i use variable from .env file i'm getting the error.

In the postgres container i can see that the user and the DB created.

英文:

I try to run python app with docker-compose and the app using postgres as container, but when i run docker-compose up the Database run successfully but the app allways getting error "psycopg2.OperationalError: fe_sendauth: no password supplied".

The setting of the postgres using a init.sql file that i've been created and copy to the container in a directory that run this file automatically.

======================== connection to DB file ========================

  1. import psycopg2
  2. import psycopg2.extras
  3. import os
  4. from dotenv import load_dotenv
  6. dotenv_path = os.path.join(os.path.dirname(__file__), '..', '.env')
  7. load_dotenv(dotenv_path)
  9. db_username = os.environ.get('POSTGRES_USER')
  10. db_password = os.environ.get('POSTGRES_PASSWORD')
  11. postgres_port = os.environ.get('POSTGRES_PORT')
  12. database_name = os.environ.get('POSTGRES_DB')
  13. # postgres_host = os.environ.get('POSTGRES_HOST')
  15. print (database_name)
  17. # Connect to the PostgreSQL database
  18. conn = psycopg2.connect(
  19.     host="db",
  20.     port=postgres_port,
  21.     database=database_name,
  22.     user=db_username,
  23.     password=db_password    
  24. )
  26. # get the data from the DB in json format
  27. cur = conn.cursor(cursor_factory=psycopg2.extras.RealDictCursor)
  29. # select data from DB
  30. def get_data(query):
  31.     try:
  33.         # Run the query and fetch the results
  34.         cur.execute(query)
  35.         data = cur.fetchall()
  36.         return data
  37.     except Exception as error:
  38.         print(error)
  39.         
  40. # update the DB        
  41. def set_data(query):
  42.     try:
  43.         # Run the query and fetch the results
  44.         cur.execute(query)
  45.         conn.commit()
  46.         return "Database was updated"
  47.     except Exception as error:
  48.         print(error)

===================== docker-compose file =====================

  1. version: "3.8"
  2. services:
  3.   db:
  4.     build: ./database/
  5.     container_name: todo-db
  6.     environment:
  7.       POSTGRES_USER: ${POSTGRES_USER}
  8.       POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
  9.       POSTGRES_DB: ${POSTGRES_DB}
  10.     restart: always
  11.     ports:
  12.       - 5432:5432
  13.     volumes:
  14.       - ./database/data:/var/lib/postgresql/data
  15.       # - ./database/init.sql:/docker-entrypoint-initdb.d/init.sql
  16.     # env_file:
  17.     #   - ../TODO-App/.env
  18.     
  19.   app :
  20.     build: ./app/
  21.     container_name: todo-app
  22.     ports: 
  23.       - 8002:8000
  24.     links:
  25.       - db
  26.     depends_on:
  27.       - db  
  29.   pgadmin:
  30.     container_name: pgadmin4_container
  31.     image: dpage/pgadmin4
  32.     restart: always
  33.     environment:
  34.       PGADMIN_DEFAULT_EMAIL: ${PGADMIN_EMAIL}
  35.       PGADMIN_DEFAULT_PASSWORD: ${PGADMIN_PASSWORD}
  36.     ports:
  37.       - "5050:80"

============================== Dockerfile of the python app ==============================

  1. FROM python:3.9
  3. # 
  4. WORKDIR /code
  6. # 
  7. COPY ./requirements.txt /code/requirements.txt
  9. # 
  10. RUN pip install --no-cache-dir --upgrade -r /code/requirements.txt
  12. # 
  13. COPY . /code
  15. # 
  16. CMD ["uvicorn", "main:app", "--host", "0.0.0.0", "--port", "8000"]

=============================== Dockerfile of the postgres DB ===============================

  1. FROM postgres:latest
  3. WORKDIR /app
  5. COPY init.sql /docker-entrypoint-initdb.d/init.sql
  7. EXPOSE 5432
  9. CMD [ "postgres" ]

============== init.sql file ==============

  1. CREATE USER IF NOT EXISTS todo_user WITH PASSWORD '${POSTGRES_PASSWORD}';
  3. CREATE DATABASE todo_db WITH OWNER todo_user;
  5. GRANT ALL PRIVILEGES ON DATABASE todo_db TO todo_user;
  7. \c todo_db todo_user;
  9. CREATE TABLE tasks(
  10.    id SERIAL PRIMARY KEY,
  11.    task VARCHAR NOT NULL,
  12.    ststus VARCHAR NOT NULL
  13. );

=========== .env file ===========

  1. POSTGRES_USER = todo_user
  2. POSTGRES_PASSWORD = Aa123456
  3. POSTGRES_DB = todo_db
  4. POSTGRES_PORT = 5432

I tried in the connection string in the app to set the default username and password of postgres database and it's working i successfully connect to database but when i use variable from .env file i'm getting the error.

In the postgres coantainer i can see that the user and the DB created.

答案1

得分: 0

看起来你只在"db"容器中使用环境变量，而没有在"app"容器中使用。

假设你的用于获取环境变量的Python代码有效，将envvars 添加到你的应用容器中：

  1. app:
  2.   build: ./app/
  3.   container_name: todo-app
  4.   environment:
  5.     POSTGRES_USER: ${POSTGRES_USER}
  6.     POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
  7.     POSTGRES_DB: ${POSTGRES_DB}
  8.   ports: 
  9.     - 8002:8000
  10.   links:
  11.     - db
  12.   depends_on:
  13.     - db
英文:

Looks like you're only using environment variables for your "db" container, but not for the "app" container.

Provided that your python code for getting environment variables works, add envvars to your app container:

  1.   app:
  2.     build: ./app/
  3.     container_name: todo-app
  4.     environment:
  5.       POSTGRES_USER: ${POSTGRES_USER}
  6.       POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
  7.       POSTGRES_DB: ${POSTGRES_DB}
  8.     ports: 
  9.       - 8002:8000
  10.     links:
  11.       - db
  12.     depends_on:
  13.       - db

huangapple
  • 本文由 发表于 2023年3月31日 22:46:01
  • 转载请务必保留本文链接：https://go.coder-hub.com/75899863.html
  • docker-compose
  • dockerfile
  • environment-variables
  • postgresql
  • python
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定