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

[Earnestinence]

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

[ManokStreZ]

1 hour ago, hendra814 said:

are you already create new account using account ID 2000000 at login table?

Or try create it via client using user_M or user _F for the first time.

after that only use user for ID.

Yes, thanks a lot i really forgot enable register _M/F silly me,,,thanks again

[GoChrisP]

hi, i try to follow step by step and found error like this, i have already read problem and solution in this forum.. and i dont get it the solution.. please help thx b4

[hendra814]

1 hour ago, GoChrisP said:

hi, i try to follow step by step and found error like this, i have already read problem and solution in this forum.. and i dont get it the solution.. please help thx b4

are you already run step 4 for SQL part ?

Edited June 20, 2024 by hendra814

[GoChrisP]

9 minutes ago, hendra814 said:

are you already run step 4 for SQL part ?

yes i have already and double check again, nothing seems anything wrong.. administrative roles i try to change uncheck dba no difference, sorry im noob

[hendra814]

1 hour ago, GoChrisP said:

yes i have already and double check again, nothing seems anything wrong.. administrative roles i try to change uncheck dba no difference, sorry im noob

i think you miss this part

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 ) 

because in your login database it's empty

[GoChrisP]

3 hours ago, hendra814 said:

i think you miss this part

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 ) 

because in your login database it's empty

this one?

i have done change that one

[hendra814]

4 hours ago, GoChrisP said:

this one?

i have done change that one

ok, sorry didn't see in the first post, but try change this into localhost

[GoChrisP]

2 hours ago, hendra814 said:

ok, sorry didn't see in the first post, but try change this into localhost

still same error, but im realize in tutorial youtube there are 3 panel when runserver and mine are 4 panel (log/login-server.exe.leaks, char-server.exe.leaks, web-server.exe.leaks, and map-server.exe.leaks). Can i ignore the error web-server.exe?

[hendra814]

10 hours ago, GoChrisP said:

still same error, but im realize in tutorial youtube there are 3 panel when runserver and mine are 4 panel (log/login-server.exe.leaks, char-server.exe.leaks, web-server.exe.leaks, and map-server.exe.leaks). Can i ignore the error web-server.exe?

sorry, is that error for web server?

and are you already import web.sql script into your database?

[GoChrisP]

5 minutes ago, hendra814 said:

sorry, is that error for web server?

and are you already import web.sql script into your database?

yes error for web server, where import web.sql script? im just follow instruction install in youtube.. sorry my noob and idont know

Edited June 21, 2024 by GoChrisP

[hendra814]

2 minutes ago, GoChrisP said:

yes error for web server, where import web.sql script? im just follow instruction install in youtube.. sorry my noob and idont know

check sql folder

[GoChrisP]

5 minutes ago, hendra814 said:

check sql folder

this one?

[hendra814]

1 hour ago, GoChrisP said:

this one?

Yes, try import and then run again for web server.

[GoChrisP]

1 hour ago, hendra814 said:

Yes, try import and then run again for web server.

wait a minute, import from where?

[hendra814]

49 minutes ago, GoChrisP said:

wait a minute, import from where?

go to your database sql, and do step import rathena SQL files to rathena & rathena_logs databases: See video time-line: 06:16

for your web.sql

Edited June 21, 2024 by hendra814

[fxvll]

Hi, just trying to get back to Ragnarok offline for the nostalgia.

Which mysql server version should i use for this? i read that this should worked with mysql 8.x but i can't get it working while creating user ragnarok, there's no standard option on the authentication type

[Sallycantdance]

26 minutes ago, fxvll said:

Hi, just trying to get back to Ragnarok offline for the nostalgia.

Which mysql server version should i use for this? i read that this should worked with mysql 8.x but i can't get it working while creating user ragnarok, there's no standard option on the authentication type

5

[fxvll]

1 hour ago, GM Winter said:

5

thank you for your response. 

 

I read the tutorial said that it work with mysql version 8.x so i tried using version 8.4.2 from the mysql download page. It said that it still have the plugin for the legacy authentication but it was disabled and since i don't know how to enable it, i can't make it work ( maybe others who has deeper understanding regarding this can explain / give pointers on how to enable it ). After trial & error, i found out that the latest version of mysql that still have the legacy authentication enabled is version 8.0.39. so for those who want to use newer version of mysql, use that version.

[Sallycantdance]

5 hours ago, fxvll said:

thank you for your response. 

 

I read the tutorial said that it work with mysql version 8.x so i tried using version 8.4.2 from the mysql download page. It said that it still have the plugin for the legacy authentication but it was disabled and since i don't know how to enable it, i can't make it work ( maybe others who has deeper understanding regarding this can explain / give pointers on how to enable it ). After trial & error, i found out that the latest version of mysql that still have the legacy authentication enabled is version 8.0.39. so for those who want to use newer version of mysql, use that version.

yes, if you use the new versions your map char and log serv will show you this error [SQL]: SSL connection error: unknown error number,  because the new version has legacy authentication and even you off it it still there 

[fxvll]

1 hour ago, GM Winter said:

yes, if you use the new versions your map char and log serv will show you this error [SQL]: SSL connection error: unknown error number,  because the new version has legacy authentication and even you off it it still there 

i don't see that error yet ( probably since i haven't finished setting it up ), i'm still setting up the client. Will update here after i finished setting up & can actually play

[fxvll]

anyone knows what error is this? i already following the guide for the client but i always got this error when starting

 

 

EDIT : I also got this error when i tried to login using the same account that previously stuck after creating a character

 

Edited September 18, 2024 by fxvll

[Styx15]

somebody can help me why like this ?and how to fix it ..thank you