Welcome to RaGEZONE - MMORPG Development Forums (sponsored by tfn.gr) Mark forums read | View Forum Leaders
RaGEZONE - MMORPG Development Forums (sponsored by tfn.gr)

Ragnarok Online Discuss, [GUIDE]How to create a RO Server with eAthena-Stable/SQL at Server Developments forum; Hey bro, okay, i did the same thing you put in there and followed throughly. [QOUTE]Setup Ragnarok Online Control Panel ...




Reply
Thread Tools
[GUIDE]How to create a RO Server with eAthena-Stable/SQL
 
 
Average Member

Rank: Omicron


Reply With Quote
 
Join Date: Jun 2006
Location: Up In Space
Posts: 53
10-02-2007, 06:45 AM
 
Hey bro, okay, i did the same thing you put in there and followed throughly.

[QOUTE]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 [Only Registered and Activated Users Can See Links. Click Here To Register...]
but if you just put all files in htdocs folder, then your ROCP page will be [Only Registered and Activated Users Can See Links. Click Here To Register...]
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:

MySQL User : cp
Password: cp
Confirm Password: cp

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:[/QOUTE]

But it didn't work on mine...i created a new folder in gravity and named CP433, then i extracted everything in there. I also went in to my MySQL and follow that step and saved. I went in config file and changed to what you told ed us. When i open a tap and typed in this [Only Registered and Activated Users Can See Links. Click Here To Register...], it didn't work. It said "Server Not Found". Where did i go wrong? can you please tell me.
 
 
permalink
 

 
Old Dog

Rank: Moderator


Reply With Quote
 
Join Date: Oct 2006
Location: The Cold-War
Posts: 1,146
10-02-2007, 12:19 PM
 
Sure, you need to download the Abyss Web Server and PHP 5.2.3 so you can make it, oh and here my guide to do that.
Lets start,
1. Download Abyss Web Server [Only Registered and Activated Users Can See Links. Click Here To Register...] and PHP [Only Registered and Activated Users Can See Links. Click Here To Register...]
2. Create a folder name PHP in C: and extract PHP 5.2.3 in the PHP folder you created. Will be C:\PHP\
3. Go to C:\PHP\ext\ and copy php_mysql.dll to your PHP main folder, which mean in C:\PHP\
4. In PHP main folder, copy php.ini-recommended to your Windows folder. Rename php.ini-recommended to php.ini and open it with Worpad or Notepad but I would suggest Worpad. Look for this line
Code:
;extension=php_mysql.dll and remove this ; so it will be extension=php_mysql.dll.
Save and exit.
5. 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
6. 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
7. In Custom Environment Variables, click Add and enter this...
Code:
Name: REDIRECT_STATUS
Value: 200
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)
Wow, ok thats all and other people can view your ROCP now, just change your CP433 folder to htdocs in Abyss Web Server folder.

-F.O.X
 
 
permalink
 

 
Average Member

Rank: Omicron


Reply With Quote
 
Join Date: Jun 2006
Location: Up In Space
Posts: 53
10-02-2007, 05:45 PM
 
Your Sooooo Awesome
 
 
permalink
 

 
Average Member

Rank: Omicron


Reply With Quote
 
Join Date: Jun 2006
Location: Up In Space
Posts: 53
10-02-2007, 06:29 PM
 
okay, it worked!! yay!!! but now i said this:

Welcome to Abyss Web Server

Quote:
Abyss Web Server is running correctly on your system. You should now change this page with yours.

Please include in your web pages (at least the first) the 'Powered by Abyss Web Server' banner to promote the use of the software.
man how many step there is? and how much more do i have to do before the website actally show and i can make an account??
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Dec 2006
Posts: 8
10-02-2007, 07:26 PM
 
hi..i seem to be having a problem..everything is up and running fine but why is it that after i create a character and select the character it say " fail to connect to server"

how do i fix this error?
 
 
permalink
 

 
Dub Dub is offline
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Nov 2006
Posts: 15
10-02-2007, 11:02 PM
 
F.O.X

I want to congratulate you, you made an awesome job, great tutorial. Very clear. Still working on it, but I assume there will be no problems...

I wish Priston server area had such tutorials =X

