Not a member yet? Register for your free account!


Go Back   elitepvpers > MMORPGs > Ragnarok Online > Ragnarok Online PServer Hosting
You last visited: Today at 23:33

  • Please register to post and access all features, it's quick, easy and FREE!

 

Creating a Ragnarok eAthena Server with SQL

This is a discussion on Creating a Ragnarok eAthena Server with SQL within the Ragnarok Online PServer Hosting forum part of the Ragnarok Online category; Guide Version : 12068 Guide Updated on 21 August 2009 Futures: F.A.Q *added* Picture(if needed)*added* More details Setup Website/ROCP *added* ...

Reply
 
Thread Tools
Old 09-19-2009, 03:51   #1
Joey Jordison
 
Join Date: Jan 2009
Posts: 379
Received Thanks: 969
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 :

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

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

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

3. Open map_athena now we are going to edit,

Code:
[SIZE=1]//--------------------------------------------------------------[/SIZE]
[SIZE=1]//            Configuration Info            [/SIZE]
[SIZE=1]//--------------------------------------------------------------[/SIZE]
[SIZE=1]// Interserver communication pass*****, set in account.txt (or equiv.)[/SIZE]
[SIZE=1]userid: [/SIZE][SIZE=1][COLOR=orange]s1[/COLOR][/SIZE][SIZE=1] < Change to ragnarok[/SIZE]
[SIZE=1]passwd: [/SIZE][SIZE=1][COLOR=orange]p1[/COLOR][/SIZE][SIZE=1] < Change to ragnarok[/SIZE]
 
[SIZE=1]// Character Server IP[/SIZE]
[SIZE=1]// The map server connects to the character server using this IP address.[/SIZE]
[SIZE=1]// NOTE: This is useful when you are running behind a firewall or are on[/SIZE]
[SIZE=1]// a machine with multiple interfaces.[/SIZE]
[SIZE=1]//char_ip: [/SIZE][SIZE=1][COLOR=orange]127.0.0.1 [COLOR=black]< Edit to your [/COLOR][/COLOR][/SIZE][SIZE=1]Local IP/Computer IP[/SIZE]
 
[SIZE=1]// The map server listens on the interface with this IP address.[/SIZE]
[SIZE=1]// NOTE: This allows you to run multiple servers on multiple interfaces[/SIZE]
[SIZE=1]// while using the same ports for each server.[/SIZE]
[SIZE=1]//bind_ip: 127.0.0.1[/SIZE]
 
[SIZE=1]// Character Server Port[/SIZE]
[SIZE=1]char_port: 6121[/SIZE]
 
[SIZE=1]// Map Server IP[/SIZE]
[SIZE=1]// The map server exports this IP address to the entire world.[/SIZE]
[SIZE=1]// NOTE: You should only need to set this if you are running behind a[/SIZE]
[SIZE=1]// firewall or are on a machine with multiple interfaces.[/SIZE]
[SIZE=1]map_ip: [/SIZE][SIZE=1][COLOR=orange]127.0.0.1[/COLOR][/SIZE][SIZE=1][COLOR=black]< Edit to your Local IP or WAN IP[/COLOR][/SIZE]
 
[SIZE=1]// Map Server Port[/SIZE]
[SIZE=1]map_port: 5121[/SIZE]
4. Open your grf-files file and ready to edit it,

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

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

Code:
[SIZE=1]// Subnet support file[/SIZE]
[SIZE=1]// Format is:[/SIZE]
[SIZE=1]// subnet: net-submask:char_ip:map_ip[/SIZE]
[SIZE=1]// you can add more than one subnet [/SIZE]
 
[SIZE=1]subnet: [B][COLOR=darkorange]255.0.0.0[/COLOR][/B] [B]> edit to your own subnet address[/B]:[/SIZE] [SIZE=1][COLOR=darkorange][B]127.0.0.1[/B] [B][COLOR=black]> Change to your LAN IP[/COLOR][/B][/COLOR][/SIZE][SIZE=1]:[B][COLOR=darkorange]127.0.0.1[/COLOR][/B] [B]> Change to your LAN IP[/B][/SIZE]
NOTICE!

