Creating eathena SQL server Linux with PuTTY and WinSCP

How Create SQL server Linux with PuTTY and WinSCP

Equipment before starting:
- PuTTY CLICK HERE
- WinSCP CLICK HERE
VPS Cpanel + (Cpanel11/kloxo/Cpanel other) at least 256MB ram
eAthena Compiled for Linux
Enterprise VPS CentOS 5

Let's Start:

1.Baca-read the first Linux Commands 1.Baca-read the first Linux Commands

2. 2. Run PuTTY
- Enter your VPS IP to Host Name box (or IP address) - Enter your VPS IP to Host Name box (or IP address)



3. 3. Enter your username and password (provided through E-Mail from providers VPS) Enter your username and password (provided through E-Mail Providers from VPS)

- Set up password on the server - Set up your password on the server

- Ketikkan passwd - passwd Ketikkan

- Enter new password and you will be asked to repeat - Enter new password and you will be asked to repeat

- Password change was successful in - Password change was successful in

4. 4. settings file in the conf folder settings file in the folder conf
- Inter_athena.conf - Inter_athena.conf

- Char_athena.conf - Char_athena.conf

- Map_athena.conf - Map_athena.conf

- Ladmin_athena.conf - Ladmin_athena.conf

and the server rate and the drop rate (all ready to finish first) and the server rate and the drop rate (all ready to finish first)

5. 5. eAthena folder compress compress folder eAthena
- EAthena compress the ZIP into the edit - the edit EAthena compress in a ZIP


6. 6. Use WinSCP
- Move your eAthena linux.zip to your VPS with drag and drop
from your computer to the VPS from your computer to the VPS

-Select copy

- Wait until complete


7. 7. how to extract the extract with
- Unzip (file name extension must use an example: eathena.zip)

- Use Zip to extract more easily

- Way into the directory - How to access directory
cd / root /

- When I know the folder where you can use it
dir


- Use
commands:
- Su-c "chmod-map server_sql"

- Su-c "chmod-char server_sql"

- Su-c "chmod-login server_sql"


8. 8. login to your Cpanel (which have earned VPS Cpanel)

- How: https: / / ipvpskamu: 7777 /

- Select MySQL database and create database with password


9. 9. Login to PhpMyAdmin

- User settings and create new privileges

- Create an account with the same ID and password from inter_athena.conf

All global privileges


10. 10. 6 import into MySQL database 6
- Into the ragnarok database and choose Import

- entered into a database that I gave six marks

- Select database ragnarok>> login

- Setting password with the password on the server map_athena and char_athena
- Press go
- The server you're done
- You have to run the server - You have to run the server
11. 11. Commands to run a server to run server Commands
/ root / stable / map-server_sql /
/ root / stable / char-server_sql /
/ root / stable / login-server_sql /
Explanation: Explanation:
/ = root directory into the root (the beginning of the directory)
/ stable = eathena my folder name (follow the appropriate folder name you eathena)
/ map = server_sql-run map-server (SQL)
/ char-run server_sql = char-server (SQL)
/ login-run server_sql = login-server (SQL)

but when you do not install the program screen, you disable the putty server = disable your eathena

let me teach teach SCREEN

12. 12. Programs screen
- Allows running eAthena ON and OFF putty
- Use the commands:
yum install screen

will appear like this:

[master @ localhost ~] $ screen
bash: screen: command not found
[master @ localhost ~] $ yum install screen
Loaded plugins: fastestmirror
You need to be root to perform this command.
[master @ localhost ~] $ su
Password:
[root @ localhost master] # yum install screen
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* Rpmforge: * apt.sw.be
* Base: mirror.nsc.liu.se
* Updates: mirror.nsc.liu.se
* Addons: centosy.centos.org
* Extras: * mirror.nsc.liu.se
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
There are remaining unfinished transactions.
Mightconsider you running yum-complete-transaction to finish them first.
-> Running transaction check ->
---> Package screen.i386 0:4.0.3-1. El5 set to be updated --->
-> Finished Dependency Resolution ->

Completed dependencies Dependencies Resolved

