OK any help would be appreciated as to why my Gameserver will not communicate with my MYSQL server?
Basically i've tried fo hours trying to figure this out and still no joy...I really hope someone understands what is incorrect here:
Used PHPMY Admin to create the "Server" Table. running the query obviously very quick to create, then the additional server rows (I have 4) using the following command:
Code:
INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
(1, '217.163.31.207:27015', 1, '2008-12-31 00:00:00', 'TF2 UK | {MAP} | {CURR}/{MAX}', 'TF2 UK | OFFLINE', 0, 0, '[no map]');
INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
(2, '216.245.211.61:27015', 1, '2008-12-31 00:00:00', 'TF2 US | {MAP} | {CURR}/{MAX}', 'TF2 US | OFFLINE', 0, 0, '[no map]');
INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
(3, '212.187.209.75:27015', 2, '2008-12-31 00:00:00', 'CSS UK | {MAP} | {CURR}/{MAX}', 'CSS UK | OFFLINE', 0, 0, '[no map]');
INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
(4, '85.234.148.165:27055', 2, '2008-12-31 00:00:00', 'CSS WCS | {MAP} | {CURR}/{MAX}', 'CSS WCS | OFFLINE', 0, 0, '[no map]');
Databases Config File:
Code:
{
"driver" "mysql"
"host" "http://*****.****.***"
"database" "serverredirect" <--- created via control panel
"user" "**********" <--- created via control panel
"pass" "**********" <--- created via control panel
//"timeout" "0"
"port" "2082"
}
User access given:
Remote MYSQL has my server IP added to Allow:
Added databases.cfg to whitelist.cfg using the following:
Code:
"add" "addons/sourcemod/configs/databases.cfg"
When reloading the server I have followed this process:
Code:
Log onto Gameserver control Panel > STOP SERVER > START SERVER
When I type !server, the horrible statement of sorry can not find the servers appears. I would highly value anybodies help in correcting this problem with communication between MYSQL and sourcemod...Although please bear in mind I am not an idiot hence why I have taken 6 hour and more to post here. This is probably as usual something simple which I am missing out
All the Very Best,
Richard