Code:
[SIZE=1][COLOR=red][NOTICE][/COLOR][/SIZE][SIZE=1]Remember to take off the "//" before the specific line in your .conf files so it would look like this[/SIZE]
 [SIZE=1]BEFORE:[/SIZE]
 [SIZE=1]//char_ip: 127.0.0.1[/SIZE]
 
 [SIZE=1]AFTER:[/SIZE]
 [SIZE=1]char_ip: 127.0.0.1[/SIZE]
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:
[COLOR=black][COLOR=black][SIZE=1][COLOR=black]Stored Connection: (leave it empty)[/COLOR][/SIZE][/COLOR][/COLOR]
[COLOR=black][COLOR=black] [SIZE=1][COLOR=black]Server Host: localhost[/COLOR][/SIZE][/COLOR][/COLOR]
[COLOR=black][COLOR=black] [SIZE=1][COLOR=black]Username   : root[/COLOR][/SIZE][/COLOR][/COLOR]
[COLOR=black][COLOR=black] [SIZE=1][COLOR=black]Password    : (Enter the password we created before for root) [/COLOR][/SIZE][/COLOR][/COLOR]
[COLOR=black][COLOR=black] [SIZE=1][COLOR=black]Port             :3306[/COLOR][/SIZE][/COLOR][/COLOR]
13. then Click OK and you should be in MySQL Administrator now, and go to User Administration and Click New User and enter this;

Code:
[SIZE=1]MySQL User         : ragnarok[/SIZE]
[SIZE=1]Password             : ragnarok[/SIZE]
[SIZE=1]Confirm Password: ragnarok[/SIZE]
13. Just click Apply changes and exit MySQL Administrator, now you are done for that steps.

C) Setting 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;

Code:
[SIZE=1]Stored Connection: (Leave it empty)[/SIZE]
[SIZE=1]Server            Host: localhost[/SIZE]
[SIZE=1]Username              : root[/SIZE]
[SIZE=1]Password: (Enter the password we created before for root)[/SIZE]
[SIZE=1]Default Schema     : ragnarok < if here is empty Edit it to ragnarok [/SIZE]
[SIZE=1]Port                        :3306[/SIZE]
2. When you are in MySQL Query Browser, click once on ragnarok database that is below Schemata, if "ragnarok" db is not show you also can create your self, right click on the right db place and choose "Create New Schema" then put in "ragnarok" and click "OK".
3. Go to menu, click File and choose Open Script, something will pop up.
4. 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 your eAthena Server and other .sql(mail.sql and log.sql) files.
5. Pick main.sql and click Open.
6. Click the Green Execute Icon at the upper right to execute. Do the same with mail.sql and execute it.
7. When you are done, we need to create "log" database by right click on right side db place within the table where the databases are and choose "Create New Schema" and type in log and click OK.
8. Double click on "log" database, go to menu, click File, choose Open Script, open logs.sql and Execute it.
9.Double click "ragnarok" database to expand to see all tables.
10. Look for "login" table and double click 2 time to see the table.
11. Click once on Edit so, we can edit the cells. This icon should be in bottom left.
12. For userid: and user_pass:, type in the same(userid and user_pass) that you used in char_athena.conf and map_athena.conf, Make sure this step is really correct for the userid and user_pass.
13. When you are done editing, just click the Apply Changes that is next to the Edit icon.
14. In menu, click Tools and choose MySQL Administrator.Go to User Administration and click ragnarok user.
15. Now, go to Schema Privileges and click once on ragnarok database/schema and click this button << and then click Apply changes. Do the same with log database/schema.
16. Well done we are done for MySQL .

D) Setup Client Side
1. Extract FullDATAv3 to your RO(Gravity) folder so you have a data folder in your RO folder.
2. Inside data folder, look for sclientinfo.xml and open it with Notepad. Put your WAN IP (Internet IP) there so you can login to your RO Server to play.
3. Send your sclientinfo.xml to those people/player who want to play your server.
4. Now, just download Hexed client and extract to your RO folder. Use this Hexed client to play RO game.
5. And dun forget to extract data file inside XRay Client to your RO folder data.

E) Launch your RO server
1. Go to your Server file, double click on "runserver-sql" it will automatic run all your login, char and map server.
EDIT: If you get Rejected from Server when you login, please refer to the F.A.Q section for more information.

F) Router Guide, Port forward
Notice: If you dun have any Router or IP block system, you can skip this step.
1. Once you get into your router configuration page, either on top of on the right, there should be a link saying port forwarding. After accessing into this page, create a new service each one named char, map and login.
2. For login, forward ports FROM 6900-6900, which means start port-6900 and end port-6900 and server ip address is your "LAN IP"
3. For char, forward ports FROM 5121-5121. which means start port-5121 and end port-5121 and server ip address is your "LAN IP"
4. For map, forwards ports FROM 6121-6121. which means start port-6121 and end port-6121 and server ip address is your "LAN IP"
5. Make sure all is TCP not DCP.

G) Installing Webserver
1. Create a folder name PHP in C: and extract PHP 5.2.3 in the PHP folder you created. Will be C:\PHP\
2. Go to C:\PHP\ext\ and copy php_mysql.dll to your PHP main folder, which mean in C:\PHP\
3. In PHP main folder, copy php.ini-recommended to your Windows folder. Rename php.ini-recommended to php.ini and open it with Wordpad or Notepad but I would suggest Wordpad. Look for this line
Code:
[SIZE=1];extension=php_mysql.dll and remove this ; so it will be extension=php_mysql.dll.[/SIZE]
Save and exit.
4. Install Abyss Web Server first and choose if you want to manually start it or start it with Windows.
After installation and when ask if you want to run Abyss Web Server now, then choose YES.
It will run and configure in Internet Explore. Choose Language and you will be in next page. Type in your login name and password to make an account.
You will be in Abyss Web Server Console now. Click the Configuration button, which is next to Stop and select Scripting Parameters.
Check in Enable Scripts Execution
Click Add in Interpreters and click Browse..., go to the directory you installed PHP and select php-cgi.exe or just simple type in this C:\PHP\php-cgi.exe
In Type, choose PHP Style
5. Check in Use the associated extensions to automatically update the Script In Associated Extensions, click Add and type in php and press OK
Now just click the OK
6. In Custom Environment Variables, click Add and enter this...

Code:
[SIZE=1]Name: REDIRECT_STATUS[/SIZE]
[SIZE=1]Value: 200[/SIZE]
Click OK when done and then click OK in bottom to go back to Configuration
Click Index Files icon, click Add and enter index.php and click OK
Everything is done for Abyss Web Server now.

Quote:
NOTE: Abyss Web Server must be running if you want other people to access your webserver (ROCP or anything)
H)Setup Ragnarok Online Control Panel

1. Go to Abyss Web Server folder and then to htdocs folder and extract ROCP 4.3.4a there or any version you have or want to use.
You can either make a new folder to put all ROCP files there or just put all files in htdocs folder. Example, if I put all files in a new folder with the name CP433, then your ROCP page will be
but if you just put all files in htdocs folder, then your ROCP page will be
You can use IP 127.0.0.1 to test but if you want people can access your ROCP page, then they must enter your Internet IP or the IP they use to connect to your server.
2. Start MySQL Query Browser, go to File in menu and choose Open Script... and look for the install.sql, which should be in rocp\install\Athena & Freya\. So, just execute install.sql.
If you get error, then try to create a cp database manually. Right-click somewhere within where your ragnarok database is and choose Create New Schema and type in cp. Double-click the cp database you just created. Now just do as I explained in step 2.
3. In menu, click the Tools and choose MySQL Administrator. Go to User Administration and in User Information, enter this:

