When do you need this to be done by? (summer 2020)

@zlopez can you take a look?

We tried to troubleshoot this issue with kwizart in #fedora-admin channel and here is what we found.

The user with the same e-mail is already in users table, but this one is associated with openid instance (https://id.rpmfusion.org/openid/id/kwizart). He was able to connect using this openid provider, but to be able to connect with FAS we need to delete his existing account.

To do this I need someone with db access to delete user with id 0a87043e-4c9b-492c-b74d-c28c981a0842 from users table in Anitya. When this will be done the kwizart should be able to login with FAS account.

To help prevent this in the future I created two tickets in Anitya:

• To enhance the error message - https://github.com/fedora-infra/anitya/issues/930

• To add admins ability to delete the users from the user management screen - https://github.com/fedora-infra/anitya/issues/931

anitya=# select * from users where id = '0a87043e-4c9b-492c-b74d-c28c981a0842';
id | email | username | active | admin
--------------------------------------+-------------------+----------------+--------+-------
0a87043e-4c9b-492c-b74d-c28c981a0842 | kwizart@gmail.com | NicolasChauvet | t |
(1 row)

anitya=# select from users where id = '0a87043e-4c9b-492c-b74d-c28c981a0842';

(1 row)

It doesn't seem to work...

"Error: There's already an account associated with your email, authenticate with openid."

Is there any other user_id using the same email ? kwizart@gmail.com ?

Oops. That second select was supposed to be a delete. :(

However:

anitya=# delete from users where id = '0a87043e-4c9b-492c-b74d-c28c981a0842';
ERROR: update or delete on table "users" violates foreign key constraint "social_auth_usersocialauth_user_id_fkey" on table "social_auth_usersocialauth"
DETAIL: Key (id)=(0a87043e-4c9b-492c-b74d-c28c981a0842) is still referenced from table "social_auth_usersocialauth".

Hm, I thought the social auth table will be set to cascade delete. In this case we need to also delete entry in social_auth_usersocialauth tables.

Done:

anitya=# delete from social_auth_usersocialauth where user_id = '0a87043e-4c9b-492c-b74d-c28c981a0842';
DELETE 1
anitya=# delete from users where id = '0a87043e-4c9b-492c-b74d-c28c981a0842';
DELETE 1

Confirmed fixed! Thanks !