================================================== ============================== ==================== ============================== ==================== ==========
Package Arch Version Repository Size
================================================== ============================== ==================== ============================== ==================== ==========
Installing: Installing:
screen i386 4.0.3-1.el5 base 549 k

Transaction Summary
================================================== ============================== ==================== ============================== ==================== ==========
Install 1 Package (s)
Update 0 Package (s)
Remove 0 Package (s)

Total download size: 549 m
Is this ok [y / N]: y
Downloading Packages:
screen-4.0.3-1.el5.i386.rpm | 549 kB 00:05
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: screen [1 / 1]

Installed: screen.i386 0:4.0.3-1. El5
Complete!
[root @ localhost master] #


- Screen has terisntall to your VPS

13.Gunakan screen to run eAthena
- Use the screen and enter commands


- / Root / stable / char-server_sql and enter - /


- Then press the CTRL + A on your keyboard and press D -

Detach the server has to SCREEN
repeat on the map and log-server_sql-server_sql

and your server will run without putty ON ..

end of guide.

Source from:
ShadowPID
Posted in:
eathena

SETTING A PATCHER (TRIAD, THOR & NEONCUBE PATCHER)

TRIAD PATCHER

Click HERE to download Triad Patcher 1.3.0.3.
Click HERE to download Triad Patcher 1.3.
Click HERE to download Triad Patcher 1.2.

For installation guide:

CLICK ME



THOR PATCHER

Click HERE to download Thor Pacther

For installation guide:

CLICK ME



NEONCUBE PATCHER

Click HERE to download Neoncube Pacther


For installation guide:

CLICK ME

SETTING DATA,MAKING GRF & SCLIENTINFO

For sclientinfo:

CLICK ME

For LATEST DATA FOLDER:

CLICK ME

HOW TO MAKE RO INSTALLER

credit goes to alohadoubt on www.eathena.ws

-------------------------------------


First, Install the Installer for Install Creator. You may download it here www.clickteam.com
This example is for my client HeinRO, he requested me to create the installer
and I will show you how to create the installer.

1. Let say that your triad now is ready check image below


You will notice that all the necessary files for triad patcher I put
it into one folder name installer (just name it anything you want, I named it as
installer for me to easy remember it)


2. Now start the Install Creator at first time you must see the "Welcome to the Install Creator wizard.
the wizard will guide you through the process of creating an installation program for your files"

see image below


3. Click "Next" and browse the folder where all your necessary files for installer.
I'l show you mine, if you remember the folder installer that i told you
to create it. here it is

see image below




4. Click "Next" and choose your language and the name of your installer

see image below



you can also see what your installer look like simply by clicking the preview.

5. Click "Next" and choose the format your installer will show. if it is Small or fullscreen.
in my case my client want small view so I'l choose small.

see image


6. You can insert any images on your installer simply by browsing the image you want
image to left and image to the top.(just resize it so it will fit to your installer)
Okay now check mine

see image



left image


top image

Note: Make sure that the left and top image are bitmap.

7. The next step is to leave note's and Rules/agreements about your installer
so here's mine

see image




8. The next step is to locate which directory your installer will be installed
the previous step if you remember I wrote it on the note's which
should be C:\Program Files\Gravity\RagnarokOnline now check
the image below

see image


see image above and change it to

see image below



(preview)

9. and "Next" just browse the file you want to create an icon in the start menu

see image below



(and check the add desktop shortcut)

10. :chirol_pupu: On the next step is optional if you want to add aditional notes about
your sites,the installer, forum, last notes etc.. just save it as .txt format any name you want.

see this image below


and then browse the file that the installer will launch it after the installation
to patch your patcher. Check the image below





11. Click "Next" and make sure that the Uninstall program is check so,
the install creator will make an uninstall program.

see image below


12. All done just click the Finish and enter the name of your installer.




(all done just upload the file on your web host)

Sorry I can't post many images sample because of the limit that allowed to..
I hope it helps

SETTING CERES CONTROL PANEL

Please download this for:

Appserv 2.5.6
Ceres CP

Web Server download Here
Ceres Control Panel download Here

Lets get started by opening the install folder and installing Appserv.

To Install, Click Next, I Agree, Next. Now make sure MySQL Database and phpmyadmin is unchecked.

Then click next, For the server name put localhost. The Administrators Email Address should

