3 source /etc/statusnet/setup.cfg
8 export password=`$PWDGEN`
9 export database=$nickname$DBBASE
10 export username=$nickname$USERBASE
14 mysqladmin -h $DBHOST -u $ADMIN --password=$ADMINPASS create $database
16 for f in statusnet.sql innodb.sql sms_carrier.sql foreign_services.sql notice_source.sql; do
17 mysql -h $DBHOST -u $ADMIN --password=$ADMINPASS $database < ../db/$f;
20 mysql -h $DBHOST -u $ADMIN --password=$ADMINPASS $SITEDB << ENDOFCOMMANDS
22 GRANT INSERT,SELECT,UPDATE,DELETE ON $database.* TO '$username'@'localhost' IDENTIFIED BY '$password';
23 GRANT INSERT,SELECT,UPDATE,DELETE ON $database.* TO '$username'@'%' IDENTIFIED BY '$password';
24 INSERT INTO status_network (nickname, dbhost, dbuser, dbpass, dbname, sitename, created)
25 VALUES ('$nickname', '$DBHOSTNAME', '$username', '$password', '$database', '$sitename', now());
29 for top in $AVATARBASE $FILEBASE $BACKGROUNDBASE; do
31 chmod a+w $top/$nickname