Chrome/Firefox 3.0.0 Can't access passwords or users

[nourcy]

##IMPORTANT: PLEASE READ

For users that are facing issue to access password or user workspace since the update of the browser extension to version 3.0.0 please have a look at the community forum of Passbolt:
https://community.passbolt.com/t/browser-extension-v3-0-0-data-issues-identified-for-users-using-passbolt-since-v1/3471

Thanks for the understanding, I leave this one open for the time being.

[rcrdo520]

I'm sorry to say that, but this fix isn't working for the users tab. :(
Is there a simple tweak to get this fixed as well?

[garrettboone]

extension is now v3.0.2 @rcrdo520 please confirm this is with update thanks

[rcrdo520]

I have 3.0.2 installed/updated Chrome. Still not working. :(

[garrettboone]

@rcrdo520 Can you look for errors in the extension debug? We can try to identify what it is related to.

[rcrdo520]

@garrettboone Could you give me a hint to find the extension debug log? :S

[garrettboone]

@rcrdo520 Enter chrome://extensions/ in address bar, and set the Developer Mode option to enabled. Click on the Passbolt Extension Details and then look for index.html under "Inspect Views".

[rcrdo520]

@garrettboone Got it, thanks. :)

[nourcy]

@rcrdo520 someone on the forum fix it on the database
https://community.passbolt.com/t/browser-extension-v3-0-0-data-issues-identified-for-users-using-passbolt-since-v1/3471
basically you need to look at the gpgkeys table to see if there is NULL in the columns bits and type and replace it (based on your server config). Like
UPDATE gpgkeys SET bits = 2048 WHERE bits is NULL;
UPDATE gpgkeys SET type ='RSA' WHERE type is NULL;

[rcrdo520]

worked! thanks. :)

[sblandford]

I had NULL bits and type fields in the gpgkeys table. But that wasn't enough to fix it for me. There was also a NULL as a group_id in the group_users table. Just pasted a valid group id into the field and the plugin is now showing users again. No idea how it got that way. I can't see anyone else experiencing the same issue outside of gpgkeys.

I am running Passbolt 2.13.5 on the server.

[nourcy]

Hi @sblandford,

Did you try to exec the cleanup on your instance?
sudo -H -u www-data bash -c "./bin/cake passbolt cleanup"

Best,
Max

[sblandford]

Hi Max, Yes, but only after I fixed it manually. I know now for the future :) Kind regards, Simon *Simon Blandford *Infrastructure Architecture +44 7791 252 040 | simon.blandford@onepointltd.com <mailto:simon.blandford@onepointltd.com>| onepointltd.com <https://www.onepointltd.com/>

…

On 28/01/2021 11:52, Maxence wrote: Hi @sblandford <https://github.com/sblandford>, Did you try to exec the cleanup on your instance? |sudo -H -u www-data bash -c "./bin/cake passbolt cleanup"| Best, Max — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#116 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABDFBP54HHINNWQQYZCW6UDS4FFZTANCNFSM4WVI3CRQ>.

-- This message contains confidential information. If you are not the intended recipient, please notify the sender and delete the message immediately. Onepoint Consulting Ltd is a limited liability company registered in England and Wales (registered number 05516457) and whose registered office is at Onepoint Consulting Ltd, Alpha House, Unit 14, 100 Villiers Road, London NW2 5PJ.

[cedricalfonsi]

Fixed with v3.0.4

[ghoebilly]

The cleanup command on the API fixed it for me. Thanks Max.

Docker non rootless here
sudo docker exec -it passbolt ./bin/cake passbolt cleanup

3.1 Firefox extension was working with latest v2 API.
Extension was failing to list passwords after upgrading the API to 3.0 then 3.1.
Clean up on backend fixed everything.

Probably resources related :

34 issues fixed in table Permissions (soft deleted resources)
34 issues fixed in table Secrets (soft deleted resources)
368 issues fixed in table Resources (missing resourcetype id)
436 issues fixed!