Hi, I have a New York VDS, the panel install the sourcebans and a VDS in another country where I have the game servers, in the logs folder I get it in the file sourcebans.log
which for now lets the banned players in and then reconnects
1.- VDS NEW YORK - UBUNTU 18.04 - PANEL WEB SOURCEBANS
2.-VDS ANOTHER COUNTRY - UBUNTU 16.04 SERVER - SERVERGAMES
ERROR:
L 01/26/2020 - 19:16:07: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 19:37:29: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 20:59:01: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 22:04:53: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 22:31:16: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 22:49:22: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 23:07:20: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/27/2020 - 00:09:50: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/27/2020 - 02:02:33: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/27/2020 - 11:03:34: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/27/2020 - 21:33:03: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during quer
LOST CONNECTION TO MYSQL- SOURCEBANS
-
- New to forums
- Posts: 1
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Mon Jan 27, 2020 9:05 pm
Re: LOST CONNECTION TO MYSQL- SOURCEBANS
That information doesn't say too much, unfortunately -- you'll need further data.
Is the MySQL daemon up the entire time?
Do you have any mechanism that would kill the connection on the MySQL side?
In long-term ping or MTR tests, are you seeing any packet loss between the two endpoints?
Is the game server or MySQL server experiencing high CPU or memory usage, or is it struggling in any other way?
Are the specific queries involved taking too long to execute, such that they time out?
Is the MySQL daemon up the entire time?
Do you have any mechanism that would kill the connection on the MySQL side?
In long-term ping or MTR tests, are you seeing any packet loss between the two endpoints?
Is the game server or MySQL server experiencing high CPU or memory usage, or is it struggling in any other way?
Are the specific queries involved taking too long to execute, such that they time out?