[hcoop/scripts.git] / create-user

#!/bin/bash -ex

# MUST be executed:
#  - on deleuze
#  - as a user with an /etc/sudoers line
#  - member of "wheel" unix group on deleuze
#  - while holding tickets for a user who can 'ssh -K' to mire
#     - and is a member of "wheel" on mire
#  - while holding tokens for a user who is:
#     - a member of system:administrator
#     - listed in 'bos listusers deleuze'
#  - and who has been set up with Domtool admin privileges by:
#     - running 'domtool-adduser $USER' while holding AFS admin tokens as
#       someone who is already a Domtool admin
#     - running 'domtool-admin grant $USER priv all' as someone who is already a
#       Domtool admin
#       (To bootstrap yourself into admindom:
#         1. Run '/etc/init.d/domtool-server stop' on deleuze.
#         2. Run '/etc/init.d/domtool-slave stop' on all Domtool slave machines
#            (e.g., mire).
#         3. Edit ~domtool/acl, following the example of adamc_admin to grant
#             yourself 'priv all'.
#         4. Run '/etc/init.d/domtool-server start' on deleuze.
#         5. Run '/etc/init.d/domtool-slave start' on all Domtool slave
#            machines.
#         6. Run 'domtool-adduser' as above.)

USER=$1

export PATH=$PATH:/afs/hcoop.net/common/bin/

if test -z "$USER"; then
	echo "Invoke as create-user <USERNAME>"
	exit 1
fi

#
# Helper functions
#

# Run a command on both mire and deleuze; assumes that no escaping is
# needed.
function mire_and_deleuze() {
    $*
    ssh mire.hcoop.net $*
}

#
# Kerberos principals
# (creat kerberos principals: fred, fred/cgi, fred/mailfilter)
#

# We use -randkey for user's main principal as well, to make sure that
# the creation process does not continue without having a main 
# principal. (But you who want to set password for a user, don't 
# worry - we'll invoke cpw later, so that it has the same effect
# as setting password right now - while it is more error tolerant).

sudo kadmin.local -p root/admin -q "ank -policy user -randkey +requires_preauth $USER@HCOOP.NET"
sudo kadmin.local -p root/admin -q "modprinc -maxlife 1day $USER@HCOOP.NET"
sudo kadmin.local -p root/admin -q "ank -policy daemon -randkey +requires_preauth $USER/daemon@HCOOP.NET"

#
# Create AFS users corresponding to krb5 principals.
# (fred/cgi principal == fred.cgi AFS user)
#

pts cu $USER || true
ID=`pts examine $USER | head -n1 | sed 's_.*, id: *__' | sed 's_,.*__'`
pts cu $USER.daemon || true
ID_DAEMON=`pts examine $USER.daemon | head -n1 | sed 's_.*, id: *__' | sed 's_,.*__'`


#
# Construct various paths for later perusal.
#

# (If it's not clear, for user fred, PATHBITS = f/fr/fred)
PATHBITS=`echo $USER | head -c 1`/`echo $USER | head -c 2`/$USER
HOMEPATH=/afs/hcoop.net/user/$PATHBITS
MAILPATH=/afs/hcoop.net/common/email/$PATHBITS
DBPATH=/afs/hcoop.net/common/.databases/$PATHBITS
PGDIR=$DBPATH/postgres
MYSQLDIR=$DBPATH/mysql


#
# Create LDAP entries. (With the whole libnss-ptdb, I kind of
# lost the idea of what I want to do with LDAP, but we'll 
# see with time how well it integrates...)
# The ID returned from AFS is important here, we want to make
# sure those IDs match.
#

# USER entry
echo "
dn: uid=$USER,ou=People,dc=hcoop,dc=net
objectClass: top
objectClass: person
objectClass: posixAccount
cn: $USER
uid: $USER
gidNumber: $ID
sn: $USER
host: abulafia
host: mire

dn: cn=$USER,ou=Group,dc=hcoop,dc=net
objectClass: top
objectClass: posixGroup
cn: $USER
gidNumber: $ID
memberUid: $USER
" | sudo ldapadd -x -D cn=admin,dc=hcoop,dc=net -y /etc/ldap.secret || true

