Raised This Month: $ Target: $400
 0% 

sourcebans can't connect to local mysql server.


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
HighGuy
Junior Member
Join Date: Sep 2015
Old 09-14-2015 , 05:56   sourcebans can't connect to local mysql server.
Reply With Quote #1

Hello i have downloaded sourcebans for my website and server.

This is my problem
Code:
can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
Database

Code:
"Databases"
	
	"sourcebans"
	{
		"driver"			"mysql"
		"host"				"185.2X.XX.XX"
		"database"			"wladmXXX_wladmXXX"
		"user"				"wladmXXX"
		"pass"				"XXX"
		//"timeout"			"0"
		"port"			"3306"
	}
I have checked for typing errors in database.
I have testet for mysql errors :status ok
i have checked if port 3306 is open.
my website is working, i can add servers on it.

.srcds_run

Code:
./srcds_run -game csgo -console -usercon -tickrate 128 +game_type 0 +net_public_adr 51.254.19.67 +ip 51.254.19.67 -port 27015 +mapgroup mg_bomb +map am_dust
if any know whats wrong, please submit a post.
Thanks

Last edited by HighGuy; 09-14-2015 at 05:59.
HighGuy is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 09-14-2015 , 05:58   Re: sourcebans can't connect to local mysql server.
Reply With Quote #2

You appear to be missing the top level of braces.
__________________
asherkin is offline
HighGuy
Junior Member
Join Date: Sep 2015
Old 09-14-2015 , 06:33   Re: sourcebans can't connect to local mysql server.
Reply With Quote #3

Quote:
Originally Posted by asherkin View Post
You appear to be missing the top level of braces.
If you mean database, i have just cut the part out with sourcebans
HighGuy is offline
BBG_Theory
Veteran Member
Join Date: Oct 2010
Location: NC USA
Old 09-16-2015 , 00:45   Re: sourcebans can't connect to local mysql server.
Reply With Quote #4

Quote:
Originally Posted by HighGuy View Post
If you mean database, i have just cut the part out with sourcebans
Code:
"Databases"
{
 "driver_default"  "mysql"
  
 "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"
 }
 "sourcebans"
 {
  "driver"   "mysql"
  "host"    "185.2X.XX.XX"
  "database"   "wladmXXX_wladmXXX"
  "user"    "wladmXXX"
  "pass"    "XXX"
  //"timeout"   "0"
  "port"   "3306"
 }
}
this is what he meant I think
Code:
"Databases"
{
 "sourcebans"
 {
  "driver"   "mysql"
  "host"    "185.2X.XX.XX"
  "database"   "wladmXXX_wladmXXX"
  "user"    "wladmXXX"
  "pass"    "XXX"
  //"timeout"   "0"
  "port"   "3306"
 }
}

your sourcebans and your gameserver are on separate ips . Don't you have to whitelist the remote MySQL hosts for remote access?

Last edited by BBG_Theory; 09-16-2015 at 00:53.
BBG_Theory is offline
balonfx
AlliedModders Donor
Join Date: Dec 2013
Location: New Haven, CT
Old 09-16-2015 , 02:03   Re: sourcebans can't connect to local mysql server.
Reply With Quote #5

I see you mentioned localhost, but the user above my observed the different IPs.

You will need to have mysql installed on the gameserver's box as well to be able to have it be capable of using mysql to another server.


If you need any help, feel free to add me on steam.
__________________
balonfx 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 02:07.


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