[Guide] How to make a Zero Server [Detailed]

[[GM]Death[PM]]

Did you add the ports into your router settings?

[lamqkhanh]

done.
fire wall off.

[[GM]Death[PM]]

So I'm guessing you have the server up and running? And for a limited time. I will help people set up their servers. Just PM me your skype name, I'll add you and help you through team viewer.

[idlemonkey]

some people should actually use these files instead of trying to use mine lol ... mine do have a lot of mistakes in them and its just generally better to start with something more basic ... adding things will be a lot easier that way

[[GM]Death[PM]]

I agree idle. People if your going to make a server, Try to do it legit. You get no where but in trouble when you try to take from others. There is no point in developing a server if you can't make or edit things your self. We have to grow as a community if Zero is ever going to go any further.

[DJjayson]

help it says server down...help!!!

[idlemonkey]

Originally Posted by DJjayson

help it says server down...help!!!

check your connections with netstat dont forget to forward your listen ports

[DJjayson]

Originally Posted by idlemonkey

check your connections with netstat dont forget to forward your listen ports

sir help...the thing is i dont want to get the server online i just want on lan or my own...i just wanna see it running on my pc



help

[idlemonkey]

Originally Posted by DJjayson

sir help...the thing is i dont want to get the server online i just want on lan or my own...i just wanna see it running on my pc

lol you have to get it online somewhat to use it on your pc ....

if you just open it the way it was released then use 127.0.0.1 in your client with the same server name then it will connect for a completely local server on your pc

according to your configurations though (assuming that the gameserver ip same one you used for the accserver) you should use 192.168.1.2 (gameserver ip)according to your picture as the ip in worlds.dat
also might wanna open those ports in your firewall if u plan on connecting with ur lan ip instead of your loopback ip as you have it configured
but like i said check your connections with netstat and your error logs to show where it is having a problem

[DJjayson]

here is my problem please help

i use my local ip add i just change 127.0.0.1 to my local ip 192.168.1.2...do i need to change it back to 127.0.0.1?

Originally Posted by idlemonkey

lol you have to get it online somewhat to use it on your pc ....

if you just open it the way it is then use 127.0.0.1 in your client with the same server name then it will connect for a completely local server on your pc
but like i said check your connections with netstat and your error logs to show where it is having a problem

i use my local ip add i just change 127.0.0.1 to my local ip 192.168.1.2...do i need to change it back to 127.0.0.1?

[idlemonkey]

your accserver and gameserver ips should be the same either one 127.0.0.1 or the other 192.168.2.1 or your external ip not a mixture of the whole lot lol and u have to allow that port in your firewall (not router for local but definately firewall for some of the settings)
and "check your ports with nestat"if it doesnt work one way try the other ...

specificly netstat -ano in your comand prompt ... to see which connection is having trouble
Im guessing your accountserver on port 9958 is where it stops because you have login and just not able to connect from the outside ....
would probably show in your comand line like established to 9865 estabilished then closed on 9958 and listening on 5816 with no connections

because port 5816 is listening in a different place in your configs it seems than the accserver ip

also check your error logs my guess is you will have one that says hwc failed ... which means just that hardware check failed lol ... which means it cant connect to the outside hardware but it can connect to itself ...

[DJjayson]

Originally Posted by idlemonkey

your accserver and gameserver ips should be the same either one 127.0.0.1 or the other 192.168.2.1 or your external ip not a mixture of the whole lot lol and u have to allow that port in your firewall (not router for local but definately firewall for some of the settings)
and "check your ports with nestat"if it doesnt work one way try the other ...

specificly netstat -ano in your comand prompt ... to see which connection is having trouble
Im guessing your accountserver on port 9958 is where it stops because you have login and just not able to connect from the outside ....
would probably show in your comand line like established to 9865 estabilished then closed on 9958 and listening on 5816 with no connections

because port 5816 is listening in a different place in your configs it seems than the accserver ip

also check your error logs my guess is you will have one that says hwc failed ... which means just that hardware check failed lol ... which means it cant connect to the outside hardware but it can connect to itself ...

this is for the netstat ang for the log error i dont see any....is says game account database connect succeed. -- Thu Nov 14 11:20:35 2013 and for the system log Async DB error:No Database Selected when execute:INSERT DELAYED IGNORE dump_attack VALUES(0, 436605, NULL, 47, 0, 24164, 67). -- Thu Nov 14 11:15:12 2013
Invalid var_name in CLuaScript::GetInt(cheatcode) -- Thu Nov 14 11:20:58 2013

