[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-cvs] [156] discuss reactivating a user; other simplifications
From: |
karl |
Subject: |
[Savannah-cvs] [156] discuss reactivating a user; other simplifications |
Date: |
Thu, 30 Apr 2015 17:15:06 +0000 |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Savannah-cvs] [156] discuss reactivating a user; other simplifications,
karl <=