Creating a Ragnarok eAthena Server with SQL

[ChibiEbil]

Originally Posted by dyera1996

my lockal IP is every time changed when i login or turn on the modem!
and when i still without close the modem and trying to run the server:-
1\ the runserver-sql.bat it workking!
2\ i dont know how can i use it to run the Hexed client and dunno where can i find the Hexed.
3\ i got 1 hexed client after that then:-
when i run it it's not english language it's anuther lang i cant understand + when i try to login the server i got "Rejected From The Server" So plz guy's help MehT_T!

You need a DNS like no-ip.com. It updates your the DNS with your IP and you are using the DNS instead of the IP as the address for you server.
Look at eathena how to diff or hex a client, its simple.
Also you will find the fulldata or language data in eathena board.
rejected from the server could have many reasons.
What are your console logs showing?

[dothers]

i already do what is given on he's ragnarok setup but when i open the
runserver-sql it pop up an cmd and then i got an erroer there

C:\Windows\System32\cmd.exe - mapserv-sql.bat
Error : Make connection : connection failed <socket #5, code 111>!

C:\Windows\System32\cmd.exe - charserv-sql.bat
Error : Make connection : connection failed <socket #5, code 111>!


it looks like this

[Leiard]

its mostly the router
did you forward the ports?
what about firewall ports or aplication allowed?

[iStar68]

Help me with my problem, i already port forward ( 6900 and 6901 )
i tried switching the 2 ports but this error persist.



Thanks in advance!

Btw, im using router.

[Leiard]

Firewall checked you need to allow them there too
also you need to forward the ports in both ways in and outbound
the ports
5121
6121
6900

[iStar68]

Another problem came up..





Thanks in advance

[Leiard]

The loginserver gives you already the answere
the user at column 1 is to long

[iStar68]

Originally Posted by Leiard

The loginserver gives you already the answere
the user at column 1 is to long

Can you explain more clearly what should i do?!

Thanks, appreciated much!

Latest guide link would help, Trans job or with 3rd job class. =)

[Leiard]

You setup a S1 Superuser
normaly it is S1 and his PW is P1
for security reasons you hav edited it
it seems like your user for S1 is now to long
go to your SQL db and short the S1 username and pw to something else
dont forget to edit it also in the configs of map and char server

for a guide you need to take a look at eathena forums
but one more advise
if you arent able to understand the warnings your server gives out
dont try 3rd class
they are buggy and there are much more errors at console than in eAthena itself

[iStar68]

Okay..

Thanks, ill try to set up my soon to be server again..

Appreciated much for your replies mate. =)

btw...
mate do you know how to get this done..
im currently playing at this newly launched RO server.

i think i know what's the user and pass of the admin
but it keeps rejecting me from the server. ( Reject from the server )

Thanks in advance =)

[Leiard]

so if you login with client you get a reject from server right?
then it is normaly the Packet version
you need to edit it
first in DB folder the packet_db.txt
there is a line

packet_db_ver: 26

uncomment it with //
than it looks like this

//packet_db_ver: 26

and than there is a line

//packet_db_ver: default

change it to

packet_db_ver: default

after that you need to edit your SRC code
open src/common/mmo.h with editor
find this line

#ifndef PACKETVER
	//#define PACKETVER	20100721
	#define PACKETVER 20100721
#endif

you see the numbers there
those numbers are the date of your game.exe
edit them to the date of your used exe
the date is year month day
in this sample this means year 2010 month 07 day 21
after changing this you need to recompile your server to make this work

so after you edit all this you need to change your clientinfo.xml
there must be a line called version or serverversion
currently not sure about it ^^
there is the server version also
I have changed it to 27 cause its the newest one
think so ^^
hope I could help you with that ^^

[iStar68]

Problem Solved!!! Thanks mate!!!

[rj111289]

please. help when i create an account is say uregistered/ rejected from server. i tried to follow the posted guides from LEIARD. and when i tried to go to mmo.h and packet_db. i cant find the #ifndr,packet_db_ver? please help.

please help? now my problem is server block?. what guide can you give me?

[niyuki1016]

Is there a way you can help me or advise me in creating my own server? >:

[mraquaman]

hello everyone! amazing thread and credit to all the help full people!!
well i have a few issues of my own that i might of missed in the thread but i thought i would just make my own.

im all done with making my ro but ingame i cant see monsters npcs and portals wat do i need to fix it can u pls show pics of file and wat i need to change or good detail on wat i need to do thank u very much!!