Sourceban website - Can't connect to MySQL server on 'xxxxxxxxxxxx.com' (4)

[Tweezy]

  Labarr said:

Ok so I got it to work again.. Strange...

 

I had to change the host on both the config.php and databases.cfg from xxxxx.com to localhost..

 

Dunno y

 

When setting up a database, always try using localhost first, unless stated otherwise. If the database is on the same server, then always connect locally.

[Labarr]

  Nishok said:

Could be because either:

- External connection is disallowed.

- Because of the DDoS external connections are hard to maintain, so through internal connection there is no interruption.

- Or something else I missed.

 

Sent from my GT-I9003 using Tapatalk 2

 

  Tweezy said:

When setting up a database, always try using localhost first, unless stated otherwise. If the database is on the same server, then always connect locally.

 

Thanks for the help you guys

[Labarr]

OK so now, the sourcebans is up. But bans ARE NOT showing up on the website and this is the error message i get in sourcebans.log

 

L 09/11/2013 - 15:57:07: [sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on 'localhost' (10061). See FAQ: http://www.sourcebans.net/node/20

 

 

config.php

[/b] * config.php
* 
* This file contains all of the configuration for the db
* that will 
* @author SteamFriends Development Team
* @version 1.0.0
* @copyright SteamFriends (www.SteamFriends.com)
* @package SourceBans
*/
if(!defined('IN_SB')){echo 'You should not be here. Only follow links!';die();}


define('DB_HOST', 'localhost');   			// The host/ip to your SQL server
define('DB_USER', 'db');					// The username to connect with
define('DB_PASS', 'temp');						// The password
define('DB_NAME', 'db_sourcebans');  						// Database name	
define('DB_PREFIX', 'sb');					// The table prefix for SourceBans
define('DB_PORT','3306');							// The SQL port (Default: 3306)


//define('DEVELOPER_MODE', true);			// Use if you want to show debugmessages
//define('SB_MEM', '128M'); 				// Override php memory limit, if isn't enough (Banlist is just a blank page)

?>[b]

 

On the control panel for nfo.. IT says "Hostname: localhost (for external connections, use db.site.nfoservers.com)

Port: not needed for localhost connections; 3306 for external connections"

However, when i change DB_HOST to db.site.nfoservers.com, I can no longer go to the sourcebans website

 

Here is the databases.cfg

 

[/b]"Databases"{
"driver_default"		"mysql"

// When specifying "host", you may use an IP address, a hostname, or a socket file path

"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"
}

"driver_default"		"mysql"

"sourcebans"
{
	"driver"			"mysql"
	"host"				"localhost"
	"database"			"db_sourcebans"
	"user"				"db"
	"pass"				"temp"
	//"timeout"			"0"
	"port"			"3306"
}


}


[b]

 

NFO gives me the option to allow external connections, and I have them checked... I don't know where to go from here..

[Labarr]

Like I said in the beginning, it worked fine for like 3 months.. then all of a sudden I am having issues..

If you wanna add me on steam that would be great

 

(Labarr15)

[Nishok]

  Labarr said:

Like I said in the beginning, it worked fine for like 3 months.. then all of a sudden I am having issues..

If you wanna add me on steam that would be great

 

(Labarr15)

 

When you see me online today (I will be online in 5h from now), open a steam chat with me and I'll try to solve it.

[Labarr]

  Nishok said:

When you see me online today (I will be online in 5h from now), open a steam chat with me and I'll try to solve it.

 

Thanks for the offer. But I finally solved it

[Nishok]

  Labarr said:

Thanks for the offer. But I finally solved it

 

Alright, cool.

 

(hint: Maybe share what you did, so if someone ever happens to have the same issue, they get the answer too )