Hi Team, 

Facing issue after OS upgrade from AIX 7.3TL1SP2 to AIX7.3TL2SP2 , however I ran dnf migration process which fix dnf command issue but after that getting more errors and unable to upgrade opensource rpms. 

Please find attachment for RPM list.  

OS Level = AIX 7300-02-02-2420
rpm command working, however dnf/yum complaining: 

server1/ # rpm -qa |head
zlib-1.2.11-1.ppc
iperf-2.0.8-1.ppc
ncurses-6.2-2.ppc
libssh2-1.9.0-1.ppc
libunistring-0.9.9-2.ppc
gettext-0.19.8.1-5.ppc
sqlite-3.32.3-1.ppc
cups-libs-2.2.3-3.ppc
samba-libs-4.10.13-2.ppc
krb5-libs-1.16.1-5.ppc

server1 / # dnf check
warning: Found bdb_ro Packages database while attempting sqlite backend: using bdb_ro backend.
AIX-rpm-7.2.1.1-11.ppc has missing requires of bzip2
AIX-rpm-7.2.1.1-11.ppc has missing requires of file
AIX-rpm-7.2.1.1-11.ppc has missing requires of file-libs
AIX-rpm-7.2.1.1-11.ppc has missing requires of gzip
AIX-rpm-7.2.1.1-11.ppc has missing requires of lua
AIX-rpm-7.2.1.1-11.ppc has missing requires of nspr
AIX-rpm-7.2.1.1-11.ppc has missing requires of nss
AIX-rpm-7.2.1.1-11.ppc has missing requires of patch
AIX-rpm-7.2.1.1-11.ppc has missing requires of rpm
puppet-agent-1.3.2-1.ppc has missing requires of /usr/bin/ruby
Error: Check discovered 10 problem(s)

not sure from where "AIX-rpm-7.2.1.1-11.ppc" is picked by dnf , installed package is "AIX-rpm-7.3.2.3-52.ppc".

server1 / # rpm -qa | grep AIX
AIX-rpm-7.3.2.3-52.ppc

server1 / # lslpp -l | grep -i rpm
  rpm.rte                4.18.1.2003  COMMITTED  RPM Package Manager
  rpm.rte                4.18.1.2003  COMMITTED  RPM Package Manager

while upgrading rpms its throwing error: 

server1 / # dnf update
warning: Found bdb_ro Packages database while attempting sqlite backend: using bdb_ro backend.
AIX 7.3 specific repository                                                                              148 kB/s | 416 kB     00:02
Australia Post AIX Repo for AIX RPM                                                                      8.3 MB/s | 2.2 MB     00:00
Last metadata expiration check: 0:00:01 ago on Fri Dec  6 14:48:32 EETDT 2024.
Error:
 Problem 1: cannot install the best update candidate for package curl-7.58.0-1.ppc
  - nothing provides libcrypto.a(libcrypto.so.1.1) needed by curl-8.9.1-1.ppc
  - nothing provides libssl.a(libssl.so.1.1) needed by curl-8.9.1-1.ppc
 Problem 2: cannot install the best update candidate for package libgcc-7.2.0-1.ppc
  - nothing provides AIX-rpm >= 7.3.0.0 needed by libgcc-1:10-2.ppc
 Problem 3: cannot install the best update candidate for package libssh2-1.8.0-1.ppc
  - nothing provides libcrypto.a(libcrypto.so.1.1) needed by libssh2-1.11.0-1.ppc
 Problem 4: cannot install the best update candidate for package lsof-4.61-4.ppc

Appreciate your help!

Thanks 

RK

Attachment(s)

rpm_list.txt   13 KB 1 version

Hi Raman,

Was their any changes done with the rpm database manually after migration ?

Can you paste the output of ?

lslpp -L | grep openssl

ls /opt/freeware/packages

Hi Sangamesh,

Thanks for looking into this.

Nothing change in RPM database, after OS upgrade we encountered issue as dnf stop working and got exact error message given to "AIX Open Source Tip: DNF errors missing libnss3.so in 73 TL2" 

Follow the provided solution and ended up with this problem as dnf command start working however is reporting wrong packages and looking for old AIX-rpm-7.3.2.3-52.ppc.

server1/ # lslpp -L | grep openssl
  openssl.base           3.0.13.1000    CE    F    Open Secure Socket Layer
  openssl.license        3.0.13.1000    C     F    Open Secure Socket License
  openssl.man.en_US      3.0.13.1000    C     F    Open Secure Socket Layer
server1 / # ls -ltr /opt/freeware/packages
total 16264
-rw-r--r--    1 root     system            0 Dec 06 14:31 rpmdb.sqlite-wal
-rw-r--r--    1 root     system      8294400 Dec 06 14:31 rpmdb.sqlite
-rw-r--r--    1 root     system        32768 Dec 07 08:19 rpmdb.sqlite-shm
server1 / #

