Login, OAuth: login error if system (local) username matches GitHub username

[s373r]

Describe the bug

• If a multi-tenant workspace is created, a system user is also created (password provider).
• When trying to log in, it tries to create a new account, but for the oauth_github provider
• Subsequently, it creates problems in the authorization process:
  • Credentials are already used by an existing account

Steps To Reproduce

• kamu-cli part:

kamu init --multi-tenant

KAMU_AUTH_GITHUB_CLIENT_ID=361a3b4fda86d0234d2f \
KAMU_AUTH_GITHUB_CLIENT_SECRET=465849325236ed49253993744069e1bec6808554 \
kamu \
  system api-server \
  --address 0.0.0.0 \
  --http-port 8080 \
  --get-token

• kamu-web-ui part:
  • Login via GitHub

Current Behavior

Credentials are already used by an existing account

Expected Behavior

No errors

kamu system info

latest (v0.213.0)

Logs

No response

Anything else?

Solution: need to update the indexes in the account table