sqlite3 upgrade problem on Centos7 and missing SQLiteDB-test.sh

nuronex

Hi,

I had lpar2rrd/stor2rrd apliance instaled and working. I'm trying upgrade to xormon following instructions.
When I started 'back-end' section i have problem with upgrade sqlite3 to 3.8 or higher.

I have problem to upgrade sqlite3 and libsqlite3.so dependencies problem.

[sanstg01v].root:/tmp/sqlupgr #  ls -al
total 3360
drwxr-xr-x   2 root root     136 Feb  2 12:49 .
drwxrwxrwt. 24 root root    4096 Feb  2 12:50 ..
-rwxr-xr-x   1 root root 2223124 Feb  2 11:28 perl-DBD-SQLite-with_dependencies.x86_64.tgz
-rwxr-xr-x   1 root root  637264 Feb  2 11:24 sqlite-3.26.0-3.el7.x86_64.rpm
-rwxr-xr-x   1 root root  572768 Feb  2 11:24 sqlite-libs-3.26.0-3.el7.x86_64.rpm
[sanstg01v].root:/tmp/sqlupgr #  rpm -qa | grep -i sqlite
sqlite-3.7.17-8.el7_7.1.x86_64
perl-DBD-SQLite-1.39-3.el7.x86_64
[sanstg01v].root:/tmp/sqlupgr #  yum install sqlite-3.26.0-3.el7.x86_64.rpm
Loaded plugins: enabled_repos_upload, fastestmirror, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager, tracer_upload
Examining sqlite-3.26.0-3.el7.x86_64.rpm: sqlite-3.26.0-3.el7.x86_64
Marking sqlite-3.26.0-3.el7.x86_64.rpm as an update to sqlite-3.7.17-8.el7_7.1.x86_64
Resolving Dependencies
--> Running transaction check
---> Package sqlite.x86_64 0:3.7.17-8.el7_7.1 will be obsoleted
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: yum-metadata-parser-1.1.4-10.el7.x86_64
Loading mirror speeds from cached hostfile
... 00:00:00
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: subversion-1.7.14-16.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: subversion-libs-1.7.14-16.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: libsoup-2.62.2-2.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: nss-softokn-3.53.1-6.el7_9.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: perl-DBD-SQLite-1.39-3.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: setools-libs-3.3.8-4.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: libstoragemgmt-1.8.1-1.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: python-libs-2.7.5-90.el7.x86_64
---> Package sqlite.x86_64 0:3.7.17-8.el7_7.1 will be updated
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: yum-metadata-parser-1.1.4-10.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: subversion-1.7.14-16.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: subversion-libs-1.7.14-16.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: libsoup-2.62.2-2.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: nss-softokn-3.53.1-6.el7_9.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: perl-DBD-SQLite-1.39-3.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: setools-libs-3.3.8-4.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: libstoragemgmt-1.8.1-1.el7.x86_64
--> Processing Dependency: libsqlite3.so.0()(64bit) for package: python-libs-2.7.5-90.el7.x86_64
---> Package sqlite.x86_64 0:3.26.0-3.el7 will be obsoleting
--> Processing Dependency: sqlite-libs = 3.26.0-3.el7 for package: sqlite-3.26.0-3.el7.x86_64
--> Finished Dependency Resolution
Error: Package: python-libs-2.7.5-90.el7.x86_64 (@updates)
           Requires: libsqlite3.so.0()(64bit)
           Removing: sqlite-3.7.17-8.el7_7.1.x86_64 (@updates)
               libsqlite3.so.0()(64bit)
           Updated By: sqlite-3.26.0-3.el7.x86_64 (/sqlite-3.26.0-3.el7.x86_64)
               Not found
           Obsoleted By: sqlite-3.26.0-3.el7.x86_64 (/sqlite-3.26.0-3.el7.x86_64)
               Not found
           Available: sqlite-3.7.17-8.el7.x86_64 (-base)
               libsqlite3.so.0()(64bit)
...
 You could try using --skip-broken to work around the problem
Uploading Enabled Repositories Report
Loaded plugins: fastestmirror, langpacks, product-id, subscription-manager
[sanstg01v].root:/tmp/sqlupgr #

When I'm looking similar problems over Internet there is some problem with higher version of sqlite3 on Centos7.


I've also question about SQLiteDB-test.sh - on my apliance is missing ...

cd /home/lpar2rrd/lpar2rrd
./bin/SQLiteDB-test.sh

nuronex

I resolved problem with SQLiteDB-test.sh - i upgraded lpar2rrd and stor2rrd to 7.06 version.

But still I have problem with upgrade and sqlite3 and missing back-end

Pavel

Hi,

what about this, same result?

yum install ./sqlite-3.26.0-3.el7.x86_64.rpm ./sqlite-libs-3.26.0-3.el7.x86_64.rpm

nuronex

Hi, thank You @Pavel. Definitely it's helped !!! my mistake.

Everything works.