Raised This Month: $51 Target: $400
 12% 

Mysql and Server no connection?


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
Simca
Senior Member
Join Date: Feb 2012
Old 05-13-2015 , 08:46   Mysql and Server no connection?
Reply With Quote #1

Ubuntu + MySql + Apache2 + Webmin + Sourcebans 1.4.11 all on the same computer.
I also tried 2.0.

Game server can't connect with mysql. Sourceban panel is working fine. Banned myself ip and steamid and i can still join my server.

Code:
L 05/13/2015 - 21:25:32: [sourcebans.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). See FAQ: http://www.sourcebans.net/node/20
L 05/13/2015 - 21:25:36: [sourcebans.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). See FAQ: http://www.sourcebans.net/node/20
L 05/13/2015 - 21:26:50: [sourcebans.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). See FAQ: http://www.sourcebans.net/node/20
L 05/13/2015 - 21:26:55: [sourcebans.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). See FAQ: http://www.sourcebans.net/node/20
L 05/13/2015 - 21:27:06: [sourcebans.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). See FAQ: http://www.sourcebans.net/node/20
In Webmin I made a seperate user 'server' and gave it any host. In Mysql Server Configuration MySQL server listening address is set to any.

Code:
"Databases"
{
"driver_default"		"mysql"
	
	"sourcebans"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcebans"
		"user"				"server"
		"pass"				"blank"
		//"timeout"			"0"
		"port"			"3306"
	}

	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}

	"clientprefs"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"clientprefs-sqlite"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	

}
Code:
         [11] <FAILED> file "connect.ext.so": /home/l4d2/server/left4dead2/addons/sourcemod/extensions/connect.ext.so: cannot open shared object file: No such file or directory
         [12] Socket (3.0.1alpha): Socket extension for SourceMod
         [13] MySQL-DBI (1.6.0-dev+4284): MySQL driver implementation for DBI
         [14] SQLite (1.6.0-dev+4284): SQLite Driver

Last edited by Simca; 05-13-2015 at 09:31.
Simca is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:12.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode