From: Reini U. <ru...@x-...> - 2007-12-08 13:11:23
|
Alastair Weller schrieb: > Ah ok, I can see this first problem. I don't have a group table. Does > anyone have the schema for this table? For a simple group:user 1:n relation just use the pref table and the groupname therein. For a more powerful group:user n:m relation (users may belong to multiple groups) use the seperate member table. -- Use the member table, if you need it for n:m user-group relations, -- and adjust your DBAUTH_AUTH_ SQL statements. CREATE TABLE member ( userid CHAR(48) BINARY NOT NULL, groupname CHAR(48) BINARY NOT NULL DEFAULT 'users', INDEX (userid), INDEX (groupname) ); > On 07/12/2007, Reini Urban <ru...@x-...> wrote: >> Alastair Weller schrieb: >>> I've tried to send this meesage to the sourceforge list but it doesn't >>> seem like it got their. Is there a problem or does sourceforge hate >>> gmail as much as gmail seems to hate mailing lists? >> From time to time gmail as any other major webmail site is blocked there. >> >>> ---------- Forwarded message ---------- >>> From: Alastair Weller <lis...@al...> >>> Date: 19 Nov 2007 13:48 >>> Subject: Fwd: [Phpwiki-talk] Fwd: User Authentication >>> To: "Discussion on PhpWiki features, bugs, development." >>> <php...@li...> >>> >>> Have you any idea on how I could move to the MYSQL groups rather than >>> CategoryGroups >> Sure, I do have. But unfortunately I'm on a business trip in the states >> for the whole week without a lot of computer access. >> >> fill the group table with your names and check out the sql templates. >> it should work out of the box. >> >> >>> ---------- Forwarded message ---------- >>> From: Alastair Weller <lis...@al... > >>> Date: 23 Oct 2007 09:31 >>> Subject: Re: [Phpwiki-talk] Fwd: User Authentication >>> To: "Discussion on PhpWiki features, bugs, development." >>> <php...@li... > >>> >>> >>> Ok no worries - I'll have a play and follow up in 2 weeks. >>> I seem to have sussed the ACL when using CategoryGroups >>> >>> Alastair >>> >>> On 23/10/2007, Reini Urban <ru...@x-...> wrote: >>>> 2007/10/20, Alastair Weller < lis...@al... >: >>>>> I sent this message a few days ago - but it hasn't shown up on the >>>>> sourceforge.net Email Archive. >>>>> Is the mailing list playing up and does anyone know how to use DB for group >>>>> management? >>>>> >>>>> Alastair >>>> I would know, but I'm for the next two weeks on holidays. Sorry. >>>> >>>>> ---------- Forwarded message ---------- >>>>> From: Alastair Weller >>>>> < lis...@al... > >>>>> Date: 17 Oct 2007 18:47 >>>>> Subject: Re: [Phpwiki-talk] User Authentication >>>>> To: "Discussion on PhpWiki features, bugs, development." >>>>> < php...@li... > >>>>> >>>>> >>>>> >>>>> >>>>> I've tried using the CategoryGroup page, and I can get the groups to appear >>>>> in the setacl page - but I can't seem to get the acl to work. >>>>> Really I want to use the DB option for the groups as well as the users - >>>>> that way it will hopefully be a lot easier to manage. >>>>> >>>>> I'm looking to be running one wiki with mutliple sections ie Company1, >>>>> Company2, Org1, Charity1 - most people will only be in one group ie >>>>> Company1Group, Company2Group, Org1Group, Charity1Group vut some will be in >>>>> more than one (they won't necessarily be administrators either) >>>>> I'd then like to define that further, so Company1Group is actualyl >>>>> Company1View, Company1Edit, Company1Create etc etc. >>>>> >>>>> Alastair >>>>> >>>>> >>>>> >>>>> On 16/10/2007, Reini Urban < ru...@x-...> wrote: >>>>>> Alastair Weller schrieb: >>>>>>> I've solved the user issue - however I now can't get my head around >>>>>>> the groups issue. >>>>>> Do you still need help about the groups? >>>>>> >>>>>> "CategoryGroup" has this: >>>>>> >>>>>> All links in this page will be used to find user groups for the >>>>>> WIKIPAGE group method. User group pages must contain a list of >>>>>> usernames, and then for consistency after four hyphens a link to this >>>>>> page. >>>>>> >>>>>> * [Administrators] >>>>>> >>>>>> So you have to create the page "Administrators" >>>>>> and list the names of users there. >>>>>> Like: >>>>>> >>>>>> * [MyTestUser] >>>>>> * [Real Name] >>>>>> >>>>>> >>>>>> and lock the pages. >>>> -- >>>> Reini Urban >>>> http://phpwiki.org/ http://murbreak.at/ >>>> http://spacemovie.mur.at/ http://helsinki.at/ >>>> >>>> ------------------------------------------------------------------------- >>>> This SF.net email is sponsored by: Splunk Inc. >>>> Still grepping through log files to find problems? Stop. >>>> Now Search log events and configuration files using AJAX and a browser. >>>> Download your FREE copy of Splunk now >> http://get.splunk.com/ >>>> _______________________________________________ >>>> Phpwiki-talk mailing list >>>> Php...@li... >>>> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk >>>> >>> >>> >> >> -- >> Reini Urban >> http://phpwiki.org/ http://murbreak.at/ >> http://helsinki.at/ http://spacemovie.mur.at/ >> > > -- Reini Urban http://phpwiki.org/ http://murbreak.at/ http://helsinki.at/ http://spacemovie.mur.at/ |