When using Workbench with a Postgres database, there may be occurrences when you see the error below:
[rserver] ERROR encryption error 1 (Cannot decrypt password due to mismatched keys, encryption key hash (00000000), decryption key hash (00000000));
This occurs when there is a key mismatch, typically, when the decryption key doesn't match the encryption key. The solution for this is to re-encrypt the password as below:
1. Run the command
sudo rstudio-server encrypt-password and enter the PostgreSQL password.
2. Copy the resulting encrypted password printed in the terminal.
3. Add or replace the password option in the database.conf file using the encrypted password copied above.
4. Restart Workbench with
If you still have issues after completing the above, you can always lodge a support ticket, where our group of friendly, and incredibly knowledgeable staff can assist with any issues that you may be having. You can submit a ticket here: