Hi guys, I recently moved web hosts, port 3306 was opened on the new host however I am getting some errors on both of my CS:S and CS:GO servers.
*Game server and web server are not on the same machine, so localhost should not be used
Code:
L 03/26/2013 - 00:42:39: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 03/26/2013 - 00:42:39: [SM] Displaying call stack trace for plugin "sourcebans.smx":
L 03/26/2013 - 00:42:39: [SM] [0] Line 1413, D:\scripting\sourcebans.sp::ProcessQueueCallback()
Here is my database cfg:
PHP Code:
"Databases"
{
"driver_default" "mysql"
"sourcebans"
{
"driver" "mysql"
"host" "216.144.242.235"
"database" "xxxxxxxxx"
"user" "xxxxxxxxx"
"pass" "xxxxxxxxxx"
//"timeout" "0"
"port" "3306"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
}
Here is the config.php in sourcebans:
PHP Code:
<?php
/**
* 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', 'xxxxxxxxxxx'); // The username to connect with
define('DB_PASS', 'xxxxxxxxxxx'); // The password
define('DB_NAME', 'xxxxxxxxxxx'); // Database name
define('DB_PREFIX', 'xxxx'); // 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)
?>
__________________