[Tutorial] Video Edition - How to Setup rAthena and run Ragnarok Updated 2018-7-28

Earnestinence · July 12, 2017

Hello rAthena Community

I'm Earnestinence, and i'll be guiding you to setup rAthena and run Ragnarok

Programs you need to install before we start

Downloads:
- Github : https://desktop.github.com/
- MySQL (When installing: make sure to check 'Use Legacy Authentication Method; Retain MySQL 5.x compatibility' ) : http://www.mysql.com/downloads/mysql/
- MySQL Workbench : http://www.mysql.com/downloads/workbench/
  - Note: remember the username and password you set when installing !
- Latest Clean kRO Full Client : by: @Akkarin
  - Spoiler
- Microsoft Visual Studio ( MVS ) : https://www.visualstudio.com/downloads/
  - Visual Studio is a code editor supporting and C andC++ compiler. more info Click here by @Aleos
- Notepad ++ : https://notepad-plus-plus.org/download/
  - Note: Notepad++ source code editor and Notepad replacement ( or just use notepad )
- 2015-11-04a unpacked client: https://mega.nz/#!w84jRRjZ!iWjU1Qfsez_3nbTtqQuFWHsbda2IglPi7TBnzZWmJtI by: @Napster
  - rAthena support all the clients listed in the packet files : read more

Required Files:

After you download and install GitHub download these files using GitHub
File > Clone Repository
- rAthena ( server ) :
```
https://github.com/rathena/rathena.git 
```
- English Translated System & Data Folders RE/PRE: by @zackdreaver
- Spoiler
  - For Renewal: https://github.com/zackdreaver/ROenglishRE For Pre-Renewal : https://github.com/zackdreaver/ROenglishPRE
- NEMO Client Patcher : https://github.com/MStr3am/NEMO.git
  - For more info see this topic by @NeoMind
- Client Setup : http://nn.ai4rei.net/dev/opensetup/
  - Client setup for Ragnarok Online by @Ai4rei

==========================================

Setting up rAthena Server-Side: See video time-line: 00:02

Step 1: Download/Clone rAthena Source

Open GitHub.
- Click Clone repository.
- Click URL tap.
- Copy and paste this URL: https://github.com/rathena/rathena.git
- Choose the downloading path.
- Click Clone and wait for it do finish downloading.

Step 2: Configuring rAthena See video time-line: 00:35

open rathena/conf/import/char_conf.txt
- Add these lines :
  - userid: username
  - passwd: password
  - login_ip: 127.0.0.1
  - char_ip: 127.0.0.1
- [Optional] To change server name add this line :
  - server_name: YourDesiredServerName
- Note: If you want to change anything in char_athena.conf, use the import-tmpl directory to avoid future issues when updating. ( just add the respective value you want ).
rathena/conf/import/map_conf.txt
- Add these lines:
  - userid: username
  - passwd: password
  - char_ip: 127.0.0.1
  - map_ip: 127.0.0.1
- Note: If you want to change anything in map_athena.conf, use the import-tmpl directory to avoid future issues when updating. ( just add the respective value you want ).
rathena/conf/import/inter_conf.txt
- Add these lines
  - login_server_db: rathena
  - ipban_db_db: rathena
  - char_server_db: rathena
  - map_server_db: rathena
  - log_db_db: rathena_logs
- Note: If you want to change anything in map_athena.conf, use the import-tmpl directory to avoid future issues when updating. ( just add the respective value you want ).
- Note: I use rathena as my main database which contain all main tables (like: chars, login, guilds, etc... ). However, I like to separate my logs to rAthena_logs .

Step 3: Compiling rAthena See video time-line: 02:16

Locate rathena/rAthena.sln
- Locate and right click rAthena.sln open with > Microsoft Visual Studio 2017 ( or 2013 / 2015 )
- Wait for the MVS to load the project, when it's ready select Solution 'rAthena' (8 projects) and then right click and Click 'Clean Solution' First when clean finish successfully click on 'build Solution'
- Wait for it to finish, make sure the log below finish successfully

Step 4: Setting SQL Database ( make sure MySQL installed and running ) See video time-line: 03:13

