This will place all the files inside\u00a0rAthena<\/code>\u00a0of your current directory in terminal.<\/p>\n

To update the server files to latest revision, run this command.<\/p>\n

    cd rAthena\r\n    git pull\r\n<\/code><\/pre>\n
\n
MySQL setup<\/strong><\/h3>\n
In this part, we’re configuring MySQL for the database of our server. First, check if your MySQL Server is running.<\/p>\n
    service mysql status\r\n<\/code><\/pre>\n
If its not running, enter this command.<\/p>\n
    service mysqld start\r\n<\/code><\/pre>\n
After running the commands above, open the MySQL console.<\/p>\n
    mysql -u root -p\r\n<\/code><\/pre>\n
You will be asked for your root password. After logging in, type the following commands to create the database for our server.<\/p>\n
CREATE DATABASE (your ragnarok database name); — We’ll name it “ragnarok”.<\/p><\/blockquote>\n
    mysql> CREATE DATABASE ragnarok;\r\n<\/code><\/pre>\n
Then, create a new user for the Ragnarok DB and log DB.<\/p>\n
GRANT ALL ON ragnarok.* TO\u00a0yourdatabaseusername@localhost\u00a0IDENTIFIED BY “yourdesiredpassword”; — We will create a new user called\u00a0admin<\/strong>\u00a0with a password of\u00a0123456<\/strong>.<\/p><\/blockquote>\n
    mysql> GRANT ALL ON ragnarok.* TO admin@localhost IDENTIFIED BY \"123456\";\r\n<\/code><\/pre>\n
You can replace\u00a0localhost<\/strong>\u00a0with an IP address if you want the user to be able to access your MySQL server remotely.<\/p>\n
Create log database for the Ragnarok game logs.<\/p>\n
CREATE DATABASE (your log database name) — We’ll name it “log”.<\/p><\/blockquote>\n
    mysql> CREATE DATABASE log;\r\n<\/code><\/pre>\n
Set permissions for the user that we created earlier named\u00a0admin<\/strong>.<\/p>\n
    mysql> GRANT ALL ON log.* TO admin@localhost;\r\n<\/code><\/pre>\n
Restore the required tables in your Ragnarok and log database. Update your password after\u00a0-p<\/code>\u00a0accordingly.<\/p>\n
mysql> quit;\r\n\r\nmysql -u admin -p123456 ragnarok  < \/path\/to\/your\/rathena folder\/sql-files\/main.sql\r\nmysql -u admin -p123456 log < \/path\/to\/your\/rathena folder\/sql-files\/logs.sql\r\n<\/code><\/pre>\n
\n
Creating a game account<\/strong><\/h3>\n
We’re using phpMyAdmin that we installed earlier to access the database. Access phpMyAdmin through your web browser.<\/p>\n
Select the\u00a0ragnarok<\/code>\u00a0database and choose the\u00a0login<\/code>\u00a0table. We can see that there’s one record in that table. Do not delete\/modify it yet. It is used by the server. To create a game account, click the SQL tab while on the\u00a0login<\/code>\u00a0table to open the query editor. Run the following query.<\/p>\n
    INSERT INTO `ragnarok`.`login` (`account_id`, `userid`, `user_pass`, `sex`, `email`, `group_id`, `state`, `unban_time`, `expiration_time`, `logincount`, `lastlogin`, `last_ip`, `birthdate`, `character_slots`, `pincode`, `pincode_change`, `vip_time`, `old_group`) VALUES ('2000000', 'admin', 'password123', 'M', 'email@email.com', '99', '0', '0', '0', '0', '0000-00-00 00:00:00', '', '0000-00-00', '9', '', '0', '0', '0');\r\n<\/code><\/pre>\n
