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

Mysql and Server no connection?


Post New Thread Reply   
 
Thread Tools Display Modes
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
samsah
AlliedModders Donor
Join Date: Mar 2008
Location: Finland
Old 05-13-2015 , 09:52   Re: Mysql and Server no connection?
Reply With Quote #2

In databases.cfg use "127.0.0.1" instead of "localhost"
__________________

Last edited by samsah; 05-13-2015 at 09:52.
samsah is offline
Robin955
Veteran Member
Join Date: Jun 2013
Old 05-13-2015 , 10:30   Re: Mysql and Server no connection?
Reply With Quote #3

well if its a paid webhost im sure there is a link too you can use instead of localhost
Robin955 is offline
Simca
Senior Member
Join Date: Feb 2012
Old 05-13-2015 , 10:53   Re: Mysql and Server no connection?
Reply With Quote #4

Not paid. Will try 127.0.0.1
Simca is offline
Simca
Senior Member
Join Date: Feb 2012
Old 05-13-2015 , 11:01   Re: Mysql and Server no connection?
Reply With Quote #5

Umm it works with 127.0.0.1 lol..

Last edited by Simca; 05-13-2015 at 11:58.
Simca is offline
Simca
Senior Member
Join Date: Feb 2012
Old 05-13-2015 , 11:55   Re: Mysql and Server no connection?
Reply With Quote #6

But is there a bug with 1.4.11? I set up myself as root server and web and i'm not admin ingame. Admin file is blank and is overwritten when i try to edit it.
Simca is offline
Smith_EG
Member
Join Date: Nov 2014
Old 05-25-2015 , 02:31   Re: Mysql and Server no connection?
Reply With Quote #7

I've got the same exact problem, has anyone here figured out why only the admin group is updated but not admin.cfg?
Smith_EG is offline
DarkDeviL
SourceMod Moderator
Join Date: Apr 2012
Old 05-25-2015 , 16:22   Re: Mysql and Server no connection?
Reply With Quote #8

Quote:
Originally Posted by Simca View Post
But is there a bug with 1.4.11? I set up myself as root server and web and i'm not admin ingame. Admin file is blank and is overwritten when i try to edit it.
Quote:
Originally Posted by Smith_EG View Post
I've got the same exact problem, has anyone here figured out why only the admin group is updated but not admin.cfg?
SourceBans is not a synchronization tool.

If your MySQL server is always up and running (like it should, hopefully!), then SourceBans will NEVER use any files at all.

If you wish to use files, don't use SourceBans.
__________________
Mostly known as "DarkDeviL".

Dropbox FastDL: Public folder will no longer work after March 15, 2017!
For more info, see the [SRCDS Thread], or the [HLDS Thread].
DarkDeviL is offline
Reply


Thread Tools
Display Modes

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 12:37.


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