be your email ie yubba@gmail.com , leave the default port. Then click next and uncheck mysql.

Now open your Query Browser, Run the script called "table.sql" in the script folder

and now to setup the files. Copy whats in the ceres folder, and go to your web server folder,

Then to the www folder, and delete phpinfo, index, and the appserv folder. Now paste the Ceres files in there.

Router Users Only

Now, lets go to your router page by finding your router ip. Now to find it go to Start, Run, Cmd, and type ipconfig. Now remove the two last digits and that should be the ip. Now forward the following port.

80

After that it should work.

End Router Users Only

Now to config it, do this by going into the install folder and opening the config file using a text editor such as wordpad or notepad.

Since all of its understandable ill help with the most needed ones.

Lets start by finding these lines:

//sql connections
$CONFIG['db_serv'] = 'localhost'; // SQL Host
$CONFIG['db_user'] = 'ragnarok'; // SQL User
$CONFIG['db_pass'] = 'ragnarok'; // SQL Password
$CONFIG['rag_db'] = 'ragnarok'; // SQL Ragnarok Database name
$CONFIG['cp_db'] = 'cp'; // SQL CP Database name
$CONFIG['md5_pass'] = '0'; // Use MD5 password (enable = 1, disable = 0)
$CONFIG['safe_pass'] = '1'; // Force the use of a safer password with size 6 and at least 2 letter and 2 numbers (enable = 1, disable = 0)

Now since we have the ragnarok user created we dont need to do much editing, but lets do change it to:

//sql connections
$CONFIG['db_serv'] = 'localhost'; // SQL Host
$CONFIG['db_user'] = 'ragnarok'; // SQL User
$CONFIG['db_pass'] = 'ragnarok'; // SQL Password
$CONFIG['rag_db'] = 'ragnarok'; // SQL Ragnarok Database name
$CONFIG['cp_db'] = 'ragnarok'; // SQL CP Database name
$CONFIG['md5_pass'] = '0'; // Use MD5 password (enable = 1, disable = 0)
$CONFIG['safe_pass'] = '1'; // Force the use of a safer password with size 6 and at least 2 letter and 2 numbers (enable = 1, disable = 0)


Now for the next couple of lines:
//map,char,login servers settings
$CONFIG['accip'] = '127.0.0.1'; // Account/Login Server IP
$CONFIG['accport'] = '6900'; // Account/Login Server Port
$CONFIG['charip'] = '127.0.0.1'; // Char Server IP
$CONFIG['charport'] = '6121'; // Char Server Port
$CONFIG['mapip'] = '127.0.0.1'; // Zone/Map Server IP
$CONFIG['mapport'] = '5121'; // Zone/Map Server Port

Change it to:
//map,char,login servers settings
$CONFIG['accip'] = 'Global IP'; // Account/Login Server IP
$CONFIG['accport'] = '6900'; // Account/Login Server Port
$CONFIG['charip'] = 'Global IP'; // Char Server IP
$CONFIG['charport'] = '6121'; // Char Server Port
$CONFIG['mapip'] = 'Global IP'; // Zone/Map Server IP
$CONFIG['mapport'] = '5121'; // Zone/Map Server Port

Remember find your global ip @ Whatismyip.com

Now this one isnt hard to figure out at all, but lets go over it:

//default language
$CONFIG['language'] = 'English'; // default language (remember to check if the translation exist before set)

This is only if you want to change the language, check in the language folder for the names. so like:

//default language
$CONFIG['language'] = 'Espanol'; // default language (remember to check if the translation exist before set)

Now that we're done with the needed ones you can go ahead and finsh editing the rest of the config. After your done copy it and overwrite the old one in the www folder.

Now to access the web, go to http://globalip . Find your global ip @ whatismyip.com

GUIDE FOR INSTALLING EATHENA SQL SERVER

Please download this for:

MySQL 5.0 Server
MySQL Tools
MySQL Bakups

Download Here

Lets get started by install MySQL 5.0. Select Complete. Skip Sign up.

Configure. Standard Configuration. Dont select include bin directory in windows path.

Enter your password, username is root by default, ill tell you how to change it later.

Also make sure to check the "Enable root access from remote machines". It should be sucessful.

Now Lets get started on setting up the tools.

When you get the choosing screen select custom. And Disable

All except Common Components, Admin, Query Browser, and thats it. Now that we're done

installing lets get started with the db. Connect threw the query browser,

Put ragnarok as the default schema. Then hit Yes.

Now we are going to run the SQL Scripts in the scripts folder, That you downloaded . Now lets do the Administrator.

Click on User Administrator, click on root, and go ahead and change the username.

Now lets make a new user by clicking the button that says "New User" at the buttom left corner

Now make the new user called ragnarok with the password ragnarok.

Now in schema privilages click on ragnarok and click the << button and hit apply.

In conf/char_athena.conf, conf/map_athena.conf, and conf/login_athena.conf do this,

Find:

//login_ip: 127.0.0.1
//bind_ip: 127.0.0.1
//char_ip:127.0.0.1

And remove the // from it to make it look like:

login_ip: Global_IP
bind_ip: Global_IP
char_ip:Global_IP

Find your global IP @ Whatisyourip.com .

Router Users Only

login_ip: Local_IP
bind_ip: Local_IP
char_ip:Local_IP

But if your a router user it should look like that. To find your Local IP, Go to Start-> Run-> Cmd -> Ipconfig, that is your local ip.

Now to forward ports. Do this by going to your router page. Look in ipconfig for the local ip and remove the two last digits and that should be your router ip. Now put it in a browser, and login. Then forward the following ports:

6900
5121
6121

End of Router Users Only

Now to config the conf/grf-files.txt, find:

grf: C:\Program Files\Gravity\RO\data.grf
grf: C:\Program Files\Gravity\RO\sdata.grf

and change it to where your grf files are located.

Now in conf/inter_athena.conf, find:

// MySQL Login SQL Server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: ragnarok
login_server_db: ragnarok

// 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: log

// MySQL Mail SQL Server
mail_server_ip: 127.0.0.1
mail_server_port: 3306
mail_server_id: ragnarok
mail_server_pw: ragnarok
mail_server_db: ragnarok

Change to:

// MySQL Login SQL Server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: ragnarok
login_server_db: ragnarok

// 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: ragnarok

// MySQL Mail SQL Server
mail_server_ip: 127.0.0.1
mail_server_port: 3306
mail_server_id: ragnarok
mail_server_pw: ragnarok
mail_server_db: ragnarok

Now, open Login-server-sql.bat, Map-server-sql.bat, and Char-server-sql.bat,

Or just runserver-sql.bat.

GUIDE FOR INSTALLING EATHENA SQL SERVER IN DEBIAN (Linux)

From RUNE WIKI

This guide assumes you have just purchased a Debian Server, so steps may be taken/ignored based on previous completion. This guide also assumes you are installing a SQL-based server.

Getting Started

First, you'll want to edit your sources to keep apt-get from trying to read your cdrom which won't do you any good but give errors. So, now you'll nano to the sources list by using.

nano /etc/apt/sources.list

Once you're inside, you'll want to comment out the cdrom

sources by making your list look as such.

#
# deb cdrom:[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 NETINST Binary-1 20070407-11:29]/ etch contrib main

#deb cdrom:[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 NETINST Binary-1 20070407-11:29]/ etch contrib main

deb http://mirror.cs.wisc.edu/pub/mirrors/linux/debian/ etch main
deb-src http://mirror.cs.wisc.edu/pub/mirrors/linux/debian/ etch main

deb http://security.debian.org/ etch/updates main contrib
deb-src http://security.debian.org/ etch/updates main contrib

Second, make another user for your server.

root is a very dangerous user - moreso than a windows administrator and with it in the wrong hands spells doom for your server.

Let's make a user named johndoe by using adduser

adduser johndoe

Once you've filled out all his info, johndoe will have his own little folder in /home named after him.

Next, we'll disable root logins via SSH by simply using changing the configurations here.

nano /etc/ssh/sshd_config

Here, just change "PermitRootLogin yes" to "PermitRootLogin no".

With this disabled, no one - even you, can log into the server as the user root. You will have to 'su' into root by simply logging into your newly created user and using 'su root', which will prompt you for the password of root and allow you to switch into that user.