We have inserted a new user in login table with the following information.<\/p>\n
\n
account_id =\u00a02000000<\/strong>\u00a0(Always start with 2000000, then 2000001…)<\/li>\n
userid =\u00a0admin<\/strong>\u00a0(Your in-game username)<\/li>\n
user_pass =\u00a0password123<\/strong>\u00a0(The password for your account)<\/li>\n
sex =\u00a0M<\/strong>\u00a0(M or F, do not use S because its just for the server)<\/li>\n
email =\u00a0email@email.com<\/strong>\u00a0(Your account’s email, used for deleting character slots in-game)<\/li>\n
group_id =\u00a099<\/strong>\u00a0(refer to\u00a0\/rathena\/conf\/groups.conf<\/code>\u00a0and check the id lines. As for now, 99 to make this a GM account for special command usage ingame.)<\/li>\n
character_slots =\u00a09<\/strong>\u00a0(Number of characters that can be created per account)<\/li>\n<\/ul>\n
Leave the other values as-is. Congratulations. You have successfully created your account for the game.<\/p>\n
\n
Configuring the server files<\/strong><\/h3>\n
First, you must know your server’s IP address. You may already know this since it was already included in the server information of your AKLWEB Host VPS. If you want to check it, type:<\/p>\n
    ifconfig\r\n<\/code><\/pre>\n
Look for the eth0\u00a0inet addr:xxx.xxx.xxx.xxx<\/strong>\u00a0part.\u00a0xxx.xxx.xxx.xxx<\/strong>\u00a0will be the IP address of your server. If you have Apache installed, you may access this to check if your web server is running.<\/p>\n
In FileZilla, login to your VPS with your server credentials and access the\u00a0\/rAthena\/conf<\/code>\u00a0folder.<\/p>\n
Edit\u00a0char_athena.conf<\/code>\u00a0and\u00a0map_athena.conf<\/code>\u00a0with your preferred text editor.<\/p>\n
Edit\u00a0char_athena.conf<\/code>\u00a0from:<\/p>\n
    \/\/ Login Server IP\r\n    \/\/ The character server connects to the login server using this IP address.\r\n    \/\/ NOTE: This is useful when you are running behind a firewall or are on\r\n    \/\/ a machine with multiple interfaces.\r\n    \/\/login_ip: 127.0.0.1\r\n\r\n    \/\/ The character server listens on the interface with this IP address.\r\n    \/\/ NOTE: This allows you to run multiple servers on multiple interfaces\r\n    \/\/ while using the same ports for each server.\r\n    \/\/bind_ip: 127.0.0.1\r\n\r\n    \/\/ Login Server Port\r\n    login_port: 6900\r\n\r\n    \/\/ Character Server IP\r\n    \/\/ The IP address which clients will use to connect.\r\n    \/\/ Set this to what your server's public IP address is.\r\n    \/\/char_ip: 127.0.0.1       \r\n<\/code><\/pre>\n
To:<\/p>\n
    \/\/ Login Server IP\r\n    \/\/ The character server connects to the login server using this IP address.\r\n    \/\/ NOTE: This is useful when you are running behind a firewall or are on\r\n    \/\/ a machine with multiple interfaces.\r\n    login_ip: xxx.xxx.xxx.xxx\r\n\r\n    \/\/ The character server listens on the interface with this IP address.\r\n    \/\/ NOTE: This allows you to run multiple servers on multiple interfaces\r\n    \/\/ while using the same ports for each server.\r\n    \/\/bind_ip: 127.0.0.1\r\n\r\n    \/\/ Login Server Port\r\n    login_port: 6900\r\n\r\n    \/\/ Character Server IP\r\n    \/\/ The IP address which clients will use to connect.\r\n    \/\/ Set this to what your server's public IP address is.\r\n    char_ip: xxx.xxx.xxx.xxx\r\n<\/code><\/pre>\n
