[Savannah-cvs] [404] Update RenamingAccounts

[bob]

Revision: 404
          
http://svn.savannah.gnu.org/viewvc/?view=rev&root=administration&revision=404
Author:   rwp
Date:     2020-05-02 02:13:07 -0400 (Sat, 02 May 2020)
Log Message:
-----------
Update RenamingAccounts

Modified Paths:
--------------
    trunk/sviki/RenamingAccounts.mdwn

Modified: trunk/sviki/RenamingAccounts.mdwn
===================================================================
--- trunk/sviki/RenamingAccounts.mdwn   2019-12-08 20:14:39 UTC (rev 403)
+++ trunk/sviki/RenamingAccounts.mdwn   2020-05-02 06:13:07 UTC (rev 404)
@@ -1,3 +1,6 @@
+Discussion
+----------
+
 [We need to define a policy about whether it is OK to rename accounts.
 Since accounts can be removed and then recreated under a different user
 name, I guess it is OK. Something like a redirection, or a way for
@@ -12,3 +15,40 @@
 
 Karl writes in this recent discussion
 (http://lists.gnu.org/archive/html/savannah-hackers/2016-05/msg00043.html):
+
+Current Status
+--------------
+
+At this time it seems that renaming of accounts is okay to do.  We
+have renamed several accounts.  The world continues.  And as noted
+previously accounts could always have been removed and recreated under
+different names creating the same effect. --rwp, 2020-05-01
+
+The previously referenced rename_user.sh script has bit rot to the
+point that it is no longer applicable.  Additionally it appears to be
+buggy with regards to some of the actions.  Do not attempt to use it
+directly.
+
+Having dug into things more deeply I have deduced this following
+recipe for renaming accounts.
+
+Verify that the new user name is not in use and available.
+
+    mysql> select * from user where user_name = 'newuser';
+    Empty set (0.01 sec)
+
+Rename the user name in the user table.
+
+    mysql> UPDATE user SET user_name='newname' WHERE user_name='oldname';
+    Query OK, 1 row affected (0.00 sec)
+    Rows matched: 1  Changed: 1  Warnings: 0
+
+Rename the user name in the group_history table.
+
+    mysql> UPDATE group_history SET old_value='newname' WHERE 
old_value='oldname';
+    Query OK, 19 rows affected (0.37 sec)
+    Rows matched: 19  Changed: 19  Warnings: 0
+
+Verify the URL to the name newuser.
+
+    https://savannah.gnu.org/users/newuser