# USER.daemon entry
echo "
dn: uid=$USER.daemon,ou=People,dc=hcoop,dc=net
objectClass: top
objectClass: person
objectClass: posixAccount
cn: $USER.daemon
uid: $USER.daemon
gidNumber: $ID_DAEMON
sn: $USER.daemon

dn: cn=$USER.daemon,ou=Group,dc=hcoop,dc=net
objectClass: top
objectClass: posixGroup
cn: $USER.daemon
gidNumber: $ID_DAEMON
memberUid: $USER.daemon
" | sudo ldapadd -x -D cn=admin,dc=hcoop,dc=net -y /etc/ldap.secret || true


#
# Export .mailfilter and .cgi keys to a keytab file
#

# create a daemon keytab (used by /etc/exim4/get-token)
# *only* if it does not exist!
test -e /etc/keytabs/user.daemon/$USER || \
  sudo kadmin.local -p root/admin -q "ktadd -k /etc/keytabs/user.daemon/$USER $USER/daemon@HCOOP.NET"

# Properly chown/mod keytab files (must be $USER:www-data)
sudo chown $USER:www-data /etc/keytabs/user.daemon/$USER
sudo chmod 440            /etc/keytabs/user.daemon/$USER

# rsync keytabs
(cd /etc/keytabs
   sudo tar clpf - user.daemon/$USER | \
     ssh mire.hcoop.net cd /etc/keytabs\; sudo tar xlpf -)
(cd /etc/keytabs
   sudo tar clpf - user.daemon/$USER | \
     ssh hopper.hcoop.net cd /etc/keytabs\; sudo tar xlpf -)

#
# Create/mount/set-perms on user's volumes (home, mail, databases, logs)
#

# HOME VOLUME
if vos examine user.$USER.d 2>/dev/null; then
	echo "Reactivating old volume (user.$USER.d)"
	vos rename user.$USER.d user.$USER
fi
vos examine user.$USER 2>/dev/null || \
  vos create deleuze.hcoop.net /vicepa user.$USER -maxquota 400000

mkdir -p `dirname $HOMEPATH`
fs ls $HOMEPATH || test -L $HOMEPATH || fs mkm $HOMEPATH user.$USER
chown $USER:nogroup $HOMEPATH
fs sa $HOMEPATH $USER            all
fs sa $HOMEPATH system:anyuser   l

# Apache logs
mkdir -p $HOMEPATH/.logs
chown $USER:nogroup $HOMEPATH/.logs
mkdir -p $HOMEPATH/.logs/apache
chown $USER:nogroup $HOMEPATH/.logs/apache
fs sa $HOMEPATH/.logs/apache $USER.daemon rlwidk
mkdir -p $HOMEPATH/.logs/mail
fs sa $HOMEPATH/.logs/mail $USER.daemon rlwidk
chown $USER:nogroup $HOMEPATH/.logs/mail

# public_html
test -e $HOMEPATH/public_html || \
 (mkdir -p $HOMEPATH/public_html; \
  chown $USER:nogroup $HOMEPATH/public_html; \
  fs sa $HOMEPATH/public_html system:anyuser none; \
  fs sa $HOMEPATH/public_html $USER.daemon rl)

# .procmail.d
mkdir -p $HOMEPATH/.procmail.d
chown $USER:nogroup $HOMEPATH/.procmail.d
fs sa $HOMEPATH/.procmail.d system:anyuser rl

# .public
mkdir -p $HOMEPATH/.public/
chown $USER:nogroup $HOMEPATH/.public
fs sa $HOMEPATH/.public system:anyuser rl

# .domtool
mkdir -p $HOMEPATH/.public/.domtool
chown $USER:nogroup $HOMEPATH/.public/.domtool
test -e $HOMEPATH/.domtool || \
    test -L $HOMEPATH/.domtool || \
        sudo -u $USER ln -s $HOMEPATH/.public/.domtool $HOMEPATH/.domtool

# Gitweb hosting
test -L /var/cache/git/$USER || \
    sudo ln -s $HOMEPATH/.hcoop-git /var/cache/git/$USER

# MAIL VOLUME
if vos examine mail.$USER.d 2>/dev/null; then
	echo "Reactivating old volume (mail.$USER.d)"
	vos rename mail.$USER.d mail.$USER
