starred/vaultwarden
1
0
Fork 0
mirror of https://github.com/dani-garcia/vaultwarden.git synced 2026-04-26 09:46:00 +03:00
Code Issues 39 Projects Releases 5 Packages Wiki Activity

[GH-ISSUE #4203] Can't login after migrating db from mysql to postgresql using pgloader #1821

New issue
Closed
opened 2026-03-03 02:12:30 +03:00 by kerem · 1 comment
kerem commented 2026-03-03 02:12:30 +03:00
Owner
Copy link

Originally created by @MurzNN on GitHub (Dec 27, 2023).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/4203

Subject of the issue

I want to migrate the Vaultwarden db from mysql to postgresql using pgloader. I did the steps, described in https://github.com/dani-garcia/vaultwarden/wiki/Using-the-PostgreSQL-Backend and the data seems migrated successfully.
The vaultwarden starts successfully without any startup errors.

But when I'm trying to log in using Web UI, I see an error:

Username or password is incorrect. Try again

The data migrated correctly and I see the row with my login in the users table in postgresql DB.

And if I switch back to mysql, it logs in successfully.

Deployment environment

  • vaultwarden version: 1.30.0
  • Install method:Docker image
  • Clients used: web vault
  • Reverse proxy and version: none
  • MySQL/MariaDB or PostgreSQL version: MariaDB 10.5, PostgreSQL 15

Steps to reproduce

  1. Get a working MySQL db.
  2. Migrate it to PostgreSQL using pgloader.
  3. Start vaultwarden and try to log in.

Expected behaviour

Log-in should succeed.

Actual behaviour

The error is shown.

Troubleshooting data

logs:

[2023-12-27 12:51:16.122][start][INFO] Rocket has launched from http://0.0.0.0:8080
[2023-12-27 12:51:16.791][request][INFO] GET /api/config
[2023-12-27 12:51:16.791][response][INFO] (config) GET /api/config => 200 OK
[2023-12-27 12:51:17.829][request][INFO] GET /api/devices/knowndevice
[2023-12-27 12:51:17.836][response][INFO] (get_known_device) GET /api/devices/knowndevice => 200 OK
[2023-12-27 12:51:22.336][request][INFO] POST /identity/accounts/prelogin
[2023-12-27 12:51:22.350][response][INFO] (prelogin) POST /identity/accounts/prelogin => 200 OK
[2023-12-27 12:51:22.415][request][INFO] POST /identity/connect/token
[2023-12-27 12:51:22.416][vaultwarden::api::identity][ERROR] Username or password is incorrect. Try again. IP: 1.2.3.4. Username: my-username@mycompany.com.
[2023-12-27 12:51:22.417][response][INFO] (login) POST /identity/connect/token => 400 Bad Request
Originally created by @MurzNN on GitHub (Dec 27, 2023). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/4203 ### Subject of the issue I want to migrate the Vaultwarden db from mysql to postgresql using pgloader. I did the steps, described in https://github.com/dani-garcia/vaultwarden/wiki/Using-the-PostgreSQL-Backend and the data seems migrated successfully. The `vaultwarden` starts successfully without any startup errors. But when I'm trying to log in using Web UI, I see an error: ``` Username or password is incorrect. Try again ``` The data migrated correctly and I see the row with my login in the `users` table in postgresql DB. And if I switch back to mysql, it logs in successfully. ### Deployment environment * vaultwarden version: 1.30.0 * Install method:Docker image * Clients used: web vault * Reverse proxy and version: none * MySQL/MariaDB or PostgreSQL version: MariaDB 10.5, PostgreSQL 15 ### Steps to reproduce 1. Get a working MySQL db. 2. Migrate it to PostgreSQL using `pgloader`. 3. Start vaultwarden and try to log in. ### Expected behaviour Log-in should succeed. ### Actual behaviour The error is shown. ### Troubleshooting data logs: ``` [2023-12-27 12:51:16.122][start][INFO] Rocket has launched from http://0.0.0.0:8080 [2023-12-27 12:51:16.791][request][INFO] GET /api/config [2023-12-27 12:51:16.791][response][INFO] (config) GET /api/config => 200 OK [2023-12-27 12:51:17.829][request][INFO] GET /api/devices/knowndevice [2023-12-27 12:51:17.836][response][INFO] (get_known_device) GET /api/devices/knowndevice => 200 OK [2023-12-27 12:51:22.336][request][INFO] POST /identity/accounts/prelogin [2023-12-27 12:51:22.350][response][INFO] (prelogin) POST /identity/accounts/prelogin => 200 OK [2023-12-27 12:51:22.415][request][INFO] POST /identity/connect/token [2023-12-27 12:51:22.416][vaultwarden::api::identity][ERROR] Username or password is incorrect. Try again. IP: 1.2.3.4. Username: my-username@mycompany.com. [2023-12-27 12:51:22.417][response][INFO] (login) POST /identity/connect/token => 400 Bad Request ```
kerem closed this issue 2026-03-03 02:12:30 +03:00
kerem commented 2026-03-03 02:12:31 +03:00
Author
Owner
Copy link

@MurzNN commented on GitHub (Dec 27, 2023):

Logs with the trace level:

[2023-12-27 13:00:46.262][tracing::span][TRACE] parse_headers;
[2023-12-27 13:00:46.263][tracing::span::active][TRACE] -> parse_headers;
[2023-12-27 13:00:46.263][tracing::span::active][TRACE] <- parse_headers;
[2023-12-27 13:00:46.263][tracing::span][TRACE] -- parse_headers;
[2023-12-27 13:00:46.263][request][INFO] POST /identity/accounts/prelogin
[2023-12-27 13:00:46.310][response][INFO] (prelogin) POST /identity/accounts/prelogin => 200 OK
[2023-12-27 13:00:46.311][tracing::span][TRACE] encode_headers;
[2023-12-27 13:00:46.311][tracing::span::active][TRACE] -> encode_headers;
[2023-12-27 13:00:46.311][tracing::span::active][TRACE] <- encode_headers;
[2023-12-27 13:00:46.311][tracing::span][TRACE] -- encode_headers;
[2023-12-27 13:00:46.763][tracing::span][TRACE] parse_headers;
[2023-12-27 13:00:46.763][tracing::span::active][TRACE] -> parse_headers;
[2023-12-27 13:00:46.763][tracing::span::active][TRACE] <- parse_headers;
[2023-12-27 13:00:46.763][tracing::span][TRACE] -- parse_headers;
[2023-12-27 13:00:46.763][request][INFO] POST /identity/connect/token
[2023-12-27 13:00:46.766][rocket::form::parser::_][TRACE] url-encoded field: ("scope", "api%20offline_access")
[2023-12-27 13:00:46.767][rocket::form::parser::_][TRACE] url-encoded field: ("client_id", "web")
[2023-12-27 13:00:46.767][rocket::form::parser::_][TRACE] url-encoded field: ("deviceType", "10")
[2023-12-27 13:00:46.767][rocket::form::parser::_][TRACE] url-encoded field: ("deviceIdentifier", "de892a44-54c6-4950-8232-e69de1f2e038")
[2023-12-27 13:00:46.767][rocket::form::parser::_][TRACE] url-encoded field: ("deviceName", "firefox")
[2023-12-27 13:00:46.768][rocket::form::parser::_][TRACE] url-encoded field: ("grant_type", "password")
[2023-12-27 13:00:46.768][rocket::form::parser::_][TRACE] url-encoded field: ("username", "my-username%40mycompany.com")
[2023-12-27 13:00:46.768][rocket::form::parser::_][TRACE] url-encoded field: ("password", "XXXXXXXXvwoBuaG1RHxYc4RzKRvpXr2ZLqK6NjCPivg%3D")
[2023-12-27 13:00:46.969][vaultwarden::api::identity][ERROR] Username or password is incorrect. Try again. IP: 1.2.3.4. Username: my-username@mycompany.com.
[2023-12-27 13:00:46.969][response][INFO] (login) POST /identity/connect/token => 400 Bad Request
[2023-12-27 13:00:46.969][tracing::span][TRACE] encode_headers;
[2023-12-27 13:00:46.969][tracing::span::active][TRACE] -> encode_headers;
[2023-12-27 13:00:46.969][tracing::span::active][TRACE] <- encode_headers;
[2023-12-27 13:00:46.969][tracing::span][TRACE] -- encode_headers;
<!-- gh-comment-id:1870287645 --> @MurzNN commented on GitHub (Dec 27, 2023): Logs with the `trace` level: ``` [2023-12-27 13:00:46.262][tracing::span][TRACE] parse_headers; [2023-12-27 13:00:46.263][tracing::span::active][TRACE] -> parse_headers; [2023-12-27 13:00:46.263][tracing::span::active][TRACE] <- parse_headers; [2023-12-27 13:00:46.263][tracing::span][TRACE] -- parse_headers; [2023-12-27 13:00:46.263][request][INFO] POST /identity/accounts/prelogin [2023-12-27 13:00:46.310][response][INFO] (prelogin) POST /identity/accounts/prelogin => 200 OK [2023-12-27 13:00:46.311][tracing::span][TRACE] encode_headers; [2023-12-27 13:00:46.311][tracing::span::active][TRACE] -> encode_headers; [2023-12-27 13:00:46.311][tracing::span::active][TRACE] <- encode_headers; [2023-12-27 13:00:46.311][tracing::span][TRACE] -- encode_headers; [2023-12-27 13:00:46.763][tracing::span][TRACE] parse_headers; [2023-12-27 13:00:46.763][tracing::span::active][TRACE] -> parse_headers; [2023-12-27 13:00:46.763][tracing::span::active][TRACE] <- parse_headers; [2023-12-27 13:00:46.763][tracing::span][TRACE] -- parse_headers; [2023-12-27 13:00:46.763][request][INFO] POST /identity/connect/token [2023-12-27 13:00:46.766][rocket::form::parser::_][TRACE] url-encoded field: ("scope", "api%20offline_access") [2023-12-27 13:00:46.767][rocket::form::parser::_][TRACE] url-encoded field: ("client_id", "web") [2023-12-27 13:00:46.767][rocket::form::parser::_][TRACE] url-encoded field: ("deviceType", "10") [2023-12-27 13:00:46.767][rocket::form::parser::_][TRACE] url-encoded field: ("deviceIdentifier", "de892a44-54c6-4950-8232-e69de1f2e038") [2023-12-27 13:00:46.767][rocket::form::parser::_][TRACE] url-encoded field: ("deviceName", "firefox") [2023-12-27 13:00:46.768][rocket::form::parser::_][TRACE] url-encoded field: ("grant_type", "password") [2023-12-27 13:00:46.768][rocket::form::parser::_][TRACE] url-encoded field: ("username", "my-username%40mycompany.com") [2023-12-27 13:00:46.768][rocket::form::parser::_][TRACE] url-encoded field: ("password", "XXXXXXXXvwoBuaG1RHxYc4RzKRvpXr2ZLqK6NjCPivg%3D") [2023-12-27 13:00:46.969][vaultwarden::api::identity][ERROR] Username or password is incorrect. Try again. IP: 1.2.3.4. Username: my-username@mycompany.com. [2023-12-27 13:00:46.969][response][INFO] (login) POST /identity/connect/token => 400 Bad Request [2023-12-27 13:00:46.969][tracing::span][TRACE] encode_headers; [2023-12-27 13:00:46.969][tracing::span::active][TRACE] -> encode_headers; [2023-12-27 13:00:46.969][tracing::span::active][TRACE] <- encode_headers; [2023-12-27 13:00:46.969][tracing::span][TRACE] -- encode_headers; ```
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
revert-7033-patch-1
cached-config-operations
test_dylint
1.35.8
1.35.7
1.35.6
1.35.5
1.35.4
1.35.3
1.35.2
1.35.1
1.35.0
1.34.3
1.34.2
1.34.1
1.34.0
1.33.2
1.33.1
1.33.0
1.32.7
1.32.6
1.32.5
1.32.4
1.32.3
1.32.2
1.32.1
1.32.0
1.31.0
1.30.5
1.30.4
1.30.3
1.30.2
1.30.1
1.30.0
1.29.2
1.29.1
1.29.0
1.28.1
1.28.0
1.27.0
1.26.0
1.25.2
1.25.1
1.25.0
1.24.0
1.23.1
1.23.0
1.22.2
1.22.1
1.22.0
1.21.0
1.20.0
1.19.0
1.18.0
1.17.0
1.16.3
1.16.2
1.16.1
1.16.0
1.15.1
1.15.0
1.14.2
1.14.1
1.14
1.13.1
1.13.0
1.12.0
1.11.0
1.10.0
1.9.1
1.9.0
1.8.0
1.7.0
1.6.1
1.6.0
1.5.0
1.4.0
1.3.0
1.2.0
1.1.0
1.0.0
0.13.0
0.12.0
0.11.0
0.10.0
0.9.0
Labels
Clear labels   
SSO

   
Third party

   
better for forum

   
bug

   
bug

   
documentation

   
duplicate

   
enhancement

   
future Vault

   
future Vault

   
future Vault

   
good first issue

   
help wanted

   
low priority

   
notes

   
pull-request

Mirrored from GitHub Pull Request

  
question

   
troubleshooting

   
wontfix
No labels
SSO
Third party
better for forum
bug
bug
documentation
duplicate
enhancement
future Vault
future Vault
future Vault
good first issue
help wanted
low priority
notes
pull-request
question
troubleshooting
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/vaultwarden#1821
No description provided.