https://bugs.contribs.org/show_bug.cgi?id=10860

Terry Fage <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|IN_PROGRESS                 |RESOLVED
         Resolution|---                         |FIXED

--- Comment #17 from Terry Fage <[email protected]> ---
VERIFICATION

= SME 9.2 with all updates as at 21 Jan 20, Prox VM

= Original problem:
Bug 10860 - Changes to Maxmind access to GeoLite2 DB

= Resolution:
Fixed in smeserver-xt_geoip-1_0_1-24_el6

* Sat Jan 18 2020 Michel Begue <[email protected]> 1.0.1-24.sme
- new download script adapted to SME (from xtables-addons) [SME: 10860]
- change geoiplookup to mmdblookup

= Current version installed:
[root@sme92test ~]# cat /etc/e-smith-release
SME Server release 9.2

[root@sme92test ~]# uname -r
2.6.32-754.25.1.el6.x86_64

[root@sme92test ~]# rpm -qa smeserver-xt_geoip
[root@sme92test ~]#

=Testing:
See bug details for initial issue..

= Updated version installed: 
Register at Mxmind - https://dev.maxmind.com/geoip/geoip2/geolite2/

Update server with new install

Create db and entry for MAXMIND License key

[root@sme92test ~]# db configuration set geoip service status enabled
LicenseKey #######

[root@sme92test ~]# config show geoip
geoip=service
    LicenseKey=#########
    status=enabled

[root@sme92test ~]# yum install --enablerepo=smetest,smecontribs
smeserver-xt_geoip
Loaded plugins: fastestmirror, post-transaction-actions, smeserver
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: centos.mirror.ausnetservers.net.au
 * smeaddons: mirror.canada.pialasse.com
 * smecontribs: mirror.canada.pialasse.com
 * smeextras: mirror.canada.pialasse.com
 * smeos: mirror.canada.pialasse.com
 * smetest: mirror.canada.pialasse.com
 * smeupdates: mirror.canada.pialasse.com
 * updates: mirror.ventraip.net.au
smecontribs                                                                    
                            | 2.9 kB     00:00
smecontribs/primary_db                                                         
                            | 513 kB     00:01
Resolving Dependencies
--> Running transaction check
---> Package smeserver-xt_geoip.noarch 0:1.0.1-24.el6.sme will be installed
--> Processing Dependency: xtables-addons = 1.47.1 for package:
smeserver-xt_geoip-1.0.1-24.el6.sme.noarch
--> Processing Dependency: libmaxminddb-devel >= 1.1.1 for package:
smeserver-xt_geoip-1.0.1-24.el6.sme.noarch
--> Processing Dependency: libmaxminddb >= 1.1.1 for package:
smeserver-xt_geoip-1.0.1-24.el6.sme.noarch
--> Running transaction check
---> Package libmaxminddb.x86_64 0:1.1.1-5.el6 will be installed
---> Package libmaxminddb-devel.x86_64 0:1.1.1-5.el6 will be installed
---> Package xtables-addons.x86_64 0:1.47.1-13.el6.sme will be installed
--> Processing Dependency: xtables-addons-kmod >= 1.47.1-1 for package:
xtables-addons-1.47.1-13.el6.sme.x86_64
--> Processing Dependency: perl-Text-CSV_XS >= 0.80 for package:
xtables-addons-1.47.1-13.el6.sme.x86_64
--> Processing Dependency: perl-Socket >= 2.021 for package:
xtables-addons-1.47.1-13.el6.sme.x86_64
--> Processing Dependency: perl-IO-Socket-INET6 >= 2.67 for package:
xtables-addons-1.47.1-13.el6.sme.x86_64
--> Running transaction check
---> Package perl-IO-Socket-INET6.noarch 0:2.57-2.el6.rfx will be updated
---> Package perl-IO-Socket-INET6.noarch 0:2.72-1.of.el6 will be an update
---> Package perl-Socket.x86_64 0:2.021-1.el6.sme will be installed
---> Package perl-Text-CSV_XS.x86_64 0:0.85-1.el6 will be installed
---> Package xtables-addons-kmod.x86_64 0:1.47.1-11.el6.sme will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================================================================
 Package                              Arch                   Version           
                 Repository                   Size