Code:
[SIZE=1]MySQL User : cp[/SIZE]
[SIZE=1]Password: cp[/SIZE]
[SIZE=1]Confirm Password: cp[/SIZE]
Go to Schema Privileges, click the cp database below to highlight it and click this button <<
NOTE: If you have cp account in your login table, then you have to delete it otherwise people can use it to access your ROCP as Admin but you can simply edit it with other name and password.
4. Among all ROCP files... open config.php in Notepad and edit these lines:

[CODEImportant:
$CONFIG['db_host'] = 'localhost';
$CONFIG['db_username'] = 'cp';
$CONFIG['db_password'] = 'cp';
$CONFIG['cp_db_name'] = 'cp';
$CONFIG['db_name'] = 'ragnarok';
$CONFIG['passphrase'] = 'whatever'; <- Enter any name/password here but no unique letter
$CONFIG['server_type'] = '2'; <- Must be 2

Optional:
$CONFIG['check_server'] = ' 1'; <- Enter 0 if you don't want it to check server status and 1 for checking server status
$CONFIG['accip'] = '127.0.0.1'; <- Your Internet IP (same IP as uses for eAthena Server)
$CONFIG['accport'] = '6900';
$CONFIG['charip'] = '127.0.0.1'; <- Your Intenet IP (same IP as uses for eAthena Server)
$CONFIG['charport'] = '6121';
$CONFIG['mapip'] = '127.0.0.1'; <- Your Internet IP (same IP as uses for eAthena Server)
$CONFIG['mapport'] = '5121';
$CONFIG['server_name'] = 'Server Name'; <- Enter your eAthena Server name here but it won't affect server side or anything. ][/CODE]

J) How to connect to your own server
1. Go to your RO folder then open data folder, and search for "sclientinfo" open it with WordPad or Notepad.
2. And it should look like this,

Code:
[SIZE=1]<?xml version="1.0" encoding="euc-kr" ?> [/SIZE]
[SIZE=1]<clientinfo> [/SIZE]
[SIZE=1]<servicetype>korea</servicetype>[/SIZE]
[SIZE=1]<servertype>sakray</servertype>[/SIZE]
[SIZE=1]<connection>[/SIZE]
[SIZE=1]<display>[COLOR=sienna]YOUR SERVER DISPLAY NAME HERE[/COLOR]</display>[/SIZE]
[SIZE=1]<desc>[COLOR=sienna]None[/COLOR]</desc> [/SIZE]
[SIZE=1]<address>[COLOR=sienna]YOUR IP HERE[/COLOR]</address>[/SIZE]
[SIZE=1]<port>6900</port>[/SIZE]
[SIZE=1]<version>20</version>[/SIZE]
[SIZE=1]<langtype>8</langtype>[/SIZE]
[SIZE=1]<registrationweb></registrationweb>[/SIZE]
[SIZE=1]<aid><admin></admin></aid>[/SIZE]
[SIZE=1]</connection>[/SIZE]
[SIZE=1]</clientinfo>[/SIZE]
3. Put in you IP, name, Desc aka description and admin code number...
4. Save then close, you are done.
Notice: If you get Rejecter from server or other problem please refer to F.A.Q section.

PLEASE READ THE "F.A.Q" FIRST IF YOU HAVE ANY PROBLEMS OCCUR


F.A.Q

Code:
So, you have a problem do you, well refer to this section for help:
 
Q: I have followed allot guide out there, but i still get "Rejected from server" at every time when i login.
  
A2: please try search around the faq section.

 
Q: My command line interface wont open when i type cmd/command into the run box, what do I do?
 
A: Reinstall, or repair, your copy of windows. Your missing some .dll files and system files also probably.
 
