X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=bootstrap-user;h=08c04db2f2c01e97ee79ddce4aad4083d28c0693;hb=3939e005001f14dcb328823cbec4814b4b5d8343;hp=dc6079cb26edf79140051fcc2fd8102ac034dfa9;hpb=81dc8132d05121442ac1396d094b67e793ab38b0;p=infra.git

diff --git a/bootstrap-user b/bootstrap-user
index dc6079c..08c04db 100755
--- a/bootstrap-user
+++ b/bootstrap-user
@@ -140,9 +140,10 @@ if ! grep -q '^[0-9]\+$' <<< $mgmOid; then
 fi
 printf "Management Organisation id is \"%s\"\n" "$mgmOid"
 
-echo "add self as orgadmin for organisation"
-csrf=$(mcurl orga/$mgmOid | csrf "head -n 2" "tail -n 1")
-mcurl orga/$mgmOid --data-urlencode "email=$adminEmail" --data-urlencode "master=y" --data-urlencode "do_affiliate=Add" --data-urlencode "csrf=$csrf" &>/dev/null
+echo "using SQL to add self as orgadmin for organisation"
+sudo lxc-attach -n postgres-primary -- su -c "psql -d gigi" postgres <<EOF
+INSERT INTO org_admin("orgid", "memid", "creator", "master") VALUES('$mgmOid', (SELECT "id" FROM "users" WHERE "email"='$adminEmail'), (SELECT "id" FROM "users" WHERE "email"='$secondaryEmail'), 'y');
+EOF
 echo "adding org-domain"
 csrf=$(mcurl orga/$mgmOid | csrf "head -n 4" "tail -n 1")
 domainName="$hostname"