AlliedModders - Can't connect to local MySQL server through socket '/tmp/mysql.sock'

AlliedModders (https://forums.alliedmods.net/index.php)

- SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)

- - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (https://forums.alliedmods.net/showthread.php?t=316833)

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

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.smx] Database 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: [SM] Exception reported: Invalid database Handle 0 (error: 4)

L 06/12/2019 - 20:34:54: [SM] Blaming: sbpp_sleuth.smx

L 06/12/2019 - 20:34:54: [SM] Call stack trace:

L 06/12/2019 - 20:34:54: [SM]   [0] SQL_TQuery

L 06/12/2019 - 20:34:54: [SM]   [1] Line 170, D:\MegaSync\Projects\Sourcemod\scripting\sbpp_sleuth.sp::OnClientPostAdminCheck

L 06/12/2019 - 20:34:54: [sbpp_comms.smx] Connecting 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

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Try changing the host in your databases.cfg file to use the IP address instead.

You're most likely using the hostname (e.g. "localhost") in the cfg, in that case, change to the IP version of "127.0.0.1" instead.

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Quote:

Originally Posted by DarkDeviL (Post 2655413)

the MYSQL server is from another host..

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Quote:

Originally Posted by benmassey (Post 2655463)

the MYSQL server is from another host..

Quote:

Originally Posted by benmassey (Post 2655359)

Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).

^

Then configure your game server / systems properly to run through that that non-local "another host" server, ...