Q: When I go to configure the MySQL service it gives me an error when I click on execute. In the explanation it says error: 0. What’s up with this?
 
A: This means that you have a service (remember that drop down menu?) already running by that name. There are 2 ways to fix this.
 
1. Click back, and select a new service name from the drop down list
 
OR
 
2. Press start, click run, type cmd in, then type this:
 
sc delete MySQL (or type any of these after the MySQL part: 4, 41,5,501,51)
 
Now rerun the MySQL Instance Config Wizard and try again.
 
Q. I have a firewall. What do I do?
 
A. You must go into your firewall's configuration page and open the ports required by eAthena (By default - 6900, 6121, 5121).
 
Q. My item descriptions (and everything else) are in gibberish.
 
A. Grab a translated "itemdesctable" (along with the other translated files) from here. Now, make sure your client was hexed to use "plaintext descriptions".
 
Q. How do I change the rates?
 
A. The options are in conf/battle/exp.conf. Don't forget that "100" is 1X, "200" is 2X, "1000" is 10X, etc.
 
Q. How do I make it so that players can level up more than once?
 
A. Look for this line in conf/battle/exp.conf and change it to "yes".
multi_level_up:
 
Q. How do I change max stats?
 
A. Look for this line in conf/battle/player.conf:
max_parameter:
 
Q. How do I set the max levels?
 
A. In conf/battle/client.conf, look for:
max_lv:
 
Now switch the official exp table (db/exp.txt) with the extended exp table (db/exp2.txt) and change the first number of each job to its desired max lvl. Do not go above lvl 1000.
 
Q. How do I get a GM sprite for my character?
 
A. In your sclientinfo, add the lines
<aid>
<admin>ACCOUNT ID</admin>
</aid>
You can also use <yellow> rather than <aid> if you want that account to have only the sprite, but no admin right click ability.
 
Q. Where do I get custom npcs?
 
A. There are a few supplied in the SVN. For more, check the script forums. There are many scripts you can use.
 
Q. I can connect to the server but others (from WAN sources) can't.
 
A. Are you using a router? Are you using a firewall?
 
Q. My server is running, and I can connect fine, but others get a "Disconnect from Server" error immediately after logging in.
 
A. Try changing the Login Server Port from the default 6900 to a diffrent port in char_athena.conf and login_athena.conf in your eAthena conf folder. Also, you would need to change the port in sclientinfo.xml (Client Side), as well as in your firewall and router settings. Make sure you change the port number in each of those files to the same one! 
 
Q: When I got to configure the MySQL service it gives me an error when I click on execute. In the explanation it says a error number other then 0. What’s up with this?
 
A: This means that you need to uninstall MySQL 5 (also uninstall any older versions of MYSQL (including non-install version)), restart your computer then reinstall MySQL 5 and it should work.
 
Q: When I go to access MySQL Admin I get an error that’s has the number 2003 in the error explanation. How do I fix this?
 
A: This means that MySQL Admin can not access your MySQL service, which means you will either have to reinstall or make sure that MySQL its running. (To find out, press ctrl + alt + delete to open the windows task manager, click the possesses tab and look for mysqld-nt. If it’s not listed then right click on start, then click on explore. Browse to your mysql folder, open the MySQL 5 folder, then open the bin folder and find mysqld-nt and run it then try to access MySQL admin again).
 
Also, make sure that if you have a firewall on your comp, on or not, to make the mysqld-nt, char server, login server, map-server, and run-server sql are all allowed programs.
 
Q: I am getting a message in red in my Char Server that says that the inter-server pass***** arent working, what do I do?
 
A: This means that you either didnt set the password in char_athena and map_athena, didnt do it corecctly, or have not set up an account for yoour server.
 
Q: I am getting a message in purple in my Map Server that says that the Sql Database could not be connected to.
 
A: This also means that you do not have an account setup for your Server in your MySql Query Browser login Table.
 
