Next Previous Contents

2. user/group/account tables

The tables uusers, ugroups, uaccounts hold the user, group, and accounting information respectively. Both the uusers and ugroups tables do not need to be setup by hand since the Maui Scheduler creates new entries for new users automatically. If you need to have an extra method of grouping users and doing accounting on them, you can use the uaccounts table, but you need to set this up by hand.

2.1 uusers

The entries in this table are dynamically created the very first time a user submits a job to the scheduler. You may need to change the default values later. NOTE that you may need to remove users from this table who are no longer authorized to use your system since the scheduler only adds users, never removes.

mysql> desc uusers;
+-------------------------+---------------+------+-----+------------+-------+
| Field                   | Type          | Null | Key | Default    | Extra |
+-------------------------+---------------+------+-----+------------+-------+
| uuser                   | char(64)      |      | PRI |            |       |
| access                  | enum('Y','N') |      | MUL | Y          |       |
| enforce_default_group   | enum('Y','N') |      |     | N          |       |
| enforce_default_account | enum('Y','N') |      |     | Y          |       |
| default_group           | char(64)      |      |     | no-group   |       |
| default_account         | char(255)     |      |     | no-account |       |
+-------------------------+---------------+------+-----+------------+-------+

Example values you might see in the table:
mysql> select * from uusers limit 5;
+----------+--------+-----------------------+-------------------------+---------------+-----------------+
| uuser    | access | enforce_default_group | enforce_default_account | default_group | default_account |
+----------+--------+-----------------------+-------------------------+---------------+-----------------+
| steviek  | N      | N                     | N                       | no-group      | no-account      |
| frankg   | Y      | N                     | N                       | no-group      | no-account      |
| testhelp | Y      | N                     | N                       | no-group      | no-account      |
| genieb   | N      | N                     | N                       | no-group      | no-account      |
| testfoo  | Y      | N                     | N                       | no-group      | no-account      |
+----------+--------+-----------------------+-------------------------+---------------+-----------------+

2.2 ugroups

This is a simple table mapping UNIX users to the UNIX groups they belong in. The entries in this table get created dynamically, but NOTE that this table needs to be reset if users change groups!

mysql> desc ugroups;
+--------+----------+------+-----+---------+-------+
| Field  | Type     | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| uuser  | char(64) |      |     |         |       |
| ugroup | char(64) |      |     |         |       |
+--------+----------+------+-----+---------+-------+

Example values you might see in the table:

mysql> select * from ugroups limit 5;
+----------+---------+
| uuser    | ugroup  |
+----------+---------+
| steviek  | steviek |
| frankg   | bin     |
| testhelp | biteme  |
| genieb   | systems |
| testfoo  | bin     |
+----------+---------+

2.3 uaccounts

This is a simple table mapping UNIX users to the accounts they belong in. THIS TABLE NEEDS TO BE SET UP BY HAND SINCE THERE IS NO EXTERNAL MECHANISM TO DETERMINE WHICH USER GOES IN WHICH ACCOUNT! By default the scheduler chooses to ignore accounts (as per the enforce_default_account entry in the uusers table, which enforces the no-account). You would only want to use accounts on your cluster if you needed another non-UNIX way to group users and account for their activities.

mysql> desc uaccounts;
+---------+-----------+------+-----+------------+-------+
| Field   | Type      | Null | Key | Default    | Extra |
+---------+-----------+------+-----+------------+-------+
| uuser   | char(64)  |      |     |            |       |
| account | char(255) |      |     | no-account |       |
+---------+-----------+------+-----+------------+-------+

Example values you might see in the table:

+----------+----------------+
| uuser    | account        |
+----------+----------------+
| steviek  | MANGE-0000-666 |
| frankg   | FOOBA-R900-444 |
| testhelp | TESTF-9998-S00 |
| genieb   | VIPPP-9999-S99 |
| testfoo  | 31337-H4X0-R69 |
+----------+----------------+


Next Previous Contents