Creating a Ragnarok eAthena Server with SQL

Guide Version : 12068
Guide Updated on 21 August 2009

Futures:
F.A.Q *added*
Picture(if needed)*added*
More details
Setup Website/ROCP *added*
Port Forward *added*
Add Customs Script to your server
Setup Register page *added*
Fully Setup
...

Guide Include -
- Requirement
- A - Setup Server file
- B - Setup MySQL
- C - Setup Databse
- D - Setup Client
- E - Launch Server
- F - Port Forward
- G - Installing WebServer
- H - Setup ROCP
- I - Picture
- J - How to connect to your own server
- F.A.Q - Frequently Asked Questions


Requirement's to begin your Server :

*MySQL 5.0.83 Download : HERE
*MySQL GUI Tools 5.0 Download : HERE
For other O.S please choose your correct platform : HERE
*Latest eAthena server files Download : HERE (13933 Stable/SQL)
*Hexed(XRay client) client Download : HERE
*Full Datav3 Download : HERE
*Ragnarok & Sakray latest Download : HERE
ROCP 4.3.4a Download : HERE
ROCP 4.3.4a and Apache user are highly recommended to apply this patch : HERE
Abyss Web Server Download : HERE

php-5.2.5-Win32.zip | Download : HERE
Winrar(If you dun have it) Download : HERE
GM commands(if you need) Download : Attachment 45308
Option Files:*Map Server SQL[PACKETVER 9] Download : HERE (ver. 13933)
*kROsakexe0528aN[PACKETVER 9] Download : HERE

* = Files require to run the server



A)Setup server file
1. We are going to setup the server files aka conf file.
Create a folder Name it what you want but dun create at desktop, then extract it to you file.
2. Go to server file open(with WordPad) conf > char_athena.conf then edit the;


Code:
// Athena Character configuration file.
 
// Note: "Comments" are all text on the right side of a double slash "//"
// Whatever text is commented will not be parsed by the servers, and serves
// only as information/reference.
 
// Server Communication username and password.
userid: s1 < Change to ragnarok
passwd: p1 < Change to ragnarok
 
// Server name, use alternative character such as ASCII 160 for spaces.
// NOTE: You should not use spaces in the server name, or guild emblems won't work client-side!
server_name: <Put your Server name HERE)
 
// Wisp name for server: used to send wisp from server to players (between 4 to 23 characters)
wisp_server_name: Server
 
// 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 < Edit to Local IP/Computer IP(192.168.1.103 something), and remove the front(//)
 
// 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 < Leave it be(dun touch this)
 
// Login Server Port
login_port: 6900
 
// Character Server IP
// The character server exports this IP address to the entire world.
// NOTE: You should only need to set this if you are running behind a
// firewall or are on a machine with multiple interfaces.
// char_ip: 192.168.1.103 < Edit to Local IP or WAN IP and remove the front(//)
 
// Character Server Port
char_port: 6121


3. Open map_athena now we are going to edit,
//--------------------------------------------------------------
//            Configuration Info            
//--------------------------------------------------------------
// Interserver communication pass*****, set in account.txt (or equiv.)
userid: s1 < Change to ragnarok
passwd: p1 < Change to ragnarok
 
// 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 < Edit to your Local IP/Computer IP
 
// 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 map server exports this IP address to the entire world.
// NOTE: You should only need to set this if you are running behind a
// firewall or are on a machine with multiple interfaces.
map_ip: 127.0.0.1< Edit to your Local IP or WAN IP
 
// Map Server Port
map_port: 5121



4. Open your grf-files file and ready to edit it,

//-----------------------------------------
// GRF List
//-----------------------------------------
 
grf: C:\Program Files\Gravity\RO\ < Edit to, where your RO files located
grf: C:\Program Files\Gravity\RO\ < Edit to, where your RO files is located
 
// You may add more in this format
// grf: <data file path>
 
//------ Others ---------------------------
 
//Path to directory that contains the data dir 
//NOTE: Path must include trailing backslash, only one data_dir entry is supported.
//data_dir: C:\Program Files\Gravity\RO\ 



Save and close.

5. Open Subnet_athena, we are going to edit it,

// Subnet support file
// Format is:
// subnet: net-submask:char_ip:map_ip
// you can add more than one subnet 
 
subnet: 255.0.0.0 > edit to your own subnet address: 127.0.0.1 > Change to your LAN IP:127.0.0.1 > Change to your LAN IP


NOTICE!
[NOTICE]Remember to take off the "//" before the specific line in your .conf files so it would look like this
 BEFORE:
 //char_ip: 127.0.0.1
 
 AFTER:
 char_ip: 127.0.0.1



B) Well done, now we are going to setup MySQL and MySQL GUI Tools,

1. Install MySQL 5.0.27
2. Click Next.
3. Choose Typical and click Next.
4. Click Install
5. Choose Skip Sign-Up and click Next
6. When It's finished, just click Finish and don't uncheck the Configure the MySQL Server now.
7. Now, you can either choose Detailed Configuration or Standard Configuration, which is up to you but if you are unsure, just choose Standard Configuration and click Next
8. In Service Name, pick MySQL5 or MySQL and click Next
9. Just enter the password you wish for root and it's important to remember cause we need it later. Click Next
10. Just click the Execute and when done, just click Finish.
11. Now we need to install MySQL GUI Tools 5.0, double click on it then install.
12. Start MySQL Administrator(Or you can find that on here, Start > All program > MySQL > MySQL Administrator) and it will prompt up a window. Fill in Host Name, Username and Password and leave other field as it is but to make sure everything is correct, it should look like this;




Code:
Stored Connection: (leave it empty)
 Server Host: localhost
 Username   : root
 Password    : (Enter the password we created before for root) 
 Port             :3306


13. then Click OK and you should be in MySQL Administrator now, and go to User Administration and Click New Userand enter this;

Code:
MySQL User         : ragnarok
Password             : ragnarok
Confirm Password: ragnarok



13. Just click Apply changes and exit MySQL Administrator, now you are done for that steps.

CSetting Database(DB)
1. Start MySQL Query Browser and it will prompt up a window that look like MySQL Administrator except there is a new field call Default Scheme. It should look like this;






No comments:

Post a Comment