Topic: geoipupdate errors

[ReetP]

If you use smeserver-geoip you are likely to experience errors in early January for the reasons outlines here:

https://forums.contribs.org/index.php/topic,53857.msg280613.html#new

Please don't open a bug....

Thanks.

[p-jones]

FYI, This issue is now causing a dependency issue with the open vpn bridge update released today.

[ReetP]

Can you be more specufic and show us what happens please. Geoip and openvpn are totally unrelated so it may be due to other factors.

[mmccarn]

I ran into the same problem yesterday with missing dependencies for smeserver-geoip. I was hoping the error was due to outdated repositories, but I'm still seeing the same errors today.

smeserver-geoip has perl-GeoIP2 as a dependency, but I don't have that package in any repo I'm using.

I am also running into a problem with both smeserver-spamassassin and spamassassin.

Code: [Select]

# yum --enablerepo=smeupdates --enablerepo=smecontribs update smeserver-geoip
Loaded plugins: fastestmirror, post-transaction-actions, smeserver
Setting up Update Process
Loading mirror speeds from cached hostfile
 * base: centos2.zswap.net
 * smeaddons: mirror.canada.pialasse.com
 * smecontribs: mirror.canada.pialasse.com
 * smeextras: mirror.canada.pialasse.com
 * smeos: mirror.canada.pialasse.com
 * smeupdates: mirror.canada.pialasse.com
 * updates: centos2.zswap.net
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction first to finish them.
The program yum-complete-transaction is found in the yum-utils package.
--> Running transaction check
---> Package smeserver-geoip.noarch 0:1.1.2-7.el6.sme will be updated
---> Package smeserver-geoip.noarch 0:1.2-3.el6.sme will be an update
--> Processing Dependency: perl-GeoIP2 for package: smeserver-geoip-1.2-3.el6.sme.noarch
--> Processing Dependency: perl(GeoIP2::Database::Reader) for package: smeserver-geoip-1.2-3.el6.sme.noarch
--> Finished Dependency Resolution
Error: Package: smeserver-geoip-1.2-3.el6.sme.noarch (smecontribs)
           Requires: perl(GeoIP2::Database::Reader)
Error: Package: smeserver-geoip-1.2-3.el6.sme.noarch (smecontribs)
           Requires: perl-GeoIP2
 You could try using --skip-broken to work around the problem
** Found 13 pre-existing rpmdb problem(s), 'yum check' output follows:
php56-php-common-5.6.39-1.el6.remi.x86_64 is a duplicate with php56-php-common-5.6.38-2.el6.remi.x86_64
php56-php-enchant-5.6.39-1.el6.remi.x86_64 is a duplicate with php56-php-enchant-5.6.38-2.el6.remi.x86_64
php56-php-gd-5.6.39-1.el6.remi.x86_64 is a duplicate with php56-php-gd-5.6.38-2.el6.remi.x86_64
php56-php-imap-5.6.39-1.el6.remi.x86_64 is a duplicate with php56-php-imap-5.6.38-2.el6.remi.x86_64
php56-php-ldap-5.6.39-1.el6.remi.x86_64 is a duplicate with php56-php-ldap-5.6.38-2.el6.remi.x86_64
php56-php-soap-5.6.39-1.el6.remi.x86_64 is a duplicate with php56-php-soap-5.6.38-2.el6.remi.x86_64
php70-php-common-7.0.33-1.el6.remi.x86_64 is a duplicate with php70-php-common-7.0.32-1.el6.remi.x86_64
php70-php-enchant-7.0.33-1.el6.remi.x86_64 is a duplicate with php70-php-enchant-7.0.32-1.el6.remi.x86_64
php70-php-gd-7.0.33-1.el6.remi.x86_64 is a duplicate with php70-php-gd-7.0.32-1.el6.remi.x86_64
php70-php-imap-7.0.33-1.el6.remi.x86_64 is a duplicate with php70-php-imap-7.0.32-1.el6.remi.x86_64
php70-php-json-7.0.33-1.el6.remi.x86_64 is a duplicate with php70-php-json-7.0.32-1.el6.remi.x86_64
smeserver-spamassassin-2.4.0-9.el6.sme.noarch has missing requires of DCC
spamassassin-3.4.1-1.el6.sme.x86_64 has missing requires of /usr/bin/dccproc


Code: [Select]

# yum --enablerepo=* list "*GeoIP*"
Loaded plugins: fastestmirror, post-transaction-actions, smeserver
Loading mirror speeds from cached hostfile
 * base: centos2.zswap.net
 * centosplus: centos2.zswap.net
 * contrib: centos2.zswap.net
 * epel: la-mirrors.evowise.com
 * epel-nodejs: la-mirrors.evowise.com
 * extras: centos2.zswap.net
 * fasttrack: centos2.zswap.net
 * smeaddons: mirror.canada.pialasse.com
 * smecontribs: mirror.canada.pialasse.com
 * smedev: mirror.canada.pialasse.com
 * smeextras: mirror.canada.pialasse.com
 * smeos: mirror.canada.pialasse.com
 * smetest: mirror.canada.pialasse.com
 * smeupdates: mirror.canada.pialasse.com
 * smeupdates-testing: mirror.canada.pialasse.com
 * updates: centos2.zswap.net
