nss-mysql: Wie groupmembers auslesen?

[gIlioner]

Hallo,

ich habe eine Frage zu libnss-mysql.

Ich benötige die Möglichkeit, alle Benutzer, die zu einer Gruppe gehören, auszulesen. Also praktisch die letzte Spalte aus /etc/group, in der ja mehrere Benutzer stehen können.

Ich kann diese Option nirgends finden.

Meine nss-mysql.conf sieht so aus:

Code: Alles auswählen

conf.version = 2;
users.host = inet:localhost:3306;
users.database = syscp;
users.db_user = syscp;
users.db_password = xxxx;
users.table = ftp_users u;
users.where_clause = u.login_enabled='Y';
users.user_column = u.username;
users.password_column = u.password;
users.userid_column = u.id;
users.uid_column = u.uid;
users.gid_column = u.gid;
users.realname_column = u.username;
users.homedir_column = u.homedir;
users.shell_column = u.shell;
groups.group_info_table = ftp_groups g;
groups.where_clause = ;
groups.group_name_column = g.groupname;
groups.groupid_column = g.id;
groups.gid_column = g.gid;
groups.password_column = "x";
groups.members_table = ftp_groups ug;
groups.member_userid_column = ug.customerid;
groups.member_groupid_column = ug.id;

Könnt ihr mir helfen?

Daanke!

Schöne Grüße,
Sebastian

[gIlioner]

Okay.. Es geht hiermit

# members_table: table containing member_{userid,groupid}_column.
# This reproduce /etc/group role by using SQL JOIN.
# See sample.sql if you don't understand what I(it) mean(s)
# The field name must be fully qualified, i.e. written as table.field
groups.members_table = user_group;

# 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;

Also leider nicht mit den kommagetrennten Angaben, wie es syscp vorsieht.

Dann muss ich mir wohl irgendwas einfallen lassen.