Anyways, gratz, just have one thing to ask: Keep it updated, and it will be awesome. =))
 
 
permalink
 

 
The Omega

Rank: New Blood


Reply With Quote
 
Join Date: Dec 2006
Posts: 103
10-03-2007, 12:41 AM
 
I don't know how i setted mine up but i used no-ip software, xamp, and the mysql essentials and gui tools :P ^_^ Website worked even server and connecting to it. Just when i type my wan ip or the url for my server. It comes up as page cannot be displayed or takes forever to load.
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Jul 2006
Location: WA
Posts: 19
10-03-2007, 02:30 AM
 
I got all my files and stuff straight, and when I log in, it sits for a minute, then hangs and says it failed to connect to server.
Any ideas?
 
 
permalink
 

 
Average Member

Rank: Omicron


Reply With Quote
 
Join Date: Jun 2006
Location: Up In Space
Posts: 53
10-03-2007, 03:44 AM
 
hal1237, how did u get the website working? mine didn't work...mine said this:


Welcome to Abyss Web Server

Quote:
Abyss Web Server is running correctly on your system. You should now change this page with yours.

Please include in your web pages (at least the first) the 'Powered by Abyss Web Server' banner to promote the use of the software.
wat did i do wrong?
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Feb 2007
Posts: 6
10-03-2007, 06:29 AM
 
hi can i know why i keep reject from the server when i login ?
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Dec 2006
Posts: 8
10-03-2007, 07:47 AM
 
er...how do i create a GM account?
 
 
permalink
 

 
Old Dog

Rank: Moderator


Reply With Quote
 
Join Date: Oct 2006
Location: The Cold-War
Posts: 1,146
10-03-2007, 10:49 AM
 
Quote: Originally Posted by Krov View Post
okay, it worked!! yay!!! but now i said this:

Welcome to Abyss Web Server



man how many step there is? and how much more do i have to do before the website actally show and i can make an account??
Do you have change the CP433 file to htdocs? and delete whole thing inside the htdocs and change CP433 file to inside, [Only Registered and Activated Users Can See Links. Click Here To Register...] or [Only Registered and Activated Users Can See Links. Click Here To Register...] .

Quote: Originally Posted by RuleBreaker View Post
hi..i seem to be having a problem..everything is up and running fine but why is it that after i create a character and select the character it say " fail to connect to server"

how do i fix this error?
can you post map_athena, char_athena, subnet_athena information and sclientinfo? and do you have any router?

Quote: Originally Posted by Dub View Post
F.O.X

I want to congratulate you, you made an awesome job, great tutorial. Very clear. Still working on it, but I assume there will be no problems...

I wish Priston server area had such tutorials =X

Anyways, gratz, just have one thing to ask: Keep it updated, and it will be awesome. =))
Yes i will if i online.

Quote: Originally Posted by ha1237 View Post
I don't know how i setted mine up but i used no-ip software, xamp, and the mysql essentials and gui tools :P ^_^ Website worked even server and connecting to it. Just when i type my wan ip or the url for my server. It comes up as page cannot be displayed or takes forever to load.
make sure the xamp software is running and inside the htdocs is got file.

Quote: Originally Posted by azkana6 View Post
I got all my files and stuff straight, and when I log in, it sits for a minute, then hangs and says it failed to connect to server.
Any ideas?
please give more information about map_athena, char_athena, subnet_athena and sclientinfo? and do you have any router?

Quote: Originally Posted by jialiang View Post
hi can i know why i keep reject from the server when i login ?
This is usually a server-side issue. "Rejected from server" usually points to firewall (including port forwarding) or configuration error (including complete removal of maps). Please look into those areas and come back with more information.

thanks you
-F.O.X
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Dec 2006
Posts: 8
10-03-2007, 11:55 AM
 
ok i fixed the "Failed To Connect TO Server" error..but i have a problem..how do i make my account a GM??
 
 
permalink
 

 
Dub Dub is offline
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Nov 2006
Posts: 15
10-03-2007, 01:28 PM
 
Quote: Originally Posted by RuleBreaker View Post
er...how do i create a GM account?
Yeah, I have this exact same doubt....how do I make GM accounts?

I saw in a FAQ that I should go to Server\conf\GM Account.txt and edit there, but didn't work out, and I think it's because this server is MySQL not txt....so I figure it has another way to do....waiting for answer in that question.

