MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: want2fly on 2016-10-11, 03:29:59

Title: How can I install geo-ip database?
Post by: want2fly on 2016-10-11, 03:29:59

Good evening.

I am trying to install geoip database and when I run the following command  :yum install geoip-database libgeoip-dev php5-geoip
  I get :
0 packages excluded due to repository protections
Setting up Install Process
No package geoip-database available.
No package libgeoip-dev available.
No package php5-geoip available.

How can I overcome the issue and install the geoip database?

Thank you

Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-11, 04:00:48

Inform here your 'sh /script/sysinfo'.

Title: Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-11, 16:05:42

A. Kloxo-MR: 6.5.0.f-2014011001

B. OS: CentOS release 6.5 (Final) i686

C. Apps:
   1. MySQL: mysql-5.5.34-1.el6.i686
   2. PHP: php53u-5.3.28-1.ius.el6.i686
   3. Httpd: httpd-2.2.26-1.el6.i686
   4. Lighttpd: --uninstalled--
   5. Nginx: --uninstalled--
   6. Qmail: qmail-toaster-1.03-1.3.31.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.14.mr.el6.i686
   7. Dns: djbdns-1.05-17.3.mr.el6.i686

D. Php-type (for Httpd/proxy): suphp_worker

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:          2048       1152        895          0          0        855
   -/+ buffers/cache:        297       1750
   Swap:          512          0        512

Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-11, 18:20:15

1. Replace php53u to php54 with 'yum replace php53u --replace-with=php54 -y'
2. Install geoip module with 'yum install php54-pecl-geoip -y'

Title: Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-11, 20:15:00

I get the following error :

[root@vps /]# yum replace php53u --replace-with=php54 -y
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.rackspace.com
 * extras: mirrors.xmission.com
 * mratwork-epel: fedora-epel.mirror.lstn.net
 * mratwork-ius: dfw.mirror.rackspace.com
 * updates: mirrors.cat.pdx.edu
http://centos.alt.ru/repository/centos/6/i386/repodata/repomd.xml: [Errno 14] Peer cert cannot be verified or peer cert invalid
Trying other mirror.
0 packages excluded due to repository protections
Replacing packages takes time, please be patient...
Error: No Package Matching php54

Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-12, 03:14:42

The problem is you used the old mratwork.repo.

Try:

Code: [Select]

yum remove mratwork* -y
rpm -ivh https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/mratwork-release-0.0.1-1.noarch.rpm
yum clean all
yum update -y
yum replace php53u --replace-with=php54 -y


Title: Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-12, 04:01:37

I get the following error when trying to remove mratwork* -y :

Code: [Select]

[root@vps /]# yum remove mratwork* -y
Loaded plugins: fastestmirror, priorities, protectbase, replace
Setting up Remove Process
No Match for argument: mratwork-release-0.0.1-1.noarch.rpm
Loading mirror speeds from cached hostfile
 * base: mirror.5ninesolutions.com
 * extras: mirror.raystedman.net
 * mratwork-epel: mirror.compevo.com
 * mratwork-ius: dfw.mirror.rackspace.com
 * updates: www.gtlib.gatech.edu
base                                                     | 3.7 kB     00:00
extras                                                   | 3.3 kB     00:00
http://centos.alt.ru/repository/centos/6/i386/repodata/repomd.xml: [Errno 14] Peer cert cannot be verified or peer cert invalid
Trying other mirror.
mratwork-epel                                            | 4.3 kB     00:00
Not using downloaded repomd.xml because it is older than what we have:
  Current   : Mon Oct 10 13:22:52 2016
  Downloaded: Sun Sep 18 22:07:34 2016
mratwork-ius                                             | 2.3 kB     00:00
mratwork-ius/primary_db                                  | 180 kB     00:00
mratwork-ius-c5                                          | 2.3 kB     00:00
mratwork-litespeed                                       | 3.6 kB     00:00
mratwork-litespeed-update                                | 3.6 kB     00:00
mratwork-release-neutral-arch                            |  951 B     00:00
mratwork-release-neutral-noarch                          |  951 B     00:00
mratwork-release-version-arch                            |  951 B     00:00
mratwork-release-version-noarch                          |  951 B     00:00
mratwork-varnish-3.0                                     |  951 B     00:00
updates                                                  | 3.4 kB     00:00
updates/primary_db                                       | 2.5 MB     00:00
vz-base                                                  |  951 B     00:00
vz-updates                                               |  951 B     00:00
0 packages excluded due to repository protections
No Packages marked for removal



Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-12, 04:30:05

Inform here 'dir -l /etc/yum.repos.d'.

Title: Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-12, 04:44:29

total 32
-rw-r--r-- 1 root root 1926 Nov 30  2013 CentOS-Base.repo
-rw-r--r-- 1 root root  638 Nov 30  2013 CentOS-Debuginfo.repo
-rw-r--r-- 1 root root  630 Nov 30  2013 CentOS-Media.repo
-rw-r--r-- 1 root root 4528 Nov 30  2013 CentOS-Vault.repo
-rw-r--r-- 1 root root 5193 Jan 17  2014 mratwork.repo
-rw-r--r-- 1 root root  219 Jul 24  2013 vz.repo

Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-12, 04:52:52

Try:

Code: [Select]

rpm -ivh https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/mratwork-release-0.0.1-1.noarch.rpm
yum clean all
yum update -y
yum replace php53u --replace-with=php54 -y

Title: Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-12, 05:06:01

Still error:

Code: [Select]

[root@vps /]# rpm -ivh https://github.com/mustafaramadhan/kloxo/raw/rpms/release                                                                                     /neutral/noarch/mratwork-release-0.0.1-1.noarch.rpm
Retrieving https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noa                                                                                     rch/mratwork-release-0.0.1-1.noarch.rpm
Preparing...                ########################################### [100%]
        package mratwork-release-0.0.1-7.noarch (which is newer than mratwork-re                                                                                     lease-0.0.1-1.noarch) is already installed
        file /etc/yum.repos.d/mratwork.repo from install of mratwork-release-0.0                                                                                     .1-1.noarch conflicts with file from package mratwork-release-0.0.1-7.noarch
[root@vps /]# yum clean all
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mratwork-centalt mratwork-epel mratwork-ius mratwork-ius-c5 mratwork-litespeed mratwork-litespeed-update mratwork-release-neutral-arch
              : mratwork-release-neutral-noarch mratwork-release-version-arch mratwork-release-version-noarch mratwork-varnish-3.0 updates vz-base vz-updates
Cleaning up Everything
Cleaning up list of fastest mirrors
[root@vps /]# yum update -y
Loaded plugins: fastestmirror, priorities, protectbase, replace
Determining fastest mirrors
 * base: mirror.teklinks.com
 * extras: mirror.raystedman.net
 * mratwork-epel: fedora-epel.mirror.lstn.net
 * mratwork-ius: dfw.mirror.rackspace.com
 * updates: dist1.800hosting.com
base                                                                                                                                          | 3.7 kB     00:00
base/primary_db                                                                                                                               | 3.7 MB     00:00
extras                                                                                                                                        | 3.3 kB     00:00
extras/primary_db                                                                                                                             |  30 kB     00:00
http://centos.alt.ru/repository/centos/6/i386/repodata/repomd.xml: [Errno 14] Peer cert cannot be verified or peer cert invalid
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: mratwork-centalt. Please verify its path and try again
[root@vps /]#


Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-12, 05:23:16

Code: [Select]

rpm -ivh https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/mratwork-testing-0.1.0-3.noarch.rpm
yum clean all
yum update -y
yum replace php53u --replace-with=php54 -y
mratwork-testing-0.1.0-3.noarch.rpm


Title: Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-12, 05:39:18

Seems like there is a problem with http://centos.alt.ru/repository/centos/6/i386/repodata/repomd.xml

