As a User, I would like to download all my encrypted passwords to local storage

Q1. What is the problem that you are trying to solve?
When I am offline, or there is a major network outage which prevents access to the passbolt server, or in case the passbolt server itself dies, I would like to have the passwords on my local filesystem so I can decrypt them with gpg.

Q2 - Who is impacted?
Users who depend on Passbolt for storing network-critical passwords or who have on-call responsibility.

Q3 - Why is it important and/or urgent?
Passbolt already sends out the individual GPG files via E-mail, but I may have deleted those E-mails. In any case, an E-mail client is not a great place to archive them, and manually pasting them into local files each time is tedious.

Q4 - What is your proposed solution? (optional)
I’d like to press a button on the web interface to download either:

  • a zipfile containing all the passwords I have access to, with filenames equal to the password name; or
  • a single long text file containing all the armoured passwords, each one prefaced by metadata

WORKAROUND: a system-level administrator can do this with a SQL query.

Q5. Community support
People can vote for this idea to show traction:

  • :ok_woman: Must have: this is critical for me to have this
  • :raising_hand_woman: Should have: this is important for me to have this
  • :tipping_hand_woman: Could have: this could be nice to have
  • :no_good_woman: Won’t have: we should not schedule this (explain why)
0 voters
1 Like

This query does the job:

mysql> select r.name,r.username,r.uri,r.description,s.modified,concat("\n",s.data) as data
       from users u
       join users_resources_permissions urp on urp.user_id=u.id
       join resources r on urp.resource_id=r.id
       left join secrets s on s.resource_id=r.id and s.user_id=u.id
       where u.username='XXXX@XXXXX' \G

Export is supported since v2.0.1.

1 Like