[Mister_Magotchi]

That should work AFAIK, nightrider.

Mine is:

	"hlxce"
	{
		"driver"			"default"
		"host"				"servername.hlstatsx.nfoservers.com"
		"database"			"servername"
		"user"				"servername"
		"pass"				"password"
		//"timeout"			"0"
		"port"			"3306"
	}

Verify that networking is enabled on your MySQL server, as I assume the API doesn't connect via a Unix socket. Also check any firewall settings that might affect its ability to connect through the localhost loopback. You might try telnet'ting to localhost on port 3306 to make sure it is at least accepting connections.

[niar82k]

I have the same problem! Can it be that the HLstatsX:CE SQL API for Sourcemod & hlxce-sm-api-0.4-alpha.zip APIs are different?

The problem occurs only on the Mapchange

L 07/23/2011 - 13:48:08: Info (map "de_dust2") (file "errors_20110723.log")
L 07/23/2011 - 13:48:08: [SM] Plugin encountered error 25: Call was aborted
L 07/23/2011 - 13:48:08: [SM] Native "SetFailState" reported: Lost database connection
L 07/23/2011 - 13:48:08: [SM] Displaying call stack trace for plugin "hlxce-sm-api.smx":
L 07/23/2011 - 13:48:08: [SM]   [0]  Line 257, Y:\Desktop\sourcemod-1.4.0-hg3360-windows\addons\sourcemod\scripting\hlxce-sm-api.sp::GetClientHLXPlayerId()
L 07/23/2011 - 13:48:08: [SM]   [1]  Line 235, Y:\Desktop\sourcemod-1.4.0-hg3360-windows\addons\sourcemod\scripting\hlxce-sm-api.sp::OnClientPostAdminCheck()

My databases.cfg

"hlxce"
	{
		"driver"			"mysql"
		"host"				"localhost"
		"database"			"hlstats"
		"user"				"USER"
		"pass"				"PASS"
	}

[nightrider]

Thank you for the kind reply Mister Magotchi
I'll check

Update:
Strange if I start the server up with the hlxce-sm-api and teambalance plugins I get the same errors.

18 <Error> "HLstatsX:CE SQL API for Sourcemod" (0.4 alpha) by psychonic
        Load Errors:
         HLstatsX:CE SQL API for Sourcemod: Lost database connection

and in error log

L 07/23/2011 - 12:58:58: Info (map "de_dust2") (file "errors_20110723.log")
L 07/23/2011 - 12:58:58: [SM] Plugin encountered error 25: Call was aborted
L 07/23/2011 - 12:58:58: [SM] Native "SetFailState" reported: Lost database connection
L 07/23/2011 - 12:58:58: [SM] Displaying call stack trace for plugin "hlxce-sm-api.smx":
L 07/23/2011 - 12:58:58: [SM]   [0]  Line 257, C:\servers\pub01 - dust2\orangebox\cstrike\addons\sourcemod\scripting\hlxce-sm-api.sp::GetClientHLXPlayerId()
L 07/23/2011 - 12:58:58: [SM]   [1]  Line 235, C:\servers\pub01 - dust2\orangebox\cstrike\addons\sourcemod\scripting\hlxce-sm-api.sp::OnClientPostAdminCheck()

If however after the server is running I unload the two SourceMod plugins
sm plugins unload teambalance
sm plugins unload hlxce-sm-api


Then reload the plugins in this order the errors are gone and it works.
sm plugins unload hlxce-sm-api
sm plugins unload teambalance

After a map change or server restart it fails unless I would unload and load the plugins again.

[Mister_Magotchi]

Strange. Mine naturally load in that order (API first, balancer second).

Regarding niar82k's question about whether the .zip file I provided of the compiled API is the same as the code provided at Google Code, I just checked out the latest version of it and compiled it with the latest SourceMod development snapshot for Windows.

[nightrider]

interesting

[Oldtimers]

Mister_Magotchi
It works only on windows?

[Mister_Magotchi]

I'm running it on LInux. I haven't tested it on Windows.

[Ares Veteran]

I have the same error than for nightrider.

[Mister_Magotchi]

I don't know what to say right now. I'm on vacation out-of-state. The API works on my server, so I made the plugin work with it. Again, Psychonic maintains the API. Is it working for anyone else?

[musosoft]

Originally Posted by Mister_Magotchi Is it working for anyone else?

I have the same problem as nightrider, it seems like hlxce sm api must be loaded before teambalance sometimes losts connection to sql on map load
testing if plugins reload after warmup round will temporary fix this problem

EDIT: hlxce sm api works without errors when plugin load is delayed after map load

Log:

L 07/31/2011 - 16:53:15: [SM] Plugin encountered error 25: Call was aborted
L 07/31/2011 - 16:53:15: [SM] Native "SetFailState" reported: Lost database connection
L 07/31/2011 - 16:53:15: [SM] Displaying call stack trace for plugin "hlxce-sm-api.smx":
L 07/31/2011 - 16:53:15: [SM]   [0]  Line 257, Y:\Desktop\sourcemod-1.4.0-hg3360-windows\addons\sourcemod\scripting\hlxce-sm-api.sp::GetClientHLXPlayerId()
L 07/31/2011 - 16:53:15: [SM]   [1]  Line 235, Y:\Desktop\sourcemod-1.4.0-hg3360-windows\addons\sourcemod\scripting\hlxce-sm-api.sp::OnClientPostAdminCheck()