I tried to open it in browser and it's blocked as an attack site by my browser. Not sure if it means anything or not but the XML file is not accessible in this url

Code: [Select]

[root@vps /]# rpm -ivh https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/mratwork-testing-0.1.0-3.noarch.rpm
Retrieving https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/mratwork-testing-0.1.0-3.noarch.rpm
error: Failed dependencies:
        mratwork-release conflicts with mratwork-testing-0.1.0-3.noarch


Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-12, 06:02:55

Change 'rpm -ivh https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/mratwork-release-0.0.1-1.noarch.rpm' to 'rpm -Uvh https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/mratwork-release-0.0.1-1.noarch.rpm'.

So using 'rpm -Uvh' instead 'rpm -ivh'.

Title: Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-12, 06:10:19

Result is the same:

Code: [Select]

[root@vps /]# rpm -Uvh https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/mratwork-release-0.0.1-1.noarch.rpm
Retrieving https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/mratwork-release-0.0.1-1.noarch.rpm
Preparing...                ########################################### [100%]
        package mratwork-release-0.0.1-7.noarch (which is newer than mratwork-release-0.0.1-1.noarch) is already installed
[root@vps /]# yum clean all
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mratwork-centalt mratwork-epel mratwork-ius mratwork-ius-c5 mratwork-litespeed mratwork-litespeed-update mratwork-release-neutral-arch
              : mratwork-release-neutral-noarch mratwork-release-version-arch mratwork-release-version-noarch mratwork-varnish-3.0 updates vz-base vz-updates
Cleaning up Everything
Cleaning up list of fastest mirrors
[root@vps /]# yum update -y
Loaded plugins: fastestmirror, priorities, protectbase, replace
Determining fastest mirrors
 * base: mirrors.xmission.com
 * extras: mirror.millry.co
 * mratwork-epel: fedora-epel.mirror.lstn.net
 * mratwork-ius: dfw.mirror.rackspace.com
 * updates: centos.mirror.lstn.net
base                                                                                                                                          | 3.7 kB     00:00
base/primary_db                                                                                                                               | 3.7 MB     00:00
extras                                                                                                                                        | 3.3 kB     00:00
extras/primary_db                                                                                                                             |  30 kB     00:00
http://centos.alt.ru/repository/centos/6/i386/repodata/repomd.xml: [Errno 14] Peer cert cannot be verified or peer cert invalid
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: mratwork-centalt. Please verify its path and try again


Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-12, 06:34:04

Try 'yum clean all' for 2-3 times before 'yum update -y'.

Title: Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-12, 06:44:49

Followed your suggestion still giving me error:

Code: [Select]

[root@vps /]# yum clean all
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mratwork-centalt mratwork-epel mratwork-ius mratwork-ius-c5 mratwork-litespeed mratwork-litespeed-update mratwork-release-neutral-arch
              : mratwork-release-neutral-noarch mratwork-release-version-arch mratwork-release-version-noarch mratwork-varnish-3.0 updates vz-base vz-updates
Cleaning up Everything
Cleaning up list of fastest mirrors
[root@vps /]# yum clean all
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mratwork-centalt mratwork-epel mratwork-ius mratwork-ius-c5 mratwork-litespeed mratwork-litespeed-update mratwork-release-neutral-arch
              : mratwork-release-neutral-noarch mratwork-release-version-arch mratwork-release-version-noarch mratwork-varnish-3.0 updates vz-base vz-updates
Cleaning up Everything
[root@vps /]# yum clean all
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mratwork-centalt mratwork-epel mratwork-ius mratwork-ius-c5 mratwork-litespeed mratwork-litespeed-update mratwork-release-neutral-arch
              : mratwork-release-neutral-noarch mratwork-release-version-arch mratwork-release-version-noarch mratwork-varnish-3.0 updates vz-base vz-updates
