Upgrade from 2.13.5-pro to 3.0.0-pro docker didn't show passwords (with solution)

I’m running an evaluation pro version. After upgrading docker image from 2.13.5 to 3.0.0 passwords didn’t load as mentioned in other post regarding Debian Source-install (didn’t wanna hijack that thread as it seems to relate to gnupg-problems).

  • I got an ever rotating “loading tags”, and the red bar at bottom of screen never comleted.
  • Could not list any passwords.
  • Tried to add passwords, which “failed” with message “could not ‘push’”, but it seems like the password was created regardless, although i couldn’t list them in UI.

Seems like the docker-container failed to migrate database properly. After running this command in container, it worked as expected again:

# su -s /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt cleanup" www-data

     ____                  __          ____
    / __ \____  _____ ____/ /_  ____  / / /_
   / /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
  / ____/ /_/ (__  |__  ) /_/ / /_/ / / /
 /_/    \__,_/____/____/_.___/\____/_/\__/

 Open source password manager for teams
---------------------------------------------------------------
 Cleanup shell (fix mode)
---------------------------------------------------------------
66 issues fixed in table Resources (missing resourcetype id)
66 issues fixed!

Subsequent executions of the commands says: No issues found, data looks squeaky clean!.
I can now see passwords in UI as before, and no additional errors popped up so far.

Reporting here so that other with similar problems might find it useful.

Checklist
[x] I have read intro post: About the Installation Issues category
[x] I have read the tutorials, help and searched for similar issues
[x] I provide relevant information about my server (component names and versions, etc.)
[ ] I provide a copy of my logs and healthcheck
[ ] I describe the steps I have taken to trouble shoot the problem
[ ] I describe the steps on how to reproduce the issue

3 Likes

Thanks for the tip @bjozet ! It was not part of my update tests to consider data not fixed before running the migrations :sweat_smile:

Thanks @bjozet for the report, the issue has been fixed with v3.0.1

Are you sure it is fixed? I had the same problem with 3.1.0 after CE to PRO upgrade on Ubuntu 20.04.

# sudo -H -u www-data bash -c "/usr/share/php/passbolt/bin/cake passbolt cleanup"

     ____                  __          ____
    / __ \____  _____ ____/ /_  ____  / / /_
   / /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
  / ____/ /_/ (__  |__  ) /_/ / /_/ / / /
 /_/    \__,_/____/____/_.___/\____/_/\__/

 Open source password manager for teams
---------------------------------------------------------------
 Cleanup shell (fix mode)
---------------------------------------------------------------
7 issues fixed in table Resources (missing resourcetype id)
7 issues fixed!

@eelke can you confirm you were migrating from 3.1.0 CE to 3.1.0 PRO?

This issue can happen if for example a user is doing an import during the migration from v2 to v3, and some similar edges cases. Would be nice to hear from you exactly what was your scenario.

Yes I was migrating from 3.1.0 CE to 3.1.0 PRO.

However the 3.1.0 CE I setup on a clean Ubuntu 20.04 server last week using a database backup from our previous 2.x server.

Then it could be some records from v2 that were not migrated, for example if you ran the migration then imported the data. Hard to tell. We’ll keep an eye on it, see if we can reproduce it.

I ran the migrations after loading the backup I am sure of that as I forgot and it didn’t work properly until I did. Also ran a new set of migrations during the upgrade to pro as instructed Passbolt Help | Upgrade Passbolt from CE to Pro on Ubuntu