[Guide]How to setup a Ragnarok Online(Server Side Only)

[Diconfrost VaNz]

Download these files first:

MySQL Gui Tools

MySQL Essentials

Download Compiled SVN here(I suggest to use trunk)

 

or use TorquiseSVN to download rAthena SVN in its Repository

 

and use Visual Studio for recompiling.

When you're done downloading those files, follow these steps:

==========// SVN Files Setup //==========

1) Goto your downloaded svn and extract it.

2) Goto conf folder and look for char_athena.txt, inter_athena.txt, map_athena.txt and subnet_athena.txt

3) Open char_athena.txt, and map_athena.txt and look for this:
 

// Server Communication username and password.
userid: s1
passwd: p1

and change that into
 

// Server Communication username and password.
userid: ragnarok
passwd: ragnarok

2) Open your char_athena.txt again and look for this:
 

// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
//login_ip: 127.0.0.1

// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Login Server Port
login_port: 6900

// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
//char_ip: 127.0.0.1

remove the "//" in login_ip and char_ip. It will look like this:
 

// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
login_ip: 127.0.0.1

// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1


// Login Server Port
login_port: 6900

// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
char_ip: 127.0.0.1

3) Open your inter_athena.txt and look for this:
 

// Global SQL settings
// overriden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: ragnarok
sql.db_password: ragnarok
sql.db_database: ragnarok
sql.codepage:

// MySQL Character SQL 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 SQL 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 SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: log
log_codepage:

if you're using my guide that is a given and you don't need to edit them. But if you're planning to change any of here like the user password or what, you need to change this too.

4) Open your map_athena.txt and look for this:

 

// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
//char_ip: 127.0.0.1


// The map server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Character Server Port
char_port: 6121


// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
//map_ip: 127.0.0.1

// Map Server Port
map_port: 5121

remove "//" in char_ip, and map_ip, it will look like this:
 

// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
char_ip: 127.0.0.1
// The map server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1
// Character Server Port
char_port: 6121
// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
map_ip: 127.0.0.1
// Map Server Port
map_port: 5121

5) Open you subnet_athena.txt and you'll see this:
 

subnet: 255.0.0.0:127.0.0.1:127.0.0.1

If you changed the ips in char_athena.txt, inter_athena.txt and map_athena.txt, you should consider to put them here too.

for example, the ip is 125.60.252.169

subnet: 255.0.0.0:125.60.252.169:125.60.252.169

==========// MySQL Setup //==========

1) Install MySQL Gui Tools

2) Install MySQL Essentials. Choose MySQL 501. Enter "ragnarok" for the password for "root"(remember you can change this later on, this is just a basic one). Just click the Execute and when done, just click Finish. Go to Task Manager and check if mysqld-nt.exe is running in processes although it's not necessary if no error occured during installation.

3) Start MySQL Query nd it will prompt up a window. Fill in
 

Stored Connection: (leave it blank)
Server Host: localhost Port: 3306
Username: root
Password: (remember the password you made when you're installing MySQL Essentials?put it here)
Default Schema: ragnarok(you can change this afterwards, this is just a basic name)

and leave other field as it is but to make sure everything is correct. Then press enter.

4) *When you are in MySQL Query Browser, click once on ragnarok database that is below Schemata.
*Go to menu, click File and choose Open Script...
*We need to execute main.sql, mail.sql and log.sql (execute upgrade_svn* .sql files, too, if require) so, look for the main.sql, which should be in sql-files folder in eAthena Server and other .sql files.
*Pick main.sql and click Open.
*Click the Green Execute Icon to the upper right to execute. Do the same with mail.sql now and execute it.
*When you are done, we need to create log database by right-click somewhere within the table where the databases are and choose Create New Schema and type in log and click OK.
*Double-click on log database, go to menu, click File, choose Open Script..., open logs.sql and Execute.
*Double click ragnarok database to expand to see all tables.
*Look for login table and double click and double click again.
*Click once on Edit so, we can edit the cells. This icon should be in bottom.
*For userid: and user_pass:, type in the name that you used in char_athena.conf and map_athena.conf.
*When you are done editing, just click the Apply Changes that is next to the Edit icon.

5) Goto MySQL Administrator. Login there.
 

Stored Connection: (leave it blank)
Server Host: localhost Port: 3306
Username: root
Password: (remember the password you made when you're installing MySQL Essentials?put it here)

Then Enter.

6) And you're inside the MySQL Administrator now. Go to User Administration and Click New User and enter this:
 

MySQL User: ragnarok
Password: ragnarok
Confirm Password: ragnarok

then click "Apply Changes".

After that, Click the ragnarok user and goto schema priviledges(right-side of user information). Click ragnarok and log database and click "<<", then click "Apply Changes"

And we're done

Edited November 14, 2014 by Diconfrost VaNz

[vBrenth]

But i prefer to make a Advance Guide like how they will set up the server starting from downloading the SVN using tortoise, recompiling, setting up, installing mySQS and more.

And much better if you provide a screenshot with it.

But good job for a nice guide.

[papol22]

ano pong trunnk ang mgandang gmitin?

[noobjaw]

sna po mga guides with pictures po pra madali lng po sa mga basic newbie po...lalo na po sa MySQL...

Edited December 15, 2011 by noobjaw

[breadpanz]

Kuya Pa Mirror naman ng Mysql Hindi ako MakaDl Sa MediaFire Salamat.

[Diconfrost VaNz]

@papol22 = ung latest

@noobjaw = try ko

@breadpanz = try mong isearch sa google meron dun

[Drakkus]

// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
//login_ip: 127.0.0.1
// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1
// Login Server Port
login_port: 6900
// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
//char_ip: 127.0.0.1

