From owner-svn-src-user@freebsd.org Sun May 6 11:51:12 2018
Return-Path: <owner-svn-src-user@freebsd.org>
Delivered-To: svn-src-user@mailman.ysv.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1])
by mailman.ysv.freebsd.org (Postfix) with ESMTP id 93496FB749B
for <svn-src-user@mailman.ysv.freebsd.org>;
Sun, 6 May 2018 11:51:12 +0000 (UTC) (envelope-from des@FreeBSD.org)
Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org
[IPv6:2610:1c1:1:606c::19:3])
(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
(Client CN "mxrelay.nyi.freebsd.org",
Issuer "Let's Encrypt Authority X3" (verified OK))
by mx1.freebsd.org (Postfix) with ESMTPS id 456CA8113E;
Sun, 6 May 2018 11:51:12 +0000 (UTC) (envelope-from des@FreeBSD.org)
Received: from repo.freebsd.org (repo.freebsd.org
[IPv6:2610:1c1:1:6068::e6a:0])
(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
(Client did not present a certificate)
by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 405B6459F;
Sun, 6 May 2018 11:51:12 +0000 (UTC) (envelope-from des@FreeBSD.org)
Received: from repo.freebsd.org ([127.0.1.37])
by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id w46BpCWW016847;
Sun, 6 May 2018 11:51:12 GMT (envelope-from des@FreeBSD.org)
Received: (from des@localhost)
by repo.freebsd.org (8.15.2/8.15.2/Submit) id w46BpC20016846;
Sun, 6 May 2018 11:51:12 GMT (envelope-from des@FreeBSD.org)
Message-Id: <201805061151.w46BpC20016846@repo.freebsd.org>
X-Authentication-Warning: repo.freebsd.org: des set sender to des@FreeBSD.org
using -f
From: =?UTF-8?Q?Dag-Erling_Sm=c3=b8rgrav?= <des@FreeBSD.org>
Date: Sun, 6 May 2018 11:51:12 +0000 (UTC)
To: src-committers@freebsd.org, svn-src-user@freebsd.org
Subject: svn commit: r333294 - user/des/fbce/db
X-SVN-Group: user
X-SVN-Commit-Author: des
X-SVN-Commit-Paths: user/des/fbce/db
X-SVN-Commit-Revision: 333294
X-SVN-Commit-Repository: base
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-BeenThere: svn-src-user@freebsd.org
X-Mailman-Version: 2.1.25
Precedence: list
List-Id: "SVN commit messages for the experimental " user"
src tree" <svn-src-user.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/svn-src-user>,
<mailto:svn-src-user-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/svn-src-user/>
List-Post: <mailto:svn-src-user@freebsd.org>
List-Help: <mailto:svn-src-user-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/svn-src-user>,
<mailto:svn-src-user-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 06 May 2018 11:51:12 -0000
Author: des
Date: Sun May 6 11:51:11 2018
New Revision: 333294
URL: https://svnweb.freebsd.org/changeset/base/333294
Log:
Various updates and improvements.
Modified:
user/des/fbce/db/notes
Modified: user/des/fbce/db/notes
==============================================================================
--- user/des/fbce/db/notes Sun May 6 11:47:53 2018 (r333293)
+++ user/des/fbce/db/notes Sun May 6 11:51:11 2018 (r333294)
@@ -34,13 +34,16 @@ psql -f db/fbce.sql fbce fbce
# One-liner to set a user's password
perl -Ilib -MFBCE -e 'FBCE->model("FBCE::Person")->find({ login => "kenneth36" })->set_password("4ltInn!?")'
+# One-liner to reset everybody's passwords
+perl -Ilib -MFBCE -e 'map { $_->reset_password() } FBCE->model("FBCE::Person")->all();'
+
#
# The list of users is generated on freefall using scripts written for
# that purpose by gjb:
#
-# des@freefall ~% ~gjb/bin/genuserlist.sh
-# des@freefall ~% sort users.txt >users-20180516.txt
-# des@freefall ~% getent passwd >gecos-20180516.txt
+# % ./genuserlist.sh
+# % sort users.txt >users-20180516.txt
+# % getent passwd | sort >gecos-20180516.txt
#
./script/fbce_user.pl import users-20180516.txt
./script/fbce_user.pl gecos gecos-20180516.txt
@@ -56,7 +59,7 @@ perl -Ilib -MFBCE -e 'FBCE->model("FBCE::Person")->fin
# fst3k=# \t on
# Showing only tuples.
# fst3k=# \o active-20180516.txt
-# fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '2017-05-16' group by p.login;
+# fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '2017-05-16' group by p.login order by p.login;
# fst3k=# \o
#
./script/fbce_user.pl activate active-20180516.txt
@@ -72,6 +75,11 @@ perl -Ilib -MFBCE -e 'FBCE->model("FBCE::Person")->fin
# Finally, generate passwords
#
./script/fbce_user.pl pwgen
+
+#
+# The resulting fbce-passwords.tgz can now be sent to clusteradm who
+# will untar it in /home on freefall.
+#
# Print the logins of active users who haven't voted
perl -Ilib -MFBCE -e 'map { print $_->login, "\n" } grep { $_->active && $_->votes_voters->count == 0 } FBCE->model("FBCE::Person")->all'