search

SFTtech / abrechnung

Payment tracking and money splitting for groups 💸
https://abrechnung.readthedocs.io
GNU Affero General Public License v3.0
135 stars 15 forks source link

Failed to create database pool #225

Closed chiel1112 closed 2 months ago

chiel1112 commented 3 months ago

image So, while I am sure that I am just missing something, I can't seem to find what I am missing here to create this error. All I can find is that it has something to do with wrong DNS when googling this issue? However my postgresql and abrechnung config just point towards localhost...

chiel1112 commented 3 months ago

here is my related abrechnung.yaml config: image and here is my postgresql config: image

mikonse commented 3 months ago

The host key in the database section should not contain the port of the database server, there's a separate key in the config to configure the port.

database:
  host: localhost
  user: ...
  password: ...
  dbname: ...
  port: 5433
chiel1112 commented 3 months ago

if i try that it still tries to connect to 5432... image image

chiel1112 commented 3 months ago

in the end i realised that i currently have nothing else running on 5432 anyway so now db migrate does work

However, I still cannot create an user, as it gives this error... image

chiel1112 commented 3 months ago

okay, it did work, but now I can't figure out how to start abrechnung itself... (I did receive an email confirming my account creation, when i executed abrechnung mailer) but cant seem to figure out how to start the web server

TheJJ commented 3 months ago

you need to build the webapp with npx nx build in the frontend directory to get the production build which you then serve with any webserver, e.g. nginx. npx nx serve to get the development build.

chiel1112 commented 3 months ago

and just to confirm, running abrechnung api should just start up the api right, and then the frontend should work?

chiel1112 commented 3 months ago

Because right now when i moved the files (that include the index.html file) to /var/www/html i just get this so i presume my api isn't started? image

TheJJ commented 2 months ago

yes, the api needs to be running as it is contacted by the website/app. you have to provide a config.json in your web root, you can copy and edit it from the example config (currently in frontend/apps/web/src/assets/config.json