The guide is very nice and simply basic, just few suggestion. why don't you tell everybody or clarify the Information.

About this.

You can either use 'HAMACHI' or 'No-IP.org' somehow there are using 'Router' that can't be using in Dynamic I.P which players could not Connect. you must specify the guide, if they want to be ONLINE the Server or OFFLINE.

And the 'SAFE' way to include the Information.

Better to use this 'GUIDE' for full information.

Links ---> http://www.eathena.w...howtopic=228231

Guide for 'No.IP.org'

Links ---> http://www.eathena.w...ndpost&p=782543

Guide for 'HAMACHI'

Links ----> http://www.eathena.ws/board/index.php?showtopic=114681

Just prefer the given links for more information.

No OFFENSE on this topic, i just wanted to help to make it more 'SPECIFY' the all information.

So that some newbies are always Asking what is the Problem specially in the 'SERVER SIDE' and 'CLIENT SIDE'

Thank you!

Regards,

Mindless

Edited December 28, 2011 by Mindless

[Diconfrost VaNz]

using hamachi is not advisable so don't include that xD it's hackable(SO EASY AND UNPROFESSIONAL TO USE) xD

and using guides is usually for basic purposes LOL

[Drakkus]

using hamachi is not advisable so don't include that xD it's hackable(SO EASY AND UNPROFESSIONAL TO USE) xD

and using guides is usually for basic purposes LOL

I know, using 'Hamachi' is not safe easily to 'HACK' i'm just including it for some Information though it's not necessary.(For Newbies)

Some of your Guide is coming From 'eAthena'

So there is no need to be 'OFFENSE' on this, i'm just giving you some 'HINTS' might help to Others.

Understand?

Regards,

Mindless

[Diconfrost VaNz]

what can it help when it's not secured -.-

and you say some of it from eathena?lets say i just learned from it and apply it on to myself?or you can say it was more precise than the other?or i more recommend some of it

you're not helping you know that's what i want to say

[Drakkus]

what can it help when it's not secured -.-

and you say some of it from eathena?lets say i just learned from it and apply it on to myself?or you can say it was more precise than the other?or i more recommend some of it

you're not helping you know that's what i want to say

Awful, you look so 'DEFENSIVE' in your TOPIC. means, you can't accept my HELP though i just give you some HINTS, to much argument for 'PINOY' they don't want to accept it.

Okay, I'll STOP this one, looking forward for your 'GUIDES' your Lucky i can't get em all the INFORMATION for the 'eA Emulator' since i'm out of eAthena a couple of years maybe 4Years from now.

Regards,

Mindless

[Diconfrost VaNz]

no comment on that one

if you just want to help then just help them as far as it is secured that's what i'm saying.

[Alphochio]

no comment on that one

if you just want to help then just help them as far as it is secured that's what i'm saying.

I totally agree.. I registered in eAthena last February and so far what I observed in eAthena even here in rAthena the process of assisting/helping the new comers/newbies is totally slow took me days to get some replies, "regarding this and regarding that etc."

excluding the time and effort of applying what people instruct you to do and the process of having the solutions if you got any errors.

well for this guide I find it effective, it reach its goal... compared on reading the rAthena guide for some instances maybe..

But I do hope that there would be someone if it's not done yet..

someone who is EXPERT enough having the authority to do a "Video Tutorial" on what rAthena Wiki talks about.

P.S - Dont we have a chat box on this site so that people can communicate fast and efficient?

[NANORAY]

pwede ko po ba gamitin ung trunk ng rathena gamit ang guide nyu po?

[noobjaw]

hindi ko lang po magets eto...wala po ung mail.sql ang gamit ko po eto 3CeAM-SQL-660[Trunk] wala po sya mail.sql

*We need to execute main.sql, mail.sql and log.sql (execute upgrade_svn* .sql files, too, if require) so, look for the main.sql, which should be in sql-files folder in eAthena Server and other .sql files.

*Pick main.sql and click Open.

*Click the Green Execute Icon to the upper right to execute. Do the same with mail.sql now and execute it.

*When you are done, we need to create log database by right-click somewhere within the table where the databases are and choose Create New Schema and type in log and click OK.

*Double-click on log database, go to menu, click File, choose Open Script..., open logs.sql and Execute.

*Double click ragnarok database to expand to see all tables.

*Look for login table and double click and double click again.

*Click once on Edit so, we can edit the cells. This icon should be in bottom.

*For userid: and user_pass:, type in the name that you used in char_athena.conf and map_athena.conf.

*When you are done editing, just click the Apply Changes that is next to the Edit icon.

paki post naman po kung ano exactly ggawin mga bossing... salamat po!

Edited March 15, 2012 by noobjaw

[taken]

tapos ko napo lahat ng nasa guiide.

Q> pano napo marun yung ragnarok?

Edited March 16, 2012 by taken

[noobjaw]

follow questions please...

[Diconfrost VaNz]

Sorry for inactivity. As of now, i'm currently working as a accountant/programmer in a company. Thanks for the consideration.

P.S. Just post your questions here and i'll try to answer them.

[MisUah]

lol i hope someone will make a latest guide

[Diconfrost VaNz]

hope so

[vBrenth]

Still very useful.. always visiting this... pag nid ko ung download link XP

[Diconfrost VaNz]

LOL xD

[MisUah]

anung version n ng MySQL ang gnagamit nyo n??

[Diconfrost VaNz]

ung ganyan prn ang gamit ko

pero my latest na ee

google mo

[xtianresente]

meron po bang full guide for congifuring my athena using hamachi?

dun sa map_athena.conf and char_athena after palitan ung mga ip with my Hamachi IP meron pa po ba ibang gagawin?

thank you

Edited August 12, 2012 by xtianresente