FATAL: password authentication failed for user "app"

[jz1459]

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]

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.