I'm having trouble getting this working. My database.cfg file is as follows:
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"
}
"l4dstats"
{
"driver" "mysql"
"host" "tythefox.xfactorservers.com"
"database" "tythefox_l4dstats"
"user" "tythefox_dbstats"
"pass" "******"
"port" "3306"
}
}
I followed the instructions to get the remote SQL access allowed via the cPanel, and everything looks right. However, when I fire up my server I get
Code:
L 03/20/2010 - 23:11:00: [l4d_stats.smx] Failed to connect to database: [2003]: Can't connect to MySQL server on 'tythefox.xfactorservers.com' (10060)
L 03/20/2010 - 23:11:00: [SM] Plugin encountered error 25: Call was aborted
L 03/20/2010 - 23:11:00: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 03/20/2010 - 23:11:00: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 03/20/2010 - 23:11:00: [SM] [0] Line 566, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart()
What gives? The RemoteSQL option wouldn't be there if it wasn't enabled, right? I placed the wildcard appropriately, so I don't see why it isn't working. I'm honestly starting to get pissed off, if you can tell me a free MySQL host that performs the required operations, I'd be grateful. '
Thanks.