From owner-svn-src-user@FreeBSD.ORG  Tue May 22 16:44:07 2012
Return-Path: <owner-svn-src-user@FreeBSD.ORG>
Delivered-To: svn-src-user@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id AE3BF1065670;
	Tue, 22 May 2012 16:44:07 +0000 (UTC) (envelope-from des@FreeBSD.org)
Received: from svn.freebsd.org (svn.freebsd.org [IPv6:2001:4f8:fff6::2c])
	by mx1.freebsd.org (Postfix) with ESMTP id 99F318FC12;
	Tue, 22 May 2012 16:44:07 +0000 (UTC)
Received: from svn.freebsd.org (localhost [127.0.0.1])
	by svn.freebsd.org (8.14.4/8.14.4) with ESMTP id q4MGi7st013819;
	Tue, 22 May 2012 16:44:07 GMT (envelope-from des@svn.freebsd.org)
Received: (from des@localhost)
	by svn.freebsd.org (8.14.4/8.14.4/Submit) id q4MGi7aN013817;
	Tue, 22 May 2012 16:44:07 GMT (envelope-from des@svn.freebsd.org)
Message-Id: <201205221644.q4MGi7aN013817@svn.freebsd.org>
From: Dag-Erling Smorgrav <des@FreeBSD.org>
Date: Tue, 22 May 2012 16:44:07 +0000 (UTC)
To: src-committers@freebsd.org, svn-src-user@freebsd.org
X-SVN-Group: user
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Cc: 
Subject: svn commit: r235792 - user/des/fbce/db
X-BeenThere: svn-src-user@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: "SVN commit messages for the experimental &quot; user&quot;
	src tree" <svn-src-user.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/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: <http://lists.freebsd.org/mailman/listinfo/svn-src-user>,
	<mailto:svn-src-user-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 22 May 2012 16:44:07 -0000

Author: des
Date: Tue May 22 16:44:07 2012
New Revision: 235792
URL: http://svn.freebsd.org/changeset/base/235792

Log:
  Add command lines used to populate the user table
  Add comments

Modified:
  user/des/fbce/db/notes

Modified: user/des/fbce/db/notes
==============================================================================
--- user/des/fbce/db/notes	Tue May 22 16:40:20 2012	(r235791)
+++ user/des/fbce/db/notes	Tue May 22 16:44:07 2012	(r235792)
@@ -1,10 +1,31 @@
 # $FreeBSD$
 
-% sudo /usr/local/etc/rc.d/postgresql initdb
-% sudo /usr/local/etc/rc.d/postgresql start
-% sudo -u pgsql createuser -s des
-% createuser -S -D -R fbce
-% createdb -E utf8 -O fbce fbce
-% psql -f db/fbce.sql fbce fbce 
-% ./db/update.sh
-% perl -Ilib -MFBCE -e 'FBCE->model("FBCE::Person")->find({ login => "kenneth36" })->set_password("altinn")'
+# Initialize PostgreSQL
+sudo /usr/local/etc/rc.d/postgresql initdb
+sudo /usr/local/etc/rc.d/postgresql start
+
+# Create a superuser for myself
+sudo -u pgsql createuser -s des
+
+# Create a regular user and database for FBCE
+createuser -S -D -R fbce
+createdb -E utf8 -O fbce fbce
+
+# Create the schema
+psql -f db/fbce.sql fbce fbce 
+
+# Regenerate the DBIC schema
+./db/update.sh
+
+# One-liner to set a user's password
+perl -Ilib -MFBCE -e 'FBCE->model("FBCE::Person")->find({ login => "kenneth36" })->set_password("altinn")'
+
+# Pull users from peter@'s cutoff list
+./script/fbce_user.pl pull
+
+# Get a copy of freefall's passwd map and load people's names from it
+ssh freefall ypcat passwd | iconv -f iso8859-1 -t utf-8 >freefall-nis-passwd-utf8
+./script/fbce_user.pl gecos freefall-nis-passwd-utf8
+
+# Generate new passwords for everybody that doesn't already have one
+./script/fbce_user.pl pwgen