Jump to content
  • 9

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


Earnestinence

Question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  6
  • Reputation:   1
  • Joined:  11/30/13
  • Last Seen:  

Great tutorial, easy to understand... but i got this CTwitterDataMgr::CreateInstance() error everytime i launched the patched ragexe... does anyone had the same error?

On 7/10/2020 at 4:15 PM, Waker said:

I've just followed this tutorial the other day and I don't have that error.

may i know which ragexe version did you use for your client? i'm using 2020-07-01cRagexe

On 7/11/2020 at 1:40 AM, Waker said:

I used the one on the tutorial files.

ah, i see... will try using other version then

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  2
  • Reputation:   0
  • Joined:  07/10/20
  • Last Seen:  

Hi,
I just followed the tutorial but when I want to create a new account there is this message i receive: Unregistered ID please make sure you have a registered account .... blabla bla.
How can I solve it, pretty please?

Edit: Registration solved in conf/login_athena, but still cant log in =(

Edited by Just Kaii
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  17
  • Reputation:   0
  • Joined:  08/05/20
  • Last Seen:  

How to create a account? because _m _f is not working example is test_m not recognize please help.

On 7/15/2020 at 6:03 PM, Just Kaii said:

Hi,
I just followed the tutorial but when I want to create a new account there is this message i receive: Unregistered ID please make sure you have a registered account .... blabla bla.
How can I solve it, pretty please?

Edit: Registration solved in conf/login_athena, but still cant log in =(

Same problem haha

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  5
  • Reputation:   0
  • Joined:  09/05/20
  • Last Seen:  

how to get the rag.exe?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  3
  • Reputation:   0
  • Joined:  09/26/20
  • Last Seen:  

On 7/12/2017 at 2:20 PM, Earnestinence said:

 

Hi guys im newbie and first time to install server i wanted to try.

 

i follow the tutorial.

 but when i move to the client side i encountered alot of error.

after downloading the Latest KRO file:  kRO_FullClient_20200409 

i couldnt find and download the rsu-kro-renewal-lite.exe and rsu-kro-rag-lite.exe not in the link.

however i just patched the rsu-kro-renewal-lite.exe and rsu-kro-rag-lite.exe on the KRO folder that existing.

then whenever i downloaded this file i coundnt find the DATA and SCLIENTINFO XML file. 

so i just download from other site that has DATA folder and Sclientinfo.xml.

 

then i received this failed to connect error below.

 

image.thumb.png.45eadd7f2e4809e55bc147db6a9c420d.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.02
  • Content Count:  55
  • Reputation:   0
  • Joined:  09/26/20
  • Last Seen:  

On 7/12/2017 at 11:50 AM, Earnestinence said:

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

Required Files: 

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

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

Step 1: Download/Clone rAthena Source

  • Open GitHub.

 

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 Screenshot_3.png  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 Screenshot_3.png 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 Screenshot_4.png 
      • locate rathena folder and go to rathena/sql-files and click on main.sql
      • Click on the light icon Screenshot_5.png * wait for the tablet to be executed *
      • Double click on rathena_logs database/schema we've just created
      • Click on Screenshot_4.png
      • locate rathena folder and go to rathena/sql-files and click on logs.sql
      • Click on the light icon Screenshot_5.png * 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 by Karthikeyan
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  12
  • Reputation:   0
  • Joined:  09/28/20
  • Last Seen:  

Hi i follow this guide its working i update the RSU rag lite and Renewal lite.

then i use zackdreavers roenglishtranslation pre. because i define my server as prere.  but after done my client still reading korean language. 

i have done this before and i successfully created a client with english version. but after im trying now its not working. is it because rathena updated the emulator? i always make server cloning the rathena from git so its always updated. i notice that the itemdb now they are using YAML. so i cannot add custom item also. anyone has  detailed guide for 2020 updated rathena and clients?

i use 20151104 ragexe. 

 

Thanks in advanced.

 

image.png.e6da0a9834ec73899a0d83dca5642445.png

 

image.png.92af7a716e373f24b2a7c710cfa76cf5.png

 

image.png.45a4a3f556dcad8c7a3f503d1755c389.png

image.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  25
  • Topics Per Day:  0.02
  • Content Count:  47
  • Reputation:   0
  • Joined:  09/28/20
  • Last Seen:  

all done tq

Edited by Styx15
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  90
  • Topics Per Day:  0.02
  • Content Count:  361
  • Reputation:   18
  • Joined:  01/09/13
  • Last Seen:  

take note on the warning.

im using latest MySQL 8 with Legacy (MySQL 5)

dsdsssss.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  2
  • Reputation:   0
  • Joined:  03/24/21
  • Last Seen:  

Hi, I need help. Sorry my for English. Here is my issue. I have follow the step show in the video and everything go well but only problem is the "" closed connection from 127.0.0.1"" shown in picture below. I did added this line #define PACKETVER 20151104 to rathena/src/custom/defines_pre.hpp . But the problem still insist. Appreciate solution/idea provide for solving this problem.

 

 

image.png.dbf493b0c03f107c35ba3052cbe60489.png

 

image.png.97377c091fdad9aa94373091dc32c223.png

 

image.png.6d47624aaf1c24cc0bed54279875ce2b.png

 

image.png.c8c645de30fd4820e80e9f28605c375c.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  4
  • Reputation:   0
  • Joined:  04/01/21
  • Last Seen:  

PLEASE HELP ME FOR ERROR PM ME

Discord :Megi#3791

 

error.png

 

image.png.bd72c581eaa56825bb8278668ebcba7f.png

 

SOMEONE HELP ME.. IM USING A ThIS

image.png.e980c117ba6f68040c72df053827d01d.png

 

PLEASE HELP ME

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  176
  • Topics Per Day:  0.15
  • Content Count:  666
  • Reputation:   9
  • Joined:  12/04/20
  • Last Seen:  

On 7/12/2017 at 2:20 PM, Earnestinence said:

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

Required Files: 

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

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

Step 1: Download/Clone rAthena Source

  • Open GitHub.

 

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 Screenshot_3.png  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 Screenshot_3.png 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 Screenshot_4.png 
      • locate rathena folder and go to rathena/sql-files and click on main.sql
      • Click on the light icon Screenshot_5.png * wait for the tablet to be executed *
      • Double click on rathena_logs database/schema we've just created
      • Click on Screenshot_4.png
      • locate rathena folder and go to rathena/sql-files and click on logs.sql
      • Click on the light icon Screenshot_5.png * 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

thank you very much sir i learned a lot in your guide and tutorials and now im running my own server now thank you very much

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  07/26/21
  • Last Seen:  

Thanks bro!!

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  176
  • Topics Per Day:  0.15
  • Content Count:  666
  • Reputation:   9
  • Joined:  12/04/20
  • Last Seen:  

On 7/27/2021 at 5:54 PM, aSync said:

Thanks bro!!

credits to the owner

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  09/18/21
  • Last Seen:  

a question? I followed all the steps but when I start the session the server closes automatically. What can I do?

 

 

Captura de pantalla (3209).png

Edited by LORDMOON2001
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  176
  • Topics Per Day:  0.15
  • Content Count:  666
  • Reputation:   9
  • Joined:  12/04/20
  • Last Seen:  

43 minutes ago, LORDMOON2001 said:

a question? I followed all the steps but when I start the session the server closes automatically. What can I do?

 

 

Captura de pantalla (3209).png

check your\conf\import

char_conf.txt
inter_conf.txt

map_conf.txt

check the user and password also the db if its match in the database

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  6
  • Reputation:   0
  • Joined:  03/12/23
  • Last Seen:  

Is this guide still working?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  1167
  • Reputation:   159
  • Joined:  06/12/12
  • Last Seen:  

1 hour ago, jblazer said:

Is this guide still working?

yes, until now still working

but for translation data files you can use new link at https://github.com/llchrisll/ROenglishRE

and nemo new link at http://nemo.herc.ws/downloads/

  • Love 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  6
  • Reputation:   0
  • Joined:  03/12/23
  • Last Seen:  

On 3/11/2023 at 11:55 PM, hendra814 said:

yes, until now still working

but for translation data files you can use new link at https://github.com/llchrisll/ROenglishRE

and nemo new link at http://nemo.herc.ws/downloads/

thanks for the links, also I ended up following this guide instead.

https://arstechnica.com/civis/threads/creating-an-open-source-ragnarok-online-server-with-kro-openkore-support.1483047/

Edited by jblazer
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.02
  • Content Count:  21
  • Reputation:   0
  • Joined:  03/07/23
  • Last Seen:  

On 7/12/2017 at 2:20 PM, Earnestinence said:

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

Required Files: 

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

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

Step 1: Download/Clone rAthena Source

  • Open GitHub.

 

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 Screenshot_3.png  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 Screenshot_3.png 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 Screenshot_4.png 
      • locate rathena folder and go to rathena/sql-files and click on main.sql
      • Click on the light icon Screenshot_5.png * wait for the tablet to be executed *
      • Double click on rathena_logs database/schema we've just created
      • Click on Screenshot_4.png
      • locate rathena folder and go to rathena/sql-files and click on logs.sql
      • Click on the light icon Screenshot_5.png * 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

Hi,

I'm on the my sql database part but it seems that it can't proceed it got alot of warnings no table created for the database. pls help

image.thumb.png.8c8589e5b34fa51d33d1af2be5d03ec2.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.02
  • Content Count:  21
  • Reputation:   0
  • Joined:  03/07/23
  • Last Seen:  

On 7/12/2017 at 2:20 PM, Earnestinence said:

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

Required Files: 

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

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

Step 1: Download/Clone rAthena Source

  • Open GitHub.

 

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 Screenshot_3.png  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 Screenshot_3.png 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 Screenshot_4.png 
      • locate rathena folder and go to rathena/sql-files and click on main.sql
      • Click on the light icon Screenshot_5.png * wait for the tablet to be executed *
      • Double click on rathena_logs database/schema we've just created
      • Click on Screenshot_4.png
      • locate rathena folder and go to rathena/sql-files and click on logs.sql
      • Click on the light icon Screenshot_5.png * 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

I've run everything smooth both emulator and client side except getting the "closed connection error" please help, below the screen shot thanks in advance

image.thumb.png.4e848cd1cf3be9d97b06e7af0affc5cc.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  176
  • Topics Per Day:  0.15
  • Content Count:  666
  • Reputation:   9
  • Joined:  12/04/20
  • Last Seen:  

37 minutes ago, mrgeiszer said:

I've run everything smooth both emulator and client side except getting the "closed connection error" please help, below the screen shot thanks in advance

image.thumb.png.4e848cd1cf3be9d97b06e7af0affc5cc.png

can you paste here your clientinfo.xml

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  25
  • Topics Per Day:  0.01
  • Content Count:  830
  • Reputation:   316
  • Joined:  02/11/19
  • Last Seen:  

On 3/24/2023 at 9:10 PM, mrgeiszer said:

I've run everything smooth both emulator and client side except getting the "closed connection error" please help, below the screen shot thanks in advance

image.thumb.png.4e848cd1cf3be9d97b06e7af0affc5cc.png

maybe you need this:

Capturadepantalla2023-09-02190946.png.aca9ea93cd1bca37de1ca80187b00a3e.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  21
  • Topics Per Day:  0.02
  • Content Count:  112
  • Reputation:   0
  • Joined:  09/02/20
  • Last Seen:  

hallo, i was download lateset rathena today
also download kro RAG_SETUP_220706.exe

for rathena connect usingMySql Workbrench tutorial Here
everything fine nothing happen until i got like this pic..

sclientinfo.xml
 

Spoiler

<?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>
              <version>55</version>
              <langtype>1</langtype>
        <registrationweb>www.ragnarok.com</registrationweb>
        <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>


if you guys know something please tell me,,,thanks a lot

123.jpg

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  54
  • Topics Per Day:  0.01
  • Content Count:  1167
  • Reputation:   159
  • Joined:  06/12/12
  • Last Seen:  

11 hours ago, ManokStreZ said:

hallo, i was download lateset rathena today
also download kro RAG_SETUP_220706.exe

for rathena connect usingMySql Workbrench tutorial Here
everything fine nothing happen until i got like this pic..

sclientinfo.xml
 

  Reveal hidden contents

<?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>
              <version>55</version>
              <langtype>1</langtype>
        <registrationweb>www.ragnarok.com</registrationweb>
        <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>


if you guys know something please tell me,,,thanks a lot

123.jpg

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...