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