Re: [Nss-mysql-users] Group Support

[Guillaume Morin]

Hi Jeff,

Dans un message du 25 jun à 19:27, Jefferson Cowart écrivait :
> # member_{userid,groupid}_column
> # FOREIGN KEYS of users.user_id and groups.group_id
> # for each row, user represented by its user_id a member
> # of the group represented by its group_id
> # The field name must be fully qualified, i.e. written as table.field
> groups.member_userid_column = user_group.user_id;
> # The field name must be fully qualified, i.e. written as table.field
> groups.member_groupid_column = user_group.group_id;
> 

As you can see the join is done on *_id columns. You cannot mix non
MySQL users with mysql groups.

> INSERT INTO groups VALUES (1, 'testgroup', 'A', 'x', 1000);
> INSERT INTO user_group VALUES (1005, 1000);

Therefore this should be INSERT INTO user_group VALUES (5, 1);
(The 5 is just an example)

Regards,

-- 
Guillaume Morin <address@hidden>

                       Alcôve - L'informatique est libre
                           http://www.alcove.com/fr/