Cleaning up Everything
[root@vps /]# yum clean all
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mratwork-centalt mratwork-epel mratwork-ius mratwork-ius-c5 mratwork-litespeed mratwork-litespeed-update mratwork-release-neutral-arch
              : mratwork-release-neutral-noarch mratwork-release-version-arch mratwork-release-version-noarch mratwork-varnish-3.0 updates vz-base vz-updates
Cleaning up Everything
[root@vps /]# yum update -y
Loaded plugins: fastestmirror, priorities, protectbase, replace
Determining fastest mirrors
 * base: mirrors.gigenet.com
 * extras: mirror.millry.co
 * mratwork-epel: mirror.compevo.com
 * mratwork-ius: dfw.mirror.rackspace.com
 * updates: centos.mirror.lstn.net
base                                                                                                                                          | 3.7 kB     00:00
base/primary_db                                                                                                                               | 3.7 MB     00:00
extras                                                                                                                                        | 3.3 kB     00:00
extras/primary_db                                                                                                                             |  30 kB     00:00
http://centos.alt.ru/repository/centos/6/i386/repodata/repomd.xml: [Errno 14] Peer cert cannot be verified or peer cert invalid
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: mratwork-centalt. Please verify its path and try again
[root@vps /]#


Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-12, 07:18:31

I think something wrong with your 'yum' database.

Try:

Code: [Select]

rm -f /var/lib/rpm/__db*
rpm --rebuilddb
yum clean all
yum update


Title: Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-12, 07:26:59

Still error.

Code: [Select]

[root@vps /]# rm -f /var/lib/rpm/__db*
[root@vps /]# rpm --rebuilddb
[root@vps /]# yum clean all
Loaded plugins: fastestmirror, priorities, protectbase, replace
Cleaning repos: base extras mratwork-centalt mratwork-epel mratwork-ius mratwork-ius-c5 mratwork-litespeed mratwork-litespeed-update mratwork-release-neutral-arch
              : mratwork-release-neutral-noarch mratwork-release-version-arch mratwork-release-version-noarch mratwork-varnish-3.0 updates vz-base vz-updates
Cleaning up Everything
Cleaning up list of fastest mirrors
[root@vps /]# yum update -y
Loaded plugins: fastestmirror, priorities, protectbase, replace
Determining fastest mirrors
 * base: mirrors.gigenet.com
 * extras: mirror.millry.co
 * mratwork-epel: fedora-epel.mirror.lstn.net
 * mratwork-ius: dfw.mirror.rackspace.com
 * updates: centos.mirror.lstn.net
base                                                                                                                                          | 3.7 kB     00:00
base/primary_db                                                                                                                               | 3.7 MB     00:00
extras                                                                                                                                        | 3.3 kB     00:00
extras/primary_db                                                                                                                             |  30 kB     00:00
http://centos.alt.ru/repository/centos/6/i386/repodata/repomd.xml: [Errno 14] Peer cert cannot be verified or peer cert invalid
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: mratwork-centalt. Please verify its path and try again


Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-12, 08:41:11

Give me an access to your ssh and Kloxo-MR panel. I want to know what's a problem is.

Send to PM.

Title: Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-12, 15:26:39

The PM with the details is sent.

Title: Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-13, 02:29:34

Since I am only able to set a maximum 8hr long session it might have expired by now. Just let me know if the password is wrong and I will create another session. Thats how that vps is set up

Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-13, 03:25:55

Quote from: want2fly on 2016-10-13, 02:29:34

Since I am only able to set a maximum 8hr long session it might have expired by now. Just let me know if the password is wrong and I will create another session. Thats how that vps is set up

Still sh access now.

Title: Re: How can I install geo-ip database?
Post by: MRatWork on 2016-10-13, 03:42:12

Already fixed.

Most issue related to still used old version. Example, still using mysql from centalt where already removed.

Title: [SOLVED] Re: How can I install geo-ip database?
Post by: want2fly on 2016-10-13, 03:48:54

Thank you!!