Where\u00a0xxx.xxx.xxx.xxx<\/code>\u00a0is the IP address of your server.<\/p>\n
In the\u00a0inter_athena.txt<\/code>\u00a0file, make these changes:<\/p>\n
    \/\/ Global SQL settings\r\n    \/\/ overridden by local settings when the hostname is defined there\r\n    \/\/ (currently only the login-server reads\/obeys these settings)\r\n\r\n    \/\/ MySQL Login server\r\n    login_server_ip: 127.0.0.1 \/\/ <- either 127.0.0.1 or your server's ip, we'll use 127.0.0.1 since it listens to own mySQL server, change it to IP if your mySQL Server is in different server.\r\n    login_server_port: 3306\r\n    login_server_id: ragnarok \/\/ <- change this to your mySQL User your created earlier\r\n    login_server_pw: ragnarok \/\/ <- its password \r\n    login_server_db: ragnarok \/\/ <- change this if your ragnarok db you set is different\r\n    login_codepage:\r\n    login_case_sensitive: no\r\n\r\n    ipban_db_ip: 127.0.0.1 \/\/ <- either 127.0.0.1 or your server's ip, we'll use 127.0.0.1 since it listens to own mySQL server, change it to IP if your mySQL Server is in different server.\r\n    ipban_db_port: 3306\r\n    ipban_db_id: ragnarok \/\/ <- change this to your mySQL User your created earlier\r\n    ipban_db_pw: ragnarok \/\/ <- its password \r\n    ipban_db_db: ragnarok \/\/ <- change this if your ragnarok db you set is different\r\n    ipban_codepage:\r\n\r\n    \/\/ MySQL Character server\r\n    char_server_ip: 127.0.0.1 \/\/ <- either 127.0.0.1 or your server's ip, we'll use 127.0.0.1 since it listens to own mySQL server, change it to IP if your mySQL Server is in different server.\r\n    char_server_port: 3306\r\n    char_server_id: ragnarok \/\/ <- change this to your mySQL User your created earlier\r\n    char_server_pw: ragnarok \/\/ <- its password \r\n    char_server_db: ragnarok \/\/ <- change this if your ragnarok db you set is different\r\n\r\n    \/\/ MySQL Map Server\r\n    map_server_ip: 127.0.0.1 \/\/ <- either 127.0.0.1 or your server's ip, we'll use 127.0.0.1 since it listens to own mySQL server, change it to IP if your mySQL Server is in different server.\r\n    map_server_port: 3306\r\n    map_server_id: ragnarok \/\/ <- change this to your mySQL User your created earlier\r\n    map_server_pw: ragnarok \/\/ <- its password \r\n    map_server_db: ragnarok \/\/ <- change this if your ragnarok db you set is different\r\n\r\n    \/\/ MySQL Log Database\r\n    log_db_ip: 127.0.0.1 \/\/ <- either 127.0.0.1 or your server's ip, we'll use 127.0.0.1 since it listens to own mySQL server, change it to IP if your mySQL Server is in different server.\r\n    log_db_port: 3306\r\n    log_db_id: ragnarok \/\/ <- change this to your mySQL User your created earlier\r\n    log_db_pw: ragnarok \/\/ <- its password \r\n    log_db_db: log \/\/ <- change this if your log db you set is different\r\n    log_codepage:\r\n    log_login_db: loginlog\r\n<\/code><\/pre>\n
In the\u00a0map_athena.txt<\/code>\u00a0file, make these changes:<\/p>\n
    \/\/ Character Server IP\r\n    \/\/ The map server connects to the character server using this IP address.\r\n    \/\/ NOTE: This is useful when you are running behind a firewall or are on\r\n    \/\/ a machine with multiple interfaces.\r\n    char_ip: x.x.x.x\r\n\r\n\r\n    \/\/ The map server listens on the interface with this IP address.\r\n    \/\/ NOTE: This allows you to run multiple servers on multiple interfaces\r\n    \/\/ while using the same ports for each server.\r\n    \/\/bind_ip: 127.0.0.1\r\n\r\n    \/\/ Character Server Port\r\n    char_port: 6121\r\n\r\n\r\n    \/\/ Map Server IP\r\n    \/\/ The IP address which clients will use to connect.\r\n    \/\/ Set this to what your server's public IP address is.\r\n    map_ip: x.x.x.x\r\n\r\n    \/\/ Map Server Port\r\n    map_port: 5121\r\n<\/code><\/pre>\n
Where\u00a0xxx.xxx.xxx.xxx<\/code>\u00a0is the IP address of your server.<\/p>\n
Open\u00a0subnet_athena.txt<\/code>\u00a0and set the IP Address.<\/p>\n
    subnet: 255.0.0.0:x.x.x.x:x.x.x.x\r\n<\/code><\/pre>\n