oh and one thing i dont have a firewall i turn it off... so how is this happening? i already change it 127.0.0.1 to my local ip .... and i got a new error on MSGserver it says..the server is over close after all 3 sec... and is closes ...help

[idlemonkey]

the log you want to look in is tpl log in the accserver log folder
a successful connection in this log file will look like this
hwc passed
tpl database connect succeed
account database connect succeed

your image of netstat shows only the gameserver listening ports not the accountserver listen ports
which is what has the problem ....
you notice the only ports you showed your system listening on are 9865 3306 and 5816 .... it should be listening on 8563 and 9958 at least locally
8653 is the port that connects your gameserver to the npc server (usually locally) and 9958 is the port that connects your accountserver to the gameserver (usually locally)

the error you showed is for a portion of your gameserver files that are not attached to any database in your config files .... namely the dump attack settings which are kinda important if u dont want a rollback when your server loses connection
these sorts of errors from mysql are easy to debug because they speak english,....
says right in the error what the problem with that one is ... that you didnt select a database or pointed it to one that isnt there.
this has nothing to do with your connection issue though so is not relevant to this discussion

also noting your other posts ... you keep pushing outdated threads for people who tried to cause a problem with my server and then asking me for help with "your" server ....
where exactly is the incentive for me to help you?
stop doing that if you want continued help from me

pushing the thanks button for the help I have given u thus far would be a good gesture as well

[DJjayson]

Originally Posted by idlemonkey

the log you want to look in is tpl log in the accserver log folder
a successful connection in this log file will look like this
hwc passed
tpl database connect succeed
account database connect succeed

suspect connection(192.168.1.2) without data, socket closed. -- Thu Nov 14 13:38:07 2013

unknow msg rcved. type:1002, size:40 -- Thu Nov 14 13:38:07 2013

////////////////////////////////////////////////////////////////////////// -- Thu Nov 14 13:38:36 2013

AccountServer Start up: 13:38, November 14, 2013 -- Thu Nov 14 13:38:36 2013

////////////////////////////////////////////////////////////////////////// -- Thu Nov 14 13:38:36 2013

hwc failed. -- Thu Nov 14 13:38:38 2013

Test(192.168.1.2) login succeed. -- Thu Nov 14 13:39:19 2013

add info of server Test, ip:192.168.1.2, port:5816 -- Thu Nov 14 13:39:19 2013

Test login assure. -- Thu Nov 14 13:39:20 2013

Test(192.168.1.2) disconnected passtive. -- Thu Nov 14 13:43:27 2013

log shows this ... how to i do with this

Originally Posted by idlemonkey

your image of netstat shows only the gameserver listening ports not the accountserver listen ports
which is what has the problem ....
you notice the only ports you showed your system listening on are 9865 3306 and 5816 .... it should be listening on 8563 and 9958 at least locally
8653 is the port that connects your gameserver to the npc server (usually locally) and 9958 is the port that connects your accountserver to the gameserver (usually locally)

so how do i make the ports listen .. i have no idea why post 9958 and 8563 or 9958 and 8563 can be change to the posts that are ok (9865 3306 and 5816)

Originally Posted by idlemonkey

the error you showed is for a portion of your gameserver files that are not attached to any database in your config files .... namely the dump attack settings which are kinda important if u dont want a rollback when your server loses connection
these sorts of errors from mysql are easy to debug because they speak english,....

so what do would i do with that error(just give me lift-up) and where do i have to edit this errors ...

Originally Posted by idlemonkey

also noting your other posts ... you keep pushing outdated threads for people who tried to cause a problem with my server and then asking me for help with "your" server ....
where exactly is the incentive for me to help you?
stop doing that if you want continued help from me

pushing the thanks button for the help I have given u thus far would be a good gesture as well

im so sorry for that sir idle i dont really know ... im just trying to make a pserver so badly im so sorry again si please help me

[idlemonkey]

hwc failed. -- Thu Nov 14 13:38:38 2013

read up and look at what i said if you get this error

one of your ips in one of your config files is different from the others ...
my guess is its the "mapped ip address=" in getconfig

also looks like you have a database permissons error