Also, using 'su' by itself will log in as root if you aren't already.

Downloading the nessecary applications

Now, you'll need a few applications downloaded before it's all done.

Install subversion, screen, mysql, gcc, phpmyadmin, and other libraries you'll need down the line by using this command.

apt-get install subversion mysql-server mysql-client mysql-common kaya phpmyadmin gcc libmysqlclient15-dev screen php5 make

Once those have been downloaded and installed,

you must now change your MYSQL root password since right now, it has none - VERY BAD.

Go to your phpmyadmin by using http://your.server.ip/phpmyadmin and log in as the user root with no password, then change it in the priveleges. Now that the root problem is out of the way, let's install eAthena.

Installing eAthena

We'll install eAthena in /home/johndoe now by making a folder called eAthena with 'mkdir eAthena'.

Then, we will check the latest revision out in the eAthena folder by using 'svn co http://svn.eathena.ws/svn/ea/trunk/'.

cd /home/johndoe
mkdir eAthena
cd eAthena
svn co http://svn.eathena.ws/svn/ea/trunk/

Once that's finished downloading, you'll be at the latest revision and ready to compile - so let's do that now :) Go into your newly created stable folder inside of eAthena and use 'make clean' and 'make sql'

cd trunk
./configure
make clean
make sql

If all goes well, you will get no errors are are ready to start.

Not quite, you'll need a working start script. Let's remove 'start' and 'athena-start' from the stable folder since they're useless to us.

rm start
rm athena-start

The Start Scripts

Use nano start to recreate the start file. Insert this into it and save it.

#!/bin/bash
# modified by shazeya@syafi.com (NL130240)

./athena-start start
sleep 30

while [ true ]; do
if [ "      0" = "$(ps | grep -e log | wc -l)" ] ||
#    if [ "      0" = "$(ps | grep -e login | wc -l)" ] ||
  [ "      0" = "$(ps | grep -e char  | wc -l)" ] ||
  [ "      0" = "$(ps | grep -e map   | wc -l)" ]; then
   printf "Error:"
   date
   sleep 10
   printf "Checking:"
   date
   if [ "      0" = "$(ps | grep -e log | wc -l)" ] ||
#        if [ "      0" = "$(ps | grep -e login | wc -l)" ] ||
      [ "      0" = "$(ps | grep -e char  | wc -l)" ] ||
      [ "      0" = "$(ps | grep -e map   | wc -l)" ]; then
       printf "Error Confirmation:"
       date
       printf "Restoration:"
       date
       ./athena-start start
   else
       printf "Check Miss Sorry:"
       date
   fi
#    else
#        printf "Check OK:"
#        date
fi
sleep 10
done

Now let's use nano athena-start to make the athena-start script

#!/bin/sh
# athena starting script by rowla
# modified by shazeya@syafi.com (NL101541)

PATH=./:$PATH

L_SRV=login-server_sql
C_SRV=char-server_sql
M_SRV=map-server_sql

