Can't access Credentials-Webinterface after upgrade about postal HOT 5 CLOSED

Could you attach some Logs please?
Also did you followed https://docs.postalserver.io/install/upgrade-to-v2 ?

from postal.

I found some log entries, related to this issue by using this command:

docker logs postal_web_1

Log:

This shows in the sql database "postal", table "credentials":

This is the table description:

I cant see any error in the database. I searched the web for "uuid" - does postal use uuidtools?

https://geekhmer.github.io/blog/2014/12/06/using-uuid-as-primary-key-in-ruby-on-rails-with-mysql-guide/

I did follow the instructions for upgrading via new installation (Section "Installing on a new server with existing data"). Before i follow the instruction for a new installation (also Prerequisites), but skipped the following commands:

postal initialize postal make-user

Restored the sql dump from the old version at this point, and then started postal

from postal.

From your table description I'm missing the uuid field. Take a look into the schema from postal for v2.
https://github.com/postalserver/postal/blob/main/db/schema.rb#L60

Added with https://github.com/postalserver/postal/blob/main/db/migrate/20200717083943_add_uuid_to_credentials.rb

from postal.

Thank you very much for pointing that out.
It is not mentioned in the documentation (Section "Installing on a new server with existing data"), that after restoring the databases, its necessary to perform a database migration.

I solved the issue by executing:

docker exec -it postal_web_1 bash
bin/rails db:migrate

from postal.

If you'd like to open a PR in the docs repo to add the missing text then that would be appreciated

from postal.