[GUIDE]How to create a RO Server with eAthena-Stable/SQL

thaihoa_87 · 10-15-2007, 03:07 PM

Quote: Originally Posted by junior303

Help when I goto my my ip adress url I have to put a username and password I need to get in to open my ports because I use router T__T Does anyone know what to doo?!?!

you mean user and password of your router web address ? then try this link

Code:

http://www.portforward.com/english/routers/port_forwarding/routerindex.htm

they show you the way to open port with your router, and user/password if you havent changed it yet!

sohjc1988 · 10-17-2007, 01:59 PM

I can't seem to connect to the servers. Can u pls help me?

My ip address is 192.168.1.110.

[Only Registered and Activated Users Can See Links. Click Here To Register...]

**F.O.X** · 10-18-2007, 05:34 PM

Sir!, can you please give more information about your conf file setting? maybe we can help you out.

-F.O.X

sohjc1988 · 10-19-2007, 03:39 AM

Quote:

// Athena Character configuration file.

// Note: "Comments" are all text on the right side of a double slash "//"
// Whatever text is commented will not be parsed by the servers, and serves
// only as information/reference.

// Server Communication username and password.
userid:ragnarok
passwd:ragnarok

// Server name, use alternative character such as ASCII 160 for spaces.
//NOTE: You should not use spaces in the server name, or guild emblems won't work client-side!
server_name:192.168.1.110

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

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

// Character Server Port
char_port: 6121

tis is the char_athene config file

Quote:

//--------------------------------------------------------------
// Configuration Info
//--------------------------------------------------------------
// Interserver communication passwords, set in account.txt (or equiv.)
userid:ragnarok
passwd: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: 192.168.1.110

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

// Map Server Port
map_port: 5121

this is the map_athene config file.

**F.O.X** · 10-19-2007, 04:35 AM

Shorted, try follow the guide probably and your picture is mean setting wrong at MySQL part.
Newbie go read the sticky thing 1st before you post!.

-F.O.X

sohjc1988 · 10-19-2007, 12:23 PM

Hmm. i've re-do it fer alot of times. is the version of the sql got smt to do wif the error?

Blue Charizard · 10-19-2007, 06:43 PM

The problem is that you have set the server communication passwords in the config files to ragnarok/ragnarok, while on the same time forgot to change them in the actual account-database.

If you are using TXT, go to /save/accounts.txt
If you are using SQL, go to the table "login"

Then find the first account, which by default should be :

Account : s1
Password : p1
Sex : S

And edit it to match the "server communication username and password"-setting, which in your case should be:

Account: ragnarok
Password : ragnarok
Sex : S

sohjc1988 · 10-20-2007, 03:48 AM

yea. i've edited it, doesn't seem to work aso. >.>

bestman · 10-22-2007, 12:18 PM

hi there, my MySQL5 can't work..dunno what's up with this error:1045

[Only Registered and Activated Users Can See Links. Click Here To Register...]

Mathew5000 · 12:54 AM

i need a lil help... when i click runserver-sql it goes for a few sec then it stops and says

[SQL]: access denied for user 'ragn'@'%' to database 'ragnarok'

[Only Registered and Activated Users Can See Links. Click Here To Register...]

[Only Registered and Activated Users Can See Links. Click Here To Register...]

[Only Registered and Activated Users Can See Links. Click Here To Register...]

Note sorry for makeing so big im to tierd to go through all of the stuff to just post them so people can c them so sorry...

TULOA · 10-24-2007, 05:26 PM

Does this setup guide assume everyone is on the same router. Or say can anyone in any place in the world play on the server if they wanted to. This would help me because im confused if this will even work for people in other towns...If not then this wont do me any good. If you cant; How do you setup a server that people from other towns could play on?

TULOA · 10-24-2007, 07:04 PM

NVM I asked a person if it would be possible and they said yes. So I no longer need an answer. However if you guys need help with port forwarding here is a link:
[Only Registered and Activated Users Can See Links. Click Here To Register...]

Enjoy and thanks anyways.

PhoenixZeal · 10-24-2007, 07:32 PM

Okay,
I followed every single step to the end. . But when I log in, A box that says "NO MSG" Appears where the server should be.
Help please

PhoenixZeal · 10-24-2007, 10:33 PM

Quote: Originally Posted by PhoenixZeal

Okay,
I followed every single step to the end. . But when I log in, A box that says "NO MSG" Appears where the server should be.
Help please

Heres a screenshot

xadsxadso · 10-25-2007, 11:49 AM

can i ask where ican put the GM commands

**F.O.X** · 10-25-2007, 03:40 PM

Quote: Originally Posted by Mathew5000

i need a lil help... when i click runserver-sql it goes for a few sec then it stops and says

