Trying to put my app out in the wild. Received a Dockerfile from running

mix phx.gen.release --docker

Then on Dokku’s host I mounted a persistent directory and set the DATABASE_PATH env:

dokku config:set --no-restart myapp DATABASE_PATH=/app/storage/db.sqlite3 PHX_HOST=myapp.com SECRET_KEY_BASE=#beforehand do mix phx.gen.secret
dokku storage:ensure-directory myapp
dokku storage:mount myapp /var/lib/dokku/data/storage/myapp:/app/storage

When deploying, I was getting a “database does not exist” error. Therefore made it manually:

sqlite3 /var/lib/dokku/data/storage/myapp/db.sqlite3 "
  PRAGMA journal_mode = WAL;
  PRAGMA auto_vacuum = INCREMENTAL;
  PRAGMA page_size = 4096;
  PRAGMA wal_autocheckpoint = 1000;
  VACUUM;"
# P.S I executed this as root, for better or worse...

However, on another deployment attempt the app still couldn’t connect to this database or run migrations. This time, the error is different:

** (RuntimeError) connect raised MatchError exception. The exception details are hidden, as they may contain sensitive data such as database credentials. You may set :show_sensitive_data_on_connection_error to true when starting your connection if you wish to see all of the details
    (exqlite 0.33.1) lib/exqlite/connection.ex:396: Exqlite.Connection.get_pragma/2
    (exqlite 0.33.1) lib/exqlite/connection.ex:405: Exqlite.Connection.maybe_set_pragma/3
    (exqlite 0.33.1) lib/exqlite/connection.ex:551: Exqlite.Connection.do_connect/2
    (db_connection 2.8.1) lib/db_connection/connection.ex:79: DBConnection.Connection.handle_event/4

Any ideas on why this could be happening?