[Rawh]

Greetings

And welcome to the first created FAQ entry on this side of the forum.
Below you will find a small index page with questions and the link to a possible answer.

Please note that although most questions have been formed to cover most issues, they can deviate a bit from the actual problem you as a user are experiencing.
I simply ask you to take your time reading, since most issues are solved in the answer.

If for any reason the question you have is not answered in the faq below, please use the forum's search function first! Threads that repeat questions already answered will be closed / moved / deleted / burned alive / send to my dog for consumption! You have been warned!!

If you have an addition to the FAQ, please send me a PM with at least the question and answer.

Regards,

HLstatsX:CE Modteam

First
While this FAQ has been around for a while now, it's been written for version 1.6.10.
It might work with versions below that as well, though I can't guarantee nor support it!

Index

• Are there install manuals for hlstatsx:ce?
  
• How can I resolve the 0/0 players notation on the website??
  How can I resolve the 366573:0:0 maptime notation on the website?
  My server is getting the error: "NOT ALLOWED SERVER"
  
• I'm getting errors with Geo::IP::PurePerl. What is it? What does it require?
  The users country flags do not work, I only get the default flags, why?
  
• What is this GeoLiteCity.dat file and how do I get it?
  
• Can I host the website and gameserver on a Dynamic IP?
  
• Anyone know of any good hosts I can get hlstatsx:ce installed & run on?
  
• Can I import earlier created log files into the database?
  Is it possible to run hlstatsx:ce without realtime updating?
  Can I ftp my files over from an other machine to import them into the database?
  
• Can I disable stats / logging on specific maps?
  
• Is there something like a top10 viewer?
  Can I use some kind of list of top players on the website, regarding stats?
  
• Heatmaps is something new. Is it possible to create my own heatmaps?
  
• I'm getting "Server Error: (1111) Invalid use of group function", what does this mean?
  
• When visiting the site I'm getting the error "The google maps API server rejected your request...."
  
• Is there a list known of ingame (plugin) commands?
  
• The ingame plugin isn't working.
  The ingame plugin gives a 404 page.
  
• The daemon won't run, getting errors with ^M lines in the configuration file.(Thanks Luigi!)
  
• Can't setup UDP socket on port 27500: Address already in use.
  
• I'm getting the following error: "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'".
  
• I'm having issues with locked tables in mysql, why is this?
  My MYSQL command seems to hog 99% cpu all the time, why is this?
  I had to kill hlstats.pl and restart it before stats got updated again, why is this?
  
• How do I adjust the connect broadcast HLStatsX:CE shows when people are joining the server?
  
• How can I use a STEAM ID and a game code to generate the signature images?
  
• What are these SuperLogs plugins I keep hearing about and where can I get them?
  
• The daemon gives the error "No data since 120 seconds"
  
• I want to create separate stats per server of one mod. How can I do this?
  My gameservers are running plugins on one mod. How do I get these servers to separate their stats?
  
• My mysql server gives an 'Server error: Access denied for user 'user'@'host' (using password: YES)' error.
  My mysql server won't let my webserver connect.
  My mysql server only allows connections from localhost.
  
  

[Rawh]

Q: Are there any manuals for installing HlStatsX:ce ?

A: Yes there are! Please click on any link to go to that manuals page.

Linux installation manual (+php, +mysql, +perl).
CPanel installation manual.
Windows installation manual (with XAMPP).

[Rawh]

Q: How can I resolve the 0/0 players notation on the website?
Q: How can I resolve the 366573:0:0 maptime notation on the website?
Q: My server is getting the error: "NOT ALLOWED SERVER"

A: This can be because of a few issues:

• Take a look at the hosting blacklist? Is your webhoster mentioned? If so, stop everything you are trying to do, it won't work, get a different hoster!!!
  
• Is the Daemon running?
  
• Is the port that the Daemon is listening on open? (is it firewalled or are you perhaps behind a router?)
  
• Do you have the correct modtype for the gameserver you are running? (ie. DoD:S and not DoD gold)
  
• Is the server you wish to include in the stats also filled in as a gameserver under the gametab (admin section)?
  
• Have you added the loggaddress to the config?
  Either add the following to the server.cfg or the autoexec.cfg file:
  HL2

  logaddress_add ip:port

  
  HL1

  logaddress_add ip port

  ip and port being the ip and port your hlstats daemon is running on. If this is the same machine, be sure to use the internal ip (192.168.100.185 for example, do not use 127.0.0.1!).
  
• The server's rcon password is not the same with that it is configured with.
  Please login as admin on the website.
  Go to the gameslist and click on the gamemod you are hosting.
  Click on the tab called "edit server" and then on the link called "configure".
  A new page should be shown in which is a textbox with the option of filling in a rcon password.
  Make sure the rcon on both this textfield and your gameserver are the same.
  
• RESTART the daemon

[Rawh]

Q: I'm getting errors with Geo::IP::PurePerl. What is it? What does it require?
Q: The users country flags do not work, I only get the default flags, why?

A: HlstatsX:CE has the option of allowing country flags. It requires certain programs in order for this to work. Geo::IP::PurePerl is such a package and can be installed in a different of ways:

• Via linux command line (cli)
  To install Geo::IP::PurePerl via cli you will need to be root and type the following:
  

  perl -MCPAN -e 'install Geo::IP::PurePerl'

  
  ---
  
• Via Cpanel
  ---
  
• Via CPAN
  Again go to a linux command line. Do the following as root:
  

  cpan
  install Geo::IP::PurePerl

  
  It should now be installed.
  ---
  
• With ppm on Windows.
  If using ActivePerl, open Perl Package Manager. Search for Geo-IP-PurePerl. Mark for Install. Run marked actions.
  If Geo-IP-PurePerl is not found, you may need to add a repository for it.

After installing Geo::IP::PurePerl you will need to set the method you are going to use with the flags.
Go to the /scripts/GeoLiteCity/ directory, and execute the file called "install_binary.sh". It might be nessecary to chmod the file to +x (execute) before you will be able to run it. This will download the GeoLiteCity.dat.

Now the only thing left is to go to your stats website, login as admin, choose "HLstatsX:CE Settings", browse down to "award settings" and select "GeoIP lookup via binary file" option. Restart the daemon afterwards!

[Rawh]

Q: What is this GeoLiteCity.dat file and how do I get it?

A:
GeoLiteCity.dat is a file that is used for Geo-ip lookups (country flags in stats). It is one of the options in the HlstatsX:CE settings tab of the website interface (after being logged in as admin).

Currently HLX:CE supports looking up IP location through the GeoLiteCity.dat file or through the MySQL database. We highly recommend that you use the GeoLiteCity.dat file instead of the database as these lookups can be quite intensive.

If you are on a Linux system, we have provided the necessary script to obtain the GeoLiteCity.dat file. We do not have a Windows script at this time.

On a Linux system follow these steps:

• SSH to the server you installed the "scripts" folder on and change directory into "scripts/GeoLiteCity".
  
• At the shell type "./install_binary.sh"
  This will download the binary and decompress it properly.
  
• Verify that your setting in HLX:CE admin console is set to use the GeoLiteCity.dat file and not the database.

You can schedule, using CRON, that script to run on a monthly or weekly basis if you wish. The script will download a new copy every time from the GeoLiteCity web site and automatically update your .dat file.

On a Windows machine you must manually obtain the file and extract it as GeoLiteCity.dat.

To do this:

• Change your directory to that where you hlstats.pl file is stored in. There should be a directory there called "GeoLiteCity". Change to this directory.
  
• Download the following file:
  http://geolite.maxmi...LiteCity.dat.gz
  
• Using 7zip (or another program that can handle .gz files) extract the file GeoLiteCity.dat into the GeoLiteCity directory.

[Rawh]

Q: Can I host the website and gameserver on a Dynamic IP?

A: Tricky question! Yes, it might be possible and also it might not be possible.

If the gameserver and statswebsite is on the same machine but keeps on having an other outside (read: on the internet) IP, then you can do the following:

• Set it all up as explained in one of the manuals you can find here.
  
• Register the pc that is hosting the gameserver with dynamic address at DynDNS.
  
• Enter the admin part of your statswebsite.
  
• Go to the "Game Settings" part and click on the mod/game you are hosting.
  
• Click the add server link. Fill in those parts as described here:
  

  Quote

  Server Address: Fill in the local ip address (do NOT use 127.0.0.1).
  Server Port: Fill in the gameservers gameport.
  Server Name: Fill in the name of the gameserver.
  Rcon Password: Fill in the rcon password you have set on the gameserver.
  Public Address: Fill in the gameservers DynDNS host + port (host:ip).
  Game Mod: Are you running a mod for adminning or someting else? Select it out of the dropdown menu.
  
  
• Restart the Daemon
  
• Give other people the link to the DynDNS host you created.

[Rawh]

Q: Anyone know of any good hosts I can get hlstatsx:ce installed & run on?

A: There have been numerous of posts around the forum which give out examples of places you can host them at.
The list you will find here isn't conclusive or in any way facilitated by us. The links have just been gathered by the mod team and put in one post for your convienince.

Whitelist (please check these!)

• http://www.ubiquityhosting.com/ (US)
  Shell access possibility. Just ask them!
  
• http://fsckvps.com/ (US)
  Great support!
  
• http://www.wizardcreation.com/ (FR)
  Slow mainsite
  
• http://www.hetzner.de/ (DE)
  
• http://www.gc-server.eu/ (DE)
  
• http://www.ovh.com (US) http://www.ovh.fr (FR) http://www.ovh.co.uk (UK) http://www.ovh.nl (NL)
  
• http://www.hostdime.com (US)
  
• http://www.servage.net
  
• http://www.3ix.com
  Have to contact their support team to open the ports used by hlstatsx!
  
• http://tigit.co.uk (UK)
  
• http://www.fsckvps.com (US)
  Cheap vps where psychonic currently hosts his hlx and this site. (affiliate link crediting hlxcommunity is in the footer of this page)
  
• http://www.ehostpros.com/
  Need to contact support for opening inbound and outbound ports!
  
• http://www.earthvps.com (US)
  
• http://www.hostgator.com/
  When ordering a VPS or Dedicated server.

Blacklist:

• Bluehost.com
  They used to allow it but now seem to close accounts that use hlstatsx.
  
• http://www.dmehosting.com (US)
  Sucky IT support. They all say something else. Point it they don't support hlx:ce and they won't open the ports for it.
  
• http://www.evohosting.co.uk/
  They use sharedhosting and have no idea how to configure their 8cores server.
  
• http://www.killersservers.co.uk/
  They do not support opening UDP ports for inbound and outbound traffic.
  Their support staff said they will need to extensively test hlx:ce first before allowing this (12jan 2010).
  
• http://www.site5.com/
  Their policy changed. No longer allowing post-listen software: http://www.site5.com/support/rup/

This post has been edited by Rawh: 12 July 2010 - 04:50 PM
Reason for edit: Hostgator moved to whitelist

[Rawh]

Q: Can I import earlier created log files into the database?
Q: Is it possible to run hlstatsx:ce without realtime updating?
Q: Can I ftp my files over from an other machine to import them into the database?

A: Yes!

To do this manually on a linux host, you would use the follow syntax

From the hlstats.pl directory

cat /path/to/logfiles/* | /usr/bin/perl ./hlstats.pl -s -t --norcon --server-ip YourServerIp --server-port 27015

On Windows

type c:\path\to\logfiles\*.log | c:\path\to\perl.exe c:\path\to\hlstats.pl -s -t --norcon --server-ip YourServerIp --server-port 27015

Also, Woody has made a wonderful perl tool which allows you all to do this automatically through ftp. As of 1.6.1 this tool is included in "scripts/hlstatsftp". More information is on our old forum. Link below.

http://archive.hlxco...72&p=5647#p5647

[Rawh]

Q: Can I disable stats / logging on specific maps?

A: Yes, most mods support this. You can delete the logaddress for hlx in a map.cfg file (where map is the name of the map you wish to disable it on) and it should stop logging to the daemon when that map is on.

HL2: logaddress_del IP:PORT (or logaddress_delall)
HL1: logaddress_del IP PORT

[Rawh]

Q: Is there something like a top10 viewer?
Q: Can I use some kind of list of top players on the website, regarding stats?

A: Yep, Stachi made a wonderful post about this. Please do note however that the post itself is in German. If you wish to read it in your own language, please refer to google translate or something similar !

Link: http://archive.hlxco...10&p=6247#p6247

[Rawh]

Q: Is it possible to create my own heatmaps?

A: Bonzo, the man in charge of creating heatmaps ( :clap: ) for hlstatsx:ce, has made a nice post on the forum which holds all the steps required to make them. Please visit the link below. Any questions related to heatmaps should be asked in the same thread.

http://archive.hlxco....php?f=4&t=1031

[Rawh]

Q: I'm getting "Server Error: (1111) Invalid use of group function" on HLX:CE 1.5.6, what does this mean?

A: You are most likely using MySQL version 4.x.x. While hlstats is build for version 5.x.x. A fix has been released so hlstats can also be run on lesser mysql versions.

Please direct yourself towards our google page here: Issue 83.
For further help regarding the subject, please direct your questions to the forum!

[Rawh]

Q: When visiting the site I'm getting the error "The google maps API server rejected your request...."

A: This is because the key you have is either not filled in or the key you have in use is not for this site.

NOTE: As of version 1.6.2 we have upgraded the API to version 3, which does not require a key. As such, you will not find the settings below on any installation of 1.6.2 or higher!

You can register a new key by following the stats on the google site: http://code.google.com/apis/maps/
After this, go to admin --> hlstatsx:ce settings and find the API part. Fill in the key there and hit save on the bottom of the page. If you refresh the page now (ctrl + f5) the API warning should be gone!

[Rawh]

Q: Is there a list known of ingame (plugin) commands?

A: Yes, there are 3 ways of getting the ingame commands:

• Open your web browser and go to http:// your.site/stats/ingame.php?mode=help
  
• When on the server you can type 'help' (when the sourcemod plugin is loaded), the motd window should appear with a list of commands available.
  
• When on the server you can type 'hlx' (when the sourcemod plugin is loaded), next hit ESC and a menu should appear with commands.

[Rawh]

Q: The ingame plugin isn't working.
Q: The ingame plugin gives a 404 page.

A: This could be because of a nummer of reasons:

• The rcon password the server and the hlstats webpage aren't the same.
  The perl daemon sends the commands to the gameservers via rcon. If the rcon passwords aren't correct, the daemon can be banned by the server and not be able to send out the menu. (listip shows ipbans at the gameserver).
  
• The stats url isn't defined / isn't defined correctly.
  The perl daemon sets the hlstatsurl to the url you have currently set the website up with. This url is send towards the gameservers via rcon from the perl daemon. If the hlstatsurl (which is found under "game settings --> mod --> edit servers --> configuration") isn't set to the correct url, the gameserver will not be ab/list]le to pull up the menu and show this ingame in the motd window.
  If you change this be sure to restart the perl daemon AND the gameserver!!

[Rawh]

Q: The daemon won't run, getting errors with ^M lines in the configuration file.

A: You edited the config file on a windows machine with either microsoft word or wordpad.

Windows, for some reason, finds in necessary to end all the lines with a ^M tag. While this tag isn't shown while editing in wordpad, on linux you can seem them clearly. You will need to de-windows-fy the configuration file. Under linux this can be done by installing "tofrodos".

After installing the above package, simply type the following:

dos2unix <dosfile> <outputfile>

Where "<dosfile>" should have the name of the file with the ^M markings and "<outputfile>" the name of the file you wish to store the changes in!

[Rawh]

Q: Can't setup UDP socket on port 27500: Address already in use

A: It seems the port is already in use. This can be because of several reasons:

• Hlstats is already running.
  If you started hlstats via the 'run_hlstats' command, try to locate the 'hlstats.pid' file, in your scripts dir. If this file is present, it means hlstats is already running.
  You can use './run_hlstats stop' to stop the current hlstats daemon.
  
• Some other program is running on that port.
  With linux, you can type 'netstat -a | grep 27500' to see if the port is already open. With 'ps aux | grep hlstats' you can see if hlstats is already running for example

[Rawh]

Q: I'm getting the following error: "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'".

A: This means that the mysql server you have installed doesn't seem to run or isn't placing the mysql socket file in the correct location.

On a linux machine you can do the following:

• Locate the mysql config file (usually located in /etc/mysql/, called 'my.cnf').
  
• Edit the file with a text editor and search for the string "socket = /var/run/mysqld/mysqld.sock".
  
• If socket is pointing towards something different, please change the string to the above and save your config file.
  
• Restart the mysql server (/etc/init.d/mysql restart).
  
• Browse to the /var/run/mysqld/ directory and do a directory listing (ls) to see if the mysqld.sock file is placed there!

A different, but less likely situation, could be that the socket file is placed there but the server itself can't connect to the localhost. Instead of using localhost as mysqlserver address, revert back to the ip 127.0.0.1 or simply use the ip address that the machine has been given if it is directly connected to the internet.

Also check to make sure that the machine isn't running a firewall (which would commonly be called 'iptables' on a linux machine) and blocks any incoming traffic to port 3306 (default sql port). You can do a listing with 'iptables -L -n'. Remember you can only edit the iptables settings if you are using 'sudo' or 'root' itself!

[Rawh]

Q: I'm having issues with locked tables in mysql, why is this?
Q: My MYSQL command seems to hog 99% cpu all the time, why is this?
Q: I had to kill hlstats.pl and restart it before stats got updated again, why is this?

A: You are having more then 3 servers logging to your hlstats daemon.

Each gameserver, when sending their logs to the hlstats.pl daemon, spam the daemon quite a lot. The hlstats.pl daemon in turn builds sql injections from those loglines and sends this to your mysql server, which in turn tries to execute them and fill the database. When you have more then 3 server logging to one hlstats.pl daemon this daemon begins to spam the mysql server with a lot of injection queries. Most mysql databases, which you as user use, aren't setup for this amount of data and begin to stop the immidiate flow of injections in order to keep it's head above water.

In order to fix this the best thing you could do is start up a multiple of hlstats.pl daemons. This can be done with the 'run_hlstats_multi' script, which is found in the same directory as hlstats.pl. Scroll down to the part where it says "PORTS[0]=30000", this is the first port which will be opened. You can add 2 or 3 more ports (depending on how many gameservers you have). By default it opens 5 daemons with port 30000 as start.
After editing this file and setting the amount of daemons you want to start, save the file and launch your daemon with 'run_hlstats_multi start'.

Next in line would be your gameservers. Write down the logaddress_add command for all the extra daemons you have. Remember to keep the max amount of gameservers per daemon around 3. If this won't work out for you, set the max amount to 2.

[Rawh]

Q: How do I adjust the connect broadcast HLStatsX:CE shows when people are joining the server?

A: Psychonic gave some irc assistance regarding this and pasted all helpful information on this forum link.

Quick sum up:

• The connect message is in HLstats_EventHandlers.plib under:
  

  sub doEvent_Connect

  
  
• Look for:
  

  if ($player->{country} ne "")
  {
          my $msg = "";
          if ($player_rank == 0)
          {
                  $msg = sprintf("Player %s has connected from %s", $player->{name},$player->{country});
          }
          elsif ($player->{skill} == 1000)
          {
                  $msg = sprintf("New Player %s has connected from %s",$player->{name},$player->{country});
          }
          elsif ($g_ranktype ne "kills")
          {
                  $msg = sprintf("%s (Pos %s with %s points) has connected from %s",$player->{name},$player_rank,$player->{skill},$player->{country});
          }
          else
          {
                  $msg = sprintf("%s (Pos %s with %s kills) has connected from %s",$player->{name},$player_rank,$player->{total_kills},$player->{country});
          }
          $g_servers{$s_addr}->messageAll($msg, $player->{playerid}, 1);
  }
  else
  {
          if ($g_ranktype ne "kills")
          {
                  $msg = sprintf("%s (Pos %s with %s points) has connected",$player->{name},$player_rank,$player->{skill});
          }
          else
          {
                  $msg = sprintf("%s (Pos %s with %s kills) has connected",$player->{name},$player_rank,$player->{total_kills});
          }
          $g_servers{$s_addr}->messageAll($msg, $player->{playerid}, 1);
  }

  
  
• You can use one of the following to adjust it:
  

  $player->{address}
  $player->{country}
  $player->{state}
  $player->{city} 

Additionally you can edit the broadcasting colors for mods.
TF2 color codes:

1 - white
3 - light green (or team color with a SayText2 message)
4 - green
5 - olive
6 - color of last item each client saw wording for or black if none since opening game 

Again, for any comments or help with the above, go to the entire forum post!