fi
vos examine mail.$USER 2>/dev/null || \
  vos create deleuze.hcoop.net /vicepa mail.$USER -maxquota 400000

mkdir -p `dirname $MAILPATH`
fs ls $MAILPATH || fs mkm $MAILPATH         mail.$USER
fs ls $HOMEPATH/Maildir || fs mkm $HOMEPATH/Maildir mail.$USER
chown $USER:nogroup $MAILPATH
chown $USER:nogroup $HOMEPATH/Maildir
fs sa $MAILPATH $USER        all
fs sa $MAILPATH $USER.daemon all
if test ! -e $MAILPATH/new; then
    mkdir -p $MAILPATH/cur $MAILPATH/new $MAILPATH/tmp
    echo -e "This email account is provided as a service for HCoop members." \
        "\n\nTo learn how to use it, please visit the page" \
        "\n<http://wiki.hcoop.net/MemberManual/Email> on our website."| \
        mail -s "Welcome to your HCoop email store" \
            -e -a "From: postmaster@hcoop.net" \
            real-$USER
fi
chown $USER:nogroup $MAILPATH/cur $MAILPATH/new $MAILPATH/tmp

# Set up shared SpamAssassin folder
if test -f $HOMEPATH/Maildir/shared-maildirs; then
    # Deal with case where user rsync'd their Maildir from fyodor
    pattern='^SpamAssassin	/home/spamd'
    file=$HOMEPATH/Maildir/shared-maildirs
    if grep $pattern $file; then
        sed -i -r -e \
            's!^(SpamAssassin	)/home/spamd!\1/var/local/lib/spamd!1' \
            $file
    fi
else
    maildirmake --add SpamAssassin=/var/local/lib/spamd/Maildir \
        $HOMEPATH/Maildir
fi

# DATABASE VOLUME
if ! vos examine db.$USER >/dev/null 2>/dev/null; then
  mkdir -p `dirname /afs/.hcoop.net/common/.databases/$PATHBITS`
  vos create -server afs -partition a -name db.$USER -maxquota 400000
  fs mkmount -dir /afs/.hcoop.net/common/.databases/$PATHBITS -vol db.$USER -rw
  fs sa -dir $DBPATH -acl system:postgres l
  fs sa -dir $DBPATH -acl system:mysql    l
  fs sa -dir $DBPATH -acl system:backup   rl
  fs sa -dir $DBPATH -acl $USER           rl
fi

# Create postgres user and tablespace placeholder within volume
if ! test -d $PGDIR; then
  mkdir -p $PGDIR
  chown postgres:postgres $PGDIR
  fs sa -dir $PGDIR -acl system:postgres write
  fs sa -dir $PGDIR -acl $USER           none

 sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1
fi

# Create mysql user and databases placeholder within volume
mkdir -p $MYSQLDIR
chown mysql:mysql $MYSQLDIR
fs sa -dir $MYSQLDIR -acl system:mysql  write
fs sa -dir $MYSQLDIR -acl $USER         none

vos release common.databases

#
# Mount points for backup volumes
#

mkdir -p `dirname /afs/hcoop.net/.old/user/$PATHBITS`
mkdir -p `dirname /afs/hcoop.net/.old/mail/$PATHBITS`
fs ls /afs/hcoop.net/.old/user/$PATHBITS || \
  fs mkm /afs/hcoop.net/.old/user/$PATHBITS user.$USER.backup
fs ls /afs/hcoop.net/.old/mail/$PATHBITS || \
  fs mkm /afs/hcoop.net/.old/mail/$PATHBITS mail.$USER.backup
vos release old

# technically this might not be necessary, but for good measure...
vos syncserv deleuze
vos syncvldb deleuze

# refresh volume location cache (takes ~2hrs otherwise)
mire_and_deleuze fs checkvolumes

#
# Non-AFS files and directories
#

# Make per-user apache DAV lock directory -- the directory must be
# both user and group-writable, which is silly.
mire_and_deleuze sudo mkdir -p /var/lock/apache2/dav/$USER
mire_and_deleuze sudo chown $USER:www-data /var/lock/apache2/dav/$USER
mire_and_deleuze sudo chmod ug=rwx,o= /var/lock/apache2/dav/$USER

#
# Domtool integration
#

domtool-adduser $USER