And we’re done configuring the server.<\/p>\n
\n
Compiling rAthena server<\/strong><\/h3>\n
Now, time to compile the server! In this part, you need to know what Ragnarok Online client version you’ll be using to connect to the server. For client setup, visit\u00a0this page<\/a>.<\/p>\n
After you decide which client to be use, let’s edit some files. Let’s just say, we chose to use the\u00a008072013<\/code>\u00a0client since this is the stable renewal client.<\/p>\n
Run this command on terminal:<\/p>\n
    .\/configure --enable-packetver=YYYYMMDD\r\n<\/code><\/pre>\n
Replace\u00a0YYYYMMDD<\/code>\u00a0with the client date (reformatted).<\/p>\n
    .\/configure --enable-packetver=20130807\r\n<\/code><\/pre>\n
The configure script will perform necessary tests and generate makefiles for our server.<\/p>\n
After that, compile the source code by entering these commands:<\/p>\n
    make server\r\n    chmod a+x login-server && chmod a+x char-server && chmod a+x map-server\r\n<\/code><\/pre>\n
… and wait for it to finish. If you make modifications on the files inside\u00a0\/rAthena\/src<\/code>\u00a0folder, you will need to recompile it.<\/p>\n
    make clean\r\n    make server\r\n<\/code><\/pre>\n
\n
Configuring the packet version for client connections<\/strong><\/h3>\n
In FileZilla, point to the\u00a0\/rAthena\/db<\/code>\u00a0folder and edit\u00a0packet_db.txt<\/code>.<\/p>\n
Find this line and edit:<\/p>\n
    \/\/\r\n    \/\/packet_db_ver: 46\r\n    packet_db_ver: default\r\n    packet_keys_use: default\r\n<\/code><\/pre>\n
Since we’re using the\u00a02013-08-07Ragexe<\/code>\u00a0client, find the specified client below and look for its\u00a0packet_ver<\/strong>\u00a0and\u00a0packet_keys<\/strong>.<\/p>\n
    \/\/2013-08-07Ragexe\r\n    packet_ver: 45\r\n    packet_keys: 0x7E241DE0,0x5E805580,0x3D807D80 \/\/ [Shakto] \r\n<\/code><\/pre>\n
Replace the default value of\u00a0packet_db_ver<\/code>\u00a0and\u00a0packet_keys_use<\/code>\u00a0into the specified client values.<\/p>\n
    \/\/\r\n    \/\/packet_db_ver: 46\r\n    packet_db_ver: 45\r\n    packet_keys_use: 0x7E241DE0,0x5E805580,0x3D807D80\r\n<\/code><\/pre>\n
And save. This is for specifying what client is to be used by players. We don’t want them to be able to use their version of choice.<\/p>\n
\n
Starting the server<\/strong><\/h3>\n
After compiling the server files, use these commands to fire up the server.<\/p>\n
To start:<\/p>\n
    .\/athena-start start\r\n<\/code><\/pre>\n
To stop:<\/p>\n
    .\/athena-start stop\r\n<\/code><\/pre>\n
To restart:<\/p>\n
    .\/athena-start restart\r\n<\/code><\/pre>\n
If you have encountered an error like this:<\/p>\n
    -bash: .\/athena-start: \/bin\/sh^M: bad interpreter\r\n<\/code><\/pre>\n
… then you need to install dos2unix to convert the script.<\/p>\n
    apt-get install dos2unix\r\n    dos2unix athena-start \r\n    chmod a+x athena-start\r\n<\/code><\/pre>\n
After running those commands, start the server again.<\/p>\n
Now that we’re done with the server setup, you just need to set your\u00a0Ragnarok<\/strong>\u00a0client to point to your\u00a0VPS server<\/strong>. Enjoy playing on your new server!<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","manualknowledgebasecat":[105,242,247],"manual_kb_tag":[214],"_links":{"self":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb\/2318"}],"collection":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/comments?post=2318"}],"version-history":[{"count":2,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb\/2318\/revisions"}],"predecessor-version":[{"id":2320,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb\/2318\/revisions\/2320"}],"wp:attachment":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/media?parent=2318"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manualknowledgebasecat?post=2318"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb_tag?post=2318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}