[Savannah-cvs] [340] expand on user.uidNumber field

[assafgordon]

Revision: 340
          
http://svn.savannah.gnu.org/viewvc/?view=rev&root=administration&revision=340
Author:   agn
Date:     2017-05-23 21:21:21 -0400 (Tue, 23 May 2017)
Log Message:
-----------
expand on user.uidNumber field

Modified Paths:
--------------
    trunk/sviki/SavannahHackingIdeas.mdwn
    trunk/sviki/UserAuthentication.mdwn

Modified: trunk/sviki/SavannahHackingIdeas.mdwn
===================================================================
--- trunk/sviki/SavannahHackingIdeas.mdwn       2017-05-13 18:21:36 UTC (rev 
339)
+++ trunk/sviki/SavannahHackingIdeas.mdwn       2017-05-24 01:21:21 UTC (rev 
340)
@@ -143,3 +143,6 @@
     See [sr#108236](https://savannah.gnu.org/support/index.php?108236).
 33. Fix the "FROM: address@hidden" in the project-approval email.
     See [sr#108243](https://savannah.gnu.org/support/?108243).
+34. Assign every new user a `uidNumber` automatically and get rid of
+    `sv_assign_uid_gid` script.
+    Search for `uidNumber` in [[UserAuthentication]] for details.

Modified: trunk/sviki/UserAuthentication.mdwn
===================================================================
--- trunk/sviki/UserAuthentication.mdwn 2017-05-13 18:21:36 UTC (rev 339)
+++ trunk/sviki/UserAuthentication.mdwn 2017-05-24 01:21:21 UTC (rev 340)
@@ -127,13 +127,31 @@
      download:~# getent passwd agn
      agn:x:131035:1003:Assaf Gordon:/srv:/usr/local/bin/sv_membersh
 
-(Notice the `uidNumber` from the mysql database is the user's Unix
-uid.)
-
 The sql statements (to extract information from the mysql database on
 `internal`) are defined in `dl:/etc/libnss-mysql.cfg` and
 `vcs:/etc/libnss-mysql.cfg`.
 
+### uidNumber
+
+Savannah users have two IDs in the database: `user.user_id` and
+`user.uidNumber`. `user_id` is used in the PHP web-frontend alone
+(it is the primary key for the user table). `uidNumber` is the
+user's unix account user id (used by `getent` above).
+
+When a new user is registerd on savannah, the `user_id` will be
+unique but the `uidNumber` will be *NULL*.
+
+A cron job (`mgt0:/etc/cron.d/savannah`) calls a script (
+[sv_assign_uid_gid](https://git.savannah.gnu.org/cgit/administration/savane.git/tree/backend/accounts/sv_assign_uid_gid.in))
+which scans the new users in the database, and creates unix user-ids and
+group ids if needed (if a user is not part of any group - they won't need
+ssh access and thus won't need user-id).
+
+Search for `sv_assign_uid_gid` in [[SavannahInternals]] to see
+how it is called (but note that the page is out-dated: the script now
+runs as a cron job on `mgt0`, not `internal`).
+
+
 ### ssh authentication
 
 The file `/etc/ssh/sshd_config` on `dl:` and `vcs:` servers have the line: