{"action":"created","issue":{"url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/343","repository_url":"https://api.github.com/repos/ThrivingVentures/ServerGuard","labels_url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/343/labels{/name}","comments_url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/343/comments","events_url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/343/events","html_url":"https://github.com/ThrivingVentures/ServerGuard/issues/343","id":150276073,"number":343,"title":"SG seems to cause our server to hang if a player joins after a certain amount of time","user":{"login":"smt923","id":3849041,"avatar_url":"https://avatars.githubusercontent.com/u/3849041?v=3","gravatar_id":"","url":"https://api.github.com/users/smt923","html_url":"https://github.com/smt923","followers_url":"https://api.github.com/users/smt923/followers","following_url":"https://api.github.com/users/smt923/following{/other_user}","gists_url":"https://api.github.com/users/smt923/gists{/gist_id}","starred_url":"https://api.github.com/users/smt923/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smt923/subscriptions","organizations_url":"https://api.github.com/users/smt923/orgs","repos_url":"https://api.github.com/users/smt923/repos","events_url":"https://api.github.com/users/smt923/events{/privacy}","received_events_url":"https://api.github.com/users/smt923/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-04-22T05:55:08Z","updated_at":"2016-04-30T20:33:44Z","closed_at":null,"body":"So our Nutscript 1.1 server works fine for the first 5/10 minutes with serverguard on but after that rough amount of time if someone joins it can cause the server to hang, not crash or spit out any errors or anything, I'm still able to type at the console I just get no response.\r\n\r\nUbuntu 14.04 lts, latest nutscript/serverguard/etc, wish I could provide some sort of log or something but there's genuinely no output at even if the server is just left to 'hang', only found out it was SG by trying everything one by one until it worked\r\n\r\nA bit more clarification: a few months ago this setup worked perfectly fine so its probably something changed in the last 6~ or so months, there isn't some sort of extra port SG needs forwarded to connect too for verification/monitoring is there? firewall/network setup got a lot more secure and complex recently (but again, without SG it all works fine, and SG works fine for the the entire time until someone joins later on)\r\n\r\nAfter some more testing the server does come back for a second or so (after 10-20 minutes) but then freezes right up again, still no errors or anything useful, after a few more minutes it seems like the server refuses to connect to SQL and from that point on it doesn't freeze (but also doesnt' work as no sql) so this might be a mysql issue (mysqloo 8.1)\r\n\r\nkinda big edit: so switching to tmysql4 revealed a lot, when the server would hang with mysqloo it now works fine, however serverguard mysql 'things' (saving ranks, showing who is what rank etc) do not work at all, and infact even the database made with mysqloo that did save just fine is now getting wiped (even after setting my self to founder, refreshing the ranks list would remain empty) every time it WOULD have froze on mysqloo (so 5-10 minutes after a restart, on any player join) hopefully this helps you guys narrow down the issue, I have no idea whats going on - now going to test sqlite, hopefully it works so I can just stick with that for now\r\n\r\nWell sqlite seem to work fine, at least so far, so i guess it's something to do with serverguard's sql and I guess nutscript? else I have no idea whats wrong\r\n\r\n**edit:** the latest version from scriptfodder does not fix this issue for me"},"comment":{"url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/comments/215993223","html_url":"https://github.com/ThrivingVentures/ServerGuard/issues/343#issuecomment-215993223","issue_url":"https://api.github.com/repos/ThrivingVentures/ServerGuard/issues/343","id":215993223,"user":{"login":"SomeSortOfDuck","id":3054653,"avatar_url":"https://avatars.githubusercontent.com/u/3054653?v=3","gravatar_id":"","url":"https://api.github.com/users/SomeSortOfDuck","html_url":"https://github.com/SomeSortOfDuck","followers_url":"https://api.github.com/users/SomeSortOfDuck/followers","following_url":"https://api.github.com/users/SomeSortOfDuck/following{/other_user}","gists_url":"https://api.github.com/users/SomeSortOfDuck/gists{/gist_id}","starred_url":"https://api.github.com/users/SomeSortOfDuck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SomeSortOfDuck/subscriptions","organizations_url":"https://api.github.com/users/SomeSortOfDuck/orgs","repos_url":"https://api.github.com/users/SomeSortOfDuck/repos","events_url":"https://api.github.com/users/SomeSortOfDuck/events{/privacy}","received_events_url":"https://api.github.com/users/SomeSortOfDuck/received_events","type":"User","site_admin":false},"created_at":"2016-04-30T20:33:44Z","updated_at":"2016-04-30T20:33:44Z","body":"Sure, that'd be great if it's no trouble to you. The more info we can get the better."}}