No worries, there is a way around that.
- Request the recovery email to be sent even though it won’t go anywhere
- Log into the server, and then the database, and be sure to use the passbolt database if you don’t default into that one
- Run this query:
- select email, subject, template_vars from email_queue order by created desc limit 3;
- I chose 3 here in case someone else tries to recover their account too
- select email, subject, template_vars from email_queue order by created desc limit 3;
Your output should look something like the below, I’ve bolded two important fields which you’ll need:
| clayton@passbolt.local | Your account recovery, C! | {“body”:{“user”:{“id”:“73a51858-0435-47d5-bc7f-62eb7ff10590”,“role_id”:“15537ea1-46cd-4e12-b2f9-a50c818b60a2”,“username”:“clayton@passbolt.local”,“active”:true,“deleted”:false,“created”:“2022-11-21T11:15:48+00:00”,“modified”:“2023-02-15T15:50:34+00:00”,“profile”:{“id”:“865a9a8d-60e8-4a11-bf05-f26ea6aa2a2b”,“user_id”:“73a51858-0435-47d5-bc7f-62eb7ff10590”,“first_name”:“C”,“last_name”:“S”,“created”:“2022-11-21T11:15:48+00:00”,“modified”:“2023-02-15T15:50:34+00:00”,“avatar”:{“id”:“2b814079-edc8-4739-9b97-235ea03b05bc”,“profile_id”:“865a9a8d-60e8-4a11-bf05-f26ea6aa2a2b”,“created”:“2023-01-02T11:56:55+00:00”,“modified”:“2023-02-15T15:50:34+00:00”,“url”:{“medium”:“https://passbolt.local/avatars/view/2b814079-edc8-4739-9b97-235ea03b05bc/medium.jpg”,“small”:“https://passbolt.local/avatars/view/2b814079-edc8-4739-9b97-235ea03b05bc/small.jpg”}}},“role”:{“id”:“15537ea1-46cd-4e12-b2f9-a50c818b60a2”,“name”:“admin”,“description”:“Organization administrator”,“created”:“2012-07-04T13:39:25+00:00”,“modified”:“2012-07-04T13:39:25+00:00”},“last_logged_in”:null},“token”:{" user_id":“73a51858-0435-47d5-bc7f-62eb7ff10590”," token":“98cec5d3-5b87-4ec7-8aad-cafe0cf9b6e3”,“active”:true,“type”:“recover”,“data”:null,“created”:“2023-02-17T13:37:07+00:00”,“modified”:“2023-02-17T13:37:07+00:00”,“id”:“b0dffa11-8e9c-4434-878d-4ed22d9a107b”},“case”:“default”,“fullBaseUrl”:“https://passbolt.local”},“title”:“Your account recovery, C!”,“locale”:“en-UK”} |
- Craft your recovery URL with this template:
https://<your_URL>/setup/recover/<user_id>/<token>- For example with the output above mine looks like:
- Paste your URL in the browser and proceed with the login
You should then be able to go to the Administration settings to correct the email issue