thilojaeggi / WinGetty

An open source REST Backend for creating a private WinGet Repo without having to rely on cloud dependencies.
https://wingetty.dev
GNU Affero General Public License v3.0
185 stars 17 forks source link

Problems with postgres as db server #31

Closed hschmidt-dev closed 10 months ago

hschmidt-dev commented 10 months ago

I try to setup wingetty using postgres 16 container as db server. There seem to be 2 problems:

  1. Python module psycopg2-binary is missing in requirements.txt
  2. Authentication against db server does not work with error message: "fe_sendauth: no password supplied"

I added the password using WINGETTY_SECRET_KEY variable. But this seems not to be used for db server authentication.

thilojaeggi commented 10 months ago

The credentials needs to be provided in the connection uri like so postgresql+psycopg2://scott:tiger@localhost:5432/mydatabase. This will not work in the current version though as it's lacking pyscopg2-binary, will work in v0.0.8 though.

thilojaeggi commented 10 months ago

Should work now in v0.0.8

thilojaeggi commented 10 months ago

Were you able to test it yet?