Problem with drupal accounts linking to civicrm contacts

[snowball]

I recently created a bunch of new accounts for administrators of my CiviCRM (3.4) install.  However rather than linking them to their own contact record in the database they have been linked to seemingly random contact records.  I was under the impression that linking was done based on email address, so I'm not sure what has gone wrong?  I guess this could be a bug, in which case how am I best to investigate it?

[petednz]

hi snowball. sounds odd. pls confirm the steps and outcome

Contact A with xx@yy.com is a civicrm contact with no related Drupal User.

You create a Drupal User - User A - using email xx@yy.com

Outcome: Contact A is not connected to User A, instead User A is connected to User Q who had email cc@dd.com

[Hershel]

Yes, this sounds odd. Can you clarify how you are determining which Contact is associated with which User also?

[snowball]

hi snowball. sounds odd. pls confirm the steps and outcome

Contact A with xx@yy.com is a civicrm contact with no related Drupal User.

You create a Drupal User - User A - using email xx@yy.com

Outcome: Contact A is not connected to User A, instead User A is connected to User Q who had email cc@dd.com

That is exactly it.

Yes, this sounds odd. Can you clarify how you are determining which Contact is associated with which User also?

Well users have been complaining that when they go in to civicrm they are being recognised as a user other than themselves.  I double checked this by clicking on the view contact record link on the drupal user page.

[Hershel]

Check that your users table is set correctly here: civicrm/admin/setting/uf?reset=1

[snowball]

Check that your users table is set correctly here: civicrm/admin/setting/uf?reset=1

It's set as "users", I assume that is correct?

[Hershel]

I can't be certain if that's correct. Can you find the database connection string in sites/default/settings.php and post that? Change the username and password when you post.

What I want to see actually is what the default prefix is set to there. Or if by some wild change there is a unique prefix for users.

[snowball]

$db_url['default'] = 'mysqli://####:####@localhost/joehill_ndb_drpl';
$db_url['civicrm'] = 'mysqli://####:####@localhost/joehill_ndb_crm';

[Hershel]

And you have a line like:

Code: [Select]

$db_prefix = '';
?

[snowball]

yep:

$db_prefix = '';

[snowball]

Also possibly related, users are reporting that when they change their passwords from the ones they were given they are unable to log in with the new password

[Hershel]

Sounds related. Do you have any multi-site modules like Domain or Domain Access?

I am wondering if either your site uses a different users table or if some other site is also accessing your users table.

But anyhow if users can't update passwords successfully, then it sounds like you have a basic Drupal problem, not necessarily related to CiviCRM. If you can fix that, then probably CiviCRM will work fine.

[snowball]

Do you have any multi-site modules like Domain or Domain Access?

Nope

But anyhow if users can't update passwords successfully, then it sounds like you have a basic Drupal problem, not necessarily related to CiviCRM. If you can fix that, then probably CiviCRM will work fine.

Will try disabling the CiviCRM modules and seeing if the problem persists

[snowball]

Ok, I seem to have fixed the issue, the problem was I had ported this data from a different Drupal install, truncating civicrm_uf_match solved the issue

[Hershel]

...the problem was I had ported this data from a different Drupal install

Aha. That explains it.

Thanks for following up.