Installed Packages
GeoIP.x86_64                               1.6.5-1.el6                           @smeos     
GeoIP-GeoLite-data.noarch                  2018.04-1.el6                         @smeupdates
GeoIP-GeoLite-data-extra.noarch            2018.04-1.el6                         @smeupdates
geoipupdate.x86_64                         2.2.1-2.el6                           @smeos     
smeserver-geoip.noarch                     1.1.2-7.el6.sme                       @smecontribs
Available Packages
GeoIP.i686                                 1.6.5-1.el6                           epel       
GeoIP-devel.i686                           1.6.5-1.el6                           epel       
GeoIP-devel.x86_64                         1.6.5-1.el6                           epel       
geoip-geolite.noarch                       2013.04-1.el6                         epel       
geoipupdate-cron.noarch                    2.2.1-2.el6                           epel       
geoipupdate-cron6.noarch                   2.2.1-2.el6                           epel       
lighttpd-mod_geoip.x86_64                  1.4.47-2.el6                          epel       
mod_geoip.x86_64                           1.2.10-1.el6                          epel       
nginx-mod-http-geoip.x86_64                1.10.2-1.el6                          epel       
opensips-mmgeoip.x86_64                    1.7.2-2.el6                           epel       
php-pecl-geoip.x86_64                      1.0.8-3.el6                           epel       
php54-php-pecl-geoip.x86_64                1.1.1-1.el6.remi                      remi-safe   
php55-php-pecl-geoip.x86_64                1.1.1-1.el6.remi                      remi-safe   
php56-php-pecl-geoip.x86_64                1.1.1-1.el6.remi                      remi-safe   
php70-php-pecl-geoip.x86_64                1.1.1-1.el6.remi                      remi-safe   
php71-php-pecl-geoip.x86_64                1.1.1-3.el6.remi                      remi-safe   
php72-php-pecl-geoip.x86_64                1.1.1-4.el6.remi                      remi-safe   
php73-php-pecl-geoip.x86_64                1.1.1-6.el6.remi                      remi-safe   
python-GeoIP.x86_64                        1.2.5-0.2.20090931cvs.el6             epel       
python-pygeoip.noarch                      0.2.6-1.el6                           epel       
smeserver-geoip.noarch                     1.2-3.el6.sme                         smecontribs
uwsgi-plugin-geoip.x86_64                  2.0.17.1-1.el6                        epel


Code: [Select]

# yum --enablerepo=* repolist
Loaded plugins: fastestmirror, post-transaction-actions, smeserver
Loading mirror speeds from cached hostfile
 * base: centos2.zswap.net
 * centosplus: centos2.zswap.net
 * contrib: centos2.zswap.net
 * epel: mirror.us.leaseweb.net
 * epel-nodejs: mirror.us.leaseweb.net
 * extras: centos2.zswap.net
 * fasttrack: centos2.zswap.net
 * smeaddons: mirror.canada.pialasse.com
 * smecontribs: mirror.canada.pialasse.com
 * smedev: mirror.canada.pialasse.com
 * smeextras: mirror.canada.pialasse.com
 * smeos: mirror.canada.pialasse.com
 * smetest: mirror.canada.pialasse.com
 * smeupdates: mirror.canada.pialasse.com
 * smeupdates-testing: mirror.canada.pialasse.com
 * updates: centos2.zswap.net
repo id                                repo name                                     status
base                                   CentOS - os                                    6,710+3
centos-sclo-rh                         Centos - RH Software Collections                 2,880
centos-sclo-sclo                       CentOS-6 - SCLo sclo                               406
centos-sclo-sclo-debuginfo             CentOS-6 - SCLo sclo Debuginfo                     145
centos-sclo-sclo-source                CentOS-6 - SCLo sclo Sources                         0
centos-sclo-sclo-testing               CentOS-6 - SCLo sclo Testing                       537
centosplus                             CentOS - centosplus                                 42
contrib                                CentOS - contrib                                     0
epel                                   Epel - EL6                                    12,503+1
epel-nodejs                            Epel - EL6                                      12,504
extras                                 CentOS - extras                                     35
fasttrack                              CentOS - fasttrack                                   2
fws                                    Firewall Services                                  440
puppet5                                Puppet 5 Repository el 6 - x86_64                  112
remi-safe                              Remi - safe                                      2,732
smeaddons                              SME Server - addons                                 28
smecontribs                            SME Server - contribs                              383
smedev                                 SME Server - dev                                   108
smeextras                              SME Server - extras                                165
smeos                                  SME Server - os                                    905
smetest                                SME Server - test                                  129
smeupdates                             SME Server - updates                               138
smeupdates-testing                     SME Server - updates testing                        88
sogo3                                  Inverse SOGo Repository                             49
sogo4                                  Inverse Sogo4 Repository                            42
stephdl                                Mirror de Labrusse                                 112
updates                                CentOS - updates                                 256+1
wazuh                                  Wazuh repository                                    88
repolist: 41,539

[edit]
I am able to update if I specify "--except=smeserver-geoip" when running yum update...

[ReetP]

If you follow the link above you will see:

"As a result you will need to install the OpenFusion repo to install the updated contrib"

Read here as well.

https://wiki.contribs.org/GeoIP