[SQL]: access denied for user 'ragn'@'%' to database 'ragnarok'

[Only Registered and Activated Users Can See Links. Click Here To Register...]

[Only Registered and Activated Users Can See Links. Click Here To Register...]

[Only Registered and Activated Users Can See Links. Click Here To Register...]

Note sorry for makeing so big im to tierd to go through all of the stuff to just post them so people can c them so sorry...

Make sure your MySQL DB > login, ID and pass is set correctly for that, or you can refer for the 1st page and picture section.

Quote: Originally Posted by TULOA

Does this setup guide assume everyone is on the same router. Or say can anyone in any place in the world play on the server if they wanted to. This would help me because im confused if this will even work for people in other towns...If not then this wont do me any good. If you cant; How do you setup a server that people from other towns could play on?

Just change which IP is need to be change to WAN IP, and if you got any router or blocking your way, so you need to port forward it.

Quote: Originally Posted by PhoenixZeal

Okay,
I followed every single step to the end. . But when I log in, A box that says "NO MSG" Appears where the server should be.
Help please

Try the new server file and latest Client.

Quote: Originally Posted by xadsxadso

can i ask where ican put the GM commands

1st off all you need to be a GM or Admin before you can use that GM Commands, if you are GM/Admin now just login in game and type the GM command in the chat box.GM Commands can be found at 1st page.

-F.O.X

Mathew5000 · 02:07 AM

ok i got it to work to the point of loading login and char server's but map all it says is this and it don't go any further stays right here its probably an easy problem but i can't think of where it would

Mathew5000 · 02:08 AM

oops sorry Messed up...

PhoenixZeal · 10-26-2007, 02:11 AM

Which version is that and were can i find them?
I have sakaray v.726 and episode 12(morroc nightmare) of ragnarok
aren't these the latest ones?

or do you think the problem is that iam using kro and not an English version?
cuz i never got this error when i was using the English version

LuckyLoki · 11:02 AM

hello iv been having one problem thats been annoying me and sorry if its kinda a begginer question but er iv tried everything and everything peoples suggested and no matter what i do the characters wont stay, you can log in and play normally everything is fine but then when you go to the character select screen or log out, the characters instantly deleted. i'v looked and couldent find a solution to this problem, and this guides helped with other things. Also how do i make it so that the ip dousent keep changing so i dont have to keep editing the clientinfo, im using a sql server, any help is apreciated ty <3

ok sorry we managed to get the non character saving fixed but still not stable ip, any help would be apreciated ty <3

PhoenixZeal · 10-26-2007, 09:52 PM

Quote: Originally Posted by PhoenixZeal

Which version is that and were can i find them?
I have sakaray v.726 and episode 12(morroc nightmare) of ragnarok
aren't these the latest ones?

or do you think the problem is that iam using kro and not an English version?
cuz i never got this error when i was using the English version

Nevermind i got it fixed.
But now when I try to login as an admin i get "rejected from server" please help

**F.O.X** · 10-27-2007, 06:22 AM

Quote: Originally Posted by LuckyLoki

hello iv been having one problem thats been annoying me and sorry if its kinda a begginer question but er iv tried everything and everything peoples suggested and no matter what i do the characters wont stay, you can log in and play normally everything is fine but then when you go to the character select screen or log out, the characters instantly deleted. i'v looked and couldent find a solution to this problem, and this guides helped with other things. Also how do i make it so that the ip dousent keep changing so i dont have to keep editing the clientinfo, im using a sql server, any help is apreciated ty <3

ok sorry we managed to get the non character saving fixed but still not stable ip, any help would be apreciated ty <3

use no-ip or dynamic ip address, you can find them in Google.

Quote: Originally Posted by PhoenixZeal

Nevermind i got it fixed.
But now when I try to login as an admin i get "rejected from server" please help

Refer to other guide or look at the 1st page at F.A.Q

-F.O.X

thennek501 · 10-27-2007, 03:43 PM

Help..... Im just a newbie..... i followed the Guide Carefully but i cant connect to my game.... it say rejected from the server..... theres no problem with the ip....... i dont know what to do..... pls help.......

PhoenixZeal · 10-27-2007, 04:20 PM

yea but iam using my loop-back ip (127.0.0.1) cuz iam still fixing stuff up
And how can i find lan and wan ip?

Mathew5000 · 10-27-2007, 07:55 PM

Quote: Originally Posted by PhoenixZeal

yea but iam using my loop-back ip (127.0.0.1) cuz iam still fixing stuff up
And how can i find lan and wan ip?

Lan ip - go to start, run type in cmd when a cmd window pops up put in ipconfig and thats ur lan ip the first ip is.

wan ip - just type in [Only Registered and Activated Users Can See Links. Click Here To Register...] theres the link to ur wan ip

so i thought this might help ya out peace