Problem adding drupal user from code

[TwoMice]

Hi gang,

I'm working on a Drupal multi-site project in which two sites are sharing the same {users} table; this normally works fine by defining $db_prefix['users'] = 'drupal_shared_database.' in settings.php for both sites, so Drupal always knows where to find the users table.

The problem comes up when CiviCRM creates a Drupal user. This happens in CRM_Core_BAO_CMSUser::createDrupalUser(), and actually creating the Drupal user goes just fine, because it uses Drupal methods to do it.  The next step then is to create an entry in civicrm_uf_match, using the new Drupal user uid.  To get that uid, this code doesn't use Drupal methods to access the data, but instead queries the database with its own methods, essentially requiring the `users` table to be in the database defined in $config->userFrameworkDSN, which in this case it's not.

Would it be reasonable to have this Drupal-specific method to use Drupal's db_query() to get the uid? Or is there another way I should be handling this?

Thanks,
- TM

[Eileen]

Won't setting the cms user table here get around this?

http://sandbox.civicrm.org/en/civicrm/admin/setting/uf?reset=1

[Donald Lobo]

I think we can and should make 2 improvements to that part of the code:

1. Use db_query instead of our database queries. Do the same for joomla. the D6 and D7 code will be different.

2. Doing the above, means we can get rid of the users table name and hence one less config option

twomice: wanna take a look and submit a patch? if you do it for drupal, we can convince a joomla developer to do the same for joomla

lobo

[TwoMice]

Yep, Eileen is right. Of course that fixes the problem instantly.

Also, it looks like a patch is pretty simple, will try to submit something today.

Thanks,
-TM

[TwoMice]

Patches for 3.4 and 4.0 added in this issue:
http://issues.civicrm.org/jira/browse/CRM-8020