[GH-ISSUE #99] Restoring OpenID users is a problem #5965

Closed
opened 2026-04-20 16:25:36 -05:00 by GiteaMirror · 3 comments
Owner

Originally created by @aleprovencio on GitHub (Dec 8, 2023).
Original GitHub issue: https://github.com/go-vikunja/vikunja/issues/99

Description

Hi,

I have my vikunja configured to use authelia's OpenID, and this is way I authenticate.

I was first surprised that I could not set a password for this account and also about the fact that it is not possible to link this account with other existing accounts.

I usually use this approach in other apps so I'm still able to log in without having to authenticate via authelia.

But anyways, authenticating with authelia was working fine, until I needed to restore the database from a backup.

The restoring process is fine, but when I try to connect to the restored account, vikunja creates a new one, so I'm locked out.

I've also tried changing the password for this account via the CLI, but that also results in an error.

Vikunja Frontend Version

0.21.0

Vikunja API Version

0.21.0

Browser and version

No response

Can you reproduce the bug on the Vikunja demo site?

No

Screenshots

No response

Originally created by @aleprovencio on GitHub (Dec 8, 2023). Original GitHub issue: https://github.com/go-vikunja/vikunja/issues/99 ### Description Hi, I have my `vikunja` configured to use `authelia`'s `OpenID`, and this is way I authenticate. I was first surprised that I could not set a password for this account and also about the fact that it is not possible to link this account with other existing accounts. I usually use this approach in other apps so I'm still able to log in without having to authenticate via `authelia`. But anyways, authenticating with `authelia` was working fine, until I needed to restore the database from a backup. The restoring process is fine, but when I try to connect to the restored account, `vikunja` creates a new one, so I'm locked out. I've also tried changing the password for this account via the `CLI`, but that also results in an error. ### Vikunja Frontend Version 0.21.0 ### Vikunja API Version 0.21.0 ### Browser and version _No response_ ### Can you reproduce the bug on the Vikunja demo site? No ### Screenshots _No response_
GiteaMirror added the bug label 2026-04-20 16:25:36 -05:00
Author
Owner

@kolaente commented on GitHub (Dec 12, 2023):

Just to confirm I understood you correctly: You restored your Vikunja instance from a backup and when you now try to log in again, you now have a new user instead of the existing one?

If that's the case, can you check if the issuer and subject in the users table are different for the old and new user?

<!-- gh-comment-id:1852837400 --> @kolaente commented on GitHub (Dec 12, 2023): Just to confirm I understood you correctly: You restored your Vikunja instance from a backup and when you now try to log in again, you now have a new user instead of the existing one? If that's the case, can you check if the `issuer` and `subject` in the `users` table are different for the old and new user?
Author
Owner

@aleprovencio commented on GitHub (Dec 13, 2023):

Yes it does create a new user, where issuer records are the same (authelia.mydomain) but subject ones are not.

<!-- gh-comment-id:1853811662 --> @aleprovencio commented on GitHub (Dec 13, 2023): Yes it does create a new user, where `issuer` records are the same (`authelia.mydomain`) but `subject` ones are not.
Author
Owner

@kolaente commented on GitHub (Dec 13, 2023):

The subject is taken from the openID provider. If it's different in the database that means your provider has changed it.

<!-- gh-comment-id:1854327379 --> @kolaente commented on GitHub (Dec 13, 2023): The subject is taken from the openID provider. If it's different in the database that means your provider has changed it.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/vikunja#5965