I've got a CiviCRM 4.7.9 install running in a Drupal multisite. I have a ton of databases, named something like this:
- CiviCRM: org_dev_crm
- Drupal default site: org_dev_cms
- Drupal site 2: org_dev_cms_other
- Drupal database for tables shared across sites: org_dev_cms_shared
The users table is shared across instances in the last database, and Drupal settings.php file contains the following line:
$databases['default']['default']['prefix']['users'] = '`org_dev_cms_shared`.';
users table is in an unusual place, I thought I'd have to tell CiviCRM about it by going to Administer > System Settings > CMS Database Integration. On a lark, however, I decided to test if this was necessary. I ran the user-to-contact sync (Administer > Users and Permissions > Synchronize Users to Contacts), and it worked just fine. If there ever was a way to test CiviCRM's ability to access Drupal's user table, I figured this was it.
So, to wrap this up:
- What is this setting used for, if not synching?
- Do we still need this setting, or has CiviCRM learned how to read Drupal config?