NpcServer Error

10/22/2013 06:31 kevinmace#1
Can Someone please tell me what is this error :mad:
[Only registered and activated users can see links. Click Here To Register...]
20:14:40¡¾MapGroup pipe full, refuse accept new socket connect!¡¿
20:14:40¡¾MapGroup pipe full, refuse accept new socket connect!¡¿
20:14:41¡¾MapGroup pipe full, refuse accept new socket connect!¡¿
20:14:41¡¾MapGroup pipe full, refuse accept new socket connect!¡¿
and this
classiceo(IP) disconnected.
info of server classiceo is deleted.
and this
[Only registered and activated users can see links. Click Here To Register...]
when irestart my vps all this is gone
but it comes back in hour or 2 as a max
10/22/2013 08:20 .Horror.#2
Someone flooded your network in DB meaning in your accounts on navicat, there is too many as for the npc server that could be low memory or shared networking
~Your Horrors
10/22/2013 08:21 kevinmace#3
thanks i'll talk to the vps company now
10/22/2013 15:04 idlemonkey#4
Quote:
Originally Posted by kevinmace View Post
thanks i'll talk to the vps company now
for most vps companies as long as your server is online it is not their concern if you are being attacked on the operating system level
...in an unmanaged environment "it is your responsibility" to secure your server from threats like this.


the reason someone is able to do this to you easily can be found on your register page ... if you dont use any kind of security on your forms(ie captcha email validation test question botlist-blocking seperate databases for accounts etc)
this will constantly happen. and will be extremely difficult to manage as long as you have your mysql port open to the world or open to a service that allows unlimited consecutive connections like you do now (ie: your website and your computer )
you can view the people connected to your site ... I am sure that will show one or two ips making multiple connections to your register page blocking these hosts will "temporarily" help the issue
and tell you who it is.

as your host is now known as "able to be exploited" changing your ip address and securing your server more will "not" work. you should close your mysql port entirely for a while (at the very least) and setup your system to register and allow you access to the database in some other way

Quote:
Originally Posted by .Horror. View Post
Someone flooded your network in DB meaning in your accounts on navicat, there is too many as for the npc server that could be low memory or shared networking
~Your Horrors
if he had low memory it would still load just very slow not crash ... you can host this game on a server with 512 mb of ram if you wanted ....also looks like his second example is from the account server ;) too many connections means simply that, "too many connections"
"shared networking" would not cause this either lol if someone had more than one server and had one system using up more bandwith than the rest it would cause the other systems to lag and lose connection not have extra connections
QOS settings resolve this issue and as far as i know any host would use such settings so that another vps in their network "couldnt" use up enough bandwith to affect the others in their network. (or they wouldnt have very many customers for long)
Quote:
Originally Posted by kevinmace View Post
when irestart my vps all this is gone
but it comes back in hour or 2 as a max
okay you dont need to restart your vps you can flush hosts, reset your connection, close port 3306 temporarily, or kill mysql and restart it to do this. Best option though would be to block the offending ip even if it is your own website for a while until the system recovers , cant make too many connections if they cant connect ;)


you come back online after reset with nothing from before because with the connection overloaded the legitimate hosts(gameserver and accserver) are not connecting to be saved and are waiting in line when you reboot

also note : EVERY time you restart your server or mysql or do a maint you should repair your database to prevent dataloss (ie all is gone when you get back)
10/23/2013 00:48 PowerChaos#5
Quote:
Originally Posted by kevinmace View Post
Can Someone please tell me what is this error :mad:
[Only registered and activated users can see links. Click Here To Register...]
20:14:40¡¾MapGroup pipe full, refuse accept new socket connect!¡¿
20:14:40¡¾MapGroup pipe full, refuse accept new socket connect!¡¿
20:14:41¡¾MapGroup pipe full, refuse accept new socket connect!¡¿
20:14:41¡¾MapGroup pipe full, refuse accept new socket connect!¡¿
and this
classiceo(IP) disconnected.
info of server classiceo is deleted.
and this
[Only registered and activated users can see links. Click Here To Register...]
when irestart my vps all this is gone
but it comes back in hour or 2 as a max
the quote is because of mysql get to many error connections
then mysql just locks your database so no more connections can be made

try changing the ip to localhost ( for the database) , that solves the problem for mysql

the other errors i got no idea , but probaly also related to mysql
see below example of how it need to look
Code:
db_host = 127.0.0.1
db = your db
pass = your pass
and this is wrong
Code:
db_host = 123.456.789.012
db = your db
pass = your pass
also check the mysql logs that are generated to see what cause that error exactly

Greetings From PowerChaos