===================================================================================================================================
Installing:
 smeserver-xt_geoip                   noarch                 1.0.1-24.el6.sme  
                 smetest                      60 k
Installing for dependencies:
 libmaxminddb                         x86_64                 1.1.1-5.el6       
                 smecontribs                  17 k
 libmaxminddb-devel                   x86_64                 1.1.1-5.el6       
                 smecontribs                  28 k
 perl-Socket                          x86_64                 2.021-1.el6.sme   
                 smecontribs                  48 k
 perl-Text-CSV_XS                     x86_64                 0.85-1.el6        
                 smecontribs                  71 k
 xtables-addons                       x86_64                 1.47.1-13.el6.sme 
                 smecontribs                  63 k
 xtables-addons-kmod                  x86_64                 1.47.1-11.el6.sme 
                 smecontribs                 1.4 M
Updating for dependencies:
 perl-IO-Socket-INET6                 noarch                 2.72-1.of.el6     
                 smecontribs                  17 k

Transaction Summary
===================================================================================================================================
Install       7 Package(s)
Upgrade       1 Package(s)

Total download size: 1.7 M
Is this ok [y/N]: y
Downloading Packages:
(1/8): libmaxminddb-1.1.1-5.el6.x86_64.rpm                                     
                            |  17 kB     00:00
(2/8): libmaxminddb-devel-1.1.1-5.el6.x86_64.rpm                               
                            |  28 kB     00:00
(3/8): perl-IO-Socket-INET6-2.72-1.of.el6.noarch.rpm                           
                            |  17 kB     00:00
(4/8): perl-Socket-2.021-1.el6.sme.x86_64.rpm                                  
                            |  48 kB     00:00
(5/8): perl-Text-CSV_XS-0.85-1.el6.x86_64.rpm                                  
                            |  71 kB     00:00
(6/8): smeserver-xt_geoip-1.0.1-24.el6.sme.noarch.rpm                          
                            |  60 kB     00:00
(7/8): xtables-addons-1.47.1-13.el6.sme.x86_64.rpm                             
                            |  63 kB     00:00
(8/8): xtables-addons-kmod-1.47.1-11.el6.sme.x86_64.rpm                        
                            | 1.4 MB     00:00
-----------------------------------------------------------------------------------------------------------------------------------
Total                                                                          
                   2.7 MB/s | 1.7 MB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libmaxminddb-1.1.1-5.el6.x86_64                                 
                                               1/9
  Installing : libmaxminddb-devel-1.1.1-5.el6.x86_64                           
                                               2/9
  Updating   : perl-IO-Socket-INET6-2.72-1.of.el6.noarch                       
                                               3/9
aa  Installing : perl-Text-CSV_XS-0.85-1.el6.x86_64                            
                                                 4/9
  Installing : perl-Socket-2.021-1.el6.sme.x86_64                              
                                               5/9
  Installing : xtables-addons-kmod-1.47.1-11.el6.sme.x86_64                    
                                               6/9
  Installing : xtables-addons-1.47.1-13.el6.sme.x86_64                         
                                               7/9
  Installing : smeserver-xt_geoip-1.0.1-24.el6.sme.noarch                      
                                               8/9
  Cleanup    : perl-IO-Socket-INET6-2.57-2.el6.rfx.noarch                      
                                               9/9

Installed:
  smeserver-xt_geoip.noarch 0:1.0.1-24.el6.sme

Dependency Installed:
  libmaxminddb.x86_64 0:1.1.1-5.el6     libmaxminddb-devel.x86_64 0:1.1.1-5.el6
   perl-Socket.x86_64 0:2.021-1.el6.sme
  perl-Text-CSV_XS.x86_64 0:0.85-1.el6  xtables-addons.x86_64