You can either continue using the old contrib with the exclude line but note you will most likely get update errors from the geoipupdate tool when the old DBs are pulled, or add the OpenFusion repo to use the new version. If you use geoip with mail then this is really the best route in the absence of a better solution..

There has been some discussion about how best to do this and there is no easy solution.

The DBs can sit alongside each other, but the updater tool will be overwritten in the new version. The old DBs stopped being maintained in April, and by then were pretty poor (I first noticed issues nearly 2 years ago, and with the shortage of IPv4 IPs, the remaining ones are being swapped around a lot leading to location issues). The v1 DBs will disappear entirely on 2nd Jan 2019.

The only core package that relies on the old GeoIP is Proftd which has the geoip module built in by upstream, even though it is never used. Regrettably no one has bothered to attend to this issue upstream, either at RH or Proftpd, despite knowing about it for nearly 2 years, so we can't deprecate/remove the old geoIP packages currently.

Note current spamassassin 3.4.1 can use geoip v1 if enabled, but it is not a install dependency.

Spamassassin 3.4.2 can use geoip v2 if enabled, but again geoip is not an install dependency. I was intending at looking if I can add some keys to enable it in spamassassin.

All in all it is messy and I wish there was a better way. But I haven't found one yet.

[brianr]

Using the openfusion repo to update geoip, results in 206 extra rpms being installed and results in this:

Transaction Check Error:
  file /usr/share/man/man3/Apache::Test.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestConfig.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestMB.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestMM.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestReport.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestRequest.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestRun.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestRunPHP.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestRunPerl.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestServer.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestSmoke.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestTrace.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestUtil.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Bundle::ApacheTest.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch

[ReetP]

Yup there are a lot of packages.

Thank maxmind who supply the dbs.....

Your error is due to having installed something from smetest or elsewhere.

I have seen someone else report the same a while back. Have a search for perl-Apache-Test here or in bugs.

[brianr]

Nothing in bugzilla.

A few in here, but nothing recent AFAICS

I get this:
[root@bjsserver ~]# rpm -qa | grep "perl-Apache-Test"
perl-Apache-Test-1.30-2.el6.rf.noarch
[root@bjsserver ~]# rpm -e perl-Apache-Test
error: Failed dependencies:
   perl(Apache::Test) is needed by (installed) spamassassin-3.4.1-1.el6.sme.x86_64
[root@bjsserver ~]#

[ReetP]

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

And I can't remember the version required.

I think it may be 2.72 but I test built 2.67 in smetest.

I need to check this when home as I can't do much with my phone.

[brianr]

Fond this now,

https://forums.contribs.org/index.php?topic=53754.0

But problem there was disabled smeupdates, which is not my problem.

Regarding the bug - I already have the updated mod_perl as far as I can see:

[root@bjsserver ~]# rpm -qa | grep mod_perl
mod_perl-2.0.4-12.1.el6.sme.x86_64
[root@bjsserver ~]#

[ReetP]

I'm pretty sure this is because at some stage you have probably installed a test package which is causing the conflict.

Seems to be a common problem where over time people have installed test packages etc and things end up in a bit of a pickle.

Can you check what is installed from where with audittools?

It may need a package remived/downgraded to let it update properly.

[ReetP]

Having had a quick look on some of my more stock install it seems that installing geoip 2 does not pull in a higher mod_perl.

rpm -qa |grep mod_perl
mod_perl-2.0.4-12.1.el6.sme.x86_64


rpm -qa |grep -i geoip
perl-GeoIP2-2.001002-1.of.el6.noarch
GeoIP-1.6.5-1.el6.x86_64
GeoIP-GeoLite-data-2018.04-1.el6.noarch
smeserver-geoip-1.2-3.el6.sme.noarch
GeoIP-GeoLite-data-extra-2018.04-1.el6.noarch
geoipupdate-2.2.1-2.el6.x86_64


So we have geoip v2 installed but with mod_perl 2.0.4 so mu guess is to look at the mod_perl issue.

[ReetP]

Brian, did you get this resolved?

[brianr]

Brian, did you get this resolved?

No (New Year intervened).

This is what I have:

[root@bjsserver ~]# rpm -qa | grep mod_perl
mod_perl-2.0.4-12.1.el6.sme.x86_64
[root@bjsserver ~]# rpm -qa | grep geoip
smeserver-geoip-1.1.2-7.el6.sme.noarch
geoipupdate-2.2.1-2.el6.x86_64
[root@bjsserver ~]#

So I seem to have the same mod_perl as you.

So, I tried the install again - and it went through ok!

 I notice that a new version of the smeserver-openfusion rpm came in this morning -so perhaps that fixed it?

As usual - thanks for the help.

PS Only 96 new perl rpms this time (it was 206 last time!). Clearly something has changed.

[ReetP]

Cool.

Openfusion rpm was just a update to other repository rpms and it auto regenerates this one so not likely.


Seems you are still on the old version of geoip? 1.2-3 is the updated one.

[brianr]

Cool.

Openfusion rpm was just a update to other repository rpms and it auto regenerates this one so not likely.


Seems you are still on the old version of geoip? 1.2-3 is the updated one.

The rpm -qa was before I did the update, this is what I got now:

[root@bjsserver ~]# rpm -qa | grep geoip
smeserver-geoip-1.2-3.el6.sme.noarch
geoipupdate-2.2.1-2.el6.x86_64
[root@bjsserver ~]#

[ReetP]

Ok.

Try:

Code: [Select]

rpm -qa | grep -i geoip
as well. You should see the perl geoip2 modules.

[brianr]

Code: [Select]

rpm -qa | grep -i geoipas well. You should see the perl geoip2 modules.

Code: [Select]

rpm -qa | grep -i geoip
smeserver-geoip-1.2-3.el6.sme.noarch
GeoIP-1.6.5-1.el6.x86_64
GeoIP-GeoLite-data-2018.04-1.el6.noarch
GeoIP-GeoLite-data-extra-2018.04-1.el6.noarch
geoipupdate-2.2.1-2.el6.x86_64
perl-GeoIP2-2.001002-1.of.el6.noarch


[brianr]

... and I try the same on one of my other (remote) servers, and get the same dependancy failure for the apache test rpm.

Can't see why it started to work on mine, unless you need a 24 hour gap between trying it, loading the openfusion repo and then trying it again?

[ReetP]

Cool. That is about correct. The old v1 stuff stays as it is a dependency of proftpd.

Geoipupdate will update the v2 DBs only and the WBL plugin to qpsmtpd should work.

There are a couple of minor enhancements we'll look at when I get home..... see the wiki page for links.

Re your other servers are you updating via the panel or CLI?

We are waiting to add the openfusion gpg key to SME. So when you first try their repo you have to accept their key.

Try it on the CLI as per the wiki and check the output.

[brianr]

Re your other servers are you updating via the panel or CLI?
We are waiting to add the openfusion gpg key to SME. So when you first try their repo you have to accept their key.
Try it on the CLI as per the wiki and check the output.

It was on the CLI and I had to accept the GPG key.  Still failed though.

[ReetP]

Please show your CLI for install.

Also:

db yum_repositories show openfusion

Are you getting the apacheTest module as above or another error?

[TerryF]

Just for a base line this is the list of packages an updated sme9.2 vm with the dansguardian contrib pulls for a  smeserver-geoip install:

Dependencies Resolved

============================================================
 Package                     Arch    Version           Repository   Size
============================================================
Installing:
 smeserver-geoip             noarch  1.2-3.el6.sme     smecontribs  21 k
Installing for dependencies:
 perl-Algorithm-C3           noarch  0.09-1.of.el6     openfusion   13 k
 perl-App-cpanminus          noarch  1.7006-1.el6      openfusion   291 k
 perl-B-Hooks-EndOfScope     noarch  0.13-1.of.el6     openfusion   26 k
 perl-B-Hooks-OP-Check       x86_64  0.19-1.of.el6     openfusion   34 k
 perl-CPAN-Meta              noarch  2.150001-1.of.el6 openfusion   141 k
 perl-Carp                   noarch  1.32-1.of.el6     openfusion   22 k
 perl-Class-C3               noarch  0.23-1.of.el6     openfusion   24 k
 perl-Class-Load             noarch  0.20-1.of.el6     openfusion   21 k
 perl-Class-Load-XS          x86_64  0.08-1.of.el6     openfusion   38 k
 perl-Class-Method-Modifiers noarch  2.10-1.of.el6     openfusion   16 k
 perl-Class-Singleton        noarch  1.4-6.el6         base         17 k
 perl-Class-XSAccessor    x86_64     1.19-1.of.el6   openfusion  89 k
 perl-Clone-PP     noarch     1.06-1.of.el6   openfusion  11 k
 perl-Data-Dumper-Concise   noarch     2.022-1.of.el6  openfusion  18 k
 perl-Data-IEEE754   noarch     0.01-1.of.el6   openfusion  11 k
 perl-Data-OptList   noarch     0.107-1.of.el6  openfusion  17 k
 perl-Data-Printer   noarch     0.35-1.of.el6   openfusion  68 k
 perl-Data-Validate-IP    noarch     0.24-1.of.el6   openfusion  16 k
 perl-DateTime     x86_64     1:1.10-1.of.el6  openfusion     168 k
 perl-DateTime-Locale noarch     0.4500-1.of.el6  openfusion     1.8 M
 perl-DateTime-TimeZone    noarch     1.46-1.of.el6   openfusion     328 k
 perl-Devel-GlobalDestruction   noarch     0.12-1.of.el6   openfusion     8.8 k
 perl-Dist-CheckConflicts   noarch     0.02-1.of.el6   openfusion  19 k
 perl-Eval-Closure   noarch     0.11-1.of.el6   openfusion  20 k
 perl-Exporter-Tiny  noarch     1.002001-1.of.el6   openfusion  48 k
 perl-ExtUtils-CBuilder    noarch     1:0.280205-1.of.el6     openfusion  41 k
 perl-ExtUtils-Install    noarch     1.68-1.of.el6   openfusion  41 k
 perl-ExtUtils-Manifest    noarch     1.64-3.of.el6   openfusion  30 k
 perl-File-HomeDir   noarch     1.002-1.of.el6  openfusion  58 k
 perl-File-Which    noarch     1.09-2.el6    base   18 k
 perl-GeoIP2  noarch     2.001002-1.of.el6   openfusion     107 k
 perl-Hash-FieldHash  x86_64     0.14-1.of.el6   openfusion  49 k
 perl-IPC-Cmd     noarch     1:0.76-1.of.el6  openfusion  33 k
 perl-Lexical-SealRequireHints  x86_64     0.007-1.of.el6  openfusion  40 k
 perl-List-AllUtils  noarch     0.08-1.of.el6   openfusion  24 k
 perl-Locale-Maketext-Simple noarch     1:0.21-1.of.el6  openfusion  13 k
 perl-MRO-Compat    noarch     0.12-1.of.el6   openfusion  13 k
 perl-Math-Int128   x86_64     0.18-1.of.el6   openfusion     101 k
 perl-Math-Int64    x86_64     0.34-1.of.el6   openfusion  92 k
 perl-MaxMind-DB-Common    noarch     0.040000-1.of.el6   openfusion  23 k
 perl-MaxMind-DB-Reader    noarch     1.000004-1.of.el6   openfusion  30 k
 perl-Module-Build   noarch     1:0.4211-1.of.el6   openfusion     263 k
 perl-Module-CoreList noarch     2.85-1.of.el6   openfusion  60 k
 perl-Module-Implementation  noarch     0.07-1.of.el6   openfusion  15 k
 perl-Module-Load   x86_64     1:0.16-144.el6  base   29 k
 perl-Module-Load-Conditional   noarch     0.48-1.of.el6   openfusion  18 k
 perl-Module-Runtime  noarch     0.014-1.of.el6  openfusion  18 k
 perl-Moo    noarch     2.003004-1.of.el6   openfusion  64 k
 perl-MooX-StrictConstructor noarch     0.006-1.of.el6  openfusion  20 k
 perl-MooX-Types-MooseLike  noarch     0.25-1.of.el6   openfusion  19 k
 perl-Moose   x86_64     2.1210-2.of.el6  openfusion     1.1 M
 perl-Net-Works    noarch     0.21-1.of.el6   openfusion  39 k
 perl-Package-DeprecationManager     noarch     0.13-1.of.el6   openfusion  15 k
 perl-Package-Stash  noarch     0.33-1.of.el6   openfusion  28 k
 perl-Package-Stash-XS    x86_64     0.25-1.of.el6   openfusion  55 k
 perl-Params-Check   noarch     1:0.32-1.of.el6  openfusion  17 k
 perl-Params-Classify x86_64     0.013-1.of.el6  openfusion  51 k
 perl-Params-Validate x86_64     1.13-1.of.el6   openfusion     136 k
 perl-Perl-OSType   noarch     1.002-4.of.el6  openfusion  16 k
 perl-Role-Tiny    noarch     2.000006-1.of.el6   openfusion  22 k
 perl-Scalar-List-Utils    x86_64     1.49-1.of.el6   openfusion     100 k
 perl-Socket  x86_64     2.009-1.of.el6  openfusion  75 k
 perl-Sort-Naturally  noarch     1.03-1.of.el6   openfusion  16 k
 perl-Sub-Exporter   noarch     0.982-4.el6    base   66 k
 perl-Sub-Exporter-Progressive  noarch     0.001011-1.of.el6   openfusion     9.9 k
 perl-Sub-Identify   x86_64     0.10-1.of.el6   openfusion  30 k
 perl-Sub-Install   noarch     0.928-1.of.el6  openfusion  18 k
 perl-Sub-Name     x86_64     0.12-1.of.el6   openfusion  32 k
 perl-Sub-Quote    noarch     2.005000-1.of.el6   openfusion  22 k
 perl-Task-Weaken   noarch     1.04-1.of.el6   openfusion  16 k
 perl-Term-ANSIColor  noarch     4.03-2.of.el6   openfusion  40 k
 perl-Test-Warnings  noarch     0.016-1.of.el6  openfusion  27 k
 perl-Throwable    noarch     0.200011-1.of.el6   openfusion  24 k
 perl-Try-Tiny     noarch     0.22-1.of.el6   openfusion  19 k
 perl-Variable-Magic  x86_64     0.53-1.of.el6   openfusion  80 k
 perl-bareword-filehandles  x86_64     0.003-1.of.el6  openfusion  40 k
 perl-indirect     x86_64     0.31-1.of.el6   openfusion  58 k
 perl-multidimensional    x86_64     0.009-1.of.el6  openfusion  39 k
 perl-namespace-autoclean   noarch     0.24-1.of.el6   openfusion  24 k
 perl-namespace-clean noarch     0.25-1.of.el6   openfusion  15 k
 perl-strictures    noarch     2.000001-1.of.el6   openfusion  20 k
Updating for dependencies:
 perl-Devel-StackTrace    noarch     1:2.03-1.of.el6  openfusion  31 k
 perl-ExtUtils-MakeMaker   noarch     6.98-1.of.el6   openfusion     279 k
 perl-List-MoreUtils  x86_64     0.415-1.of.el6  openfusion     130 k
 perl-parent  noarch     1:0.228-1.of.el6 openfusion     8.9 k
 perl-version     x86_64     3:0.9908-1.of.el6   openfusion     110 k

Transaction Summary
============================================================
Install   82 Package(s)
Upgrade    5 Package(s)

Total download size: 7.2 M
Is this ok [y/N]: y

[ReetP]

A few more for your list Brian......

yum info mod_perl

And these just for good measure.

/sbin/e-smith/audittools/newrpms |grep dev
/sbin/e-smith/audittools/newrpms |grep test
/sbin/e-smith/audittools/newrpms |grep reetp

[TerryF]

Hi Brian

Just to add to johns post, all that from the remote system that is throwing the error like your original system and a list of the repos configured on same along with the command being issued for the install...

Have been pushing things down the throat of a clean new VM trying to get it to throw a tanty but not yet, just trying to get it to reproduce so as to be prepared for any in future..

Thanks mate

[brianr]

Here's the details asked for:
The Errors:

Transaction Check Error:
  file /usr/share/man/man3/Apache::Test.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestConfig.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestMB.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestMM.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestReport.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestRequest.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestRun.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestRunPHP.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestRunPerl.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestServer.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestSmoke.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestTrace.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Apache::TestUtil.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch
  file /usr/share/man/man3/Bundle::ApacheTest.3pm.gz from install of mod_perl-2.0.9-1.of.el6.x86_64 conflicts with file from package perl-Apache-Test-1.30-2.el6.rf.noarch

OpenFusion Repo:

openfusion=repository
    BaseURL=http://repo.openfusion.net/centos$releasever-$basearch
    EnableGroups=no
    GPGCheck=yes
    GPGKey=http://repo.openfusion.net/RPM-GPG-KEY-openfusion
    Name=Openfusion
    Visible=yes
    status=disabled

Mod_perl

Loading mirror speeds from cached hostfile
 * base: mirror.bytemark.co.uk
 * smeaddons: www.mirrorservice.org
 * smeextras: www.mirrorservice.org
 * smeos: www.mirrorservice.org
 * smeupdates: www.mirrorservice.org
 * updates: mirrors.ukfast.co.uk
Installed Packages
Name        : mod_perl
Arch        : x86_64
Version     : 2.0.4
Release     : 12.1.el6.sme
Size        : 6.1 M
Repo        : installed
From repo   : smeupdates
Summary     : An embedded Perl interpreter for the Apache HTTP Server
URL         : http://perl.apache.org/
License     : ASL 2.0
Description : Mod_perl incorporates a Perl interpreter into the Apache web
            : server, so that the Apache web server can directly execute Perl
            : code. Mod_perl links the Perl runtime library into the Apache web
            : server and provides an object-oriented Perl interface for Apache's
            : C language API.  The end result is a quicker CGI script turnaround
            : process, since no external Perl interpreter has to be started.
            :
            : Install mod_perl if you're installing the Apache web server and
            : you'd like for it to directly incorporate a Perl interpreter.

and install extra rpm's (mmmh - why smetest I wonder?)

smeserver-geoip.noarch                   1.1.2-7.el6.sme            @smetest   
smeserver-mailstats.noarch               1.1-9.el6.sme              @smetest   

[ReetP]

Ahhhhh.... OK - this should not be installed and hence your basic error:

 mod_perl-2.0.9-1.of.el6.x86_64

That package is in openfusion and I presume that for whatever good reason your system is trying to update it.

I'm not sure why because it hasn't on any of our test setups.

I can patch that with the openfusion extra repo rpm but in the meantime try:

Code: [Select]

db yum_repositories setprop openfusion Exclude mod_perl

Code: [Select]

signal-event yum-modify
Latest in sme-updates is

 mod_perl-2.0.4-12.1.el6.sme.x86_64

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

I'll patch that shortly if you can confirm this allows you to update geoip.

And these are pretty obvious - you have installed them from test....

smeserver-geoip.noarch                   1.1.2-7.el6.sme            @smetest   
smeserver-mailstats.noarch               1.1-9.el6.sme              @smetest   

geoip was in contribs but superceded by the new version.

mailstats still has that version as current in contribs.

After you fix the openfusion repo then rip them out and reinstall from contribs

[brianr]

I can patch that with the openfusion extra repo rpm but in the meantime try:

Code: [Select]

db yum_repositories setprop openfusion Exclude mod_perl

Code: [Select]

signal-event yum-modifyLatest in sme-updates is
 mod_perl-2.0.4-12.1.el6.sme.x86_64
https://bugs.contribs.org/show_bug.cgi?id=10685
I'll patch that shortly if you can confirm this allows you to update geoip.

Yup, confirming that worked - patch away!

[ReetP]

Yup, confirming that worked - patch away!

Thanks Brian - on it now.

I have one gotcha that I have just realised.

If you do:

Code: [Select]

yum --enablerepo=smecontribs,openfusion update
It may well drag in a load of updated files which we don't want. I need to test this as it could get messy.

The correct form is:

Code: [Select]

yum --enablerepo=smecontribs,openfusion install smeserver-geoip
Problem is the 'Include' line would be 80 + packages, and probably similar for 'Exclude'

I need to go through and see what else to exclude.

[brianr]

... and the bad news is that server that I updated has lost the ability to resolve through DNS.

I can ping internet IP addresses (e.g .8.8.8.8 ), but not "google.com".

As it is a "live" system I have set its external DNS entry to 8.8.8.8, but that does not seem to allow workstations to work (unless I guess I set there DNS to 8.8.8.8 as well).

I can still login remotely, but not dmagent or Teamviewer through to the workstations.  Luckily it is only a few minutes walk from me.

PS This ought to be in bugzilla?

[ReetP]

... and the bad news is that server that I updated has lost the ability to resolve through DNS.