open MySQL Workbench
- log in :
  - Using the username 'root 'and the password you set when you first install MySQL ( If you don't remember the password, you can reconfigure MySQL using MySQL installer )
- once you logged in create new user account and grant Administrator Privileges: - See video time-line: 04:17
  1. In The Left Side click on Users and Privileges
  2. At The Bottom click on Add account
  3. Set Login Name : ragnarok
  4. Set Password : ragnarok
  5. Set Confirm Password : ragnarok
  6. At The Top Menu Click Administrative Roles: and then check DBA
  7. Click Apply
  8. logout by clicking on X at the top of the current tap and then login using the new user account ragnarok with password ragnarok See video time-line: 05:00
- Creating databases/schema : See video time-line: 05:26
  - Click on create new database/schema
  - Set the Name: rathena ( this will be our main database/schema )
  - Set Charset: utf8 ( Now this's is important you need to check this )
  - Click apply, apply and then finish
  - Now Click on create new database/schema
  - Set the Name: rathena_logs ( this will be our logs database/schema )
  - Set Charset: utf8 ( Now this's is important you need to check this )
  - Click apply, apply and then finish
- import rathena SQL files to rathena & rathena_logs databases: See video time-line: 06:16
  - Double click on rathena database/schema we've just created
  - Click on
  - locate rathena folder and go to rathena/sql-files and click on main.sql
  - Click on the light icon * wait for the tablet to be executed *
  - Double click on rathena_logs database/schema we've just created
  - Click on
  - locate rathena folder and go to rathena/sql-files and click on logs.sql
  - Click on the light icon * wait for the tablet to be executed *
- change the username and password of the server: See video time-line: 07:03
  - Now next/around rathena database right click on a blank area and click refresh all ( in order to view the tables we've just created or just relog )
  - Click on rathena database/schema > tables > locate login table..
  - now click on tables and locate login table then right click and click on select Rows - Limit 1000
  - Double click on s1 and change it to username then hit enter ( we put the userid: username in rathena/conf/import-tmpl/char_conf.txt and map_conf.txt make sure you use the same one you put in these files )
  - Double click on p1 and change it to password then hit enter ( we put the passwd: password in rathena/conf/import-tmpl/char_conf.txt and map_conf.txt make sure you use the same one you put in these files )
  - Click apply, apply and then finish

Step 5 ( running the server )

Running rAthena server See video time-line: 07:35
- locate rathena folder rathena/ click on runserver
  - ( less than 8 mins without any errors )

==================================================

Client Side Running & patch ragnarok online client

open Official kRO Client/
- Updating kRO Files:
  - Locate and run rsu-kro-rag-lite.exe and wait for it to finish and then rsu-kro-renewal-lite.exe and wait for it to finish updating ..
- Adding translated system/data files
  - Locate ROenglishRE or ROenglishPRE and copy Data & System folders , GuildTip & Tipoftheday
  - and paste these files into the official kro client folder ( Replace the files when asked )
- Setting up clientinfo.xml :
  - locate official kRO client folder open folder data/ and edit file clientinfo.xml
    1. ~~change the version to 55 <version>55</version>~~ (This might not be needed anymore.)
    2. set the langtype to 1 < To be able to write in English. ( refer to this page to find your preferred language beside English: https://github.com/rathena/rathena/wiki/Clientinfo.xml ).
    3. set admin sprite for any account you want, just put the account id
      1. <aid> <admin>2000000</admin> </aid>
- Copy and paste the setup file into the the official kRO client folder
- Patching the Client 2015-11-04
  - load the client and select recommended and click enter for data.ini and then CHANGE/EDIT system/iteminfo.lub to system/iteminfo.lua and check read data folder first, ignore missing palettes, ignore resource errors and then customize the client as you want

Here's my additional patches:

>>>
Custom Window Title ( name you server )
Disable Swear Filter
Disconnect to Login Window
Enable Title Bar Menu
Read Data Folder First
Show Cancel To Service Select
Ignore Missing Palette Error
Ignore Resource Errors
Use Ragnarok Icon ( ragnarok icon for the client )
<<<

copy the new 2015-11-04aRagexe_patched and paste it your official kRO client folder

now the client is ready, just run the game using 2015-11-04aRagexe_patched and Enjoy

to create a male account just type ex: admin_f for female - admin_m for male

and don't forget to set the account group id 99 to get full GM permissions

Issue #1: Closed connection from '127.0.0.1'.
Solve: go to your rathena/src/custom/defines_pre.hpp and open it with notepad++ ( or any notepad ) add this line #define PACKETVER 20151104

========================================================

As of 28-7-2018: the topic is fully updated and support MySQL 8.x

========================================================

For further questions or concerns regarding the tutorial, Do NOT hesitate to contact me in this topic.

- Earnestinence

Edited March 5, 2020 by Earnestinence
Added issue and solve #1

straycatchy · November 2, 2018

Do i have to change some code in "packets.hpp" at "rAthena\src\config" before compiling server ?

Spoiler


#define PACKETVER 20180620

to


#define PACKETVER 20151104

and disable "PACKET_OBFUSCATION" by adding "//" infront of it ?

Spoiler


#define PACKET_OBFUSCATION

to


//#define PACKET_OBFUSCATION

and do i have to select "Disable Packet Encryption"

(https://i.imgur.com/ZPe60QN.jpg)

in Nemo patcher before patch ?

Edited November 2, 2018 by straycatchy

eden · November 9, 2018

Hey Earnestinence,

yoou still there???

On 10/25/2018 at 4:43 AM, d3athrave said:

Somehow i managed to solve my problem.

Try to go to your rathena/src/custom/defines_pre.hpp and open it with notepad.

and just under this two lines:

#ifndef CONFIG_CUSTOM_DEFINES_PRE_HPP
#define CONFIG_CUSTOM_DEFINES_PRE_HPP

add:

#define PACKETVER YYYYMMDD <------ your client

then recompile. This solved my problem.

Hi,

Could you please help what you mean by

#define PACKETVER YYYYMMDD <------ your client ???

lets say my client's name is 2015-11-04aRagexe_patched.

So, its gonna be
#define PACKETVER 20151104 ???

Hi Everyone,

Please help as my SQL doesnt have the sys as per video.

image.png.3c8e56d6ef8e83887fb9ed3c3c092fcd.png

AsynjuRO · November 13, 2018

Hi, I have serch for info to make a Client .exe file but I cann't find anything!! Can someone patch me an exe file? I yust need the same exe but with this options marked on NEMO:

-Use Custom Aura Sprites

-Use Custom Aura Limits

On this custom aura limits, I dont really know how it works, but I want it to show 99 aura at 99 and 3rd Job aura at 120

If some one could help me out with the patched client or the unpatched client but explaining me how to do this I'll be happy!! I all ready read lots of guides, but if you know one that explanes how to make the unpatch file that would be awsome too!!!

Thx for your time reading!

Cheers!!

Earnestinence · November 18, 2018

On 10/25/2018 at 3:12 AM, d3athrave said:

I have tried to search you on discord but sadly i cant find you.

My problem with this guide is that i cannot proceed to character creation. Can you help me with this? Thanks.

What client are you using?

On 11/9/2018 at 5:23 PM, eden said:

Hey Earnestinence,

yoou still there???

Hi,

Could you please help what you mean by

#define PACKETVER YYYYMMDD <------ your client ???

lets say my client's name is 2015-11-04aRagexe_patched.

So, its gonna be
#define PACKETVER 20151104 ???

Hi Everyone,

Please help as my SQL doesnt have the sys as per video.

3

Quote

lets say my client's name is 2015-11-04aRagexe_patched.

So, its gonna be
#define PACKETVER 20151104 ???

Yes. that is correct!

- sys database is not important for the tutorial.

On 11/13/2018 at 6:41 PM, AsynjuRO said:

Hi, I have serch for info to make a Client .exe file but I cann't find anything!! Can someone patch me an exe file? I yust need the same exe but with this options marked on NEMO:

-Use Custom Aura Sprites

-Use Custom Aura Limits

On this custom aura limits, I dont really know how it works, but I want it to show 99 aura at 99 and 3rd Job aura at 120

If some one could help me out with the patched client or the unpatched client but explaining me how to do this I'll be happy!! I all ready read lots of guides, but if you know one that explanes how to make the unpatch file that would be awsome too!!!

Thx for your time reading!

Cheers!!

You can create the .exe application file by nemo. All you need is the unpacked client file.

Quote

2015-11-04a unpacked client: https://mega.nz/#!w84jRRjZ!iWjU1Qfsez_3nbTtqQuFWHsbda2IglPi7TBnzZWmJtI by: @Napster
rAthena support all the clients listed in the packet files : read more

3

Regarding the aura, please search for it in the forums and the wiki.

On 10/28/2018 at 6:13 PM, AidiRO said:

how to choose renewal or pre renewal?

You can find that on the wiki, or the forums. it's easy

On 10/20/2018 at 8:14 AM, beanbean02 said:

I followed all your guide but.. Always FAILED TO CONNECT WHY?

Hi there,

this is probably late, but is there any error on logs? and what client are you using?

Ely912 · November 26, 2018

does this still work seem to be having problems with compiling Error C1083. I downloaded it with Github Dekstop

akki24 · January 15, 2019

Hello! I am starting to experiment to make a pre renewal server and I ran into an issue with your guide...

On 7/12/2017 at 1:20 AM, Earnestinence said:

For Renewal: https://github.com/zackdreaver/ROenglishRE For Pre-Renewal : https://github.com/zackdreaver/ROenglishPRE

I noticed that in your guide we have to modify the clientinfo.xml but the prerenewal data folder doesn't have the clientinfo.xml, only the renewal one does.

How can I solve this problem?

Domo412 · January 16, 2019

On 1/4/2018 at 6:13 PM, Hitsukay said:

It's my first time using rAthena and making my own server
I was following the guide who has on GiftHub but was not understanding much. So I researched and found your video
I did everything exactly like you did, but this happens when i build solution (sorry for the PT-BR in Visual Studio)

I had the same problem, what helped me was adding this. I hope this helps someone :3.

Earnestinence · January 16, 2019

On 1/15/2019 at 6:18 AM, akki24 said:

Hello! I am starting to experiment to make a pre renewal server and I ran into an issue with your guide...

I noticed that in your guide we have to modify the clientinfo.xml but the prerenewal data folder doesn't have the clientinfo.xml, only the renewal one does.

How can I solve this problem?

Create one or just use this

<?xml version="1.0" encoding="euc-kr" ?>
<clientinfo>
	<desc>Ragnarok Client Information</desc>
	<servicetype>korea</servicetype>
	<servertype>primary</servertype>
	<connection>
		<display>Local</display>
      		<address>127.0.0.1</address>
      		<port>6900</port>
      		<langtype>1</langtype>
		<registrationweb>www.ragnarok.com</registrationweb>
		<aid>
		<admin>2000000</admin>
		</aid>
		<loading>
			<image>loading00.jpg</image>
			<image>loading01.jpg</image>
			<image>loading02.jpg</image>
			<image>loading03.jpg</image>
			<image>loading04.jpg</image>
			<image>loading05.jpg</image>
			<image>loading06.jpg</image>
		</loading>
   	</connection>
</clientinfo>

Mhiikhaleefha · March 15, 2019

is there a way I can add special skill to all classes? e.g. AB has skills that summons mobs from biolab to aid in battle? TIA for answering

raka26 · March 20, 2019

Thank for the tutorial, im traying to make Online server on my own house! Thanks!

Hey, when re-compile char_server.conf and map, on import folder dont change de configuration. What can we do?Hey, when re-compile char_server.conf and map, on import folder dont change de configuration. What can we do?

exiie · April 10, 2019

Much respect and appreciation for the guide and easy to follow video configurations. This helped tremendously for beginner such as myself. Only one small suggestion, it would be useful to note where to obtain the 2015-11-04aRagexe.exe client which is one of the more stable client versions.

Earnestinence · April 11, 2019

On 4/11/2019 at 2:49 AM, exiie said:

Much respect and appreciation for the guide and easy to follow video configurations. This helped tremendously for beginner such as myself. Only one small suggestion, it would be useful to note where to obtain the 2015-11-04aRagexe.exe client which is one of the more stable client versions.

I appreciate your show of gratitude. I am so glad that this guide has helped you.

2015-11-04a unpacked client: https://mega.nz/#!w84jRRjZ!iWjU1Qfsez_3nbTtqQuFWHsbda2IglPi7TBnzZWmJtI by: @Napster

Edited April 13, 2019 by Earnestinence

Razza · April 22, 2019

I followed this guide to a T and for some reason the char server isn't connecting? The passwords match on MySQL Workbench, so I'm not sure what I could be doing wrong.

Thanks for your time!

Earnestinence · April 22, 2019

12 hours ago, Razza said:

I followed this guide to a T and for some reason the char server isn't connecting? The passwords match on MySQL Workbench, so I'm not sure what I could be doing wrong.

Thanks for your time!

Check your mysql password, and inter.conf file in ipmort folder

Razza · April 22, 2019

I went ahead and restarted from the beginning and got it working. Thank you for taking the time to answer and for the guide itself.

krono · April 27, 2019

Hey guys,

I am having the same issue, I have followed the tutorial to a T but run into this error as well,

Does anyone know how to fix this? I have checked the files I have edited and they are all set as userid: username passwd: password and I have also changed s1 and p1 in the login table to username and password

I have not touched s1 or p1 anywhere else as this guide did not direct me to. Any help would be greatly appreciated

Thanks!

Kyoshira · May 13, 2019

help me !

I followed the tutorial step by step, however I have a problem.

see:

image.png.509bc0f746f800971eeab279402a9f1f.png

thx

Earnestinence · May 14, 2019

14 hours ago, Kyoshira said:

help me !

I followed the tutorial step by step, however I have a problem.

see:

[Error]: parse_char: Received unknown packet 0x64 from ip 'xx.xx.xx.xx'! Desconnecting!

thx

Greetings,
First, don't show your IP for any reason. Secondly, what led to this error? what client are you using?

Edited May 14, 2019 by Earnestinence

Kyoshira · May 15, 2019

On 5/14/2019 at 10:49 AM, Earnestinence said:

Greetings,
First, don't show your IP for any reason. Secondly, what led to this error? what client are you using?

The problem was my server ports.

,

thx

Felipe Morita · May 23, 2019

Hi, thank you for the awesome tutorial, I learned a lot!

I had an issue that i found no one else having. If its not too much trouble, i could use some help.

After a sucessful compile/build, following the steps of the tutorial, I started the "runserver.bat". Everything worked fine for 15 seconds, no message of error whatsoever.

Suddenly the server print a message about restarting, everything closes automatically and the "runserver.bat" file vanishes. I cant open the server no more.

The client configuration went well, but once im inside ragnarok and I try to log in it says "failed to connect to the server".

Unfortunately, there is no message of error, or anything to show to help my search.

Any ideas of what could it be?

Thanks anyway!

VaRai · May 23, 2019

Thank you for an amazing tutorial.

My server runs perfectly well and I got others joining it without problems thanks to you.

I have one question I hope you can help me with, regarding account registration:

Since I disabled _M and _F account registration, now I manually make accounts inside mysql workbench by filling the login table line by line, and it gets really tough with so many requests. I don't know how to make a registration page that fills the login table in mysql workbench automatically. Any idea how to do it?

Thank you!

Earnestinence · May 23, 2019

13 hours ago, VaRai said:

Thank you for an amazing tutorial.

My server runs perfectly well and I got others joining it without problems thanks to you.

I have one question I hope you can help me with, regarding account registration:

Since I disabled _M and _F account registration, now I manually make accounts inside mysql workbench by filling the login table line by line, and it gets really tough with so many requests. I don't know how to make a registration page that fills the login table in mysql workbench automatically. Any idea how to do it?

Thank you!

Hey there, I'm glad you managed to get your server up and working perfectly.

In order to register new accounts without using the client, you need to install fluxcp. ( https://github.com/rathena/fluxcp ). It is easy to install.

Hazo- · June 14, 2019

How to solve this problem pls

Login.png.6d3eac80d83c275df13d674e96d3920e.png

Edited June 14, 2019 by Hazo-

Earnestinence · June 14, 2019

5 hours ago, Hazo- said:

How to solve this problem pls

What account are you trying to login with? Do not use the server account with the id 1, create another account and use it.

Hazo- · June 14, 2019

5 minutes ago, Earnestinence said:

What account are you trying to login with? Do not use the server account with the id 1, create another account and use it.

I create a new One like you in Video Admin_m but still don't work

Sign In

[Tutorial] Video Edition - How to Setup rAthena and run Ragnarok Updated 2018-7-28

Question

Link to comment

Share on other sites

Top Posters For This Question

Popular Days

Top Posters For This Question

Popular Days

Popular Posts

Earnestinence

Akkarin

Earnestinence

Posted Images

172 answers to this question

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Recently Browsing 0 members

Announcements