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:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   2
  • Joined:  08/30/18
  • Last Seen:  

56 minutes ago, Earnestinence said:

@Steinhart Hi, Make sure you create User with the username and password 'ragnarok' and in your sql db

Feel free you contact me at disocrd: @sexual Thought#5337

Coul you please tell which part i messed up every detail in your guide i followed, more patience Please tia

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.00
  • Content Count:  152
  • Reputation:   77
  • Joined:  06/13/15
  • Last Seen:  

12 hours ago, Steinhart said:

Coul you please tell which part i messed up every detail in your guide i followed, more patience Please tia

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

Also check this: 

 

  • 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 ) 
Edited by Earnestinence
Link to comment
Share on other sites

  • 0

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

Hey guys I'm still a beginner and I need someone to help me step by step on creating my own test offline/lan server ragnarok 255/120. Thank you in advance. 

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:  

On 9/6/2018 at 1:21 AM, Steinhart said:

i followed everything but this is the outcomeimage.thumb.png.349e168bb85d075396296b943226b2c6.png

kindly help me tia 

I think your problem at conf\inter_athena.conf

// MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: ragnarok
login_server_db: ragnarok
login_codepage:
login_case_sensitive: no

ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: ragnarok
ipban_db_pw: ragnarok
ipban_db_db: ragnarok
ipban_codepage:

// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: ragnarok

// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: ragnarok

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

 

Are you already set Your sql ID and password in this part?

Edited by hendra814
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   2
  • Joined:  08/30/18
  • Last Seen:  

12 minutes ago, hendra814 said:

I think your problem at conf\inter_athena.conf


// MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: ragnarok
login_server_db: ragnarok
login_codepage:
login_case_sensitive: no

ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: ragnarok
ipban_db_pw: ragnarok
ipban_db_db: ragnarok
ipban_codepage:

// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: ragnarok

// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: ragnarok

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

 

Are you already set Your sql ID and password in this part?

im already done with that thank you!

 

my problem now is the second part of the video, i followed the guide but my client doesnt open at all.

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:  

10 minutes ago, Steinhart said:

im already done with that thank you!

 

my problem now is the second part of the video, i followed the guide but my client doesnt open at all.

What nemo option do you pick and what client version do you use?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   2
  • Joined:  08/30/18
  • Last Seen:  

4 minutes ago, hendra814 said:

What nemo option do you pick and what client version do you use?

image.thumb.png.0f6d7737bb955dd663e996dd99f4a580.png

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:  

7 minutes ago, Steinhart said:

image.thumb.png.0f6d7737bb955dd663e996dd99f4a580.png

Here try patch with nemo using this option

Spoiler
Quote

2 Chat Flood Allow
8 Custom Window Title
9 Disable 1rag1 type parameters (Recommended)
13 Disable Ragexe Filename Check (Recommended)
19 Enable Title Bar Menu
20 Extend Chat Box
21 Extend Chat Room Box
22 Extend PM Box
24 Fix Camera Angles (Recommended)
28 Increase Headgear ViewID
29 Disable Game Guard (Recommended)
33 Always Call SelectKoreaClientInfo() (Recommended)
34 Enable /showname (Recommended)
35 Read Data Folder First
36 Read msgstringtable.txt (Recommended)
37 Read questid2display.txt (Recommended)
38 Remove Gravity Ads (Recommended)
39 Remove Gravity Logo (Recommended)
40 Restore Login Window (Recommended)
41 Disable Nagle Algorithm (Recommended)
43 Always Use Email for Char Deletion
44 Translate Client (Recommended)
46 Use Normal Guild Brackets (Recommended)
47 Use Ragnarok Icon
48 Use Plain Text Descriptions (Recommended)
49 Enable Multiple GRFs (Recommended)
51 Always Show License Screen
53 Use Ascii on All LangTypes (Recommended)
61 Disable Packet Encryption
64 @ Bug Fix (Recommended)
65 Load Custom lua file instead of iteminfo*.lub (Recommended)
68 Enable 64k Hairstyle
71 Ignore Resource Errors
72 Ignore Missing Palette Error
73 Remove Hourly Announce (Recommended)
76 Enforce Official Login Background
84 Remove Serial Display (Recommended)
85 Show Cancel To Service Select
86 Only First Login Background
88 Allow space in guild name
90 Enable DNS Support (Recommended)
91 Disconnect to Login Window
97 Cancel to Login Window (Recommended)
104 Increase Hair Style & Color Limits
201 Enable Custom Homunculus
204 Increase Attack Display
207 Resize Font
212 Restore Roulette
213 Disable Help Message on Login (Recommended)
222 Show Replay Button
225 Show Register Button
234 Ignore Lua Errors
 

 

 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   2
  • Joined:  08/30/18
  • Last Seen:  

25 minutes ago, hendra814 said:

Here try patch with nemo using this option

  Reveal hidden contents

 

 

i tried again but client doesnt appear, maybe you could do team viewer with me?

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:  

8 minutes ago, Steinhart said:

i tried again but client doesnt appear, maybe you could do team viewer with me?