Also, I had a problem with ROCP.....I configured it with no problem, edited the config.php, but when I tipe 127.0.0.1/ROCP (the file I named was ROCP) this image appears: [Only Registered and Activated Users Can See Links. Click Here To Register...]


Is this error common? Can you help me?

Last edited by Dub; 10-03-2007 at 01:31 PM. Reason: link
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Feb 2007
Posts: 6
10-03-2007, 10:06 PM
 
Thank you F.O,X
but it still wont work for me T.T

can i post char_athena,ladmin_athena,map_athena,subnet_athena in here?
so you can correct me if im wrong
 
 
permalink
 

 
Average Member

Rank: Omicron


Reply With Quote
 
Join Date: Jun 2006
Location: Up In Space
Posts: 53
10-04-2007, 02:43 AM
 
i mess some stuff up now i can't make it work right, so i deleted everything and going to start over...haha.
 
 
permalink
 

 
Old Dog

Rank: Moderator


Reply With Quote
 
Join Date: Oct 2006
Location: The Cold-War
Posts: 1,146
10-04-2007, 05:07 AM
 
Quote: Originally Posted by RuleBreaker View Post
ok i fixed the "Failed To Connect TO Server" error..but i have a problem..how do i make my account a GM??
Ok i have make some picture, here
[Only Registered and Activated Users Can See Links. Click Here To Register...]
1. Open you MySQL Query browser, and click on ragnarok DB.
2. then find login table, double two time and you got that.
[Only Registered and Activated Users Can See Links. Click Here To Register...]
3. Search for your ID which 1 want to be GM then search for level and edit the number 0 to 99.
4. Click on Apply Change and you are done.
Quote: Originally Posted by Dub View Post
Yeah, I have this exact same doubt....how do I make GM accounts?

I saw in a FAQ that I should go to Server\conf\GM Account.txt and edit there, but didn't work out, and I think it's because this server is MySQL not txt....so I figure it has another way to do....waiting for answer in that question.

Also, I had a problem with ROCP.....I configured it with no problem, edited the config.php, but when I tipe 127.0.0.1/ROCP (the file I named was ROCP) this image appears: [Only Registered and Activated Users Can See Links. Click Here To Register...]


Is this error common? Can you help me?
That mean you are setting the database not correctly, go back to the guide and configure again.

Quote: Originally Posted by jialiang View Post
Thank you F.O,X
but it still wont work for me T.T

can i post char_athena,ladmin_athena,map_athena,subnet_athena in here?
so you can correct me if im wrong
Sure, but please use the [code] tag for your char_athena etc... and what is the error or problem is appear on you?

-F.O.X
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Oct 2007
Posts: 11
10-04-2007, 07:14 AM
 
Hi Fox this is weird I have no errors when I look at the configs and when I launch the exe for servers but wwhen I try to join I get rejected from server. right away.
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Dec 2006
Posts: 8
10-04-2007, 09:40 AM
 
erm i mean make the account in a GM account...isnt that just changing the level?
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Dec 2006
Posts: 8
10-04-2007, 10:00 AM
 
oh..ok i got what u mean about the GM account...just 2 more question and my server would be all ready..how to i change the starting amount of zeny character gets? and about the RO-Control Panel Website...how do i make an admin account? my user is currently just a "Logged in as: <myloginid> Access Level: User " and how do i change the Acess Level to Admin.
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Feb 2007
Posts: 6
10-04-2007, 12:06 PM
 
im using eAthena-SQL-11332[Stable]
my friend can login but after that he got reject from server
i already do portforward
[Only Registered and Activated Users Can See Links. Click Here To Register...]
im using this Aztech router
[Only Registered and Activated Users Can See Links. Click Here To Register...]



Code:
=========
char_athena
=========
// 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: 192.168.1.2 <- myip
 
// 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:60.50.226.152 <- wanip
Code:
=========
Map athena
=========
// 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: 192.168.1.2 <- myip
 
// 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: 60.50.226.152 <- wanip
 
// Map Server Port
map_port: 5121
Code:
============
subnet_athena
============
// Subnet support file
// Format is:
// subnet: net-submask:char_ip:map_ip
// you can add more than one subnet 
 
