Question

.I would like to know if someone has integrated a database with this tool to be used in an access controlled manner by different groups ?

• TWiki version:
• Web server:
• Server OS:

-- PranavDandekar - 24 Jul 2001

Answer

Not exactly sure if I understand your question.

In case you want to authenticate users by other means then the .htaccess files you can do that. There are several authentication plugins for Apache, i.e. at work we set TWiki up to authenticate with the Unix accounts. All TWiki needs from the web server is the REMOTE_USER environment variable set for the scripts you want to have under authentication (usually edit, preview, save, attach, upload).

TWiki differenciates between authentication and authorization. For the latter one you define groups within TWiki, and based on those you define access restrictions. TWikiAccessControl has more. At this time, TWiki does not support groups defined outside of TWiki.

In case you want to query a SQL database and display some of that data in TWiki pages you can do that with a TWiki plugin. I.e. at work we have a plugin that pulls bug data out of an Oracle database and displays them in TWiki pages. The DB handling was done with the the Perl DBI module.

-- PeterThoeny - 26 Jul 2001

Question

Thanx Peter for an elaborate and informative answer.I have a small supplementary question.Do I have to write my own Twiki plugin to access data from a Oracle/MSAccess database , or someone has already written a generic plugin for this ?

-- PranavDandekar - 26 Jul 2001

You probably have to write your own unless someone else already did a plugin. The one I did is very much company specific.

-- PeterThoeny - 28 Jul 2001