Hi Raman,

I don't see  lsof rpm package listed in the "rpm -qa" output, but DNF is throwing an below error.

nothing provides AIX-rpm < 6.2.0.0 needed by lsof-4.89-1.ppc

You had lsof rpm package installed before migration ?

Have you tried to run "updtvpkg"?  I've found this is quite often needed after TL/SP application.

Hi Phill, 

Thanks for looking into this, yes, I have "updtvpkg" multiple times. 

Thanks 

Raman

Hi Raman,

I see that you have provided string command output for "/var/lib/rpm # strings Packages | grep AIX-rpm"

But I don't see the same file (Packages) in the other output you provided.

lserver1 / # ls -ltr /opt/freeware/packages
total 16264
-rw-r--r--    1 root     system            0 Dec 06 14:31 rpmdb.sqlite-wal
-rw-r--r--    1 root     system      8294400 Dec 06 14:31 rpmdb.sqlite
-rw-r--r--    1 root     system        32768 Dec 07 08:19 rpmdb.sqlite-shm

/var/lib/rpm is a soft link to /opt/freeware/packages

Can you provided the output of "ls -l /var/lib/rpm" ?

Hi Sangamesh, 

Below was the output of /var/lib/rpm, we have removed this and created soft link to /usr/opt/freeware/packages, but it didn't help. 

we removed all RPMS, install dnf and then reinstall back all RPMS worked. Somehow old packages stuck in RPM DB which didn't allow to move forward. 

server1/ # ls -l /var/lib/ORIG_rpm
total 45256
-rw-r--r--    1 root     system            0 Nov 16 2023  .dbenv.lock
-rw-r--r--    1 root     system            0 Apr 09 2018  .rpm.lock
-rw-r--r--    1 root     system       933888 Apr 09 2018  Basenames
-rw-r--r--    1 root     system         8192 Apr 09 2018  Conflictname
-rw-r--r--    1 root     system       143360 Apr 09 2018  Dirnames
-rw-------    1 root     system         8192 Dec 06 01:32 Enhancename
-rw-------    1 root     system         8192 Dec 06 01:30 Filetriggername
-rw-r--r--    1 root     system         8192 Apr 09 2018  Group
-rw-r--r--    1 root     system         8192 Apr 09 2018  Installtid
-rw-r--r--    1 root     system         8192 Apr 09 2018  Name
-rw-r--r--    1 root     system         8192 Apr 09 2018  Obsoletename
-rw-r--r--    1 root     system      4472832 Apr 09 2018  Packages_bkp
-rw-r--r--    1 root     system        94208 Apr 09 2018  Providename
-rw-------    1 root     system         8192 Dec 06 01:32 Recommendname
-rw-r--r--    1 root     system        16384 Apr 09 2018  Requirename
-rw-r--r--    1 root     system         8192 Apr 09 2018  Sha1header
-rw-r--r--    1 root     system         8192 Apr 09 2018  Sigmd5
-rw-------    1 root     system         8192 Dec 06 01:32 Suggestname
-rw-------    1 root     system         8192 Dec 06 01:32 Supplementname
-rw-------    1 root     system         8192 Dec 06 01:32 Transfiletriggername
-rw-r--r--    1 root     system         8192 Apr 09 2018  Triggername
-rw-r--r--    1 root     system        24576 Dec 06 12:55 __db.001
-rw-r--r--    1 root     system      7356416 Apr 10 2018  __db.002
-rw-r--r--    1 root     system     83894272 Apr 10 2018  __db.003
-rw-r--r--    1 root     system       557056 Apr 10 2018  __db.004
-rw-r--r--    1 root     system        20480 Jun 19 2017  conflictsindex.rpm
-rw-r--r--    1 root     system       647168 Apr 09 2018  fileindex.rpm
-rw-r--r--    1 root     system        20480 Apr 09 2018  groupindex.rpm
-rw-r--r--    1 root     system        20480 Apr 09 2018  nameindex.rpm
lrwxrwxrwx    1 root     system           26 Dec 07 08:17 packages -> /usr/opt/freeware/packages
-rw-r--r--    1 root     system      2597896 Apr 09 2018  packages.rpm
-rw-r--r--    1 root     system        69632 Apr 09 2018  providesindex.rpm
-rw-r--r--    1 root     system        20480 Apr 09 2018  requiredby.rpm
-rw-r--r--    1 root     system       212992 Dec 09 17:05 rpmdb.sqlite
-rw-r--r--    1 root     system        32768 Dec 09 17:11 rpmdb.sqlite-shm
-rw-r--r--    1 root     system            0 Dec 09 17:05 rpmdb.sqlite-wal
-rw-r--r--    1 root     system         4096 Feb 14 2008  triggerindex.rpm
server1 / #

Thanks 
Raman