[Guide]Setting up a Eathena Sql Server

[buddy1986]

This guides target users:
eAthena: svn 48xx and up
Os: Windows XP/98

I'm doing this guide in light that a lot of the sql guides on these forums are out of date, don’t work too well, or leave out on explaining things. So imma do my best to explain everything fully.

What this guide will include:

A: Pre-installation things to do and other info
1. Differances between a SQL Server and a TXT Server
2. Download eAthena
3. Download MySQL
4. Download MySQL Admin
5. Download MySQL Query Browser
6. Getting all the information you will need
B: Setting up eAthena
1. What files you will need to locate for editing
2. Editing char_athena
3. Editing login_athena
4. Editing map_athena
5. Editing lan_support
6. Editing Sclientinfo.xml
C: Installing and Setting up MySQL
D: Installing MySQL Administrator & MySQL Query Browser
E: Setting up MySQL Admin
F: Setting up MySQL Query Browser
G: Post-setup things to do
1. Setting up No-ip (optional)
2. Diffing a Client
3. Getting GRF Factory
4. Getting a Data Folder
H: MySql server modifications and customizations
1. Enabling Mob Databses, Item Databases, and Mail Database
2. Changing the Ragnarok Database to another name
3. Make fields accept larger numbers
I: Trouble Shooting
J: Guide Version

A. Pre-installation things to do

1. The Differeances between a SQL Server and a TXT Server:

I decided to add this since i have been getting lots of pms about simple things that are different in SQL then in TXT lol. So here we go.

So, you wanna know what the differance is? Well there really isnt too much different from a txt server and a SQL server. The main differeance is that SQL makes it eaiser to edit. Sql also only uses only the account and guild aspects, in other words, it only deals with guilds, login names and passwords, charecters, and ip bans. This also means that you will make your GM's through MySQL Query Browser. See the level coloum in there, well you put your gm's level in there. Also, but im not sure how to make eathna do it, your athena server can read the mob and item data base from SQL, please dont send me any pms asking how to, cuz i really dont know lol. And thats where the differeances stop im afraid, except for the ease of backing up your databases. (see Section I for more SQL customizations).

2. Download eAthena

Where to download eAthena SQL:
You may locate the newest versions of eAthena in here:

You must be registered to see links

You will also need to download the .dll files (can be located on the same page as the svn download).

3. Download MySQL
4. Download MySQL Administrator
5. Download MySQL Query Browser

Now, in these next screen shots, anywhere that is circled is where you can click to take you to the next area which is displayed in the next screen shot.

first go to mysql.com then follow these:

See the other stuff I have circled? Well you will need to download those also

Ok, make sure that you download these 3 programs into a folder for easy finding (the MySQL setup is called Setup...pretty vague huh?

)

now, go back a few pages to where i had the query browser, and admin circled and download those.


6. Getting all the information that you will need

Now, open your web browser of choice (fire fox for me lol) and type whatsmyip.net in the address bar. You should get a page that looks like this:

now, where ever I have circled lists your Wan IP, write that down somewhere, you will need it later.

Ok, now open your start menu and click on run and type in cmd (type in command if your using windows 98) and the command line interface (CLI) should come up. If it doesn’t, see Section H for troubleshooting. Now, in the CLI type ipconfig/all. something looking like this should appear:

again, in the places I have circled, write down those address' and be sure to lable what they all are.


B. Setting up eAthena

1. What files you will need to locate for editing

Now, once you have eAthena on your computer, and all the proper information you will need to go into the folder named conf and locate and open these txt files:
char_athena
login_athena (optional) (if your using version 48xx (i think) or higher then you wont need to open this)
map_athena
lan_support

change anything thats in bold

2. Editing char_athena

Ok, now bring char_athena to the front.
before we continue, please make these corrections in your own txt file, do not copy paste.


QUOTE
// Athena Character configuration file.

// Server Communication username and password.
userid: s1 change this to ragnarok
passwd: p1 change this to ragnarok

// Server name, use alternative character such as ASCII 160 for spaces.
server_name: eAthena change to your server name

// 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: Lan IP

// 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 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: Wan IP or No-ip (see end of guide for information on getting a no-ip account)

// Character Server Port
char_port: 6121

and save then close

3. Editing login_athena

Bring your login_athena to the front now:

QUOTE
// Athena Login Server configuration file.
// Translated by Peter Kieser <pfak@telus.net>

login_ip: Wan IP or No-ip

// The login 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

again, save and close

4. Editing map_athena

Bring map_athena to the front:

QUOTE
//--------------------------------------------------------------
// Configuration Info
//--------------------------------------------------------------
// Interserver communication passwords, 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: Lan 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: Wan IP or No-ip

// Map Server Port
map_port: 5121

save and close

5. Editing Subnet_Athena

Now, last is Subnet_Athena:

QUOTE
// Subnet support file
// Format is:
// subnet: subnet-subnet mask:char_ip:map_ip
// you can add more than one that line

subnet: put the address you have written down as your Default Gateway: here-put what you have written down as your Subnet Mask: here:Lan IP:Lan IP

save and close

6. Editing the Sclientinfo.xml

Now, download this (it goes into your grf or data folder)

You must be registered to see links

once you have it downloaded refer to this to set it up:

right click on it and select edit from that menu then again change anything that’s in bold


QUOTE
<?xml version="1.0" encoding="euc-kr" ?>

<clientinfo>

<desc>Ragnarok Client Information - Taiwan Version</desc>

<servicetype>korea</servicetype>
<servertype>sakray</servertype>

<connection>
<display>put the name of your server here</display>
<desc></desc>
<address>*~!~see note 1~!~*</address>
<port>6900</port>
<version>20</version>
<langtype>07</langtype>
<registrationweb>Athena</registrationweb>
<aid>
<admin>you can put the account Id's of your GMs here<admin>
</aid>
</connection>
</clientinfo>

Note 1: In the one that you are using put your Lan IP but in the one you give to your other players put your Wan IP or No-ip here.

whew, that’s a lot of typing lol, and were only half done!!!!!!

alright, take a break or a breather then we will go into the next stage...installing My
SQL and its assistant programs.

This is the end of part one.

 

[Uzieal]

wow im amazed nobody replied to this, very excellent guide, wish you would have finished it but awesome work anyway