Username or password is incorrect. Try again

Help
1

Hey guys. I am already running the latest version of vaultwarden. So my existing server got crashed due to service provide that i am using i am also using external database from planet scale to store the data i have the data backed up through cron job. So i re-created the vaultwarden server again and gave it new DATABASE url as well (it has all data from cron job). The data is nothing but a dump from the db.And now it is saying that username or password is incorrect.

{
    "ErrorModel": {
        "Message": "Username or password is incorrect. Try again",
        "Object": "error"
    },
    "ExceptionMessage": null,
    "ExceptionStackTrace": null,
    "InnerExceptionMessage": null,
    "Message": "Username or password is incorrect. Try again",
    "Object": "error",
    "ValidationErrors": {
        "": [
            "Username or password is incorrect. Try again"
        ]
    },
    "error": "",
    "error_description": ""
}

this is response from network tab.
Also i checked Bitwarden Crypto link to test the email and master password and the Master Password Hash is exactly same as the password hash send by browser payload.

2

Could be the database is corrupted. Or the dumps or restore didn’t worked well. The password is stored as a blob of binary data. So that can go wrong quickly, als if using the wrong charset or collation if that is different now from the previous db.

3

Thanks for quick reply man.
The database is not corrupted i believe because i have created a new instance of it and it is working fine i can login multiple times the main problem seems either in backup or restore which i am checking.
Is there a way to update the master password some how because if i delete the existing user and re create it all the save passwords will be gone.
Or is there a method to link the new user to existing passwords that will also work.

4

And one more question the password and salt is it store in hexadecimal like
0x and the values because in my db it is showing in this format is it correcct?

5

So i have got the solution it might be planet scale specific idk. So while inserting the password hash and salt insert it using UNHEX function and pass the value and then the master password will work fine. See more in docs