readflow icon indicating copy to clipboard operation
readflow copied to clipboard

Fresh Install: Unable to get user information

Open AsixJin opened this issue 6 months ago • 5 comments

I'm trying to install readflow on my server (Docker) but I just can't seem to get this working. I get a page that says it can't get user information. It seems to be an issue with the database, but I can't figure out what's going on. Below is my current docker compose:

version: "3"

services:
  ########################################
  # PostgreSQL
  ########################################
  db:
    image: postgres:14
    container_name: db_postgres
    restart: always
    ports:
      - "5432:5432"
    environment:
      - POSTGRES_DB=${POSTGRES_DB:-readflow}
      - POSTGRES_USER=${POSTGRES_USER:-postgres}
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD:-secert}
    volumes:
      - db-data:/var/lib/postgresql/data

  ########################################
  # readflow
  ########################################
  readflow:
    image: "ncarlier/readflow:edge"
    restart: always
    depends_on:
      - db
    ports:
      - "${PORT:-92}:8080"
    environment:
      - READFLOW_DATABASE_URI=postgres://${POSTGRES_USER:-postgres}:${POSTGRES_PASSWORD:-secert}@db_postgres:5432/${POSTGRES_DB:-readflow}?sslmode=disable
      - READFLOW_AUTHN_METHOD=basic
      - READFLOW_AUTHN_BASIC_HTPASSWD_FILE=file:///var/local/demo.htpasswd # "demo" as username and password
    volumes:
      - path/to/var/demo.htpasswd:/var/local/demo.htpasswd

networks:
  default:

volumes:
  db-data:

readflow container log

2024/08/06 11:52AM fatal error during command execution | error=unable to configure the database: could not validate PostgreSQL connection: dial tcp 172.22.0.2:5432: connect: connection refused command=serve
2024/08/06 11:52AM fatal error during command execution | error=unable to configure the database: could not validate PostgreSQL connection: dial tcp 172.22.0.2:5432: connect: connection refused command=serve
2024/08/06 11:52AM fatal error during command execution | error=unable to configure the database: could not validate PostgreSQL connection: dial tcp 172.22.0.2:5432: connect: connection refused command=serve
2024/08/06 11:52AM WRN Migrating Database... | version=1
2024/08/06 11:52AM WRN Migrating Database... | version=2
2024/08/06 11:52AM WRN Migrating Database... | version=3
2024/08/06 11:52AM WRN Migrating Database... | version=4
2024/08/06 11:52AM WRN Migrating Database... | version=5
2024/08/06 11:52AM WRN Migrating Database... | version=6
2024/08/06 11:52AM WRN Migrating Database... | version=7
2024/08/06 11:52AM WRN Migrating Database... | version=8
2024/08/06 11:52AM WRN Migrating Database... | version=9
2024/08/06 11:52AM WRN Migrating Database... | version=10
2024/08/06 11:52AM WRN Migrating Database... | version=11
2024/08/06 11:52AM WRN Migrating Database... | version=12
2024/08/06 11:52AM WRN Migrating Database... | version=13
2024/08/06 11:52AM WRN Migrating Database... | version=14
2024/08/06 11:52AM WRN Migrating Database... | version=15
2024/08/06 11:52AM INF using PostgreSQL database | component=database uri=postgres://postgres:xxxxx@db_postgres:5432/readflow?sslmode=disable
2024/08/06 11:52AM INF using BoltDB cache | component=cache uri=boltdb:///tmp/readflow-downloads.cache?maxSize=256,maxEntries=5000,maxEntrySize=1
2024/08/06 11:52AM INF properties loaded | component=service rev=1
2024/08/06 11:52AM INF using Basic Authentification | component=auth htpasswd=file:///var/local/demo.htpasswd
2024/08/06 11:52AM INF using Avatar provider | component=api provider=https://robohash.org/{seed}?set=set4&size=48x48
2024/08/06 11:52AM INF starting the server... | component=http addr=:8080

AsixJin avatar Aug 06 '24 16:08 AsixJin