[Nss-mysql-users] system does not see memberships/groups...

[Dragiša Durić]

  Hi,

  I've installed nss-mysql recently and here I have this problem... At
end of this message are results of queries for user's groups, group's
members, group and user record for user leka and group linuks. 

  But, what system sees is:

  frodo:dragisha/pts/4: ~# id leka
  uid=611(leka) gid=611(leka) groups=611(leka)

  Also, getent group does not show this group. Looks like it show only
groups which are present both in /etc/group and mysql (like root, bin,
adm...).

  This user exists only in mysql, and he uses systems without other
problems. Same for this group, in mysql only.

  Any solutions to this? 

  Thanks,
  dd


mysql> select groups.gid, user.uid, user.user_id, groups.group_id,
user_name, group_name from user, groups, user_group where
user.user_id=user_group.user_id and groups.group_id=user_group.group_id
and user.user_name="leka";
+-----+-----+---------+----------+-----------+------------+
| gid | uid | user_id | group_id | user_name | group_name |
+-----+-----+---------+----------+-----------+------------+
| 505 | 611 |       4 |       76 | leka      | linuks     |
| 611 | 611 |       4 |       56 | leka      | leka       |
+-----+-----+---------+----------+-----------+------------+
1 row in set (0.00 sec)

mysql> select groups.gid, user.uid, user.user_id, groups.group_id,
user_name, group_name from user, groups, user_group where
user.user_id=user_group.user_id and groups.group_id=user_group.group_id
and groups.group_name="linuks";
+-----+-----+---------+----------+-----------+------------+
| gid | uid | user_id | group_id | user_name | group_name |
+-----+-----+---------+----------+-----------+------------+
| 505 | 501 |      21 |       76 | dragisha  | linuks     |
| 505 | 502 |       7 |       76 | stomic    | linuks     |
| 505 | 611 |       4 |       76 | leka      | linuks     |
+-----+-----+---------+----------+-----------+------------+
3 rows in set (0.01 sec)

mysql> select group_id, group_name, gid from groups where
group_name="linuks";
+----------+------------+-----+
| group_id | group_name | gid |
+----------+------------+-----+
|       76 | linuks     | 505 |
+----------+------------+-----+
1 row in set (0.00 sec)

mysql> select user_id, user_name, uid, gid from user where
user_name="leka";
+---------+-----------+-----+-----+
| user_id | user_name | uid | gid |
+---------+-----------+-----+-----+
|       4 | leka      | 611 | 611 |
+---------+-----------+-----+-----+
1 row in set (0.00 sec)

-- 
Dragiša Durić <address@hidden>

signature.asc
Description: This is a digitally signed message part