[Dr. Septapus]

I thought I had everything set up, but upon entering my server and typing /hlx the menu comes up but selecting anything just makes the menu disappear. There is also no sign of any hlstats activity in chat. Now in the install guide It says to install DBD-mysql and Geo-IP-PurePerl. The mysql one is installed on my server, however I don't have Geo-IP-PurePerl, I have Geo-IP (without the PurePerl suffix). I am using cPanel and cannot find that module through the built in search function. I don't actually know that this is the problem, does anybody have any ideas though?


I have a shared server
I have enabled logging in my server.cfg and it points to the correct location in IP : PORT format.
I talked with my host and they said they do not block port 27500 UPDATE: Telnet-ing to my site on port 27500 timed out, they may have lied to me. I'm investigating now.
sm plugins list shows that hlstats is installed
My server now has the hlstats tag
This is for a TF2 server

The daemon is running successfully (or so it says).

UPDATE: I manually ran hlstats.pl and got this in the console:
2013-01-11 16:50:21: - MYSQL: Connecting to MySQL database 'XXX' on 'localhost' as user 'XXX' ... connected ok
2013-01-11 16:50:21: - CONFIG: Reading database config...
2013-01-11 16:50:21: - CONFIG: I have found the following server configs in database:
2013-01-11 16:50:21: - S_CONFIG: 68.232.172.50:27015
2013-01-11 16:50:21: - ERROR: GeoIP method set to binary file lookup but Geo::IP:urePerl module NOT FOUND
2013-01-11 16:50:21: - HLSTATSX: HLstatsX:CE 1.6.19 starting...
2013-01-11 16:50:21: - UDP: Opening UDP listen socket on port 27500 ... ok
2013-01-11 16:50:21: - HLSTATSX: Tracking Trend of the stats are enabled
2013-01-11 16:50:21: - HLSTATSX: Maximum Skill Change on all servers are 25 points
2013-01-11 16:50:21: - HLSTATSX: Minimum Skill Change on all servers are 2 points
2013-01-11 16:50:21: - HLSTATSX: Minimum Players Kills on all servers are 50 kills
2013-01-11 16:50:21: - HLSTATSX: Players chat logging is enabled
2013-01-11 16:50:21: - HLSTATSX: Broadcasting public chat is disabled
2013-01-11 16:50:21: - HLSTATSX: Event queue size is set to 10
2013-01-11 16:50:21: - HLSTATSX: HLstatsX:CE is now running (Normal mode, debug level 1)
2013-01-11 16:52:20: - HLSTATSX: No data since 120 seconds

That minimum player kills is interesting, does that mean its not going to start updating until there are 50 kills by players?

The more I look into this the more I think the name of this thread is incorrect. I apologize.

[Mavrick4283]

http://code.activestate.com/ppm/Geo-IP-PurePerl/ for that.

But it looks like the daemon is not able to send rcon or your server can not talk back check your firewall settings.

[Dr. Septapus]

Thanks for the perl module.

I got up this morning and did some tinkering. It seems to be working more than before. It now seems to be tracking the bots we have on the server. However Nothing is tracked besides playtime. I went in and killed some bots and nothing got updated. Also there is still nothing happening in game, any of the menu options just cause the menu to disappear.

You can see for yourself if you like: This is the php frontend

Console is showing this interesting line:
2013-01-12 12:06:49: 68.232.172.50:27015 - TRCON: Cannot setup TCP socket on 68.232.172.50:27015: Connection timed out

I also saw a line saying it was ignoring bots, so that might not be why stats are updating. But shouldn't I still see some sort of in game HLSTATS stuff? The menu just goes away. I have enabled remote access to my database from my gameserver so unless something is broken behind the scenes there (or somehow I blew it) I don't think that's it.

UPDATE: I disabled ignoring bots. Kills and stuff are getting logged. Still no ingame feedback though.

[Mavrick4283]

Originally Posted by Dr. Septapus Console is showing this interesting line: 2013-01-12 12:06:49: 68.232.172.50:27015 - TRCON: Cannot setup TCP socket on 68.232.172.50:27015: Connection timed out I have enabled remote access to my database from my gameserver so unless something is broken behind the scenes there (or somehow I blew it)

You gameserver does not access the HLX:CE database direct, it uses the daemon to do that you need to make sure that the daemon port is not being blocked or filtered (when you start the daemon it will tell you what port this is)

I do not know why some of the data is being sent and other info is not unless there is a firewall or a proxy server that is not allowing all the data to come through.

[Dr. Septapus]

I was told by my host that port 27500 is open for incoming and outgoing tcp/udp. I will talk to the gameserver host and see if anything is the issue over there.

[Mavrick4283]

Hay, https://bitbucket.org/psychonic/hlst...SGO-HOTFIX.zip download and apply this hotfix and see if that fixes it.

[Dr. Septapus]

I'm running a TF2 server. Should I still try that?

[Mavrick4283]

Yes, thinking that i should rename that fix i get asked that every time

[Dr. Septapus]

Still no luck. I'm waiting on my gameserver host to get back to me. I'm still getting that TCP socket connection timed out.

[Dr. Septapus]

In the meantime would you mind explaining to me how I am supposed to install Geo::IP:urePerl? I have never had any exposure to perl so I have no idea what is going on. I don't even know where to put it.

Does the daemon only work through port 27500? Would I have to open another port for the tcp connection? Right now i've only requested that port 27500 be open. I'm just trying to think why It could connect to rcon, but not be able to set up a tcp socket.

2013-01-13 08:51:40: 68.232.172.50:27015 - SERVER: Connecting to rcon on 68.232.172.50:27015 ... ok
2013-01-13 08:51:40: 68.232.172.50:27015 - TRCON: Cannot setup TCP socket on 68.232.172.50:27015: Connection timed out

Gameserver host wasn't much help. They told me to whitelist the gameserver IP for mysql database and thats about. After that they closed the ticket and said they wouldn't be able to help anymore.

I used this to test port 27015 on the gameserver( 68.232.172.50), and it said that the port is open for tcp.


UPDATE: fixed. Had to open port 27015 on the webserver.

I could still use some help with that perl module though. Still don't know what to do with that.