Q: How can i create GM account?
 
A: Ok i have make some picture, here
[URL="http://forum.********.com/attachments/f84/45392-guide-how-to-create-a-ro-server-with-eathena-stable-sql-howtobegm.jpg"]Attachment 45392[/URL]
1. Open you MySQL Query browser, and click on ragnarok DB.
2. then find [B]login [/B]table, double two time and you got that.
[URL="http://forum.********.com/attachments/f84/45391-guide-how-to-create-a-ro-server-with-eathena-stable-sql-howtobegm2.jpg"]Attachment 45391[/URL]
3. Search for your ID which 1 want to be GM then search for [B]level[/B]  and edit the number [B]0[/B] to [B]99[/B].
4. Click on [B]Apply Change[/B] and you are done.
 
Q: What is RO aka Ragnarok Online?
 
A: Ragnarok is an online role-playing game based on Norse mythology.
Users can create characters and venture off alone or in groups
in far-flung fantasy worlds full of adventure.
[B]Over 20 different job classes[/B]
Players can select from a wide range of job classes that suit their individual playing style. Each job class comes with a unique array of skills and abilities. The strengths and weaknesses of these classes encourages to players of different types to form parties.
[B]Lush Graphics and Sound[/B]
Ragnarok features hand-drawn, anime-rendered characters set onto realistic 3D backgrounds. The graphical design of the environments has been inspired by mythological and historical elements from various cultures around the world. Similarly, the music score is a diverse collection of eclectic songs drawn from various genre inspirations. The huge music library composed by TeMP, ensures that users will rarely be bored with the same song twice.    
[B]Windows Oriented Interface[/B]
Ragnarok has an easy-to-control interface. Most of the basic functions can be controlled by using the mouse. Users can also customize the interface to optimize usability and comfort.
More info visit [URL="http://forum.********.com/redirector.php?url=http%3A%2F%2Fen.wikipedia.org%2Fwiki%2FRagnarok_Online"]HERE[/URL]
[I]......[/I]

Code:
Credits:
eAthene Board / [URL="http://www.eathena.ws/board"]eAthena Support Board (Powered by Invision Power Board)[/URL]
SVN Release Website / [URL="http://forum.********.com/redirector.php?url=http%3A%2F%2Fsacredangelro.com%2Fsvn%2F"]SVN Release[/URL]
eAthena.ws/wiki / [URL="http://eathena.ws/wiki/index.php/Main_Page"]Main Page - EAthena[/URL]
Bladestorm for the router guide
artzi for the F.A.Q
rozandas for some tips
Code:
[I]If any credits is missing please tell me...[/I]
[--------------------------------------------------------------------------------------------]



Please check it out guys you'll really find the help you're looking for.

Also for those searching the latest release check here


All Credits to F.O.X

__________________

darkmik07 is offline  
Thanks
30 Users
Aimless Angel (09-19-2009), akiro2020 (01-24-2012), aspera71 (05-14-2013), CHICO79 (01-26-2011), CrypticVexx (02-10-2010), cute_fenrir (11-12-2011), dexter009988 (05-25-2010), dragantra (06-09-2011), evangelion18 (06-07-2010), holy-warrior (04-02-2011), johan orlando (07-04-2012), Kryptonicc (01-02-2010), leomarjane (08-21-2011), leyn1205 (06-09-2011), lightyagami27 (12-23-2012), Loki. (12-06-2010), marcopolo1990 (03-28-2011), mathgenius (06-27-2011), ragnadark24 (03-09-2011), RazierX (07-16-2013), redrobin99 (09-20-2009), scawy0 (12-09-2009), sentimode (02-20-2011), SilentStar (05-18-2010), skeena (03-12-2010), ssj5_andrew (02-01-2010), vankan84 (03-15-2011), XhidanxX (05-13-2010), yoshikunikazuma (10-09-2010), Ziin. (10-07-2010)
Old 09-19-2009, 12:30   #2
Call me Kommissar :)

 
Join Date: Dec 2005
Posts: 30,504
Received Thanks: 13,455
very nice!
i just edited the thread titel a bit!

