[Savannah-cvs] [156] discuss reactivating a user; other simplifications

[karl]

Revision: 156
          
http://svn.sv.gnu.org/viewvc/?view=rev&root=administration&revision=156
Author:   karl
Date:     2015-04-30 17:14:50 +0000 (Thu, 30 Apr 2015)
Log Message:
-----------
discuss reactivating a user; other simplifications

Modified Paths:
--------------
    trunk/sviki/ForAdministrators.mdwn
    trunk/sviki/FrontPage.mdwn
    trunk/sviki/ProjectApproval.mdwn
    trunk/sviki/UserAuthentication.mdwn

Removed Paths:
-------------
    trunk/sviki/SavannahMoreInfo.mdwn

Modified: trunk/sviki/ForAdministrators.mdwn
===================================================================
--- trunk/sviki/ForAdministrators.mdwn  2015-04-16 16:57:38 UTC (rev 155)
+++ trunk/sviki/ForAdministrators.mdwn  2015-04-30 17:14:50 UTC (rev 156)
@@ -22,7 +22,3 @@
 
 A better solution would be to add a 'task\_id' field in the 'groups'
 table, filled in at registration time.
-
-#### subtopics:
-
--   [savannah.el|vim](http://savannah.gnu.org/maintenance/SavannahElVim)

Modified: trunk/sviki/FrontPage.mdwn
===================================================================
--- trunk/sviki/FrontPage.mdwn  2015-04-16 16:57:38 UTC (rev 155)
+++ trunk/sviki/FrontPage.mdwn  2015-04-30 17:14:50 UTC (rev 156)
@@ -40,7 +40,6 @@
         -   [[NoAdvertising]]
         -   [[PasswordAuthentication]]
         -   [[SavannahCryptographicRestrictions]]
-        -   [[SavannahMoreInfo]]
         -   [[SavannahTLSInfo]]
         -   [[SavannahUpdateDelays]]
         -   [[SavannahCountryRestrictions]]
@@ -77,9 +76,6 @@
     -   [[AboutTranslations]]
     -   [[ApprovingSubmission]]
     -   [[FileFormats]]
-    -   [[ForAdministrators]]
-        -   
[savannah.el|vim](http://savannah.gnu.org/maintenance/SavannahElVim)
-
     -   [[GnuOrgTranslationTeams]]
     -   [[HowToBecomeASavannahHacker]]
     -   [[LicensingRequirements]]

Modified: trunk/sviki/ProjectApproval.mdwn
===================================================================
--- trunk/sviki/ProjectApproval.mdwn    2015-04-16 16:57:38 UTC (rev 155)
+++ trunk/sviki/ProjectApproval.mdwn    2015-04-30 17:14:50 UTC (rev 156)
@@ -1,9 +1,12 @@
+Project Approval at Savannah
+============================
+
 About project reviews
 ---------------------
 
-Savannah is a perfect place to emphasize free software values,
-especially the non-obvious/non-technical ones. We want you to understand
-them and follow a few good practices for your project.
+Savannah is a place to emphasize free software values, especially the
+non-obvious/non-technical ones. We want you to understand them and
+follow a few good practices for your project.
 
 The official requirements list is at
 <https://savannah.gnu.org/register/requirements.php>.
@@ -63,20 +66,14 @@
 -   [[AboutTranslations]]
 -   [[ApprovingSubmission]]
 -   [[FileFormats]]
--   [For
-    administrators](http://savannah.gnu.org/maintenance/ForAdministrators)
-    -   [savannah.el|vim](http://savannah.gnu.org/maintenance/SavannahElVim)
-
 -   [[GnuOrgTranslationTeams]]
--   [How to become a Savannah
-    Hacker](http://savannah.gnu.org/maintenance/HowToBecomeASavannahHacker)
+-   [HowToBecomeASavannahHacker]]
 -   [[LicensingRequirements]]
     -   [[DocumentationFormats]]
     -   [[DocumentationNotices]]
     -   [[DualLicensing]]
     -   [[GnuGplTwoOrLater]]
-    -   [How know if a license is free in 3
-        
points](http://savannah.gnu.org/maintenance/HowKnowIfALicenseIsFreeIn3Points)
+    -   [HowKnowIfALicenseIsFreeIn3Points]]
     -   [[ProprietaryUseOfFreeSoftware]]
     -   [[ValidNotices]]
 
@@ -92,3 +89,31 @@
 -   [[URIsToTheDependencies]]
 -   [[UpstreamCollaboration]]
 -   [[WhyLegalChecksBeforeRelease]]
+
+For Administrators
+==================
+
+Pinged message
+--------------
+
+If after one week, the submitter of a new project for approval didn't
+answer, the admin need to send a pinged message. The pinged message can
+be founded in [savannah.el|vim] as sv-pinged() under emacs and
+SV\_pinged() under vim.
+
+Zombie projects
+---------------
+
+When projects are removed from the tracker but not from the database,
+they stay there and increase the "pending projects" frontpage
+statistics. To find such projects, a good heuristic is:
+
+    SELECT groups.group_id, unix_group_name, groups.status, task.bug_id, 
task.status_id, groups.group_name FROM groups, task WHERE groups.status='P' AND 
task.group_id=5802 AND task.status_id=3 AND task.category_id=1 AND task.details 
LIKE CONCAT("%* System Name:  *", groups.unix_group_name, "*%") AND (SELECT 
count(*) FROM task WHERE task.group_id=5802 AND task.status_id=1 AND 
task.category_id=1 AND task.details LIKE CONCAT("%* System Name:  *", 
groups.unix_group_name, "*%")) = 0 GROUP BY groups.group_id ORDER BY bug_id;
+
+    DELETE groups FROM groups, task WHERE groups.status='P' AND 
task.group_id=5802 AND task.status_id=3 AND task.category_id=1 AND task.details 
LIKE CONCAT("%* System Name:  *", groups.unix_group_name, "*%") AND (SELECT 
count(*) FROM task WHERE task.group_id=5802 AND task.status_id=1 AND 
task.category_id=1 AND task.details LIKE CONCAT("%* System Name:  *", 
groups.unix_group_name, "*%")) = 0;
+
+It only fails if the group name was changed after the submission, or if
+a user maliciously fakes a submission item.
+
+A better solution would be to add a 'task\_id' field in the 'groups'
+table, filled in at registration time.

Deleted: trunk/sviki/SavannahMoreInfo.mdwn
===================================================================
--- trunk/sviki/SavannahMoreInfo.mdwn   2015-04-16 16:57:38 UTC (rev 155)
+++ trunk/sviki/SavannahMoreInfo.mdwn   2015-04-30 17:14:50 UTC (rev 156)
@@ -1,11 +0,0 @@
-Following are some useful links to get more information:
-
--   <http://www.gnu.org/prep/standards_toc.html>
-    The GNU coding standards
--   <http://www.gnu.org/help/evaluation.html>
-    The GNU evaluation team page, people related to GNU candidate
--   <http://www.cvshome.org/> about CVS using
--   <http://www.cvshome.org/docs/manual/cvs_17.html#SEC153>
-    Quick CVS reference
--   <http://www.gnu.org/copyleft/gpl.html#SEC4>
-    How to apply the GNU GPL to your programs

Modified: trunk/sviki/UserAuthentication.mdwn
===================================================================
--- trunk/sviki/UserAuthentication.mdwn 2015-04-16 16:57:38 UTC (rev 155)
+++ trunk/sviki/UserAuthentication.mdwn 2015-04-30 17:14:50 UTC (rev 156)
@@ -36,6 +36,18 @@
 (The database currently contains some malformed/invalid keys - when
 users uploaded invalid keys.)
 
+### Reactivating a user
+
+It's possible to do this in the web interface: Main page -> Browse Users
+List -> find user -> "[Activate]" in the Actions column.
+
+Also possible to do it in sql, of course.  Check the status, do the
+update as safely as possible, check again:
+
+    mysql> select user_id,user_name,status from user where user_name = 'FOO';
+    mysql> update user set status='A' where user_id=N and user_name='FOO' 
limit 1;
+    mysql> select user_id,user_name,status from user where user_name = 'FOO';
+
 ### User/group accounts
 
 In Savannah systems, there is a unix user for *each* Savannah