subnet: 255.255.255.0:60.50.226.152:60.50.226.152
Code:
===========
sclientinfo
===========
<?xml version="1.0" encoding="euc-kr" ?> 
<clientinfo> 
<servicetype>korea</servicetype>
<servertype>sakray</servertype>
<connection>
<display>elvenRO</display>
<desc>None</desc> 
<address>elvenRO.sytes.net</address> < using no-ip
<port>6900</port>
<version>20</version>
<langtype>8</langtype>
<registrationweb></registrationweb>
<aid><admin></admin></aid>
</connection>
</clientinfo>
pls correct me if my wrong
THX YOU
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Dec 2006
Posts: 8
10-04-2007, 04:13 PM
 
oh great my server is up and running i got all the problems fixed accept for the starting amount of zeny..anyone here knows how to change the zeny starting amount?
 
 
permalink
 

 
Average Member

Rank: Omicron


Reply With Quote
 
Join Date: Jun 2006
Location: Up In Space
Posts: 53
10-05-2007, 05:28 AM
 
ahh man!!! i wanna play!!
 
 
permalink
 

 
Old Dog

Rank: Moderator


Reply With Quote
 
Join Date: Oct 2006
Location: The Cold-War
Posts: 1,146
10-05-2007, 08:58 AM
 
Quote: Originally Posted by RuleBreaker View Post
oh..ok i got what u mean about the GM account...just 2 more question and my server would be all ready..how to i change the starting amount of zeny character gets? and about the RO-Control Panel Website...how do i make an admin account? my user is currently just a "Logged in as: <myloginid> Access Level: User " and how do i change the Acess Level to Admin.
OK here the guide, go to your server file > conf > char_athena and search for;
Code:
// Starting zeny for new characters
start_zeny: 0
change the 0 to #, and there you can change many thing like starting point, starting weapon etc etc...
And for the RO-CP try go to MySQL Query Browser and open cp db and edit, try your self(i never edit that thing :P).

Quote: Originally Posted by jialiang View Post
im using eAthena-SQL-11332[Stable]
my friend can login but after that he got reject from server
i already do portforward
[Only Registered and Activated Users Can See Links. Click Here To Register...]
im using this Aztech router
[Only Registered and Activated Users Can See Links. Click Here To Register...]



Code:
=========
char_athena
=========
// 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: 192.168.1.2 <- myip
 
// 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:60.50.226.152 <- wanip
Code:
=========
Map athena
=========
// 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: 192.168.1.2 <- myip
 
// 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: 60.50.226.152 <- wanip
 
// Map Server Port
map_port: 5121
Code:
============
subnet_athena
============
// Subnet support file
// Format is:
// subnet: net-submask:char_ip:map_ip
// you can add more than one subnet 
 
subnet: 255.255.255.0:60.50.226.152:60.50.226.152
Code:
===========
sclientinfo
===========
<?xml version="1.0" encoding="euc-kr" ?> 
<clientinfo> 
<servicetype>korea</servicetype>
<servertype>sakray</servertype>
<connection>
<display>elvenRO</display>
<desc>None</desc> 
<address>elvenRO.sytes.net</address> < using no-ip
<port>6900</port>
<version>20</version>
<langtype>8</langtype>
<registrationweb></registrationweb>
<aid><admin></admin></aid>
</connection>
</clientinfo>
pls correct me if my wrong
THX YOU
Hmmm, try change this;
Code:
 // 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:60.50.226.152 <- wanip (Change to no-ip address)
Code:
 // 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: 60.50.226.152 <- wanip (Change to no-ip address)
and this if above still can't try this,
Code:
============
subnet_athena
============
// Subnet support file
// Format is:
// subnet: net-submask:char_ip:map_ip
// you can add more than one subnet 
 
subnet: 255.255.255.0:60.50.226.152(change to 192.168.1.2):60.50.226.152(change to 192.168.1.2)
 
 
permalink
 

 
Newbie

Rank: Omicron


Reply With Quote
 
Join Date: Feb 2007
Posts: 6
10-05-2007, 04:28 PM
 
Thx you F.O.X my problem solve and my friend can login now you did a great job xD
 
 
permalink
 

Reply

Tags