svn commit: r235792 - user/des/fbce/db

[Dag-Erling Smorgrav]

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