#
# Subscribe user to our mailing lists.
#
echo $USER@hcoop.net | sudo -u list \
    /var/lib/mailman/bin/add_members -r - hcoop-announce
Commit	Line	Data
d2462e94	1	#!/bin/bash -ex
	2
	3	# MUST be executed:
	4	# - on deleuze
	5	# - as a user with an /etc/sudoers line
64f69c08	6	# - member of "wheel" unix group on deleuze
78725790	7	# - while holding tickets for a user who can 'ssh -K' to mire
64f69c08	8	# - and is a member of "wheel" on mire
d2462e94	9	# - while holding tokens for a user who is:
	10	# - a member of system:administrator
	11	# - listed in 'bos listusers deleuze'
241a0263	12	# - and who has been set up with Domtool admin privileges by:
	13	# - running 'domtool-adduser $USER' while holding AFS admin tokens as
	14	# someone who is already a Domtool admin
	15	# - running 'domtool-admin grant $USER priv all' as someone who is already a
	16	# Domtool admin
	17	# (To bootstrap yourself into admindom:
	18	# 1. Run '/etc/init.d/domtool-server stop' on deleuze.
	19	# 2. Run '/etc/init.d/domtool-slave stop' on all Domtool slave machines
	20	# (e.g., mire).
	21	# 3. Edit ~domtool/acl, following the example of adamc_admin to grant
	22	# yourself 'priv all'.
	23	# 4. Run '/etc/init.d/domtool-server start' on deleuze.
	24	# 5. Run '/etc/init.d/domtool-slave start' on all Domtool slave
	25	# machines.
	26	# 6. Run 'domtool-adduser' as above.)
d2462e94	27
	28	USER=$1
	29
cd0db70e	30	export PATH=$PATH:/afs/hcoop.net/common/bin/
cd0db70e	31
d2462e94	32	if test -z "$USER"; then
	33	echo "Invoke as create-user <USERNAME>"
	34	exit 1
	35	fi
	36
7e1859cd	37	#
	38	# Helper functions
	39	#
	40
	41	# Run a command on both mire and deleuze; assumes that no escaping is
	42	# needed.
	43	function mire_and_deleuze() {
	44	$*
	45	ssh mire.hcoop.net $*
	46	}
d2462e94	47
	48	#
	49	# Kerberos principals
	50	# (creat kerberos principals: fred, fred/cgi, fred/mailfilter)
	51	#
	52
	53	# We use -randkey for user's main principal as well, to make sure that
	54	# the creation process does not continue without having a main
	55	# principal. (But you who want to set password for a user, don't
	56	# worry - we'll invoke cpw later, so that it has the same effect
	57	# as setting password right now - while it is more error tolerant).
	58
52e2a5b3	59	sudo kadmin.local -p root/admin -q "ank -policy user -randkey +requires_preauth $USER@HCOOP.NET"
cd0db70e	60	sudo kadmin.local -p root/admin -q "modprinc -maxlife 1day $USER@HCOOP.NET"
cd0db70e	61	sudo kadmin.local -p root/admin -q "ank -policy daemon -randkey +requires_preauth $USER/daemon@HCOOP.NET"
d2462e94	62
	63	#
	64	# Create AFS users corresponding to krb5 principals.
	65	# (fred/cgi principal == fred.cgi AFS user)
	66	#
	67
	68	pts cu $USER \|\| true
	69	ID=`pts examine $USER \| head -n1 \| sed 's_., id: __' \| sed 's_,.*__'`
cd0db70e	70	pts cu $USER.daemon \|\| true
cd0db70e	71	ID_DAEMON=`pts examine $USER.daemon \| head -n1 \| sed 's_., id: __' \| sed 's_,.*__'`
d2462e94	72
	73
	74	#
	75	# Construct various paths for later perusal.
	76	#
	77
	78	# (If it's not clear, for user fred, PATHBITS = f/fr/fred)
	79	PATHBITS=`echo $USER \| head -c 1`/`echo $USER \| head -c 2`/$USER
	80	HOMEPATH=/afs/hcoop.net/user/$PATHBITS
	81	MAILPATH=/afs/hcoop.net/common/email/$PATHBITS
