no password when update to 1.11.0
-
@luckow thanks for digging this out - I just realized I have vaultwarden broken since the latest update, which is happened at 24th of Dec for me.
Here is the short instructions and extract based on @luckow findings:
On Web GUI:
- go the app
- click terminal
Now on the terminal:
echo ${CLOUDRON_MYSQL_DATABASE} # note the output - it's 35629ca3ac8992ec in my case mysql --user=${CLOUDRON_MYSQL_USERNAME} --password=${CLOUDRON_MYSQL_PASSWORD} --host=${CLOUDRON_MYSQL_HOST} ${CLOUDRON_MYSQL_DATABASE}Now starts making database voddoo - make sure you have database backup first.
SELECT * FROM information_schema.SCHEMATA WHERE schema_name = "35629ca3ac8992ec"; SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;') AS CharSetConvert FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="35629ca3ac8992ec" AND TABLE_TYPE="BASE TABLE"; ALTER DATABASE `35629ca3ac8992ec` CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; SET foreign_key_checks = 0; /* execute all queries from CharSetConvert output earlier here */ ALTER TABLE `__diesel_schema_migrations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `attachments` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `ciphers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `ciphers_collections` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `collections` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `collections_groups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `devices` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `emergency_access` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `event` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `favorites` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `folders` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `folders_ciphers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `groups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `groups_users` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `invitations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `org_policies` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `organizations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `sends` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `twofactor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `twofactor_incomplete` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `users` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `users_collections` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; ALTER TABLE `users_organizations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; SET foreign_key_checks = 1; /* verify CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci is on the place */Now restart the app (via big button at the top of the terminal).
@girish , guess Vaultwarden 1.27.0 is a braking change and/or the patch before updating is required (as per above).
-
@potemkin_ai I wonder why I seemingly haven't hit this issue though
@jdaviescoates random thought: how old is your cloudron instance?
Mine is from the around of the middle of the year 2022, migrated via export/import from an older one. -
@jdaviescoates random thought: how old is your cloudron instance?
Mine is from the around of the middle of the year 2022, migrated via export/import from an older one.@potemkin_ai I quite recently (Nov 2022) migrated to a new server, so I guess it's pretty new.
I'm also on Ubuntu 20.04.5 LTS, you?
-
@jdaviescoates random thought: how old is your cloudron instance?
Mine is from the around of the middle of the year 2022, migrated via export/import from an older one.@potemkin_ai good question
i recently installed cloudron on a fresh
"Welcome to Ubuntu 22.04.1 LTS (GNU/Linux 5.15.0-56-generic x86_64)" instance installed at hetzner. -
@potemkin_ai I wonder why I seemingly haven't hit this issue though
@jdaviescoates said in no password when update to 1.11.0:
@potemkin_ai I wonder why I seemingly haven't hit this issue though
Me neither. My instance is 4-5 years old including Ubuntu migrations from 18.04 -> 20.04 -> 22.04, had Bitwarden since the beginning incl. organizations.
-
@potemkin_ai I quite recently (Nov 2022) migrated to a new server, so I guess it's pretty new.
I'm also on Ubuntu 20.04.5 LTS, you?
@jdaviescoates , @luckow , @necrevistonnezr , it was just a wild guess - it feels like it must be somehow connected to the software updates, since it impact only a small fraction of the users.
Might be just some random bug...
-
Our company and my personal installation is quite old as well (~4 years or so). I wonder why we don't hit this. Let me investigate quickly to see if this is something obvious.
@girish thanks for prompt reaction!
-
@JOduMonT just a double check to get a better idea of the setting for the reproducible support problem:
- do you use a browser plugin?
- do you have an organization?
- do you store the password only in the organization?
- is the organization and the number of passwords displayed in vaultwarden.example.org/admin? (no idea how to get access to /admin => https://docs.cloudron.io/apps/vaultwarden/)
@luckow said in no password when update to 1.11.0:
do you use a browser plugin?
password disappears after updating via the browser (webapp) and the app in the browser (plugin) and in my androids don't sync anymore
do you have an organization?
NO
do you store the password only in the organization?
NO
is the organization and the number of passwords displayed in vaultwarden.example.org/admin? (no idea how to get access to /admin => https://docs.cloudron.io/apps/vaultwarden/)
NO
my Cloudron is update to date on an Ubuntu 20.04LTS; no change or weird configuration as been done.
-
I'm still not at all clear what the actual issue(s) people are facing is, but so far I've not noticed anything wrong with my Vaultwarden (on the latest Cloudron versions, which it sounds like everyone having issues also is).
It'd be useful if people could perhaps post screenshots of what they are (not) seeing
@jdaviescoates said in no password when update to 1.11.0:
I'm still not at all clear what the actual issue(s) people are facing is, but so far I've not noticed anything wrong with my Vaultwarden (on the latest Cloudron versions, which it sounds like everyone having issues also is).
with 1.26.0 I have password
while with 1.27.0 I don't have passwordPASSWORD + SYNC OK
App Title and VersionVaultwarden 1.26.0
App ID4584d250-1515-4380-be5b-87a4ab3cd92d
Package Repositorycore
Package Versioncom.github.bitwardenrs@1.10.2
Last Updated4 days agosorry for your eyes; my internet is too bad right now for uploading screenshot
NO PASSWORD + SYNC FAIL
App Title and VersionVaultwarden 1.27.0
App ID4584d250-1515-4380-be5b-87a4ab3cd92d
Package Repositorycore
Package Versioncom.github.bitwardenrs@1.11.0
Last Updated2 minutes ago -
I'm still not at all clear what the actual issue(s) people are facing is, but so far I've not noticed anything wrong with my Vaultwarden (on the latest Cloudron versions, which it sounds like everyone having issues also is).
It'd be useful if people could perhaps post screenshots of what they are (not) seeing
@jdaviescoates said in no password when update to 1.11.0:
screenshots
Old school screenshots
Before update: https://ibb.co/0BNyck3
Update: https://ibb.co/3dD9P5c
After update: https://ibb.co/9bCS731
Restore backup = everything is back -
Even with the new update, the issue remain
Ubuntu: 22.04 LTS @Hetzner
Cloudron: v7.3.4 (Ubuntu 22.04.1 LTS)I have password
with the bitwarden icon
App: Vaultwarden 1.26.0
Package: com.github.bitwardenrs@1.10.2
I don't have password and sync fail
with the vaultwarden icon
Application: Vaultwarden 1.27.0
Package: com.github.bitwardenrs@1.11.0
-
Even with the new update, the issue remain
Ubuntu: 22.04 LTS @Hetzner
Cloudron: v7.3.4 (Ubuntu 22.04.1 LTS)I have password
with the bitwarden icon
App: Vaultwarden 1.26.0
Package: com.github.bitwardenrs@1.10.2
I don't have password and sync fail
with the vaultwarden icon
Application: Vaultwarden 1.27.0
Package: com.github.bitwardenrs@1.11.0
-
@JOduMonT You might consider trying one of the following tools for screenshotting and using their masking/pixelating/painting options:
- Flameshot
- ShareX (which works with XbackBone
@LoudLemur said in no password when update to 1.11.0:
@JOduMonT You might consider trying one of the following tools for screenshotting and using their masking/pixelating/painting options:
Flameshot
ShareX (which works with XbackBonewhy you don't like my style
I'm using the Mac of My wife via a hotspot
Still have issue with my Internet at Home so I don't have access to my Desktop. -
Even with the new update, the issue remain
Ubuntu: 22.04 LTS @Hetzner
Cloudron: v7.3.4 (Ubuntu 22.04.1 LTS)I have password
with the bitwarden icon
App: Vaultwarden 1.26.0
Package: com.github.bitwardenrs@1.10.2
I don't have password and sync fail
with the vaultwarden icon
Application: Vaultwarden 1.27.0
Package: com.github.bitwardenrs@1.11.0
@JOduMonT there is no new update for the Vaultwarden app. To fix "your" problem, you need to follow the steps described here by potemkin_ai -> https://forum.cloudron.io/topic/8327/no-password-when-update-to-1-11-0/17?_=1673358163784
-
L luckow referenced this topic on
-
J JOduMonT marked this topic as a question on
-
J JOduMonT has marked this topic as solved on
-
@LoudLemur said in no password when update to 1.11.0:
@JOduMonT You might consider trying one of the following tools for screenshotting and using their masking/pixelating/painting options:
Flameshot
ShareX (which works with XbackBonewhy you don't like my style
I'm using the Mac of My wife via a hotspot
Still have issue with my Internet at Home so I don't have access to my Desktop.@JOduMonT said in no password when update to 1.11.0:
@LoudLemur said in no password when update to 1.11.0:
@JOduMonT You might consider trying one of the following tools for screenshotting and using their masking/pixelating/painting options:
Flameshot
ShareX (which works with XbackBonewhy you don't like my style
I'm using the Mac of My wife via a hotspot
Still have issue with my Internet at Home so I don't have access to my Desktop.HAha! JOduMonT - you have GREAT style!
-
I think I found the issue here. When cloudron creates a mysql database the default collation order is
utf8mb4_0900_ai_ci. This is to match the MySQL 8 default - https://dev.mysql.com/doc/mysqld-version-reference/en/optvar-changes-8-0.html . When restoring, it creates the database with collation orderutf8mb4_0900_ci. This was an oversight and I have fixed this for the next release. -
I think I found the issue here. When cloudron creates a mysql database the default collation order is
utf8mb4_0900_ai_ci. This is to match the MySQL 8 default - https://dev.mysql.com/doc/mysqld-version-reference/en/optvar-changes-8-0.html . When restoring, it creates the database with collation orderutf8mb4_0900_ci. This was an oversight and I have fixed this for the next release.@girish thanks for finding and sharing a root cause!
My instance went through the restore indeed.
-
if I restore my vaultwarden on Version 2022.10.2 my password are their
as soon it updates and the container restart I lose all my password and I cannot import my backup- package: v1.10.2 == password
- package: v1.11.0 == no password
