This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "FusionForge".
The branch, 6.0 has been updated
via 8c96aabed2bd120b708f65e46062bde39820d54a (commit)
via d6fe330b9379c5018f29f3aa97a2b4a5891d8397 (commit)
via 956984890d1fac93eb611d77094bbf0f8928f795 (commit)
via 01f5bbaa24155279dab13e1e34dc7d82b70c25c1 (commit)
via 65ed1ae89f6553cf01d971436744a1af7b5c65a3 (commit)
from 710d073a17acb7a5a89ff00e251483df96bfdab3 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
https://scm.fusionforge.org/anonscm/gitweb/?p=fusionforge/fusionforge.git;a=commitdiff;h=8c96aabed2bd120b708f65e46062bde39820d54a
commit 8c96aabed2bd120b708f65e46062bde39820d54a
Author: Roland Mas <[email protected]>
Date: Tue Dec 8 10:48:11 2015 +0100
Also refresh NSS for groups
diff --git a/src/utils/refresh_nss.php b/src/utils/refresh_nss.php
index 1bb9a9d..4c24133 100644
--- a/src/utils/refresh_nss.php
+++ b/src/utils/refresh_nss.php
@@ -41,4 +41,14 @@ while ($arr = db_fetch_array($res)) {
$SYS->sysCheckCreateUser($u->getID());
}
+$res = db_query_params ('SELECT group_id FROM groups WHERE status=$1 ORDER BY
group_id',
+ array ('A'));
+
+while ($arr = db_fetch_array($res)) {
+ $g = group_get_object($arr['group_id']);
+ echo "Refreshing NSS for group ".$g->getUnixName()."\n" ;
+
+ $SYS->sysCheckCreateGroup($g->getID());
+}
+
?>
https://scm.fusionforge.org/anonscm/gitweb/?p=fusionforge/fusionforge.git;a=commitdiff;h=d6fe330b9379c5018f29f3aa97a2b4a5891d8397
commit d6fe330b9379c5018f29f3aa97a2b4a5891d8397
Author: Roland Mas <[email protected]>
Date: Tue Jul 7 18:29:13 2015 +0200
Added helper script to force refresh of NSS tables
diff --git a/src/utils/refresh_nss.php b/src/utils/refresh_nss.php
new file mode 100644
index 0000000..1bb9a9d
--- /dev/null
+++ b/src/utils/refresh_nss.php
@@ -0,0 +1,44 @@
+#! /usr/bin/php
+<?php
+/**
+ * Copyright 2010 Roland Mas
+ *
+ * This file is part of FusionForge. FusionForge is free software;
+ * you can redistribute it and/or modify it under the terms of the
+ * GNU General Public License as published by the Free Software
+ * Foundation; either version 2 of the Licence, or (at your option)
+ * any later version.
+ *
+ * FusionForge is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License along
+ * with FusionForge; if not, write to the Free Software Foundation, Inc.,
+ * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
+ */
+
+require (dirname(__FILE__).'/../common/include/env.inc.php');
+require_once $gfcommon.'include/pre.php';
+
+$err='';
+
+// Plugins subsystem
+require_once 'common/include/Plugin.class.php';
+require_once 'common/include/PluginManager.class.php';
+
+setup_plugin_manager () ;
+session_set_admin () ;
+
+$res = db_query_params ('SELECT user_id FROM users WHERE status=$1 ORDER BY
user_id',
+ array ('A'));
+
+while ($arr = db_fetch_array($res)) {
+ $u = user_get_object($arr['user_id']);
+ echo "Refreshing NSS for user ".$u->getUnixName()."\n" ;
+
+ $SYS->sysCheckCreateUser($u->getID());
+}
+
+?>
https://scm.fusionforge.org/anonscm/gitweb/?p=fusionforge/fusionforge.git;a=commitdiff;h=956984890d1fac93eb611d77094bbf0f8928f795
commit 956984890d1fac93eb611d77094bbf0f8928f795
Author: Roland Mas <[email protected]>
Date: Thu Feb 26 13:19:12 2015 +0100
Ensure constraint will be satisfied before trying to set it up
diff --git a/src/db/20121026-add-constraints.sql
b/src/db/20121026-add-constraints.sql
index 4869ebd..5b3acb7 100644
--- a/src/db/20121026-add-constraints.sql
+++ b/src/db/20121026-add-constraints.sql
@@ -93,6 +93,7 @@ ALTER TABLE people_job_inventory ADD FOREIGN KEY
(skill_year_id) REFERENCES peop
ALTER TABLE people_job ADD FOREIGN KEY (status_id) REFERENCES
people_job_status ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE people_job ADD FOREIGN KEY (category_id) REFERENCES
people_job_category ON DELETE CASCADE ON UPDATE CASCADE;
+DELETE FROM frs_dlstats_filetotal_agg WHERE file_id NOT IN (SELECT file_id
FROM frs_file);
ALTER TABLE frs_dlstats_filetotal_agg ADD FOREIGN KEY (file_id) REFERENCES
frs_file ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE forum_agg_msg_count ADD FOREIGN KEY (group_forum_id) REFERENCES
forum_group_list ON DELETE CASCADE ON UPDATE CASCADE;
https://scm.fusionforge.org/anonscm/gitweb/?p=fusionforge/fusionforge.git;a=commitdiff;h=01f5bbaa24155279dab13e1e34dc7d82b70c25c1
commit 01f5bbaa24155279dab13e1e34dc7d82b70c25c1
Author: Roland Mas <[email protected]>
Date: Thu Feb 26 13:04:20 2015 +0100
Set "deleted" artifacts to "closed" in order to be able to continue upgrade
diff --git a/src/db/20111125-drop-artifact-deleted-status.sql
b/src/db/20111125-drop-artifact-deleted-status.sql
index c621898..de2fbbc 100644
--- a/src/db/20111125-drop-artifact-deleted-status.sql
+++ b/src/db/20111125-drop-artifact-deleted-status.sql
@@ -1 +1,2 @@
+UPDATE artifact SET status_id = 2 WHERE status_id = 3;
DELETE FROM artifact_status WHERE id=3 AND status_name='Deleted';
https://scm.fusionforge.org/anonscm/gitweb/?p=fusionforge/fusionforge.git;a=commitdiff;h=65ed1ae89f6553cf01d971436744a1af7b5c65a3
commit 65ed1ae89f6553cf01d971436744a1af7b5c65a3
Author: Roland Mas <[email protected]>
Date: Thu Feb 26 11:31:41 2015 +0100
Made ADD CONSTRAINT more resilient (by adding DROP CONSTRAINT IF EXISTS
beforehand)
diff --git a/src/db/20111017-schema-convergence-from-nondeb.sql
b/src/db/20111017-schema-convergence-from-nondeb.sql
index 84fe513..be904bb 100644
--- a/src/db/20111017-schema-convergence-from-nondeb.sql
+++ b/src/db/20111017-schema-convergence-from-nondeb.sql
@@ -1,12 +1,16 @@
ALTER FUNCTION frs_dlstats_filetotal_insert_ag() RENAME TO
frs_dlstats_filetotal_insert_agg;
+ALTER TABLE ONLY artifact_type_monitor DROP CONSTRAINT IF EXISTS
artifact_type_monitor_group_artifact_id_fkey;
ALTER TABLE ONLY artifact_type_monitor ADD CONSTRAINT
artifact_type_monitor_group_artifact_id_fkey FOREIGN KEY (group_artifact_id)
REFERENCES artifact_group_list(group_artifact_id) ON DELETE CASCADE;
+ALTER TABLE ONLY artifact_type_monitor DROP CONSTRAINT IF EXISTS
artifact_type_monitor_user_id_fkey;
ALTER TABLE ONLY artifact_type_monitor ADD CONSTRAINT
artifact_type_monitor_user_id_fkey FOREIGN KEY (user_id) REFERENCES
users(user_id);
ALTER TABLE artifact_type_monitor DROP CONSTRAINT "$1";
ALTER TABLE artifact_type_monitor DROP CONSTRAINT "$2";
+ALTER TABLE ONLY forum_attachment DROP CONSTRAINT IF EXISTS
forum_attachment_msg_id_fkey;
ALTER TABLE ONLY forum_attachment ADD CONSTRAINT forum_attachment_msg_id_fkey
FOREIGN KEY (msg_id) REFERENCES forum(msg_id) ON DELETE CASCADE;
+ALTER TABLE ONLY forum_attachment DROP CONSTRAINT IF EXISTS
forum_attachment_userid_fkey;
ALTER TABLE ONLY forum_attachment ADD CONSTRAINT forum_attachment_userid_fkey
FOREIGN KEY (userid) REFERENCES users(user_id) ON DELETE SET DEFAULT;
ALTER TABLE forum_attachment DROP CONSTRAINT "$1";
@@ -16,6 +20,7 @@ ALTER SEQUENCE supported_langu_language_id_seq RENAME TO
supported_languages_pk_
ALTER TABLE supported_languages ALTER COLUMN language_id SET DEFAULT
nextval(('supported_languages_pk_seq'::text)::regclass);
ALTER SEQUENCE group_cvs_history_id_seq RENAME TO group_cvs_history_pk_seq;
ALTER TABLE group_cvs_history ALTER COLUMN id SET DEFAULT
nextval(('group_cvs_history_pk_seq'::text)::regclass);
+ALTER TABLE group_cvs_history DROP CONSTRAINT IF EXISTS group_cvs_history_pkey;
ALTER TABLE group_cvs_history ADD CONSTRAINT group_cvs_history_pkey PRIMARY
KEY (id);
ALTER SEQUENCE project_messa_project_messa_seq RENAME TO
project_messages_project_message_id_seq;
@@ -29,24 +34,33 @@ ALTER TABLE db_images ALTER COLUMN version SET DEFAULT 0;
ALTER TABLE group_join_request DROP CONSTRAINT "$1";
ALTER TABLE group_join_request DROP CONSTRAINT "$2";
+ALTER TABLE group_join_request DROP CONSTRAINT IF EXISTS
group_join_request_group_id_fkey;
ALTER TABLE group_join_request ADD CONSTRAINT group_join_request_group_id_fkey
FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;
+ALTER TABLE group_join_request DROP CONSTRAINT IF EXISTS
group_join_request_user_id_fkey;
ALTER TABLE group_join_request ADD CONSTRAINT group_join_request_user_id_fkey
FOREIGN KEY (user_id) REFERENCES users(user_id);
+ALTER TABLE groups DROP CONSTRAINT IF EXISTS groups_license;
ALTER TABLE groups ADD CONSTRAINT groups_license FOREIGN KEY (license)
REFERENCES licenses(license_id) MATCH FULL;
ALTER TABLE groups ALTER COLUMN unix_box SET DEFAULT 'shell'::character
varying;
ALTER TABLE users ALTER COLUMN unix_box SET DEFAULT 'shell'::character varying;
DROP INDEX plugins_plugin_name_key;
+ALTER TABLE plugins DROP CONSTRAINT IF EXISTS plugins_plugin_name_key;
ALTER TABLE plugins ADD CONSTRAINT plugins_plugin_name_key UNIQUE
(plugin_name);
+ALTER TABLE project_tags DROP CONSTRAINT IF EXISTS project_tags_group_id_fkey;
ALTER TABLE project_tags ADD CONSTRAINT project_tags_group_id_fkey FOREIGN KEY
(group_id) REFERENCES groups(group_id) MATCH FULL;
+ALTER TABLE project_task DROP CONSTRAINT IF EXISTS
project_task_group_project_id_f;
ALTER TABLE project_task ADD CONSTRAINT project_task_group_project_id_f
FOREIGN KEY (group_project_id) REFERENCES project_group_list(group_project_id)
MATCH FULL;
ALTER TABLE project_task_external_order DROP CONSTRAINT "$1";
+ALTER TABLE project_task_external_order DROP CONSTRAINT IF EXISTS
project_task_external_order_project_task_id_fkey;
ALTER TABLE project_task_external_order ADD CONSTRAINT
project_task_external_order_project_task_id_fkey FOREIGN KEY (project_task_id)
REFERENCES project_task(project_task_id) MATCH FULL ON DELETE CASCADE;
+ALTER TABLE project_weekly_metric DROP CONSTRAINT IF EXISTS
project_weekly_metric_pkey;
ALTER TABLE project_weekly_metric ADD CONSTRAINT project_weekly_metric_pkey
PRIMARY KEY (ranking);
DROP SEQUENCE project_metric_wee_ranking1_seq;
ALTER TABLE role DROP CONSTRAINT "$1";
+ALTER TABLE role DROP CONSTRAINT IF EXISTS role_group_id_fkey;
ALTER TABLE role ADD CONSTRAINT role_group_id_fkey FOREIGN KEY (group_id)
REFERENCES groups(group_id) ON DELETE CASCADE;
ALTER TABLE project_messages ALTER COLUMN project_message_id SET DEFAULT
nextval('project_messages_project_message_id_seq'::regclass);
@@ -113,15 +127,18 @@ ALTER TABLE user_preferences RENAME COLUMN set_date_new
TO set_date;
ALTER TABLE project_task DROP CONSTRAINT project_task_category_id_fkey;
DROP INDEX project_categor_category_id_key;
+ALTER TABLE project_category DROP CONSTRAINT IF EXISTS project_category_pkey;
ALTER TABLE project_category ADD CONSTRAINT project_category_pkey PRIMARY KEY
(category_id);
+ALTER TABLE project_task DROP CONSTRAINT IF EXISTS
project_task_category_id_fkey;
ALTER TABLE project_task ADD CONSTRAINT project_task_category_id_fkey FOREIGN
KEY (category_id) REFERENCES project_category(category_id);
ALTER TABLE users DROP CONSTRAINT users_themeid;
DROP INDEX themes_theme_id_key;
+ALTER TABLE themes DROP CONSTRAINT IF EXISTS themes_pkey;
ALTER TABLE themes ADD CONSTRAINT themes_pkey PRIMARY KEY (theme_id);
+ALTER TABLE users DROP CONSTRAINT IF EXISTS users_themeid;
ALTER TABLE users ADD CONSTRAINT users_themeid FOREIGN KEY (theme_id)
REFERENCES themes(theme_id) MATCH FULL;
-
CREATE OR REPLACE VIEW stats_project_all_vw AS SELECT
stats_project_months.group_id, (avg(stats_project_months.developers))::integer
AS developers, (avg(stats_project_months.group_ranking))::integer AS
group_ranking, avg(stats_project_months.group_metric) AS group_metric,
sum(stats_project_months.logo_showings) AS logo_showings,
sum(stats_project_months.downloads) AS downloads,
sum(stats_project_months.site_views) AS site_views,
sum(stats_project_months.subdomain_views) AS subdomain_views,
sum(stats_project_months.page_views) AS page_views,
sum(stats_project_months.file_releases) AS file_releases,
sum(stats_project_months.msg_posted) AS msg_posted,
(avg(stats_project_months.msg_uniq_auth))::integer AS msg_uniq_auth,
sum(stats_project_months.bugs_opened) AS bugs_opened,
sum(stats_project_months.bugs_closed) AS bugs_closed,
sum(stats_project_months.support_opened) AS support_opened,
sum(stats_project_months.support_closed) AS support_closed,
sum(stats_project_months.patches_opened) AS patches_opened,
sum(stats_project_months.patches_closed) AS patches_closed,
sum(stats_project_months.artifacts_opened) AS artifacts_opened,
sum(stats_project_months.artifacts_closed) AS artifacts_closed,
sum(stats_project_months.tasks_opened) AS tasks_opened,
sum(stats_project_months.tasks_closed) AS tasks_closed,
sum(stats_project_months.help_requests) AS help_requests,
sum(stats_project_months.cvs_checkouts) AS cvs_checkouts,
sum(stats_project_months.cvs_commits) AS cvs_commits,
sum(stats_project_months.cvs_adds) AS cvs_adds FROM stats_project_months GROUP
BY stats_project_months.group_id;
CREATE OR REPLACE VIEW stats_project_vw AS SELECT spd.group_id, spd.month,
spd.day, spd.developers, spm.ranking AS group_ranking, spm.percentile AS
group_metric, salbg.count AS logo_showings, fdga.downloads, sasbg.count AS
site_views, ssp.pages AS subdomain_views, (COALESCE(sasbg.count, 0) +
COALESCE(ssp.pages, 0)) AS page_views, sp.file_releases, sp.msg_posted,
sp.msg_uniq_auth, sp.bugs_opened, sp.bugs_closed, sp.support_opened,
sp.support_closed, sp.patches_opened, sp.patches_closed, sp.artifacts_opened,
sp.artifacts_closed, sp.tasks_opened, sp.tasks_closed, sp.help_requests,
scg.checkouts AS cvs_checkouts, scg.commits AS cvs_commits, scg.adds AS
cvs_adds FROM (((((((stats_project_developers spd LEFT JOIN stats_project sp
USING (month, day, group_id)) LEFT JOIN stats_project_metric spm USING (month,
day, group_id)) LEFT JOIN stats_cvs_group scg USING (month, day, group_id))
LEFT JOIN stats_agg_site_by_group sasbg USING (month, day, group_id)) LEFT JOIN
stats_agg_logo_by_group salbg USING (month, day, group_id)) LEFT JOIN
stats_subd_pages ssp USING (month, day, group_id)) LEFT JOIN
frs_dlstats_group_vw fdga USING (month, day, group_id));
-----------------------------------------------------------------------
Summary of changes:
src/db/20111017-schema-convergence-from-nondeb.sql | 19 ++++++++++++++++++-
src/db/20111125-drop-artifact-deleted-status.sql | 1 +
src/db/20121026-add-constraints.sql | 1 +
src/{bin => utils}/refresh_nss.php | 0
4 files changed, 20 insertions(+), 1 deletion(-)
copy src/{bin => utils}/refresh_nss.php (100%)
mode change 100755 => 100644
hooks/post-receive
--
FusionForge
_______________________________________________
Fusionforge-commits mailing list
[email protected]
http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-commits
