Configuring Dekiwiki for multiple tenants

From BeSTGRID

Jump to: navigation, search

Dekiwiki is a wiki system which among others supports multiple tenants - virtual wiki sites within one system.

I have configured a Dekiwiki instance running at http://dekiwiki.canterbury.ac.nz/ to support multiple tenants - namely:

To configure the multiple tenants, I followed the Multi-Tenant Setup Guide at OpenGarden, the self-help site for Dekiwiki.

[edit] Setting up multiple tenants

Setting up the tenant wikis is just a few steps:

  • Create a directory for attachements
    mkdir /var/www/deki-hayes/attachments-{librarywiki,uctlwiki,itwiki}
  • Create the database for each of the wikis: 
/var/www/deki-hayes/maintenance/createdb.sh --dbName librarywikidb \
 --dbAdminUser root --dbAdminPassword DbAdminPassword --dbServer localhost \
 --dbWikiUser wikiuser --wikiAdmin Admin \
 --wikiAdminPassword WikiAdminPassword \
 --wikiAdminEmail robin.harrington@canterbury.ac.nz \
 --storageDir /var/www/deki-hayes/attachments-librarywiki
  • Create a configuration entry for the wiki in the <wikis> section in /etc/dekiwiki/mindtouch.deki.startup.xml:
    • Copy the default entry, and change id, host, and db-catalog entries: 
        <config id="librarywiki">
          <host>librarywiki</host>
          <host>librarywiki.canterbury.ac.nz</host>

          <db-server>localhost</db-server>
          <db-port>3306</db-port>
          <db-catalog>librarywikidb</db-catalog>
          <db-user>wikiuser</db-user>
          <db-password hidden="true">WikiUserPassword</db-password>
          <db-options>pooling=true; Connection Timeout=5; Connection Lifetime=30; Protocol=socket; Min Pool Size=2; Max Pool Size=50; Connection Reset=false;character set=u
tf8;ProcedureCacheSize=25;Use Procedure Bodies=true;</db-options>
        </config>

        <config id="uctlwiki">
          <host>uctlwiki</host>
          <host>uctlwiki.canterbury.ac.nz</host>

          <db-server>localhost</db-server>
          <db-port>3306</db-port>
          <db-catalog>uctlwikidb</db-catalog>
          <db-user>wikiuser</db-user>
          <db-password hidden="true">WikiUserPassword</db-password>
          <db-options>pooling=true; Connection Timeout=5; Connection Lifetime=30; Protocol=socket; Min Pool Size=2; Max Pool Size=50; Connection Reset=false;character set=u
tf8;ProcedureCacheSize=25;Use Procedure Bodies=true;</db-options>
        </config>

        <config id="itwiki">
          <host>itwiki</host>
          <host>itwiki.canterbury.ac.nz</host>

          <db-server>localhost</db-server>
          <db-port>3306</db-port>
          <db-catalog>itwikidb</db-catalog>
          <db-user>wikiuser</db-user>
          <db-password hidden="true">WikiUserPassword</db-password>
          <db-options>pooling=true; Connection Timeout=5; Connection Lifetime=30; Protocol=socket; Min Pool Size=2; Max Pool Size=50; Connection Reset=false;character set=u
tf8;ProcedureCacheSize=25;Use Procedure Bodies=true;</db-options>
        </config>
  • Configure wiki databases in LocalSettings.php so that the update scripts knows about the databases and can apply database updates to each tenant wiki: 
$wgWikis = array(
         'testtenantwiki.canterbury.ac.nz' => array(
                 'db-server' => 'localhost',
                 'db-port' => '3306',
                 'db-catalog' => 'testtenantwikidb',
                 ),
         'dekiwiki.canterbury.ac.nz' => array(
                 'db-server' => 'localhost',
                 'db-port' => '3306',
                 'db-catalog' => 'wikidb',
                 ),
         'librarywiki.canterbury.ac.nz' => array(
                 'db-server' => 'localhost',
                 'db-port' => '3306',
                 'db-catalog' => 'librarywikidb',
                 ),
         'uctlwiki.canterbury.ac.nz' => array(
                 'db-server' => 'localhost',
                 'db-port' => '3306',
                 'db-catalog' => 'uctlwikidb',
                 ),
         'itwiki.canterbury.ac.nz' => array(
                 'db-server' => 'localhost',
                 'db-port' => '3306',
                 'db-catalog' => 'itwikidb',
                 ),
 );

invoke-rc.d dekihost restart
invoke-rc.d apache2 restart

[edit] Notes

  • Dekiwiki won't complain about XML syntax error in the configuration - use xmllint to make sure it's correct.
  • MySQL root password is in /var/www/deki-hayes/AdminSettings.php
  • Contrary to the guide, createdb.sh requires a storageDir (or an S3 configuration), hence the need to create a separate storage directory.
  • I found the value used for creating the intial databases with: 
select * from config where config_key = 'storage/fs/path';

 Site settings could not be loaded
 We were unable to locate the API to request site settings.
 Please see below for debugging information.
 HTTP Response Status Code: 410
    • I have left dekiwiki.canterbury.ac.nz as the default entry - e.g., if someone access the machine via it's IP address, they should end up there.

[edit] Miscellaneous configuration

  • Configure timezone: 
tzconfig

Well, that is not enough. Dekiwiki would display all time information to users in what it considers as a suitable timezone, which is by default GMT - ignoring whatever is set at the OS level.

Following what OpenGarden forum on timezone says, one can set the $wgDefaultTimezone variable to set the timezone offset. To use timezone information to automatically adjust for DST, and cater for PHP timezonedb not being updated with new NZ rules, I finally put the following to /var/www/deki-hayes/LocalSettings.php: 

$wgDefaultTimezone  = date('P',time()-86400*21); //GMT offset

And, I set /etc/ntp.conf to use cantva.canterbury.ac.nz and clock1.canterbury.ac.nz instead of the default Debian machines (unreachable via the firewall).

Retrieved from "http://wiki.test.bestgrid.org/index.php/Configuring_Dekiwiki_for_multiple_tenants"