sorry i'm at office now, but are you already put the patched file in KRO folder

because without KRO client this ragexe client can't be open.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   2
  • Joined:  08/30/18
  • Last Seen:  

3 minutes ago, hendra814 said:

sorry i'm at office now, but are you already put the patched file in KRO folder

because without KRO client this ragexe client can't be open.

game is not appearing when i double click the ragexe and rsu is already patch

image.thumb.png.f2862b6be3878daadfdf66e0bb71467c.pngi cli

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.01
  • Content Count:  45
  • Reputation:   0
  • Joined:  08/27/18
  • Last Seen:  

whats wrong?

1.png

Link to comment
Share on other sites

  • 0

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

Very good tutorial however at Step 5, my server is refusing to run, it gives me this error

 

-----mapserv.bat-----

[SQL]: Unknown database 'ragnarok'
[Error]: Couln't connect with uname='ragnarok',passwd='ragnarok',host='127.0.0.1

 

 

-----charserv.bat----

[Status]connecting to 127.0.0.1:6900

[Error]connection failed socket #2, timeout after 10s

 

I've triple checked that my .txt file and my conf file has the same value to connect to the server and SQL server, but I'm out of ideas now haha

Edited by AprilFungus
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  3
  • Reputation:   0
  • Joined:  12/05/12
  • Last Seen:  

On 10/5/2018 at 9:08 AM, AprilFungus said:

Very good tutorial however at Step 5, my server is refusing to run, it gives me this error

 

-----mapserv.bat-----


[SQL]: Unknown database 'ragnarok'
[Error]: Couln't connect with uname='ragnarok',passwd='ragnarok',host='127.0.0.1

 

 

-----charserv.bat----

[Status]connecting to 127.0.0.1:6900

[Error]connection failed socket #2, timeout after 10s

 

I've triple checked that my .txt file and my conf file has the same value to connect to the server and SQL server, but I'm out of ideas now haha

change you'r conf/import-tmpl/char_conf text to
userid: s1    
passwd: p1
login_ip: 127.0.0.1
char_ip: 127.0.0.1
NB: dont change you'r first id username and pass keep it with s1 and p1 and dont change the id number, the default id in your sql is 1 in the tutorial video when you make a clientinfo.xml is 2000001
i hope this can help you and try to run your server

 

anyone can help me?
my server is working fine but my client side setup show the error like this
what's iam missing thanks
 

Capture.PNG

Edited by HybirdMoon
Try for help
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.00
  • Content Count:  152
  • Reputation:   77
  • Joined:  06/13/15
  • Last Seen:  

On 10/7/2018 at 5:49 PM, HybirdMoon said:

anyone can help me?
my server is working fine but my client side setup show the error like this
what's iam missing thanks
 

Capture.PNG

Use a fresh english translated fils from zack or asheraf

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  10/31/14
  • Last Seen:  

I think I messed up somewhere, it doesn't find a file that's right there and cannot read another one.
Why? ;_;

image.thumb.png.b46b5420e63420ea9ef0ccc4322222de.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.00
  • Content Count:  152
  • Reputation:   77
  • Joined:  06/13/15
  • Last Seen:  

12 hours ago, Deanari said:

I think I messed up somewhere, it doesn't find a file that's right there and cannot read another one.
Why? ;_;

image.thumb.png.b46b5420e63420ea9ef0ccc4322222de.png

Try and configure these :
 

conf/char_athena.conf

conf/map_athena.conf

conf/inter_athena.conf

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   1
  • Joined:  10/19/18
  • Last Seen:  

Hi, sorry to ask..
but what is my id & password?
I manage to make the server run and also the client.
is my id and pswd the one that i create when i edit clientinfo.xml?
<admin>2000000</admin>. is this the one? bcuz i keep on read the post over and over again.
i cant find it.. thank you.

[EDIT] owh, i didnt check the all video. i found it alreday.
-----------------------------------------------------------------------------------

 

Edited by JohnKim
solved old problem and now new problem.
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   1
  • Joined:  10/19/18
  • Last Seen:  

Now i got " Closed connection from "127.0.0.1"..
I already double check everything..

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  4
  • Reputation:   0
  • Joined:  10/17/18
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  6
  • Reputation:   1
  • Joined:  10/24/18
  • Last Seen:  

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.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   1
  • Joined:  10/19/18
  • Last Seen:  

1 hour ago, 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.

did u manage to go thru the login part? im still stuck at "close connection 127.0.0.1"

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  6
  • Reputation:   1
  • Joined:  10/24/18
  • Last Seen:  

8 hours ago, JohnKim said:

did u manage to go thru the login part? im still stuck at "close connection 127.0.0.1"

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.

Edited by d3athrave
found a solution
  • Upvote 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   1
  • Joined:  10/19/18
  • Last Seen:  

owh.. thanks alot.. i solve my problem with your suggestion.

@d3athrave

Edited by JohnKim
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  5
  • Reputation:   1
  • Joined:  10/25/18
  • Last Seen:  

how to choose renewal or pre renewal?

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...