64f69c08	82	DBPATH=/afs/hcoop.net/common/.databases/$PATHBITS
d2462e94	83	PGDIR=$DBPATH/postgres
	84	MYSQLDIR=$DBPATH/mysql
	85
	86
	87	#
	88	# Create LDAP entries. (With the whole libnss-ptdb, I kind of
	89	# lost the idea of what I want to do with LDAP, but we'll
	90	# see with time how well it integrates...)
	91	# The ID returned from AFS is important here, we want to make
	92	# sure those IDs match.
	93	#
	94
	95	# USER entry
	96	echo "
	97	dn: uid=$USER,ou=People,dc=hcoop,dc=net
	98	objectClass: top
	99	objectClass: person
	100	objectClass: posixAccount
	101	cn: $USER
	102	uid: $USER
	103	gidNumber: $ID
d2462e94	104	sn: $USER
	105	host: abulafia
	106	host: mire
	107
	108	dn: cn=$USER,ou=Group,dc=hcoop,dc=net
	109	objectClass: top
	110	objectClass: posixGroup
	111	cn: $USER
	112	gidNumber: $ID
	113	memberUid: $USER
0963ebc5	114	" \| sudo ldapadd -x -D cn=admin,dc=hcoop,dc=net -y /etc/ldap.secret \|\| true
d2462e94	115
cd0db70e	116	# USER.daemon entry
d2462e94	117	echo "
cd0db70e	118	dn: uid=$USER.daemon,ou=People,dc=hcoop,dc=net
d2462e94	119	objectClass: top
	120	objectClass: person
	121	objectClass: posixAccount
cd0db70e	122	cn: $USER.daemon
	123	uid: $USER.daemon
	124	gidNumber: $ID_DAEMON
	125	sn: $USER.daemon
d2462e94	126
cd0db70e	127	dn: cn=$USER.daemon,ou=Group,dc=hcoop,dc=net
d2462e94	128	objectClass: top
d2462e94	129	objectClass: posixGroup
cd0db70e	130	cn: $USER.daemon
	131	gidNumber: $ID_DAEMON
	132	memberUid: $USER.daemon
0963ebc5	133	" \| sudo ldapadd -x -D cn=admin,dc=hcoop,dc=net -y /etc/ldap.secret \|\| true
d2462e94	134
	135
	136	#
	137	# Export .mailfilter and .cgi keys to a keytab file
	138	#
	139
cd0db70e	140	# create a daemon keytab (used by /etc/exim4/get-token)
	141	# only if it does not exist!
	142	test -e /etc/keytabs/user.daemon/$USER \|\| \
	143	sudo kadmin.local -p root/admin -q "ktadd -k /etc/keytabs/user.daemon/$USER $USER/daemon@HCOOP.NET"
d2462e94	144
cd0db70e	145	# Properly chown/mod keytab files (must be $USER:www-data)
	146	sudo chown $USER:www-data /etc/keytabs/user.daemon/$USER
	147	sudo chmod 440 /etc/keytabs/user.daemon/$USER
d2462e94	148
3a9bd77a	149	# rsync keytabs
cd0db70e	150	(cd /etc/keytabs
	151	sudo tar clpf - user.daemon/$USER \| \
	152	ssh mire.hcoop.net cd /etc/keytabs\; sudo tar xlpf -)
3a9bd77a CE	153	(cd /etc/keytabs
	154	sudo tar clpf - user.daemon/$USER \| \
	155	ssh hopper.hcoop.net cd /etc/keytabs\; sudo tar xlpf -)
d2462e94	156
	157	#
	158	# Create/mount/set-perms on user's volumes (home, mail, databases, logs)
	159	#
	160
	161	# HOME VOLUME
3a9bd77a CE	162	if vos examine user.$USER.d 2>/dev/null; then
	163	echo "Reactivating old volume (user.$USER.d)"
	164	vos rename user.$USER.d user.$USER
	165	fi
