Raised This Month: $62 Target: $400
 15% 

GeoLiteCity.dat NOT FOUND problem


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
HiDeath
Senior Member
Join Date: Aug 2018
Old 05-20-2019 , 16:57   GeoLiteCity.dat NOT FOUND problem
Reply With Quote #1

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

Last edited by HiDeath; 05-20-2019 at 17:00.
HiDeath is offline
Natan
AlliedModders Donor
Join Date: Aug 2015
Location: Behind you
Old 05-20-2019 , 20:31   Re: GeoLiteCity.dat NOT FOUND problem
Reply With Quote #2

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.
__________________
Natan is offline
NomisCZ
AlliedModders Donor
Join Date: Mar 2014
Location: $this->Czech_Republic
Old 05-21-2019 , 12:25   Re: GeoLiteCity.dat NOT FOUND problem
Reply With Quote #3

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.
__________________



Steam: NomisCZ

Last edited by NomisCZ; 05-21-2019 at 12:26.
NomisCZ is offline
HiDeath
Senior Member
Join Date: Aug 2018
Old 05-23-2019 , 13:55   Re: GeoLiteCity.dat NOT FOUND problem
Reply With Quote #4

Quote:
Originally Posted by Natan View Post
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 is offline
HiDeath
Senior Member
Join Date: Aug 2018
Old 05-23-2019 , 13:56   Re: GeoLiteCity.dat NOT FOUND problem
Reply With Quote #5

Quote:
Originally Posted by NomisCZ View Post
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

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

Last edited by HiDeath; 05-23-2019 at 13:57.
HiDeath is offline
NomisCZ
AlliedModders Donor
Join Date: Mar 2014
Location: $this->Czech_Republic
Old 05-23-2019 , 15:00   Re: GeoLiteCity.dat NOT FOUND problem
Reply With Quote #6

Quote:
Originally Posted by HiDeath View Post
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

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
__________________



Steam: NomisCZ
NomisCZ is offline
HiDeath
Senior Member
Join Date: Aug 2018
Old 05-23-2019 , 18:16   Re: GeoLiteCity.dat NOT FOUND problem
Reply With Quote #7

Quote:
Originally Posted by NomisCZ View Post
Yep, it's possible.
1. Stop daemon
2. Run all migration queries: [url]https://github.com/NomisCZ/hlstatsx-community-...
Oh thanks dude
HiDeath is offline
HiDeath
Senior Member
Join Date: Aug 2018
Old 05-23-2019 , 21:42   Re: GeoLiteCity.dat NOT FOUND problem
Reply With Quote #8

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

Last edited by HiDeath; 05-23-2019 at 21:46.
HiDeath is offline
NomisCZ
AlliedModders Donor
Join Date: Mar 2014
Location: $this->Czech_Republic
Old 05-24-2019 , 12:29   Re: GeoLiteCity.dat NOT FOUND problem
Reply With Quote #9

Quote:
Originally Posted by HiDeath View Post
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
__________________



Steam: NomisCZ
NomisCZ is offline
HiDeath
Senior Member
Join Date: Aug 2018
Old 05-24-2019 , 13:53   Re: GeoLiteCity.dat NOT FOUND problem
Reply With Quote #10

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 ?
HiDeath is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 16:54.


Powered by vBulletin®
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Theme made by Freecode