Difference between revisions of "Installation (CentOS)"
(→Create SQL database for Hercules) |
Dastgirpojee (Talk | contribs) m (Reverted edits by Gmclerk (talk) to last revision by Dastgirpojee) |
||
(16 intermediate revisions by 2 users not shown) | |||
Line 19: | Line 19: | ||
By the [[wikipedia:Principle_of_least_privilege|principle of least privilege]], it is recommended you do '''NOT''' run Hercules as root. | By the [[wikipedia:Principle_of_least_privilege|principle of least privilege]], it is recommended you do '''NOT''' run Hercules as root. | ||
# Type the following command to create a non-root Linux account: | # Type the following command to create a non-root Linux account: | ||
− | #: <pre>useradd --create-home --shell /bin/bash | + | #: <pre>useradd --create-home --shell /bin/bash hercules1234</pre> |
#: <code>--create-home</code> = create the user's home directory | #: <code>--create-home</code> = create the user's home directory | ||
#: <code>--shell</code> = sets their login shell to [[wikipedia:Bash_(Unix_shell)|Bash]] | #: <code>--shell</code> = sets their login shell to [[wikipedia:Bash_(Unix_shell)|Bash]] | ||
Line 25: | Line 25: | ||
#: ''<code>1234</code>'' = pick your own random numbers to make the username more unique | #: ''<code>1234</code>'' = pick your own random numbers to make the username more unique | ||
# Set a password for the new user (run this command and follow the prompts): | # Set a password for the new user (run this command and follow the prompts): | ||
− | #: <pre>passwd | + | #: <pre>passwd hercules1234</pre> |
=== Configure MySQL === | === Configure MySQL === | ||
Line 44: | Line 44: | ||
==== Create SQL database for Hercules ==== | ==== Create SQL database for Hercules ==== | ||
# At the MySQL prompt, type this to [http://dev.mysql.com/doc/refman/5.5/en/create-database.html create a database] (replace <code>hercules1234</code> with the Linux username you created earlier): | # At the MySQL prompt, type this to [http://dev.mysql.com/doc/refman/5.5/en/create-database.html create a database] (replace <code>hercules1234</code> with the Linux username you created earlier): | ||
− | #: <pre>mysql> CREATE DATABASE | + | #: <pre>mysql> CREATE DATABASE hercules1234_rag;</pre> |
# Create a separate database for logs: | # Create a separate database for logs: | ||
− | #: <pre>mysql> CREATE DATABASE | + | #: <pre>mysql> CREATE DATABASE hercules1234_log;</pre> |
==== Setup a MySQL user for Hercules ==== | ==== Setup a MySQL user for Hercules ==== |
Latest revision as of 18:53, 10 June 2016
This guide covers how to install Hercules on CentOS and other versions of Linux that use yum.
Contents |
Requirements
- CentOS or an RPM-based Linux that has the yum command
- root access or access to an account that has sudo privileges
- an Internet connection to download install packages
Prerequisites
All of these commands will be typed at the command-line interface.
Install Prerequisites
- Login to your server via SSH, or if you are already logged into a GUI press Ctrl+Alt+T to open a terminal window.
- Type the following command (this will install GCC, Make, MySQL, MySQL header files, MySQL Server, PCRE header files, Git, and Zlib header files)
-
yum install gcc make mysql mysql-devel mysql-server pcre-devel git zlib-devel
-
- (Optional) type the following command to install some additional packages:
-
yum -y install dos2unix gdb nano screen unzip wget zip
-
Create a non-root Linux user
By the principle of least privilege, it is recommended you do NOT run Hercules as root.
- Type the following command to create a non-root Linux account:
-
useradd --create-home --shell /bin/bash hercules1234
-
--create-home
= create the user's home directory -
--shell
= sets their login shell to Bash -
hercules1234
= the login name of the new Linux account -
1234
= pick your own random numbers to make the username more unique
-
- Set a password for the new user (run this command and follow the prompts):
-
passwd hercules1234
-
Configure MySQL
Set a root password
The default MySQL Server install creates a MySQL user 'root'@'localhost' with NO password. It is recommended you create a password for the root user.
- Run this command and follow the prompts:
- Firest Start MySQL:
-
/etc/init.d/mysqld start
- Then configure MySQL by:
-
mysql_secure_installation
- Login to your MySQL Server as root:
- When prompted, enter your root MySQL password.
-
mysql --user=root -p
- Now your prompt should look like this (the MySQL command prompt):
-
mysql>
-
Create SQL database for Hercules
- At the MySQL prompt, type this to create a database (replace
hercules1234
with the Linux username you created earlier):-
mysql> CREATE DATABASE hercules1234_rag;
-
- Create a separate database for logs:
-
mysql> CREATE DATABASE hercules1234_log;
-
Setup a MySQL user for Hercules
- At the MySQL prompt, type something like this to create a new MySQL user:
-
mysql> CREATE USER 'hercules1234'@'localhost' IDENTIFIED BY 'secretpassword';
-
hercules1234
= the name of the MySQL user (we named it the same as the Linux user to make it easier to identify) -
localhost
= the hostname or IP it will connect from -
secretpassword
= the password for this MySQL user
-
- Grant privileges to the 'hercules' MySQL user:
-
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON `hercules1234\_rag`.* TO 'hercules1234'@'localhost';
-
mysql> GRANT SELECT,INSERT ON `hercules1234\_log`.* TO 'hercules1234'@'localhost';
(note the escaped underscore)
-
Install Hercules
Login as your non-root Linux user
The rest of the setup is done as hercules1234 (the Linux user you created in step 2.2)
- Logout from root SSH (or minimize the window).
- Login to your server via SSH as the hercules1234 Linux user.
Git Clone
Type the following to create a Hercules working copy in your home (~) directory
git clone https://github.com/HerculesWS/Hercules.git ~/Hercules
Import MySQL Tables
- Change directory to the sql-files folder.
-
cd sql-files/
-
- Execute these commands:
- When prompted, enter your MySQL root password.
-
mysql -u root -prootpassword hercuser_rodb < main.sql
-
mysql -u root -prootpassword hercuser_rodblog < logs.sql
- If your Control Panel software or website requires it, you may also import the item, monster and monster skill databases (not necessary for the correct operation of Hercules)
- (pre-renewal)
-
mysql -u root -prootpassword hercuser_rodb < item_db.sql
-
mysql -u root -prootpassword hercuser_rodb < mob_db.sql
-
mysql -u root -prootpassword hercuser_rodb < mob_skill_db.sql
- (renewal)
-
mysql -u root -prootpassword hercuser_rodb < item_db_re.sql
-
mysql -u root -prootpassword hercuser_rodb < mob_db_re.sql
-
mysql -u root -prootpassword hercuser_rodb < mob_skill_db_re.sql
- (common to renewal and pre-renewal)
-
mysql -u root -prootpassword hercuser_rodb < item_db2.sql
-
mysql -u root -prootpassword hercuser_rodb < mob_db2.sql
-
mysql -u root -prootpassword hercuser_rodb < mob_skill_db2.sql
NOTE: if you want to use different SQL DBs for login/char/map servers this is the list of databases each server use:
- login-server: global_acc_reg_num_db, global_acc_reg_str_db, ipbanlist, login, loginlog
- map-server: autotrade_data, autotrade_merchants, mapreg, npc_market_data
- char-server: everything else
Note that the sql_updates table is needed by all three servers.
Configure Hercules
Compile Source Code
cd Hercules ./configure make sql
How to Recompile
In the future (after you update or edit any file in /src) to recompile, add make clean before make sql:
cd Hercules ./configure make clean make sql
Start your Hercules Server
//change access mode of athena-start file so that you can execute it. //Use (dos2unix athena-start) if yo uare getting ^M errors ie. newline errors chmod a+x athena-start
//To Start ./athena-start start //To Stop ./athena-start stop //To Restart ./athena-start restart