0963ebc5	166	vos examine user.$USER 2>/dev/null \|\| \
0963ebc5	167	vos create deleuze.hcoop.net /vicepa user.$USER -maxquota 400000
3a9bd77a	168
d2462e94	169	mkdir -p `dirname $HOMEPATH`
3304c1fa	170	fs ls $HOMEPATH \|\| test -L $HOMEPATH \|\| fs mkm $HOMEPATH user.$USER
b7b1cdff	171	chown $USER:nogroup $HOMEPATH
d2462e94	172	fs sa $HOMEPATH $USER all
cd0db70e	173	fs sa $HOMEPATH system:anyuser l
d2462e94	174
d2462e94	175	# Apache logs
655b4c82	176	mkdir -p $HOMEPATH/.logs
	177	chown $USER:nogroup $HOMEPATH/.logs
	178	mkdir -p $HOMEPATH/.logs/apache
	179	chown $USER:nogroup $HOMEPATH/.logs/apache
	180	fs sa $HOMEPATH/.logs/apache $USER.daemon rlwidk
	181	mkdir -p $HOMEPATH/.logs/mail
	182	fs sa $HOMEPATH/.logs/mail $USER.daemon rlwidk
	183	chown $USER:nogroup $HOMEPATH/.logs/mail
d2462e94	184
7a7e31c9	185	# public_html
42d22a10	186	test -e $HOMEPATH/public_html \|\| \
	187	(mkdir -p $HOMEPATH/public_html; \
	188	chown $USER:nogroup $HOMEPATH/public_html; \
	189	fs sa $HOMEPATH/public_html system:anyuser none; \
	190	fs sa $HOMEPATH/public_html $USER.daemon rl)
b7b1cdff	191
	192	# .procmail.d
	193	mkdir -p $HOMEPATH/.procmail.d
	194	chown $USER:nogroup $HOMEPATH/.procmail.d
	195	fs sa $HOMEPATH/.procmail.d system:anyuser rl
	196
	197	# .public
cd0db70e	198	mkdir -p $HOMEPATH/.public/
b7b1cdff	199	chown $USER:nogroup $HOMEPATH/.public
	200	fs sa $HOMEPATH/.public system:anyuser rl
	201
	202	# .domtool
	203	mkdir -p $HOMEPATH/.public/.domtool
	204	chown $USER:nogroup $HOMEPATH/.public/.domtool
cd0db70e	205	test -e $HOMEPATH/.domtool \|\| \
cd0db70e	206	test -L $HOMEPATH/.domtool \|\| \
74e97319	207	sudo -u $USER ln -s $HOMEPATH/.public/.domtool $HOMEPATH/.domtool
7a7e31c9	208
0008b2c9	209	# Gitweb hosting
d890ae7b	210	test -L /var/cache/git/$USER \|\| \
d890ae7b	211	sudo ln -s $HOMEPATH/.hcoop-git /var/cache/git/$USER
0008b2c9	212
d2462e94	213	# MAIL VOLUME
3a9bd77a CE	214	if vos examine mail.$USER.d 2>/dev/null; then
	215	echo "Reactivating old volume (mail.$USER.d)"
	216	vos rename mail.$USER.d mail.$USER
	217	fi
0963ebc5	218	vos examine mail.$USER 2>/dev/null \|\| \
0963ebc5	219	vos create deleuze.hcoop.net /vicepa mail.$USER -maxquota 400000
3a9bd77a	220
d2462e94	221	mkdir -p `dirname $MAILPATH`
ef64fd5f	222	fs ls $MAILPATH \|\| fs mkm $MAILPATH mail.$USER
ef64fd5f	223	fs ls $HOMEPATH/Maildir \|\| fs mkm $HOMEPATH/Maildir mail.$USER
894794d2	224	chown $USER:nogroup $MAILPATH
894794d2	225	chown $USER:nogroup $HOMEPATH/Maildir
cd0db70e	226	fs sa $MAILPATH $USER all
ea773cea	227	fs sa $MAILPATH $USER.daemon all
739364a2	228	if test ! -e $MAILPATH/new; then
	229	mkdir -p $MAILPATH/cur $MAILPATH/new $MAILPATH/tmp
	230	echo -e "This email account is provided as a service for HCoop members." \
	231	"\n\nTo learn how to use it, please visit the page" \
ffff3a6f	232	"\n<http://wiki.hcoop.net/MemberManual/Email> on our website."\| \
739364a2	233	mail -s "Welcome to your HCoop email store" \
	234	-e -a "From: postmaster@hcoop.net" \
	235	real-$USER
	236	fi
