Linking existing contact to existing drupal user account

[gholt]

Sorry if this is already documented somewhere, but I can't find it.

I found a contact in my CiviCRM database that didn't have a Drupal user account associated with it. Not a problem. It just means that one of us added the contact manually rather than having it be created automatically in the Drupal registration process. But this contact also has an active Drupal account. They just aren't linked.

So, I'm trying to figure out how I can link the existing contact to the existing user account. Can someone please point me to the documentation?

Thanks in advance!

[petednz]

you have a Drupal User that is not connected to a Civi Contact?

or is the Drupal User connected to a Contact that is now in civi Trash - if so, restore, then merge the civi records so the User gets connected to the right record

otherwise you need to add/edit a row in your uf_match table which is what connects drupal users and civi contacts

[gholt]

Yes. A Drupal User that is not connected to a Civi Contact. Same person for each, and both are active, but not connected.

Thanks for the reply, Pete.

Is this a common problem? It seems like it would be pretty easy to do by mistake -- at least in our use case where people can either register themselves online for our events, or they can send in a paper registration form and we'll enter it for them.

If others have this same problem, it would be nice to have a "Connect to existing Drupal User" button. At my experience level, it's probably dangerous for me to go into the database and make changes directly.     But perhaps one of my colleagues in the organization can help me with this.

Thanks again.

[petednz]

if you create a contact then want to add a user you can do that - either via Actions or by creating the user and using the same unique email

but no this shouldn't be an easy mistake unless you are using different emails for the 2 contacts.

or perhaps i am not understanding your flow of work - pls spell it out more

[gholt]

Aha! Your mention of the emails pointed out my mistake. I didn't check the email address. It wasn't her address on the account with her name. It must have happened when she was trying to register someone else in her company.

Thank you for your patience, Pete. I've changed the "impostor's" username and now I will be able to create a new user record for the other person using the Actions button.

I forgot that syncing would connect a new drupal user to an existing civi contact using their email address.

[petednz]

damn those imposters

[Full Trucker]

otherwise you need to add/edit a row in your uf_match table which is what connects drupal users and civi contacts

This post just helped me figure out how to change Drupal account associated with a CiviCRM contact record. We had a member ask to merge him and his wife's account, and my staffer picked the wrong associated Drupal account during the merge. Both Drupal accounts wound up with the same email address, so when he'd log in to his account he wasn't seeing his membership data. A couple of searches on teh Googles later I found this post which pointed me in the right direction of where to find the table which holds this info.

Thanks Pete!