search

fineprint-global / mrio-viewer

A set of tools that allow for interactive visualization of input-output tables.
GNU General Public License v3.0
10 stars 1 forks source link

FATAL: password authentication failed for user "app" #24

Open jz1459 opened 2 years ago

jz1459 commented 2 years ago

Hi there,

I'm trying to run the mrio-viewer and have hopefully followed the steps listed on the readme properly. However, after downloading the necessary dependencies and opening the docker container in a browser, I run into this error: An error has occurred The application failed to start. The application exited during initialization.

Going into the shiny error logs I see this message: Error in postgresqlNewConnection(drv, ...) : RS-DBI driver: (could not connect app@ioviz_db:5432 on dbname "fabio": FATAL: password authentication failed for user "app" ) Calls: runApp ... -> -> postgresqlNewConnection Execution halted

I copied the .Renviron file from the Readme directly: db_host=ioviz_db db_port=5432 db_name=fabio db_user=app db_password=appuserpassword

Thus, I am confused as to what the proper password is, or if there was a step I messed up setting up the docker image.

Thank you for all your help!

Gutschlhofer commented 2 years ago

Hello, thanks for reaching out!

As the error message indicates, there is something wrong with the database - before running the app you need to start it and fill it with data. As described in the README, you will need to get the files for the MRIO database yourself, either the FABIO files or other files.

I hope this helps, let me know if you have any other questions/issues!

EDIT: one more thing: you need to set environment variables for the passwords via the .env file, the "appuserpassword" is just a placeholder for the actual password.