scripts/setup_status_network.sh

   1 #!/bin/bash
   2
   3 # live fast! die young!
   4
   5 set -e
   6
   7 source /etc/statusnet/setup.cfg
   8
   9 # setup_status_network.sh mysite 'My Site' '1user' 'owner@example.com' 'Firsty McLastname'
  10
  11 export nickname="$1"
  12 export sitename="$2"
  13 export tags="$3"
  14 export email="$4"
  15 export fullname="$5"
  16 export siteplan="$6"
  17
  18 if [ "$siteplan" == '' ]; then
  19     siteplan='single-user'
  20 fi
  21
  22 # Fixme: if this is changed later we need to update profile URLs
  23 # for the created user.
  24 export server="$nickname.$WILDCARD"
  25
  26 # End-user info
  27 export userpass=`$PWDGEN`
  28 export roles="administrator moderator owner"
  29
  30 # DB info
  31 export password=`$PWDGEN`
  32 export database=$nickname$DBBASE
  33 export username=$nickname$USERBASE
  34
  35 # Create the db
  36
  37 mysqladmin -h $DBHOST -u $ADMIN --password=$ADMINPASS create $database
  38
  39 for f in statusnet.sql innodb.sql sms_carrier.sql foreign_services.sql notice_source.sql; do
  40     mysql -h $DBHOST -u $ADMIN --password=$ADMINPASS $database < ../db/$f;
  41 done
  42
  43 mysql -h $DBHOST -u $ADMIN --password=$ADMINPASS $SITEDB << ENDOFCOMMANDS
  44
  45 GRANT ALL ON $database.* TO '$username'@'localhost' IDENTIFIED BY '$password';
  46 GRANT ALL ON $database.* TO '$username'@'%' IDENTIFIED BY '$password';
  47 INSERT INTO status_network (nickname, dbhost, dbuser, dbpass, dbname, sitename, created)
  48 VALUES ('$nickname', '$DBHOSTNAME', '$username', '$password', '$database', '$sitename', now());
  49
  50 ENDOFCOMMANDS
  51
  52 for top in $AVATARBASE $FILEBASE $BACKGROUNDBASE; do
  53     mkdir $top/$nickname
  54     chmod a+w $top/$nickname
  55 done
  56
  57 php $PHPBASE/scripts/checkschema.php -s"$server"
  58
  59 php $PHPBASE/scripts/settag.php -s"$server" "$nickname" "$tags"
  60
  61 php $PHPBASE/scripts/registeruser.php \
  62   -s"$server" \
  63   -n"$nickname" \
  64   -f"$fullname" \
  65   -w"$userpass" \
  66   -e"$email"
  67
  68 for role in $roles
  69 do
  70   php $PHPBASE/scripts/userrole.php \
  71     -s"$server" \
  72     -n"$nickname" \
  73     -r"$role"
  74 done
  75
  76 if [ -f "$MAILTEMPLATE" ]
  77 then
  78     # fixme how safe is this? are sitenames sanitized?
  79     cat $MAILTEMPLATE | \
  80       sed "s/\$nickname/$nickname/" | \
  81       sed "s/\$sitename/$sitename/" | \
  82       sed "s/\$userpass/$userpass/" | \
  83       sed "s/\$siteplan/$siteplan/" | \
  84       php $PHPBASE/scripts/sendemail.php \
  85         -s"$server" \
  86         -n"$nickname" \
  87         --subject="$MAILSUBJECT"
  88 else
  89     echo "No mail template, not sending email."
  90 fi
  91
  92 if [ -f "$POSTINSTALL" ]
  93 then
  94     echo "Running $POSTINSTALL ..."
  95     source "$POSTINSTALL"
  96 fi