forked from MarkusNemesis/VanillaWoWDB2
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathInitital-Setup-guide.txt
158 lines (118 loc) · 7.36 KB
/
Initital-Setup-guide.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
# Supported OS:
Ubuntu Server 18.04 LTS
# -=-=-=-=-=-=-=-=-=- Post OS install steps -=-=-=-=-=-=-=-=-=-
apt-get update
apt-get upgrade
# Install any packages you will need later
apt-get install p7zip-full -y
# Enable SSH
nano /etc/ssh/sshd_config
Uncomment line "Port 22"
Save
service sshd restart
# Get your IP address so you can SSH (If running on a host, you'll need to get the IP from control panel and allow SSH in the firewall (Port 22))
# You may now SSH into your host, which will allow you to copy paste the remaining commands
# -=-=-=-=-=-=-=-=-=- Setting up and configuring your HTTPD environment - Here we install Apache, PHP and MySQL (Known as LAMP) -=-=-=-=-=-=-=-=-=-
apt-get install apache2 -y
# The following command will likely fail.
apache2ctl configtest
# Modify the following file to set it up for your domain/IP
nano /etc/apache2/apache2.conf
Insert a new line at the very bottom of the file to read "ServerName domain_or_IP", replacing "domain_or_IP" with whatever domain or IP you plan to use.
Save
# Rerun this command. It should now no longer throw an error.
apache2ctl configtest
# Restart Apache for your changes to take effect
systemctl restart apache2
# Now adjust your firewall to allow HTTPD traffic - This will open up ports 80 and 443. Please ensure these ports are open on your firewall.
ufw allow in "Apache Full"
# Your web server should now be reachable via a web browser, using your domain or your IP
# Now to install MySQL, this is the database server that will store all the data the site will use.
apt-get install mysql-server -y
# Once installed, you need to ensure that it is relatively secure by running the Best Practices wizard. You can answer any way you like, but is advised to just say Y to all.
mysql_secure_installation
# You will need to modify a config file to allow it to work with the aowow codebase
nano /etc/mysql/mysql.conf.d/mysqld.cnf
add the following line AFTER [mysqld]
sql-mode = ""
# Restart mysql to apply changes
service mysql restart
# Now we are to install PHP. We will need to use a custom repo for this as PHP 7 is not compatible with the libraries used in this site.
add-apt-repository ppa:ondrej/php
apt-get update
apt-get install php5.6 php5.6-simplexml php5.6-gd php5.6-mysql php5.6-mbstring -y
a2enmod php5.6
# Some config for PHP is required to ensure php pages are loaded over other pages
nano /etc/apache2/mods-enabled/dir.conf
Under line <IfModule mod_dir.c> , move index.php to be the first in the list. It should read the following
DirectoryIndex index.php index.html index.cgi index.pl index.xhtml index.htm
# Restart apache2
service apache2 restart
# -=-=-=-=-=-=-=-=-=- Aowow Deployment and Config -=-=-=-=-=-=-=-=-=-
# cd into the web directory and git clone the repo
cd /var/www/html
git clone https://github.com/MarkusNemesis/VanillaWoWDB2.git
# Download the latest database file from the https://github.com/brotalnia/database repo, into your users home folder. In this case, the latest DB was June 8th
cd ~/
wget https://raw.githubusercontent.com/brotalnia/database/master/world_full_08_june_2018.7z
7z x ./world_full_08_june_2018.7z
# Create the aowow and realmd databases and create your database user
mysql -u root -p
type the following:
create database aowow;
create database realmd;
GRANT ALL PRIVILEGES ON aowow.* TO '<YOURUSERNAME>'@'localhost' IDENTIFIED BY '<YOURPASSWORD>';
GRANT ALL PRIVILEGES ON realmd.* TO '<YOURUSERNAME>'@'localhost' IDENTIFIED BY '<YOURPASSWORD>';
exit
# Import the world DB contents into the aowow database in mysql
mysql -u root -p aowow < world_full_08_june_2018.sql
# Import the Aowow sql files
cd /var/www/html/VanillaWoWDB2/tools/sql/aowow
mysql -u root -p aowow < aowow.sql
mysql -u root -p aowow < aowow_zones.sql
mysql -u root -p aowow < faction.sql
mysql -u root -p aowow < indexes.sql
# Import the realmd sql file
cd /var/www/html/VanillaWoWDB2/tools/sql/realmd
mysql -u root -p realmd < realmd.sql
# Configure your site via making a new config file.
cd /var/www/html/VanillaWoWDB2/configs/
cp ./config.php.in ./config.php
nano ./config.php
Make your desired changes to the config (Patch version, site name. Use the mysql database credentials you set in the steps above.)
# -=-=-=-=-=-=-=-=-=- Importing Aowow comments -=-=-=-=-=-=-=-=-=-
# If you want to import comments from Aowow, you can find them here: https://github.com/Sunksat/aowow_comments
cd ~/
git clone https://github.com/Sunksat/aowow_comments
# You'll need to modify the accounts SQL files to fit the realmd we are using. You can do this with a find/replace via sed
find ./aowow_comments/ -type f -exec sed -i -e "s/'changepass1234', '0', null, null, null, '', '', null, '2004-11-23 21:10:00', '0.0.0.0', '127.0.0.1', '127.0.0.1', '0', '0', '00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '0', '0', '', '', '0', '', '0', '0', '0', '0', '', '0', null, null, '0', null, null, '0', null, null)/'REPLACEWITHGIBBERISH',0,NULL,NULL,NULL,NULL,'2004-11-23 21:10:00','0.0.0.0',0,0,'0000-00-00 00:00:00',0,0,0,0,NULL,0)/i" {} \;
# You will need to convert the links inside the comments to point to your database. To do so, run the following as you did before. Note: You'll need to ESCAPE out the slashes in this string. Use this site to help you: http://dwaves.de/tools/escape/
find ./ -type f -exec sed -i -e "s/http:\/\/DBURLHERE\//http:\/\/yourwebsitenamehere.com\//g" {} \;
# You may have some comments that break the import process due to not being cleaned correctly before importing. If this occurs, fix the troublesome lines and then run the following before attempting to re-import them
find ./ -type f -exec sed -i -e "s/INSERT INTO/REPLACE INTO/i" {} \;
# You will need to import each type separately by running the following.
cd ~/aowow_comments/aowow_comments_dbvanilla/
# Items
mysql -u root -p aowow < ./items/htmlfix/aowow_comments_items_comments_HTMLFIX_sql_FINAL.sql
mysql -u root -p aowow < ./items/aowow_comments_items_ratings_sql_FINAL.sql
mysql -u root -p realmd < ./items/aowow_comments_items_accounts_sql_FINAL.sql
# Item Sets
mysql -u root -p aowow < ./itemset/htmlfix/aowow_comments_itemset_comments_sql_FINAL.sql
mysql -u root -p aowow < ./itemset/aowow_comments_itemset_comments_rating_sql_FINAL.sql
mysql -u root -p realmd < ./itemset/aowow_comments_itemset_accounts_sql_FINAL.sql
# NPCs
mysql -u root -p aowow < ./npc/htmfix/aowow_comments_npc_comments_HTMLFIX_sql_FINAL.sql
mysql -u root -p aowow < ./npc/aowow_comments_npc_ratings_sql_FINAL.sql
mysql -u root -p realmd < ./npc/aowow_comments_npc_accounts_sql_FINAL.sql
# Objects
mysql -u root -p aowow < ./object/htmlfix/aowow_comments_objects_comments_HTMLFIX_sql_FINAL.sql
mysql -u root -p aowow < ./object/aowow_comments_objects_ratings_sql_FINAL.sql
mysql -u root -p realmd < ./object/aowow_comments_objects_accounts_sql_FINAL.sql
# Quests
mysql -u root -p aowow < ./quest/htmlfix/aowow_comments_quests_comments_HTMLFIX_sql_FINAL.sql
mysql -u root -p aowow < ./quest/aowow_comments_quests_ratings_sql_FINAL.sql
mysql -u root -p realmd < ./quest/aowow_comments_quests_accounts_sql_FINAL.sql
# Zones
mysql -u root -p aowow < ./zone/htmlfix/aowow_comments_zone_comments_HTMLFIX_sql_FINAL.sql
mysql -u root -p aowow < ./zone/aowow_comments_zone_ratings_sql_FINAL.sql
mysql -u root -p realmd < ./zone/aowow_comments_zone_accounts_sql_FINAL.sql