Description:
fixed database creation instructions in installer script. patch by Witchakorn Kamolpornwijit
Commit status:
[Not Reviewed]
References:
Diff options:
Comments:
0 Commit comments
0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
r97:b344db59d967 - - 1 file changed: 2 inserted, 2 deleted
@@ -1,97 +1,97 | |||
|
1 | 1 | #!/bin/sh |
|
2 | 2 | |
|
3 | 3 | echo "This script will install and configure Cafe grader." |
|
4 | 4 | |
|
5 | 5 | echo "Installing required apt" |
|
6 | 6 | |
|
7 | 7 | sudo apt-get update |
|
8 | 8 | sudo apt-get install mysql-server mysql-client ruby1.8 ruby1.8-dev rdoc1.8 \ |
|
9 | 9 | g++ gcc libmysql-ruby1.8 irb apache2 libmysqlclient15-dev build-essential \ |
|
10 | 10 | git-core rubygems rake openssl libopenssl-ruby |
|
11 | 11 | |
|
12 | 12 | echo "Installing rails" |
|
13 | 13 | |
|
14 | 14 | sudo gem install rails --no-ri --no-rdoc |
|
15 | 15 | sudo gem install rack -v=1.0.1 --no-ri --no-rdoc |
|
16 | 16 | |
|
17 | 17 | echo "Fetching Cafe Grader from Git repositories" |
|
18 | 18 | |
|
19 | 19 | echo "Fetching web interface" |
|
20 | 20 | |
|
21 | 21 | mkdir cafe_grader |
|
22 | 22 | cd cafe_grader |
|
23 | 23 | git clone http://git.gitorious.org/cafe-grader/cafe-grader-web.git web |
|
24 | 24 | |
|
25 | 25 | echo "Configuring rails app" |
|
26 | 26 | |
|
27 | 27 | cp web/config/environment.rb.SAMPLE web/config/environment.rb |
|
28 | 28 | |
|
29 | 29 | echo "At this point we will need MySQL user and database." |
|
30 | 30 | echo "Have you created MySQL user and database for Cafe grader? (Y/N) " |
|
31 | 31 | read ch |
|
32 | 32 | |
|
33 | 33 | if [ "$ch" = "n" -o "$ch" = "N" ] |
|
34 | 34 | then |
|
35 | 35 | echo "Please open another terminal and create the user and database for Cafe grader." |
|
36 | 36 | echo "Don't forget to grant access to that database for the user." |
|
37 | 37 | echo "Please have username, password, and database name ready before continue." |
|
38 | 38 | echo |
|
39 | 39 | echo "The following are instructions:" |
|
40 | 40 | echo "1. Run mysql:" |
|
41 | 41 | echo |
|
42 | 42 | echo " mysql -u root -p" |
|
43 | 43 | echo |
|
44 | 44 | echo " if you have just installed mysql, the root password is the one that you have just entered" |
|
45 | 45 | echo "2. Create a new database, a new user, and grant access to grader database:" |
|
46 | 46 | echo |
|
47 | 47 | echo " create user 'USERNAME'@'localhost' identified by 'PASSWORD';" |
|
48 | - echo " create database DATABASENEME;" | |
|
49 | - echo " grant all on DATABASENAME.* to 'USERNAME'@'localhost';" | |
|
48 | + echo " create database \`DATABASENEME\`;" | |
|
49 | + echo " grant all on \`DATABASENAME\`.* to 'USERNAME'@'localhost';" | |
|
50 | 50 | echo |
|
51 | 51 | echo " Replace USERNAME, PASSWORD, and DATABASENAME accordingly." |
|
52 | 52 | echo |
|
53 | 53 | echo "Hit enter when ready..." |
|
54 | 54 | read dummy |
|
55 | 55 | fi |
|
56 | 56 | |
|
57 | 57 | CAFE_PATH=`pwd` |
|
58 | 58 | |
|
59 | 59 | cd web |
|
60 | 60 | |
|
61 | 61 | echo "Please provide grader database:" |
|
62 | 62 | read database |
|
63 | 63 | |
|
64 | 64 | echo "Please provide grader username:" |
|
65 | 65 | read username |
|
66 | 66 | |
|
67 | 67 | echo "Please provide $username password:" |
|
68 | 68 | read password |
|
69 | 69 | |
|
70 | 70 | echo "development:" > config/database.yml |
|
71 | 71 | echo " adapter: mysql" >> config/database.yml |
|
72 | 72 | echo " database: $database" >> config/database.yml |
|
73 | 73 | echo " username: $username" >> config/database.yml |
|
74 | 74 | echo " password: $password" >> config/database.yml |
|
75 | 75 | echo " host: localhost" >> config/database.yml |
|
76 | 76 | echo "" >> config/database.yml |
|
77 | 77 | echo "production:" >> config/database.yml |
|
78 | 78 | echo " adapter: mysql" >> config/database.yml |
|
79 | 79 | echo " database: $database" >> config/database.yml |
|
80 | 80 | echo " username: $username" >> config/database.yml |
|
81 | 81 | echo " password: $password" >> config/database.yml |
|
82 | 82 | echo " host: localhost" >> config/database.yml |
|
83 | 83 | |
|
84 | 84 | echo "Object.instance_eval{remove_const :GRADER_ROOT_DIR}" >> config/environment.rb |
|
85 | 85 | echo "Object.instance_eval{remove_const :GRADING_RESULT_DIR}" >> config/environment.rb |
|
86 | 86 | echo "GRADER_ROOT_DIR = '$CAFE_PATH/judge'" >> config/environment.rb |
|
87 | 87 | echo "GRADING_RESULT_DIR = '$CAFE_PATH/judge/result'" >> config/environment.rb |
|
88 | 88 | |
|
89 | 89 | echo "Installing required gems" |
|
90 | 90 | |
|
91 | 91 | sudo rake gems:install |
|
92 | 92 | # to remove log file owned by root |
|
93 | 93 | sudo rm log/* |
|
94 | 94 | sudo rmdir log |
|
95 | 95 | |
|
96 | 96 | echo "Running rake tasks to initialize database" |
|
97 | 97 |
You need to be logged in to leave comments.
Login now