Topic: Who's Online Update

[Forever]

Has anyone else noticed that the Who's Online script stopped updating it's Maxmind GeoLiteCity database in March?

It seems MaxMind made a change that broke the script. https://dev.maxmind.com/geoip/legacy/geolite/

Anyone know the best way to fix this?

[DW7240]

Hi,

Since the change at Maxmind you need to change the URL address in the "wo-update.php" script as follows....

// maxmind url to download from
$C['url'] = 'http://geolite.maxmind.com/download/geoip/database/GeoLiteCityv6-beta/GeoLiteCityv6.dat.gz';
//$C['url'] = 'http://www.642weather.com/weather/GeoLiteCity.dat.gz'; // do not use my URL!

just edit the middle line as above, the database will then update when you run "wo-update.php" from your website.

THis is only a short term fix, the scripts will have to be changed before January 2019 - Hopefully someone is upto the task...


Nick. dw7240.com.

[Forever]

Thanks for looking at this.

I get the following when I change the URL as above.

Code: [Select]

Checking for updates for the Maxmind GeoLiteCity database...
Connecting to this URL: http://www.642weather.com/weather/GeoLiteCity.dat.gz
curl_last_mod error: fetching timestamp failed for URL, 404 not found?

[DW7240]

Hi,

My mistake, I forgot one file update, you need to goto        https://dev.maxmind.com/geoip/legacy/geolite/


Then find "GeoLite City" dat file, third in the list, Binary / Gzip file, download this, unzip if needed, then copy to your website directory where the main scripts live, the file once on your site should be called GeoLiteCityv6.dat.

Now the script should update as normal, but only until January 2019, then the main scripts have to be updated.  Also you mafind that you have to periodically update the GeoLiteCity.dat file, I think this file is updated monthly.

Also check your URL entry, it looks like you script is trying to load 642weather.com which is the address of the main script writer, it should be downloading from http://geolite.maxmind.com/download/geoip/database/GeoLiteCityv6-beta/GeoLiteCityv6.dat.gz';

Nick. dw7240.com.

[gwwilk]

As a start on additional changes I found this change needed at line 706 in '/whos-online/include-whos-online-page.php':

Code: [Select]

        $remote_file_time = curl_last_mod('http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz');to

Code: [Select]

        $remote_file_time = curl_last_mod('http://geolite.maxmind.com/download/geoip/database/GeoLiteCityv6-beta/GeoLiteCityv6.dat.gz');
in order to check for the correct file time.  There's code in there that demands a 6 hr. wait before checking the file time again, so I'm not sure yet if this works like it should becauseI didn't want to diddle further with the script.

[gwwilk]

Also '/whos-online/wo-update.php' on line 33:

Code: [Select]

$this->setting['url'] = 'http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz';to

Code: [Select]

$this->setting['url'] = 'http://geolite.maxmind.com/download/geoip/database/GeoLiteCityv6-beta/GeoLiteCityv6.dat.gz';
but then the script becomes much less transparent to me.  I don't think this simple change will be effective because more changes appear to be needed.

I suspect that the 'last updated' time will be wrong until these further changes are made.

[ALITTLEweird1]

I got mine too update after making those changes.

[Forever]

I went back to the old file because I was getting odd output with the beta file.