Index: user/des/fbce/db/notes =================================================================== --- user/des/fbce/db/notes (revision 331559) +++ user/des/fbce/db/notes (revision 331560) @@ -1,73 +1,73 @@ #!/bin/sh # # These are instructions for creating and populating the FBCE # database. Note that although this is a syntactically correct shell # script, it will not (or at least should not) run unmodified. # # $FreeBSD$ # # Initialize PostgreSQL sudo service postgresql initdb sudo service postgresql start # Create a superuser for myself -sudo -u pgsql createuser -s des +sudo -u postgres 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 # # Note that this will not overwrite lib/FBCE/Model/FBCE.pm, but # instead create lib/FBCE/Model/FBCE.pm.new. You may replace the old # file with the new, but you should remove the connect_info and place # it in fbce_local.conf instead (copy the section from # fbce.conf and insert the correct host, user and password). # ./db/update.sh fbce # One-liner to set a user's password perl -Ilib -MFBCE -e 'FBCE->model("FBCE::Person")->find({ login => "kenneth36" })->set_password("4ltInn!?")' # # 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-20160518.txt # des@freefall ~% getent passwd >gecos-20160518.txt # ./script/fbce_user.pl import users-20160518.txt ./script/fbce_user.pl gecos gecos-20160518.txt # # The list of active committers is extracted from fst3k: # # fst3k=# \t on # Showing only tuples. # fst3k=# \o active-20160518.txt # fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '2015-05-18' group by p.login; # fst3k=# \o # ./script/fbce_user.pl smash ./script/fbce_user.pl activate active-20160518.txt # # The list of incumbents is obtained from freefall: # # des@freefall ~% getent group core | grep -v matthew | cut -d: -f4 | tr , '\n' >core-20160518.txt # ./script/fbce_user.pl incumbent core-20160518.txt # # Finally, generate passwords # ./script/fbce_user.pl pwgen # 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' Index: user/des/fbce/fbce.conf =================================================================== --- user/des/fbce/fbce.conf (revision 331559) +++ user/des/fbce/fbce.conf (revision 331560) @@ -1,35 +1,35 @@ # $FreeBSD$ -title = 2016 FreeBSD Core Team Election -descr = 2016 FreeBSD core team election +title = 2018 FreeBSD Core Team Election +descr = 2018 FreeBSD core team election dsn = "dbi:Pg:dbname=dbname" user = "user" password = "password" - nominating_starts = 2016-05-18 18:00:00 UTC - nominating_ends = 2016-05-25 18:00:00 UTC - voting_starts = 2016-05-25 18:00:00 UTC - voting_ends = 2016-06-22 18:00:00 UTC - announcement = 2016-06-29 18:00:00 UTC - investiture = 2016-07-06 18:00:00 UTC + nominating_starts = 2018-05-16 18:00:00 UTC + nominating_ends = 2018-05-23 18:00:00 UTC + voting_starts = 2018-05-23 18:00:00 UTC + voting_ends = 2018-06-20 18:00:00 UTC + announcement = 2018-06-27 18:00:00 UTC + investiture = 2018-07-04 18:00:00 UTC max_votes = 9 cutoff = 1 year expires = 7200 cookie_expires = 0 # cookie_secure = true storage = /tmp/fbce.__UID__/session-cache unlink_on_exit = 0 cache_size = 8m