I can ping internet IP addresses (e.g .8.8.8.8 ), but not "google.com".

As it is a "live" system I have set its external DNS entry to 8.8.8.8, but that does not seem to allow workstations to work (unless I guess I set there DNS to 8.8.8.8 as well).

I can still login remotely, but not dmagent or Teamviewer through to the workstations.  Luckily it is only a few minutes walk from me.

PS This ought to be in bugzilla?

We have never experienced anything like this at all Brian. I've had it running for months, Terry has done more test installs than I care to recall and we have never seen this.

And I'm not sure how it is directly relates to geoip beyond the fact that you obviously have various test packages and possibly other stuff  your install that we don't know of that is causing issues.

None of the packages that are installed for geoip should have anything to do with your machine resolving as far as I am aware. So it doesn't make a huge amount of sense right now.

Have you actually gone and checked the logs in this machine to see what might be happening and why it isn't resolving?

Firewall, DNS, messages etc etc etc? There should be something in the logs somewhere.

Try:
/var/log/dnscache/current
/var/log/dnscache.forwarder/current
/var/log/tinydns/current

[brianr]

nothing in those dnscache and tinydns logs of note except nothing at all after 14:40 this afternoon (all three) which happens to be just the time when I did the yum update to geoip.

Here's the logs from /var/log/messages at that time:

Jan  2 14:40:00 messerver yum[23956]: Updated: perl-Taint-Util-0.08-1.of.el6.x86_64
Jan  2 14:40:02 messerver yum[23956]: Updated: 1:perl-parent-0.228-1.of.el6.noarch
Jan  2 14:40:05 messerver yum[23956]: Updated: perl-Net-CIDR-Lite-0.21-1.of.el6.noarch
Jan  2 14:40:07 messerver yum[23956]: Updated: perl-Net-IP-1.26-1.of.el6.noarch
Jan  2 14:40:12 messerver yum[23956]: Updated: perl-Crypt-OpenSSL-RSA-0.28-1.of.el6.x86_64
Jan  2 14:40:15 messerver yum[23956]: Updated: perl-RPM2-1.0-1.of.el6.x86_64
Jan  2 14:40:20 messerver yum[23956]: Updated: perl-Geo-IP-1.45-1.of.el6.x86_64
Jan  2 14:40:24 messerver yum[23956]: Updated: perl-BSD-Resource-1.2904-1.of.el6.x86_64
Jan  2 14:40:26 messerver yum[23956]: Updated: perl-Text-Template-1.46-1.of.el6.noarch
Jan  2 14:40:29 messerver yum[23956]: Updated: mod_auth_tkt-2.3.99b1-1.of.el6.x86_64
Jan  2 14:40:32 messerver yum[23956]: Updated: perl-Time-TAI64-2.11-1.of.el6.noarch
Jan  2 14:40:36 messerver yum[23956]: Updated: perl-Net-Server-2.008-1.of.el6.noarch
Jan  2 14:40:38 messerver yum[23956]: Updated: perl-IO-Socket-INET6-2.72-1.of.el6.noarch
Jan  2 14:40:49 messerver yum[23956]: Installed: daemontools-encore-1.10-2.of.el6.x86_64
Jan  2 14:40:59 messerver yum[23956]: Updated: perl-DBD-MySQL-4.033-1.of.el6.x86_64
Jan  2 14:41:02 messerver yum[23956]: Updated: perl-File-MMagic-1.30-1.of.el6.noarch
Jan  2 14:41:33 messerver yum[23956]: Erased: perl-IO-Compress-Bzip2
Jan  2 14:43:32 messerver yum[23956]: Erased: perl-Compress-Zlib
Jan  2 14:43:33 messerver yum[23956]: Erased: perl-IO-Compress-Zlib
Jan  2 14:43:43 messerver yum[23956]: Erased: perl-IO-Compress-Base
Jan  2 14:43:58 messerver yum[23956]: Erased: urlview
Jan  2 14:44:24 messerver yum[23956]: Erased: daemontools
Jan  2 14:44:31 messerver /sbin/e-smith/db[27747]: /home/e-smith/db/configuration: OLD UnsavedChanges=no
Jan  2 14:44:31 messerver /sbin/e-smith/db[27747]: /home/e-smith/db/configuration: NEW UnsavedChanges=yes

and this is the last entries in the dnscache log

2019-01-02 14:40:30.234746500 query 21957 c0a80373:f5b7:6deb 1 cescollector.cwatchapi.com.
2019-01-02 14:40:30.234763500 tx 0 1 cescollector.cwatchapi.com. . 7f000002
2019-01-02 14:40:30.234848500 nxdomain 7f000002 0 cescollector.cwatchapi.com.
2019-01-02 14:40:30.234862500 sent 21957 44
2019-01-02 14:40:40.240137500 query 21958 c0a80373:cd8b:6b44 1 cescollector.cwatchapi.com.
2019-01-02 14:40:40.240156500 tx 0 1 cescollector.cwatchapi.com. . 7f000002
2019-01-02 14:40:40.240244500 nxdomain 7f000002 0 cescollector.cwatchapi.com.
2019-01-02 14:40:40.240257500 sent 21958 44

Looks like requests are not getting through to the dns at all?