0:1.47.1-13.el6.sme  xtables-addons-kmod.x86_64 0:1.47.1-11.el6.sme

Dependency Updated:
  perl-IO-Socket-INET6.noarch 0:2.72-1.of.el6

Complete!

[root@sme92test ~]# signal-event post-upgrade; signal-event reboot

[root@sme92test xt_geoip]# /usr/share/xt_geoip/update_base

[root@sme92test xt_geoip]# ll
total 60
drwxr-xr-x 2 root root 12288 Jan 21 12:33 BE
-rwxr-xr-x 1 root root  6190 Jan 19 23:03 geoip_countries_list.txt
-rwxr-xr-x 1 root root  2251 Jan 19 23:03 geoip_exstat
-rwxr-xr-x 1 root root   326 Jan 19 23:03 geoip_listat
-rwxr-xr-x 1 root root   230 Jan 19 23:03 geoip_look
-rwxr-xr-x 1 root root  2338 Jan 19 23:03 geoip_stats
drwxr-xr-x 2 root root  4096 Jan 21 12:34 GeoLite2-Country-CSV_20200114
drwxr-xr-x 2 root root 12288 Jan 21 12:33 LE
-rwxr-x--- 1 root root   120 Jan 19 23:03 update_base
-rwxr-x--- 1 root root   802 Jan 21 12:31 xt_geoip_dl

Confirmed contrib operates without error.

= Problem fixed:
- new download script adapted to SME (from xtables-addons) [SME: 10860]
- change geoiplookup to mmdblookup

= Verified or Reopen:
VERIFIED

= DOCUMENTATION IMPACT:
Wiki will need updating with details and usage

User must apply for a Maxmind account to secure a licence key

new in ConfigDB : geoip->status and geoip->LicenseKey

= Suggested release notes:
Fixed in smeserver-xt_geoip-1_0_1-24_el6

* Sat Jan 18 2020 Michel Begue <[email protected]> 1.0.1-24.sme
- new download script adapted to SME (from xtables-addons) [SME: 10860]
- change geoiplookup to mmdblookup

--- Comment #16 from Terry Fage <[email protected]> ---
VERIFICATION

= SME 9.2 with all updates as at 21 Jan 20, Prox VM

= Original problem:
Bug 10860 - Changes to Maxmind access to GeoLite2 DB

= Resolution:
Fixed in smeserver-xt_geoip-1_0_1-24_el6

* Sat Jan 18 2020 Michel Begue <[email protected]> 1.0.1-24.sme
- new download script adapted to SME (from xtables-addons) [SME: 10860]
- change geoiplookup to mmdblookup

= Current version installed:
[root@sme92test ~]# cat /etc/e-smith-release
SME Server release 9.2

[root@sme92test ~]# uname -r
2.6.32-754.25.1.el6.x86_64

[root@sme92test ~]# rpm -qa smeserver-xt_geoip
[root@sme92test ~]#

=Testing:
See bug details for initial issue..

= Updated version installed: 
Register at Mxmind - https://dev.maxmind.com/geoip/geoip2/geolite2/

Update server with new install

Create db and entry for MAXMIND License key

[root@sme92test ~]# db configuration set geoip service status enabled
LicenseKey #######

[root@sme92test ~]# config show geoip
geoip=service
    LicenseKey=#########
    status=enabled

[root@sme92test ~]# yum install --enablerepo=smetest,smecontribs
smeserver-xt_geoip
Loaded plugins: fastestmirror, post-transaction-actions, smeserver
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: centos.mirror.ausnetservers.net.au
 * smeaddons: mirror.canada.pialasse.com
 * smecontribs: mirror.canada.pialasse.com
 * smeextras: mirror.canada.pialasse.com
 * smeos: mirror.canada.pialasse.com
 * smetest: mirror.canada.pialasse.com
 * smeupdates: mirror.canada.pialasse.com
 * updates: mirror.ventraip.net.au
smecontribs                                                                    
                            | 2.9 kB     00:00
smecontribs/primary_db                                                         
                            | 513 kB     00:01
Resolving Dependencies
--> Running transaction check
---> Package smeserver-xt_geoip.noarch 0:1.0.1-24.el6.sme will be installed
--> Processing Dependency: xtables-addons = 1.47.1 for package:
smeserver-xt_geoip-1.0.1-24.el6.sme.noarch
--> Processing Dependency: libmaxminddb-devel >= 1.1.1 for package:
smeserver-xt_geoip-1.0.1-24.el6.sme.noarch
--> Processing Dependency: libmaxminddb >= 1.1.1 for package:
smeserver-xt_geoip-1.0.1-24.el6.sme.noarch
--> Running transaction check
---> Package libmaxminddb.x86_64 0:1.1.1-5.el6 will be installed
---> Package libmaxminddb-devel.x86_64 0:1.1.1-5.el6 will be installed
---> Package xtables-addons.x86_64 0:1.47.1-13.el6.sme will be installed
--> Processing Dependency: xtables-addons-kmod >= 1.47.1-1 for package:
xtables-addons-1.47.1-13.el6.sme.x86_64
--> Processing Dependency: perl-Text-CSV_XS >= 0.80 for package:
xtables-addons-1.47.1-13.el6.sme.x86_64
--> Processing Dependency: perl-Socket >= 2.021 for package:
xtables-addons-1.47.1-13.el6.sme.x86_64
--> Processing Dependency: perl-IO-Socket-INET6 >= 2.67 for package:
xtables-addons-1.47.1-13.el6.sme.x86_64
--> Running transaction check
---> Package perl-IO-Socket-INET6.noarch 0:2.57-2.el6.rfx will be updated
---> Package perl-IO-Socket-INET6.noarch 0:2.72-1.of.el6 will be an update
---> Package perl-Socket.x86_64 0:2.021-1.el6.sme will be installed
---> Package perl-Text-CSV_XS.x86_64 0:0.85-1.el6 will be installed
---> Package xtables-addons-kmod.x86_64 0:1.47.1-11.el6.sme will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================================================================
 Package                              Arch                   Version           
                 Repository                   Size
===================================================================================================================================
Installing:
 smeserver-xt_geoip                   noarch                 1.0.1-24.el6.sme  
                 smetest                      60 k
Installing for dependencies:
 libmaxminddb                         x86_64                 1.1.1-5.el6       
                 smecontribs                  17 k
 libmaxminddb-devel                   x86_64                 1.1.1-5.el6       
                 smecontribs                  28 k
 perl-Socket                          x86_64                 2.021-1.el6.sme   
                 smecontribs                  48 k
 perl-Text-CSV_XS                     x86_64                 0.85-1.el6        
                 smecontribs                  71 k
 xtables-addons                       x86_64                 1.47.1-13.el6.sme 
                 smecontribs                  63 k
 xtables-addons-kmod                  x86_64                 1.47.1-11.el6.sme 
                 smecontribs                 1.4 M
Updating for dependencies:
 perl-IO-Socket-INET6                 noarch                 2.72-1.of.el6     
                 smecontribs                  17 k

Transaction Summary
===================================================================================================================================
Install       7 Package(s)
Upgrade       1 Package(s)

Total download size: 1.7 M
Is this ok [y/N]: y
Downloading Packages:
(1/8): libmaxminddb-1.1.1-5.el6.x86_64.rpm                                     
                            |  17 kB     00:00
(2/8): libmaxminddb-devel-1.1.1-5.el6.x86_64.rpm                               
                            |  28 kB     00:00
(3/8): perl-IO-Socket-INET6-2.72-1.of.el6.noarch.rpm                           
                            |  17 kB     00:00
(4/8): perl-Socket-2.021-1.el6.sme.x86_64.rpm                                  
                            |  48 kB     00:00
(5/8): perl-Text-CSV_XS-0.85-1.el6.x86_64.rpm                                  
                            |  71 kB     00:00
(6/8): smeserver-xt_geoip-1.0.1-24.el6.sme.noarch.rpm                          
                            |  60 kB     00:00
