View Single Post
Author Message
benmassey
Member
Join Date: Dec 2018
Old 06-12-2019 , 15:45   Can't connect to local MySQL server through socket '/tmp/mysql.sock'
Reply With Quote #1

hey guys, I hope someone can help me here, so I've installed a new server in my new dedicated server
everything works just fine except sourceban I'm using version 1.6.3 with theme star,
I'm using centos 7.2
php7.2 (web)

Description:

when I try to set admin, the web gives me success message
but when I check in logs I see that error:

Sourceban error:

PHP Code:
L 06/12/2019 20:34:35: [sbpp_main.smxDatabase failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). See Docs: https://sbpp.github.io/docs/ 
Error log:
PHP Code:
L 06/12/2019 20:34:54: [SMException reportedInvalid database Handle 0 (error4)
L 06/12/2019 20:34:54: [SMBlamingsbpp_sleuth.smx
L 06
/12/2019 20:34:54: [SMCall stack trace:
L 06/12/2019 20:34:54: [SM]   [0SQL_TQuery
L 06
/12/2019 20:34:54: [SM]   [1Line 170D:\MegaSync\Projects\Sourcemod\scripting\sbpp_sleuth.sp::OnClientPostAdminCheck
L 06
/12/2019 20:34:54: [sbpp_comms.smxConnecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) 

I tried to log in to MySQL throw terminal and I succeed to log in...


what I tried to do to fix that:

change soket (socket=/var/lib/mysql/mysql.sock)
open port for mysql (3306)
restart service
benmassey is offline