This describes how to set up the database and scripts for the ACL system.
| Prerequisite |
Description |
| Apache |
A familiarity with apache config files is essential to this process. The ACL system may also work with Jigsaw but has not been tested |
| MySQL |
This process is specifcally maintained on a system using MySQL. It may work on other systems |
Steps
-
install perl code base
The code base may be be installed from CVS and possibly by CPAN at some date.
-
create the ACLs DB
W3C/Rnodes/bin$ mysqladmin create w3c
W3C/Rnodes/bin$ mysql w3c < makeAclTables.sql
This describes how to set up a test environment for the ACL system.
| Prerequisite |
Description |
| installed ACL Systems |
see Set Up |
Steps
-
populate the ACLs DB with some sample data
W3C/Rnodes/bin$ mysql w3c < populateAclTables.sql
Appendix
This data emulates a portion of the W3C structure.
ids
| id | stops | type | value | pubKey | expire | info | last | orgId |
|---|
| 1 | 0 | A | all | | | | 20040427003408 | 0 |
| 100 | 0 | G | cabal | | | | 20040427003408 | 0 |
| 102 | 0 | G | w3cteamgroup | | | | 20040427003408 | 0 |
| 111 | 0 | G | W3T_KEIO | | | | 20040427003408 | 0 |
| 114 | 0 | G | W3T_MIT | | | | 20040427003408 | 0 |
| 2112 | 0 | U | eric | | | | 20040427003408 | 0 |
| 16315 | 0 | U | ot | | | | 20040427003408 | 0 |
groupDetails
| id | type | acRep | entityEncoded | alphaname | category | name | notes | last | shortname |
|---|
| 100 | G | 0 | | cabal | | Group of those having member access | | 20040427003408 | |
| 102 | G | 0 | | w3cteamgroup | | W3C Team | | 20040427003408 | |
| 111 | G | 0 | | W3T_KEIO | | Keio site | | 20040427003408 | |
| 114 | G | 0 | | W3T_MIT | | MIT site | | 20040427003408 | |
userDetails
| id | family | given | prefix | status | passwd | mailback | email | emailUrisId | last | cleartxt | notes |
|---|
| 2112 | Prud'hommeaux | Eric | Yo | 0 | 12yKKsoKp69Xw | | | 0 | 20040427003408 | eric | |
| 16315 | Thereaux | Olivier | Ms | 0 | 34VQDg9aqpNiY | | | 0 | 20040427003408 | ot | |
hierarchy
| super | type | sub | sponsor | stops | last |
|---|
| 111 | G | 16315 | | 0 | 20040427003408 |
| 114 | G | 2112 | | 0 | 20040427003408 |
| 102 | G | 111 | | 0 | 20040427003408 |
| 102 | G | 114 | | 0 | 20040427003408 |
uris
| id | uri | acl | last |
|---|
| 810 | http://www.w3.org/Member/Overview.html | 6 | 20040427003408 |
| 1991 | http://www.w3.org/Overview.html | 7 | 20040427003408 |
| 10643 | http://www.w3.org/Team/Overview.html | 5 | 20040427003408 |
acls
| acl | type | id | access | last |
|---|
| 5 | G | 102 | 3955 | 20040427003407 |
| 6 | G | 100 | 3122 | 20040427003408 |
| 6 | G | 102 | 3955 | 20040427003408 |
| 7 | A | 1 | 3122 | 20040427003408 |
| 7 | G | 102 | 3955 | 20040427003408 |
uriMaps
| id | uri | chacl | filepath | map | fileToURI |
|---|
| 1 | http://localhost/.* | http://localhost/chacl | /var/www | s|\Ahttp://localhost/|/var/www/| | s|\A/var/www/|http://localhost/| |
fileSystemIds
| id | type | name | descrip | webId | webType |
|---|
| 69 | G | www | W3 team group | 102 | G |
| 12817 | U | eric | tux user | 2112 | U |
| 16029 | U | ot | tux user | 16315 | U |
superGroups
compileIdInclusions
compileSuperGroups
idInclusions
idUpdates
| id | type | groupId | g | seqNo | action | agent | last |
|---|
Eric Prud'hommeaux
$Id: Setup.html,v 1.8 2004/04/28 13:24:29 eric Exp $