print_start() {
#    more <<> save/account.txt
#    echo "1    s2    p2    -  S   0" >>save/account.txt
#    echo "2    s3    p3    -  S   0" >>save/account.txt
#    echo "3    s4    p4    -  S   0" >>save/account.txt
#    echo "4    s5    p5    -  S   0" >>save/account.txt
#    fi
#}

check_files() {

for i in ${L_SRV} ${C_SRV} ${M_SRV}
do
   if [ ! -f ./$i ]; then
       echo "$i does not exist, or can't run."
       echo "Stop. Check your compile."
       exit 1;
   fi
done

#    more <<> 
Configuring and Starting eAthena
 
Now that both of those are saved, start eAthena, right? Wrong. There's still a server to configure of course :) 
First, rename conf-tmpl and save-tmpl to conf and save, respectively. 
 
mv conf-tmpl conf
mv save-tmpl save
svn update
 
Now you have your conf and save folders ready,
 as well as the templates in case something goes wrong. 
Now, i'll make this part
(which is usually difficult for a lot of people)
 REALLY simple instead of difficult.
 move into your /conf/import folder of eAthena. S
ince you're still in the stable folder, just 
 
cd /conf/import
 
The import folder is much better than editing
the configuration files themselves because there
 may be a time where you will have to overwrite them
thanks to an svn update or what not.
Here, we can simply add in the settings we wanted to change
and they'll always be here and it's much easier to keep up with.
Let's open login_conf.txt (which is the import file for login_athena.conf)
Add in the following lines. 
 
level_new_gm: 0
use_MD5_passwords: yes
 
Now, anyone using the @gm command to gain gm powers will get nothing out of it,
even if they know it. Also, passwords are encrypted with MD5 as a security measure. 
Now to open char_conf.txt (which is the import file for char_athena.conf) 
 
userid: 
passwd: 
login_ip: 
char_ip: 
 
Now to open map_conf.txt (which is the import file for map_athena.conf) 
 
userid: 
passwd: 
char_ip: 
map_ip: 
 
YOU NEED TO MAKE ABSOLUTELY SURE YOUR USERID AND PASSWD
ARE THE SAME IN BOTH CHAR AND MAP CONFIGS BECAUSE
THE SERVERS USE THIS TO COMMUNICATE WITH EACH OTHER AND IF THEY ARE INCORRECT,
NO ONE WILL BE ABLE TO CONNECT. 
 
Setting up the MySQL Databases
 
Let's go into phpmyadmin as root and create a database
named 'ragnarok' (you may name it something else)
and create a user for example called ragnarok with the password ragnarok.
Don't use that username and password for real, that's bad.. really bad.
Next, give him access and priveleges to the
ragnarok database and once you're in ragnarok,
import the following files out of your /sql-files folder in eAthena. 
 
main.sql
mail.sql
logs.sql
item_db.sql
item_db2.sql
mob_db.sql
mob_db2.sql
 
Now that you've done this, go into the `login` table inside of your
ragnarok database and change the server account username/password
from s1/p1 to whatever you set in the configurations beforehand.
Once that's done, import one more file. 
 
convert_passwords.sql
 
Now, go to inter_conf.txt in your /conf/import folder
and set up your databases. Here, the ragnarok/ragnarok/ragnarok
is used by default but simply change it to what
your username/password/databases are. 
 
// MySQL Login SQL Server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: ragnarok
login_server_db: ragnarok

// 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: log

// MySQL Mail SQL Server
mail_server_ip: 127.0.0.1
mail_server_port: 3306
mail_server_id: ragnarok
mail_server_pw: ragnarok
mail_server_db: ragnarok

use_sql_db: yes
 

Now, the passwords are in md5. Now that the
server is set up, you may start it now
by using ./start in the eAthena folder. 

©2007 Created by Shrasa Milu Temperis.
 Shell Scripts by rowla, modified by Shazeya

FOR CLEAR VIEW OF THE GUIDE:
CLICK ME

THIS GUIDE IS FOR FREYA SVN SQL AND TXT SERVER INSTALLATION

---

Things To Download (not finish)

1. MySQL 4.1.14
2. MySQL Control Center

3. Freya Latest Compiled SVN [The SQL Type] and also the CYGWINDLL files which is a compulsory to download.

4. Abyss Web Server

5. PHP 4.3.11

6. RO Control Panel 4.3.4a


-=First Thing To Do Before Setup=-

1. Check your local IP by clicking the windows START > RUN. Type in cmd and click OK.

2. At the command prompt type /ipconfig and write down the IP address. ie. Something like 192.168.1.2

3. Go to www.ipchicken.com and write down what is your WAN IP (Internet IP).


1. Use Win RAR to extract the program files.

2. Extract it to anywhere you want but not in your desktop.

3. Go to Conf folder, open grf-files.txt and edit the patch to where your RO folder is but default is C:\Program Files\Gravity\RO\

4. Files we need to edit are char_athena.conf, login_athena.conf and map_athena.conf.
Use Notepad to edit .conf files.
char_athena.conf
Remove // for login_ip:, char_ip: and change 127.0.0.1 to your Internet IP (IP for letting ppl to connect to your server) but if you just want to test out, then just use 127.0.0.1, which is Local IP/Computer IP.
SAVE and exit.
login_athena.conf
Look for new_account: and change the value to 0 to disable using _M/_F registration. (Don't Change for TXT users. Player registration by typing Account_M or Account_F to account registration)
SAVE and exit.
map_athena.conf
Remove // for char_ip:, map_ip: and change 127.0.0.1 to your Internet IP (read char_athena.conf)
SAVE and exit.


-=MySQL Installation and Configurations Guide =-

1. Double click the installation file to start the installation.
2. Choose Typical Installation.
3. Click Install and the program will start setting up to program to your server.
4. When done you will be asked for MySQL.com mdone you will be asked for MySQL.com membership sign up. Click SKIP SIGN UP and Next.
5. Click FINISH to start configure your installed MySQL Server.
6. Click Next to proceed.
7. Choose Detailed Configuration and then click Next to proceed.
8. Choose Server Machine and click Next to proceed.
9. Choose Multifunctional Database and click Next to proceed.
10. Define your installation path and Click Next to proceed. In this manual all are default locations.
11. Choose Online Transaction Processing (OLTP) or Manually Define base on your server load.
12. Enable the TCP/IP Networking and Port Number 3306.
13. Choose standard character set for English or Manual select your own desired character set.
14. Tick Install As Windows Service and Launch the MySQL Server Automatically.
15. Uncheck the Modify Security Settings and click Next to proceed.
16. Click Execute to finish the configuration.
17. There you are your own MySQL Server.



-=MySQL Control Center Installation and Configurations Guide =-

1. Double click on the setup.exe to begin installation.
2. Accept the License Agreement and proceed to the NEXT ALL THE WAY. CONTINUE NEXT TILL THE END OF THE INSTALLATION.
3. After done the installation part, double click the MySQL Control Center icon on your desktop. It will launch the Register Server screen.
4. Key in the Name : ragnarok and Host Name : localhost Username : root Password : and the click Test.
5. It will show a CONNECTION SUCCESSFUL SCREEN
6. Click OK and proceed with the Add Button.
7. The console manager will indicate that the database server ragnarok have been created but is not running. It is shown in red.
8. Double click on it and it will run itself.
9. Right click on the Databases and select New Database.
10. Enter ragnarok as your database name.
11. The database ragnarok is created. Double click on it and it will shown as below.
12. Right click on it and choose New Window from Here.
13. At the New Window from Here screen, click on the SQL button on the top right or press CTRL+Q
14. From the Query window, click the Open button or CTRL+O.
15. Point to the newly downloaded + extracted Freya SVN\sql folder.
16. Choose the main.sql and click open button.
17. Then click CTRL+E or click on the Execute button to process it. The Executing Query will turn black during the execution process and will be gray off when completed.
18. Press CTRL+O or click Open button to process the next sql.
19. Select the db_tables.sql and press CTRL+E or click Execute button to process. Repeat this step with item_db.sql, mob_db.sql and upgrade_2.0.2_database.sql.
20. After you have done with the upgrade_2.0.2_database.sql then close the MySQL Control Center.
21. Go back in to the MySQL Control Center and click on the database ragnarok > tables
22. Look for Login under the Tables and double click on it.
23. Right Click on the account_id field on the 15'th line amd select Insert Record
24. It will show a [NULL] field.
25. Double click on it and put in 2000001 and press ENTER
26. Fill in the userid [Your User ID] and the user_pass [Your Password] . After that at the level field, put in 99. This will be your Admin/GM account. Repeat the same thing to add more GM account.
27. Close the MySQL Control Center.
28. Go back in to the MySQL Control Center and double click the User Administration
29. Right click on the User Administration and select New User
30. The Add User Screen is shown as below.
31. Fill in Username : ragnarok Host : localhost Password : ragnarok . Tick All Priviledges as shown in the picture. Click Add and then Close.
32. MySQL Control Panel settings is complete for SVN settings.



-=PHP 4.3.11 Installation and Configurations Guide =-

1. Double click the installation file to start installation.
2. Click On Agree
3. Choose Standard.
4. Click Next to proceed.
5. Click Next to proceed.
6. Choose Microsoft IIS4 or higher and click Next to proceed.
7. Click Next to proceed.
8. Click OK to ignore the error message. It is NORMAL.
9. Click OK to proceed.
10. Installation End