dig bjsystems.co.uk
; <<>> DiG 9.8.2rc1-RedHat-9.8.2-0.68.rc1.el6_10.1 <<>> bjsystems.co.uk
;; global options: +cmd
;; connection timed out; no servers could be reached

tinydns and dnscache seems to be running:

[root@messerver dnscache.forwarder]# ps ax | grep tinydns
  961 ?        Ds     0:05 runsv tinydns
 7130 ?        S      0:00 /usr/local/bin/tinydns
28041 pts/1    S+     0:00 grep tinydns
[root@messerver dnscache.forwarder]# ps ax | grep dnscache
  940 ?        Ss     0:05 runsv dnscache.forwarder
  969 ?        Ss     0:05 runsv dnscache
 6991 ?        S      0:00 /usr/local/bin/dnscache
 7252 ?        S      0:00 /usr/local/bin/dnscache
28677 pts/1    S+     0:00 grep dnscache

Wondering about perl_IO-Socket-INET6.

This is version from the non working system - perl-IO-Socket-INET6-2.72-1.of.el6.noarc

and this is the one from a working one - perl-IO-Socket-INET6-2.57-2.el6.rfx.noarch

It was updated just about when the tinydns last got a request, and sounds relevant (!)

However i can't use yum to downgrade as the server will not resolve!  I think it might work direct on the console - i'll have to try tomorrow.

[ReetP]

I installed the latest perl INET6 myself and it seemed to work

From the look of it you have installed everything updatable from openfusion. I can see a few files there that should NOT have been updated

I'm not sure how you managed that?

What command did you issue - I did mention above what to do?

[brianr]

I installed the latest perl INET6 myself and it seemed to work

From the look of it you have installed everything updatable from openfusion. I can see a few files there that should NOT have been updated

I'm not sure how you managed that?

What command did you issue - I did mention above what to do?

Yes i follwed your instructions I think:

[root@messerver dnscache.forwarder]# db yum_repositories show openfusion
openfusion=repository
    BaseURL=http://repo.openfusion.net/centos$releasever-$basearch
    EnableGroups=no
    Exclude=mod_perl
    GPGCheck=yes
    GPGKey=http://repo.openfusion.net/RPM-GPG-KEY-openfusion
    Name=Openfusion
    Visible=yes
    status=disabled
 
and then did the yum update -y --enablerepo=smecontribs,openfusion

aha - I did not soley update smeserver-geoip I did a full update.  That I presume was the mistake?  Drat.

Any idea how I can back out of it?  Or is it a full re-install and restore?

I can get a full list of the rpms updated by

/sbin/e-smith/audittools/newrpms |grep openfusion

If I could get rpm downgrade to work then I could downgrade each one in a batch file?

[ReetP]

There's your problem:

yum update -y --enablerepo=smecontribs,openfusion

You have enabled both repos and told SME to update all available packages from them.

From my earlier post....

The correct form is:

yum --enablerepo=smecontribs,openfusion install smeserver-geoip

I'm not sure if you can downgrade. There's a lot of packages. Likely first culprit is daemontools. A lot of the perl packages probably aren't so important.

[brianr]

I'm getting this for daemontools:

[root@messerver ~]# yum downgrade daemontools
Loaded plugins: fastestmirror, post-transaction-actions, smeserver
Setting up Downgrade Process
Loading mirror speeds from cached hostfile
 * base: mirrors.ukfast.co.uk
 * smeaddons: www.mirrorservice.org
 * smeextras: www.mirrorservice.org
 * smeos: www.mirrorservice.org
 * smeupdates: www.mirrorservice.org
 * updates: repo.uk.bigstepcloud.com
No Match for available package: daemontools-0.76-6.el6.sme.x86_64
Nothing to do

How can I tell which repo it came from?  I tried smecontribs as well.

[root@messerver ~]# rpm -qa | grep daemon
daemontools-encore-1.10-2.of.el6.x86_64
[root@messerver ~]#

[ReetP]

Normally yum info, but that will only show you the LATEST repo, not the original.

Best thing is to probably take a browse in the main repos:

http://mirror.hakkers.com/releases/9.2/

http://mirror.hakkers.com/releases/9.2/smeos/x86_64/Packages/

[brianr]

Normally yum info, but that will only show you the LATEST repo, not the original.
Best thing is to probably take a browse in the main repos:
http://mirror.hakkers.com/releases/9.2/
http://mirror.hakkers.com/releases/9.2/smeos/x86_64/Packages/

Found it in smeos - Any idea why it won't install / downgrade?

[ReetP]

Found it in smeos - Any idea why it won't install / downgrade?

In a word no. Is it because there are other dependencies?

Can you download a copy and localinstall?

[brianr]

Had to abandon this now  - am re-installing from ISO and restoring the data.

[ReetP]

Had to abandon this now  - am re-installing from ISO and restoring the data.

Damn......

[brianr]

Damn......

Sorry - my clients need a system.

Actually I'll probably be replacing one of the Raid drives, so I might be able to resume troubleshooting it in a few days.

[ReetP]

Sorry - my clients need a system.

Needs must.

I'm sorry it went pear shaped

Actually I'll probably be replacing one of the Raid drives, so I might be able to resume troubleshooting it in a few days.

Ok... we need as many hands as possible to prevent this sort of thing happening.

I'll try and have a look at mailstats too when I get a minute.