[msleeper]

First of all, check your error log. Post anything relevant that may be there about this plugin. Did you restart the server after uploading the new databases.cfg?

Secondly, I am 99.9999999999% sure that GameServers doesn't allow external MySQL connections with their bargain bin web hosting. You can ask them if they do but don't get your hopes up.

[Spank]

I... didn't know there was an error log, I found it though... and...

There's alot of information in there and I have no clue what's relevant or important really, haha.

Here's a link to it: http://dl.getdropbox.com/u/882811/errors_20090423.log
And here's it is again if that's easier. I attempted to remove all the duplicate entries, I think this is all origional stuff.

L 04/23/2009 - 17:16:43: SourceMod error session started L 04/23/2009 - 17:16:43: Info (map "l4d_hospital01_apartment") (file "errors_20090423.log") L 04/23/2009 - 17:16:43: [l4d_stats.smx] Failed to connect to database: [2003]: Can't connect to MySQL server on '208.167.247.22' (111) L 04/23/2009 - 170:05: [SM] Detected parse error(s) in file "/usr/local/games/l4d_demo/756796/208.167.247.22:27015/l4d/left4dead/addons/sourcemod/configs/databases.cfg" L 04/23/2009 - 170:05: [SM] Line 40: Section beginning without a matching ending L 04/23/2009 - 170:05: Error log file session closed. L 04/23/2009 - 1786: SourceMod error session started L 04/23/2009 - 1786: Info (map "l4d_hospital01_apartment") (file "errors_20090423.log") L 04/23/2009 - 1786: [l4d_stats.smx] Failed to connect to database: [2003]: Can't connect to MySQL server on '208.167.247.22' (111) L 04/23/2009 - 17:403: [SM] Native "GetConVarBool" reported: Invalid convar handle 0 (error 4) L 04/23/2009 - 17:403: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 04/23/2009 - 17:403: [SM] [0] Line 1756, /home/groups/alliedmodders/forums/files/3/7/5/2/1/36374.attach::IsVersusMode() L 04/23/2009 - 17:403: [SM] [1] Line 538, /home/groups/alliedmodders/forums/files/3/7/5/2/1/36374.attach::timer_UpdatePlayers() L 04/23/2009 - 18:04:17: SourceMod error session started L 04/23/2009 - 18:04:17: Info (map "l4d_hospital01_apartment") (file "errors_20090423.log") L 04/23/2009 - 18:04:17: [l4d_stats.smx] Failed to connect to database: [1045]: Access denied for user 'Admin'@'208.167.247.5' (using password: YES) L 04/23/2009 - 18:04:17: [CLIENTPREFS] [1045]: Access denied for user 'c756796_Admin'@'208.167.247.5' (using password: YES) L 04/23/2009 - 18:04:17: [SM] Native "RegClientCookie" reported: Clientprefs is disabled due to a failed database connection L 04/23/2009 - 18:04:17: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 04/23/2009 - 18:04:17: [SM] [0] Line 294, /home/groups/alliedmodders/forums/files/3/7/5/2/1/36374.attach::OnPluginStart()

[msleeper]

It looks like...

A.) The plugin can't connect to the database. Assuming that you have the correct details, did you restart the server after updating your databases.cfg?

B.) You have the wrong database info.

C.) GameServers is infact blocking external MySQL connections. Contact them for confirmation.

I am pretty sure the clientprefs errors are because of the same issues. The GetConVarBool error is weird, I haven't seen that before, I'll have to look into that more since it may or may not be related.

[Spank]

Server has been restarted multiple times, I'll doublecheck the database info, and I've made a post on the GS forums to find out.

The database is correct, so I guess I'll have to wait on a reply from GS.

If not, I guess I'll have to try a find somewhere to host it, free hopefully or low cost, since this is the only thing I'm trying to run.

[IH_Jimbo]

You will find a hard time finding free hosting with mysql especially that allows external connections. GoDaddy is probably the least expensive that I know of that allows external connections(Means the sqlserver is a different server than the game server.)

[msleeper]

PM me and maybe I can help you out there.

[Spank]

I submitted a ticket, my reply:

Yes. Brian "devicenull" Rak GameServers.com Support

So, that means, I'm screwing something up.

[Xenoskh]

Have somone that has a webhosting account and that you trust try connecting to the mysql database remotely. I used a simple php script to verify my remote connection was working.

ie:

<?php $link = mysql_connect('66.55.132.31','user','pass'); if (!$link) { die('Could not connect to MySQL: ' . mysql_error()); } echo 'Connection OK'; mysql_close($link); ?>

[gehn]

Originally Posted by IH_Jimbo You will find a hard time finding free hosting with mysql especially that allows external connections. GoDaddy is probably the least expensive that I know of that allows external connections(Means the sqlserver is a different server than the game server.)

Your last statement is true but they only allow external servers that they own to connect to their database servers. Trust me, i've tried.

msleeper:

Will the 1.1.0 stats web parts be upgradable to 1.2.0 or will we have to start from scratch? Thanks

[IH_Jimbo]

I initially tested this script on GoDaddy, I had the game server on our MyIS servers and the web app and mySQL were on GoDaddy. Never had a problem with the external connections there. Maybe that is a change they made recently.