(7/8): xtables-addons-1.47.1-13.el6.sme.x86_64.rpm                             
                            |  63 kB     00:00
(8/8): xtables-addons-kmod-1.47.1-11.el6.sme.x86_64.rpm                        
                            | 1.4 MB     00:00
-----------------------------------------------------------------------------------------------------------------------------------
Total                                                                          
                   2.7 MB/s | 1.7 MB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libmaxminddb-1.1.1-5.el6.x86_64                                 
                                               1/9
  Installing : libmaxminddb-devel-1.1.1-5.el6.x86_64                           
                                               2/9
  Updating   : perl-IO-Socket-INET6-2.72-1.of.el6.noarch                       
                                               3/9
aa  Installing : perl-Text-CSV_XS-0.85-1.el6.x86_64                            
                                                 4/9
  Installing : perl-Socket-2.021-1.el6.sme.x86_64                              
                                               5/9
  Installing : xtables-addons-kmod-1.47.1-11.el6.sme.x86_64                    
                                               6/9
  Installing : xtables-addons-1.47.1-13.el6.sme.x86_64                         
                                               7/9
  Installing : smeserver-xt_geoip-1.0.1-24.el6.sme.noarch                      
                                               8/9
  Cleanup    : perl-IO-Socket-INET6-2.57-2.el6.rfx.noarch                      
                                               9/9

Installed:
  smeserver-xt_geoip.noarch 0:1.0.1-24.el6.sme

Dependency Installed:
  libmaxminddb.x86_64 0:1.1.1-5.el6     libmaxminddb-devel.x86_64 0:1.1.1-5.el6
   perl-Socket.x86_64 0:2.021-1.el6.sme
  perl-Text-CSV_XS.x86_64 0:0.85-1.el6  xtables-addons.x86_64
0:1.47.1-13.el6.sme  xtables-addons-kmod.x86_64 0:1.47.1-11.el6.sme

Dependency Updated:
  perl-IO-Socket-INET6.noarch 0:2.72-1.of.el6

Complete!

[root@sme92test ~]# signal-event post-upgrade; signal-event reboot

[root@sme92test xt_geoip]# /usr/share/xt_geoip/update_base

[root@sme92test xt_geoip]# ll
total 60
drwxr-xr-x 2 root root 12288 Jan 21 12:33 BE
-rwxr-xr-x 1 root root  6190 Jan 19 23:03 geoip_countries_list.txt
-rwxr-xr-x 1 root root  2251 Jan 19 23:03 geoip_exstat
-rwxr-xr-x 1 root root   326 Jan 19 23:03 geoip_listat
-rwxr-xr-x 1 root root   230 Jan 19 23:03 geoip_look
-rwxr-xr-x 1 root root  2338 Jan 19 23:03 geoip_stats
drwxr-xr-x 2 root root  4096 Jan 21 12:34 GeoLite2-Country-CSV_20200114
drwxr-xr-x 2 root root 12288 Jan 21 12:33 LE
-rwxr-x--- 1 root root   120 Jan 19 23:03 update_base
-rwxr-x--- 1 root root   802 Jan 21 12:31 xt_geoip_dl

Confirmed contrib operates without error.

= Problem fixed:
- new download script adapted to SME (from xtables-addons) [SME: 10860]
- change geoiplookup to mmdblookup

= Verified or Reopen:
VERIFIED

= DOCUMENTATION IMPACT:
Wiki will need updating with details and usage

User must apply for a Maxmind account to secure a licence key

new in ConfigDB : geoip->status and geoip->LicenseKey

= Suggested release notes:
Fixed in smeserver-xt_geoip-1_0_1-24_el6

* Sat Jan 18 2020 Michel Begue <[email protected]> 1.0.1-24.sme
- new download script adapted to SME (from xtables-addons) [SME: 10860]
- change geoiplookup to mmdblookup

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
_______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at https://lists.contribs.org/mailman/public/contribteam/

Reply via email to