[127] | 1 | #!/bin/sh |
---|
| 2 | |
---|
| 3 | checkfailed() { |
---|
| 4 | if [ -f "$lroot/web_scripts/$addrend/.failed" ]; then |
---|
| 5 | rm -f $lroot/web_scripts/$addrend/.failed |
---|
| 6 | exit 1 |
---|
| 7 | fi |
---|
| 8 | } |
---|
| 9 | |
---|
| 10 | sshrun() { |
---|
[659] | 11 | athrun scripts scripts-ssh "$lname" "/mit/scripts/$@" |
---|
[127] | 12 | } |
---|
| 13 | |
---|
| 14 | vsshrun() { |
---|
[463] | 15 | athrun scripts scripts-ssh "$lname" "/mit/scripts/$@" |
---|
[127] | 16 | } |
---|
| 17 | |
---|
| 18 | checksqlpass() { |
---|
| 19 | errors=`sshrun 'sql/bin$scriptsdev/test-password'` |
---|
| 20 | if [ "$errors" != "" ]; then |
---|
| 21 | if [ "$1" -eq 1 ]; then |
---|
| 22 | rm -f $lroot/.sql/my.cnf |
---|
| 23 | fi |
---|
| 24 | echo |
---|
| 25 | echo ERROR: |
---|
| 26 | printf "$2" |
---|
| 27 | printf "$3" |
---|
| 28 | exit |
---|
| 29 | fi |
---|
| 30 | } |
---|
| 31 | |
---|
| 32 | echo |
---|
| 33 | echo == Welcome to the sql.mit.edu signup process == |
---|
| 34 | echo |
---|
| 35 | |
---|
| 36 | echo "For documentation, including a link to the Athena rules of use," |
---|
| 37 | echo "see <http://sql.mit.edu>." |
---|
| 38 | echo |
---|
| 39 | echo Please report problems with this signup process to sql@mit.edu. |
---|
| 40 | echo |
---|
| 41 | echo Are you performing this signup for: |
---|
| 42 | echo 1. Your personal Athena account |
---|
| 43 | echo 2. A locker that you control \(a club, a course, etc\) |
---|
| 44 | echo If you do not understand this question, you should answer \'1\'. |
---|
| 45 | printf "Please enter either '1' or '2' (without quotes): " |
---|
| 46 | read whofor |
---|
| 47 | if [ "$whofor" -eq 1 ]; then |
---|
| 48 | lname=$USER |
---|
| 49 | lroot=$HOME |
---|
| 50 | elif [ "$whofor" -eq 2 ]; then |
---|
| 51 | echo |
---|
| 52 | echo OK. A MySQL account will be created for a locker of your choice that |
---|
| 53 | echo you control. Please enter the name of the selected locker below. |
---|
| 54 | echo "(For the locker /mit/sipb, you would enter sipb)." |
---|
| 55 | printf "Locker name: " |
---|
| 56 | read lname |
---|
| 57 | lroot="/mit/$lname" |
---|
| 58 | else |
---|
| 59 | echo |
---|
| 60 | echo ERROR: |
---|
| 61 | echo You must select either '1' or '2'. |
---|
| 62 | exit 1 |
---|
| 63 | fi |
---|
| 64 | |
---|
| 65 | # Users need to sign up for scripts.mit.edu so that they can |
---|
| 66 | # authenticate themselves to sql.mit.edu |
---|
[659] | 67 | attach scripts |
---|
[127] | 68 | . /mit/scripts/bin$scriptsdev/signup-web |
---|
| 69 | |
---|
| 70 | if [ "$requires_sql" = "" ]; then |
---|
| 71 | requires_sql=1 |
---|
| 72 | fi |
---|
| 73 | |
---|
| 74 | if [ ! -f "$lroot/.my.cnf" ]; then |
---|
[659] | 75 | mkdir $lroot/.sql |
---|
[127] | 76 | fs sa $lroot/.sql system:anyuser none |
---|
[157] | 77 | fs sa $lroot/.sql system:authuser none |
---|
[127] | 78 | fs sa $lroot/.sql daemon.scripts write |
---|
[382] | 79 | fs sa $lroot/.sql daemon.sql write |
---|
[659] | 80 | ln -nfs $lroot/.sql/my.cnf $lroot/.my.cnf |
---|
[127] | 81 | fi |
---|
| 82 | |
---|
| 83 | if [ "$requires_sql" -eq 1 ]; then |
---|
| 84 | sqlinfo=`sshrun "sql/bin$scriptsdev/get-password"` |
---|
| 85 | if [ "$sqlinfo" = "" ]; then |
---|
| 86 | echo |
---|
| 87 | echo You already have a MySQL account but you do not have a .my.cnf file. |
---|
| 88 | echo If you do not remember your MySQL account password, you can change it |
---|
| 89 | echo at http://sql.mit.edu using MIT certificates. |
---|
| 90 | printf "Please type your MySQL password and press [enter]: " |
---|
| 91 | stty -echo |
---|
| 92 | read sqlpass |
---|
| 93 | stty echo |
---|
| 94 | echo |
---|
| 95 | sqlhost="sql.mit.edu" |
---|
| 96 | sqluser=$lname |
---|
| 97 | . /mit/scripts/sql/bin$scriptsdev/save-password |
---|
| 98 | checksqlpass 1 'The MySQL password that you typed appears to be incorrect.\n' '' |
---|
| 99 | echo |
---|
| 100 | echo OK. Continuing with the install... |
---|
| 101 | else |
---|
| 102 | checksqlpass 0 'The MySQL login information in your .my.cnf file\n' 'appears to be incorrect.\n' |
---|
| 103 | fi |
---|
| 104 | fi |
---|
| 105 | |
---|
| 106 | echo |
---|
| 107 | echo == Setup complete! == |
---|
| 108 | echo Your MySQL login information has been written to the file |
---|
| 109 | echo "</mit/$lname/.sql/my.cnf>." |
---|
| 110 | echo You must use the sql.mit.edu web interface to add or drop databases. |
---|
| 111 | echo If you have trouble with your MySQL account, feel free to contact |
---|
| 112 | echo the sql.mit.edu team by e-mailing sql@mit.edu |
---|
| 113 | exit 0 |
---|