Integrating DekiWiki and Drupal

This howto describes how to configure DekiWiki to authenticate against Drupal user database. It also configures Drupal 5 to login a user into DekiWiki when that user logs in to Drupal

- Login to DekiWiki as the DekiWiki admin 

- Configure a new authentication service from the Services Management page on DekiWiki.

Description DrupalAuth

SID http://services.mindtouch.com/deki/d...2007/05/drupal

Config

db-server         localhost

db-user            drupaluser

db-port            3306

db-catalog       drupal

db-password    xxxxxx

- If your Drupal installation uses database table prefixes, it's necessary to create views on the database to make it work.

CREATE VIEW drupal.users AS SELECT * FROM drupal.drupal_users;
CREATE VIEW drupal.users_roles AS SELECT * FROM drupal.drupal_users_roles;
CREATE VIEW drupal.role AS SELECT * FROM drupal.drupal_role;

- Uncompress the DekiWiki SSO module (attached below) into the Drupal 5 sites/all/modules folder.

- Login to Drupal 5 as the Drupal admin

- Activate the DekiWiki SSO module at Home -> Administer -> Site building -> Modules

- Configure the DekiWiki SSO module at Home -> Administer -> Site configuration -> DekiWiki SSO module settings

DekiWiki server full DNS name      wiki.server.com
DekiWiki cookie domain                .server.com

The DNS name is used by Drupal to contact DekiWiki. As usually DekiWiki and Drupal use different DNS names the cookies should be set at domain level, not host level. Be careful with the initial dot, as it's necessary.

- Finally configure DekiWiki login/logout links to use Drupal login/logout pages

$wgTemplateOverrides['loginurl'] = 'http://www.server.com/user';
$wgTemplateOverrides['logouturl'] = 'http://www.server.com/logout';