On Sun, Mar 8, 2009 at 5:44 AM, Thoughts Ltd domains@thoughts.pro wrote:
Has anyone here know how to get Drupal to share the 'users' table with another database?
(Or, in other words, connect to a different database to access the 'users' table.)
I have a "people" database that I share between all my different projects, so that all of my clients/users need not sign up multiple times. Signing up to anything gets them signed up to everything. Change their name/email/password once, it's changed everywhere.
I've been able to do this because I was hand-coding all of my projects, but now I'd like to use Drupal, yet still access this central "users" table (I can make it exactly fit Drupal's specs/schema).
Perhaps there's a different way to achieve what I'm trying to do?
Any suggestions or pointers?
Some resources that you may find useful:
For Drupal 6, check these API functions: http://api.drupal.org/api/function/user_external_load http://api.drupal.org/api/function/user_external_login/6 (Drupal 6 only) http://api.drupal.org/api/function/user_external_login_register/6 (Drupal 6 only) and generally the user API http://api.drupal.org/api/file/modules/user/user.module/6
See how the first two are used in the code of http://api.drupal.org/api/function/openid_authentication/6 (Drupal 6 only)
For Drupal 5, you can find a few relevant discussions around such as http://drupal.org/node/151515 http://www.darrenmothersele.com/content/using-external-data-source-drupal-us... Maybe also the code of openid_authentication() in http://drupal.org/project/openid
If your solution involves a Drupal bootstrap in an external php script, make sure to set the $cookie_domain in Drupal's settings.php file.
Thanks much.
-- [ Drupal support list | http://lists.drupal.org/ ]