3d7737ab	237	chown $USER:nogroup $MAILPATH/cur $MAILPATH/new $MAILPATH/tmp
d2462e94	238
64a96d98	239	# Set up shared SpamAssassin folder
	240	if test -f $HOMEPATH/Maildir/shared-maildirs; then
	241	# Deal with case where user rsync'd their Maildir from fyodor
	242	pattern='^SpamAssassin /home/spamd'
	243	file=$HOMEPATH/Maildir/shared-maildirs
	244	if grep $pattern $file; then
	245	sed -i -r -e \
	246	's!^(SpamAssassin )/home/spamd!\1/var/local/lib/spamd!1' \
	247	$file
	248	fi
64a96d98	249	else
	250	maildirmake --add SpamAssassin=/var/local/lib/spamd/Maildir \
	251	$HOMEPATH/Maildir
	252	fi
	253
d2462e94	254	# DATABASE VOLUME
	255	if ! vos examine db.$USER >/dev/null 2>/dev/null; then
	256	mkdir -p `dirname /afs/.hcoop.net/common/.databases/$PATHBITS`
	257	vos create -server afs -partition a -name db.$USER -maxquota 400000
	258	fs mkmount -dir /afs/.hcoop.net/common/.databases/$PATHBITS -vol db.$USER -rw
d2462e94	259	fs sa -dir $DBPATH -acl system:postgres l
	260	fs sa -dir $DBPATH -acl system:mysql l
	261	fs sa -dir $DBPATH -acl system:backup rl
9c29302d	262	fs sa -dir $DBPATH -acl $USER rl
d2462e94	263	fi
	264
	265	# Create postgres user and tablespace placeholder within volume
e576ecef	266	if ! test -d $PGDIR; then
d2462e94	267	mkdir -p $PGDIR
	268	chown postgres:postgres $PGDIR
	269	fs sa -dir $PGDIR -acl system:postgres write
9c29302d	270	fs sa -dir $PGDIR -acl $USER none
d2462e94	271
	272	sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1
	273	fi
	274
	275	# Create mysql user and databases placeholder within volume
	276	mkdir -p $MYSQLDIR
	277	chown mysql:mysql $MYSQLDIR
	278	fs sa -dir $MYSQLDIR -acl system:mysql write
9c29302d	279	fs sa -dir $MYSQLDIR -acl $USER none
d2462e94	280
7fff2fea	281	vos release common.databases
d2462e94	282
	283	#
	284	# Mount points for backup volumes
	285	#
	286
cd0db70e	287	mkdir -p `dirname /afs/hcoop.net/.old/user/$PATHBITS`
	288	mkdir -p `dirname /afs/hcoop.net/.old/mail/$PATHBITS`
	289	fs ls /afs/hcoop.net/.old/user/$PATHBITS \|\| \
	290	fs mkm /afs/hcoop.net/.old/user/$PATHBITS user.$USER.backup
	291	fs ls /afs/hcoop.net/.old/mail/$PATHBITS \|\| \
	292	fs mkm /afs/hcoop.net/.old/mail/$PATHBITS mail.$USER.backup
	293	vos release old
d2462e94	294
7fe272af	295	# technically this might not be necessary, but for good measure...
d2462e94	296	vos syncserv deleuze
d2462e94	297	vos syncvldb deleuze
7fe272af	298
7fe272af	299	# refresh volume location cache (takes ~2hrs otherwise)
7e1859cd	300	mire_and_deleuze fs checkvolumes
2c556c0c	301
2c556c0c	302	#
7e1859cd	303	# Non-AFS files and directories
2c556c0c	304	#
2c556c0c	305
da0bc057	306	# Make per-user apache DAV lock directory -- the directory must be
da0bc057	307	# both user and group-writable, which is silly.
7e1859cd	308	mire_and_deleuze sudo mkdir -p /var/lock/apache2/dav/$USER
	309	mire_and_deleuze sudo chown $USER:www-data /var/lock/apache2/dav/$USER
	310	mire_and_deleuze sudo chmod ug=rwx,o= /var/lock/apache2/dav/$USER
db51e5b7	311
	312	#
	313	# Domtool integration
	314	#
	315
	316	domtool-adduser $USER
2a2fcc8e	317
	318	#
	319	# Subscribe user to our mailing lists.
	320	#
	321	echo $USER@hcoop.net \| sudo -u list \
	322	/var/lib/mailman/bin/add_members -r - hcoop-announce