AlliedModders
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

AlliedModders (https://forums.alliedmods.net/index.php)
-   HLstatsX:CE (https://forums.alliedmods.net/forumdisplay.php?f=156)
-   -   GeoLiteCity.dat NOT FOUND problem (https://forums.alliedmods.net/showthread.php?t=316385)

HiDeath 05-20-2019 16:57
GeoLiteCity.dat NOT FOUND problem
 
Hi there ,

i have installed HLstatsx properly using the guide , with the required perl modules , database , etc ...

i still got an error , all players locations are set to unknown

i get this error from daemon logs :
Code:
ERROR: GeoIP method set to binary file lookup but .//GeoLiteCity/GeoLiteCity.dat NOT FOUND
Any help would be appreciated , thanks in advance :):)

Natan 05-20-2019 20:31
Re: GeoLiteCity.dat NOT FOUND problem
 
Hello...

The error log is very clear.
you miss the .dat file in your FTP folder..

Re-install GeoLiceCity by using your install_binary.sh and Watch if there´s a error log in console.

If you have error logs due to NOT FOUND (404) in web server, try to change the Maxmind URL....

from:

Code:

URL=http://geolite.maxmind.com/download/geoip/database/
FILE=GeoLiteCity.dat.gz
to:

Code:
URL=https://geolite.maxmind.com/download/geoip/database/
FILE=GeoLite2-City.tar.gz
And next time try to post more details about the machine you´re running...and post error logs here also. :wink:

NomisCZ 05-21-2019 12:25
Re: GeoLiteCity.dat NOT FOUND problem
 
Hello,
if you are using old HLStatsX, you can't only change URL, because GeoLite2-City.tar.gz using different file format (mmdb) and it's supported only with updated HLStatsX version - https://github.com/NomisCZ/hlstatsx-community-edition.

HiDeath 05-23-2019 13:55
Re: GeoLiteCity.dat NOT FOUND problem
 
Quote:
Originally Posted by Natan (Post 2652458)
Hello...

The error log is very clear.
Hi there ,

Thanks for the reply , it was really quiet helpful !

i did change the url and file values , but i still get 1 more error :

Code:
chmod: cannot access ‘*.dat’: No such file or directory

HiDeath 05-23-2019 13:56
Re: GeoLiteCity.dat NOT FOUND problem
 
Quote:
Originally Posted by NomisCZ (Post 2652534)
Hello,
if you are using old HLStatsX, you can't only change URL, because GeoLite2-City.tar.gz using different file format (mmdb) and it's supported only with updated HLStatsX version - https://github.com/NomisCZ/hlstatsx-community-edition.
Hi there ,

Thanks for the reply , really appreciated for both of you guys !

is it possible to update the current HLstatsX without losing any stats or settings ( same database configs ? ) ?

Thanks in advance :D :D

PS : I did download it from here , i really don't know if it's the latest version or not

NomisCZ 05-23-2019 15:00
Re: GeoLiteCity.dat NOT FOUND problem
 
Quote:
Originally Posted by HiDeath (Post 2652813)
Hi there ,

Thanks for the reply , really appreciated for both of you guys !

is it possible to update the current HLstatsX without losing any stats or settings ( same database configs ? ) ?

Thanks in advance :D :D

PS : I did download it from here , i really don't know if it's the latest version or not

Yep, it's possible.
1. Stop daemon
2. Run all migration queries: https://github.com/NomisCZ/hlstatsx-...sql/migrations
3. Download latest daemon: https://github.com/NomisCZ/hlstatsx-...master/scripts
4. Replace all daemon files (backup your hlstatsx.conf before)
4. Install Perl packages (1.5. Install Perl packages) - https://github.com/NomisCZ/hlstatsx-...llation#-linux
5. Prepare GeoIP2 (2.4 Prepare GeoIP2) - https://github.com/NomisCZ/hlstatsx-...2-installation
6. Start daemon and check logs
7. Download latest web files - https://github.com/NomisCZ/hlstatsx-...ree/master/web
8. Backup your config.php, upload all files to your webhosting and remove updater folder

HiDeath 05-23-2019 18:16
Re: GeoLiteCity.dat NOT FOUND problem
 
Quote:
Originally Posted by NomisCZ (Post 2652820)
Yep, it's possible.
1. Stop daemon
2. Run all migration queries: [url]https://github.com/NomisCZ/hlstatsx-community-...
Oh thanks dude :D :D :D

HiDeath 05-23-2019 21:42
Re: GeoLiteCity.dat NOT FOUND problem
 
I did the update successfully , but i still get more erros , when i click on players tab :
Code:
Server Error: (1054) Unknown column 'hlstats_Players.mmrank' in 'field list'
Last SQL Query:
                                SELECT
                                        SQL_CALC_FOUND_ROWS
                                        hlstats_Players.playerId,
                                        hlstats_Players.connection_time,
                                        unhex(replace(hex(hlstats_Players.lastName), 'E280AE', '')) as lastName,
                                        hlstats_Players.flag,
                                        hlstats_Players.country,
                                        hlstats_Players.skill,
                                        hlstats_Players.mmrank,
                                        hlstats_Players.kills,
                                        hlstats_Players.deaths,
                                        hlstats_Players.last_skill_change,
                                        ROUND(hlstats_Players.kills/(IF(hlstats_Players.deaths=0, 1, hlstats_Players.deaths)), 2) AS kpd,
                                        hlstats_Players.headshots,
                                        ROUND(hlstats_Players.headshots/(IF(hlstats_Players.kills=0, 1, hlstats_Players.kills)), 2) AS hpk,
                                        IFNULL(ROUND((hlstats_Players.hits / hlstats_Players.shots * 100), 1), 0) AS acc,
                                        activity
                                FROM
                                        hlstats_Players
                                WHERE
                                        hlstats_Players.game = 'cstrike'
                                        AND hlstats_Players.hideranking = 0
                                        AND hlstats_Players.kills >= 1
                                ORDER BY
                                        skill desc,
                                        kpd desc,
                                        hlstats_Players.lastName ASC
                                LIMIT
                                        0,
                                        50
Can i keep the old web verions with the current database / daemon , i really like it better :) :)

NomisCZ 05-24-2019 12:29
Re: GeoLiteCity.dat NOT FOUND problem
 
Quote:
Originally Posted by HiDeath (Post 2652869)
I did the update successfully , but i still get more erros , when i click on players tab :

...
Sorry, I forgot to add one more older migration: https://github.com/NomisCZ/hlstatsx-...02_22_0000.sql

HiDeath 05-24-2019 13:53
Re: GeoLiteCity.dat NOT FOUND problem
 
I'm sorry guys , but i don't actually like the current version , the old one looks better in some way ,
I think the first problem could be fixed by GeoLiteCity.dat , anyone can pass it in zip please ?


All times are GMT -4. The time now is 10:14.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.