Hello. I encounter an error in my logs when I add a ban via sm_addban
L 06/14/2020 - 13:58:22: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 06/14/2020 - 13:58:22: [SM] Blaming: sbpp_main.smx
L 06/14/2020 - 13:58:22: [SM] Call stack trace:
L 06/14/2020 - 13:58:22: [SM]  SQL_TQuery
L 06/14/2020 - 13:58:22: [SM]  Line 686, .\sbpp_main.sp::CommandAddBan
I am using the same MySQL DB for 2 servers, with the same user and password.
The first server is able to add bans fine, but the second isn't. The logfile for SourceBans doesn't contain any connection errors (it contains nothing), so I assume my server is connected to my remote MySQL DB.
But for debugging sake, I used sb_debug_connection.php provided in the root folder of SourceBans web:
[+] SourceBans "Error Connecting()" Debug starting for server 126.96.36.199:27015
[+] Trying to establish UDP connection
[+] UDP connection successfull!
[+] Trying to write to the socket
[+] Successfully requested server info. (That doesn't mean anything on an UDP stream.) Reading...
[+] Got an response! Server: [QuadFrag] Casual Competitive | Prime | 128t | !rank !ws !knife !gloves
[+] Trying to establish TCP connection
[+] TCP connection successfull!
[+] Trying to write to TCP socket and authenticate via rcon
[+] Successfully sent authentication request. Reading...
[+] Got an response!
[+] Password correct!
I am not entirely sure why I am unable to write to my remote MySQL DB.
Any help is appreciated, thank you!