Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

connection related issue.

Initiate Mage
Joined
Mar 9, 2017
Messages
61
Reaction score
2
So far I've noticed a occasional issue popping up with my server. I have found a solution that simi-works to resolve it however there is no way to determine when it has or will happen again so I have no way to really automate the fix. What I have noticed is occasionally somebody will have a connection issue where they can not connect to the server. If I run cabal_status it shows that the server is infact online. however, if I look into the logs files it does not show any connection what so ever that they even attempted to connect

The solution I currently have is to do a full reboot, immediately login, manually stop the server and restart it again. its almost an exact science at this point. Every time this issue happens I can simply do this to solve it. However the issue keeps cropping up.

Currently the server is running on a wired connection in my home(yes I do have the network capacity to support it and yes I do have the resources in hardware for it to run stable. I even have a backup power source and replacement parts incase of a part failing, benefits of an in-home PC repair service)

Currently the server is running on a dual-core CPU with 16gb of ram and 2HDDs in raid. Server OS is CentOS7 and the mssql is hosted on the same machine as the server itself. everything is properly portforward correctly excluding the DB port which is purposefully running to a dummy box(local connected rasberry Pi running as a honeypot)

so pretty much currently there is a single box running the server with everything it needs. What I need help with is identifying what is causing this drop in connectivity between client and server. I don't THINK that its related to the router/modem, reason being the server shows that it is online even when this issue is happening. aswell I can easily still make connections to the DB itself and perform changes actions and such. I don't know if this is fully an application based issue either. I know its something happening on my end tho for sure
 
Initiate Mage
Joined
Mar 9, 2017
Messages
61
Reaction score
2
I'm actually running everything on a single OS. the SQL DB is on the same machine as the Game Server is. connecting to DB via localhost. Less resources required and no need to deal with windows issues or extra ports being opened and managed. tho I'll look into each logfile next time it happens
 
Upvote 0
Initiate Mage
Joined
Mar 9, 2017
Messages
61
Reaction score
2
I haven't found anything related to CPU stuck yet, however some rat has been trying to get in with ALOT of failed attempts to the servers DB.

Going to continue looking, also I find it funny that even in MMOs people try alot of malicious stuff lol. I think I'm going to check the firewall now and block access for the SQL outside of lan

Jul 28 13:16:34 localhost sqlservr: 2018-07-28 13:16:34.00 Logon Login failed for user 'ps'. Reason: Could not find a login matching the name provided. [CLIENT: IP HIDDEN]Jul 28 13:16:35 localhost sqlservr: 2018-07-28 13:16:35.79 Logon Error: 18456, Severity: 14, State: 5.
 
Upvote 0
Initiate Mage
Joined
Mar 9, 2017
Messages
61
Reaction score
2
I believe the issue has be resolved but unsure. I think it was mostly just dumb cunts trying to bruteforce into the DB thinking that I was using default credentials. I counted around 40+ different IPs trying to get in with failed attempts

right now I'm currently just seeing this repeated over and over again. The only thing concerning is the line below with

Jul 30 14:06:29 localhost dbus[653]: [system] Successfully activated service 'org.freedesktop.nm_dispatcher'


Jul 30 14:06:28 localhost dhclient[15907]: DHCPREQUEST on enp1s0 to IP HIDDEN port HIDDEN (xid=0x631de8c5)
Jul 30 14:06:28 localhost dhclient[15907]: DHCPACK from IP HIDDEN (xid=0x631de8c5)
Jul 30 14:06:28 localhost NetworkManager[1188]: <info> [1532973988.9894] dhcp4 (enp1s0): address IP HIDDEN
Jul 30 14:06:28 localhost NetworkManager[1188]: <info> [1532973988.9894] dhcp4 (enp1s0): plen 24 (HIDDEN)
Jul 30 14:06:28 localhost NetworkManager[1188]: <info> [1532973988.9894] dhcp4 (enp1s0): gateway IP HIDDEN
Jul 30 14:06:28 localhost NetworkManager[1188]: <info> [1532973988.9895] dhcp4 (enp1s0): lease time 3600
Jul 30 14:06:28 localhost NetworkManager[1188]: <info> [1532973988.9895] dhcp4 (enp1s0): nameserver 'IP HIDDEN'
Jul 30 14:06:28 localhost NetworkManager[1188]: <info> [1532973988.9896] dhcp4 (enp1s0): nameserver 'IP HIDDEN'
Jul 30 14:06:29 localhost NetworkManager[1188]: <info> [1532973988.9896] dhcp4 (enp1s0): nameserver 'IP HIDDEN'
Jul 30 14:06:29 localhost NetworkManager[1188]: <info> [1532973988.9896] dhcp4 (enp1s0): state changed bound -> bound
Jul 30 14:06:29 localhost systemd: Starting Network Manager Script Dispatcher Service...
Jul 30 14:06:29 localhost dbus[653]: [system] Activating via systemd: service name='org.freedesktop.nm_dispatcher' unit='dbus-org.freedesktop.nm-dispatcher.service'
Jul 30 14:06:29 localhost dhclient[15907]: bound to [IP HIDDEN] -- renewal in 1464 seconds.
Jul 30 14:06:29 localhost dbus[653]: [system] Successfully activated service 'org.freedesktop.nm_dispatcher'
Jul 30 14:06:29 localhost systemd: Started Network Manager Script Dispatcher Service.
Jul 30 14:06:29 localhost nm-dispatcher: req:1 'dhcp4-change' [enp1s0]: new request (3 scripts)
Jul 30 14:06:29 localhost nm-dispatcher: req:1 'dhcp4-change' [enp1s0]: start running ordered scripts...
 
Upvote 0
Initiate Mage
Joined
Mar 9, 2017
Messages
61
Reaction score
2
hmmmm, seems the issue has not cropped back up YET. is it possible that somebody trying to bruteforce their way in caused the DB software to cut all current connections and the server simply didn't bother to re-establish thinking it was still connected?
 
Upvote 0
Joined
Aug 3, 2011
Messages
963
Reaction score
506
hmmmm, seems the issue has not cropped back up YET. is it possible that somebody trying to bruteforce their way in caused the DB software to cut all current connections and the server simply didn't bother to re-establish thinking it was still connected?

Update your firewall, remove all access on incoming and outgoing connection. Create a new rule and allow specific IP and ports.
 
Upvote 0
Initiate Mage
Joined
Mar 9, 2017
Messages
61
Reaction score
2
Nah no need when db isn't external. Now its just dropping any attempt before it reaches the machine at all. only thing able to access it is the server itself



Nah no need when db isn't external. Now its just dropping any attempt before it reaches the machine at all. only thing able to access it is the server itself
 
Upvote 0
Back
Top