~pinned~
Aimless Angel is offline  
Thanks
1 User
lightyagami27 (12-23-2012)
Old 09-20-2009, 00:54   #3
Joey Jordison
 
Join Date: Jan 2009
Posts: 379
Received Thanks: 969
Quote:
Originally Posted by Aimless Angel View Post
very nice!
i just edited the thread titel a bit!

~pinned~
thanks Aimless Angel
darkmik07 is offline  
Thanks
2 Users
CHICO79 (01-27-2011), desktop29 (06-10-2010)
Old 09-20-2009, 05:32   #4
Junior Member
 
Join Date: Mar 2009
Posts: 26
Received Thanks: 5
Very nice indeed! Great guide for those who have been out of RO for awhile.

I tested out everything step by step just to see how accurate your guide was (been a while since I've setup a server) and it's perfect. Great job.

Just a shame the sakray client doesn't patch correctly
redrobin99 is offline  
Old 09-22-2009, 02:44   #5
Bot.
 
Join Date: Aug 2005
Posts: 1,723
Received Thanks: 68
Good Guide.

Quote:
grf: C:\Program Files\Gravity\RO\ < Edit to, where your RO files located
Where the GRF Files are located!
A Server dun need a full RO install.
Also only the sdata is needed.

Hideki
ChibiEbil is offline  
Old 09-22-2009, 11:07   #6
Junior Member
 
Join Date: Sep 2009
Posts: 1
Received Thanks: 0
Aimless Angel Please Add me IN YM

For THe SET_UP for the Server RO THANKS!
yorme is offline  
Old 09-29-2009, 12:33   #7
Junior Member
 
Join Date: Oct 2007
Posts: 1
Received Thanks: 0
hello, thanks for the guide, its working but why every jobs skill tree is empty? i tried searching for the another translation but the skill tree keep empty, please help?
thanks
shadow57 is offline  
Old 11-01-2009, 04:18   #8
Junior Member
 
Join Date: Nov 2009
Posts: 1
Received Thanks: 0
ok yah i'm having the same trouble as shadow 57! i've made a server before and it does seem that everything needs translating, but will that also fix the skill tree? plz someone reply and thanks for the best guide evah ^______________^
kaitzure is offline  
Old 11-10-2009, 00:44   #9
Junior Member
 
Join Date: Nov 2009
Posts: 1
Received Thanks: 0
some problem

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 your eAthena Server and other .sql(mail.sql and log.sql) files.
5. Pick main.sql and click Open.

this 1 i no understand man!some 1 can help me ?
weelun is offline  
Old 11-15-2009, 12:51   #10
Junior Member
 
Join Date: Nov 2009
Posts: 1
Received Thanks: 0
Wow, great guide, just created a server But i have one problem.
After i log in and choose my server is says that I am Rejected from the Server
Or that i failed to connect. I have the login, Char and map servers running
Can you tell me a few things that may have gone wrong?? Please reply soon

:Edit:
I have also managed to get in-game and i cannot go into monster maps or i crash
No default NPCs and no skills.

Last edited by Limez; 11-15-2009 at 21:31.
Limez is offline  
Reply

 

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
eAthena Server Crasher zenmark RO Exploits, Hacks, Bots & Guides 5 06-03-2010 18:25
Ragnarok Server Hosting - eAthena Trazer Ragnarok Online PServer Hosting 30 02-09-2008 00:44
eAthena Map-Server Probleme demon2005 Ragnarok Online PServer Hosting 6 10-18-2007 08:20
eAthena RO Server? DDPhoenix Ragnarok Online 15 10-07-2005 11:44



All times are GMT +2. The time now is 23:33.


Powered by vBulletin®
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.