Re: [Phpwiki-talk] Fwd: Fwd: User Authentication

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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/