SQLite version problem

majherek · June 2021

Hi,

in make a fresh install of xormon. I try to configure backend using local installation.
I get:

Checking Xormon mode
Executing SQLiteDB-test.sh
Getting jquery/mainLib.js
Enabling lpar2rrd native UI via settings.sh
Enabling lpar2rrd native UI via settings.sh responseStatus: 200 OK body: { "status" : "OK", "detail" : "UI enabled already" }
Syncing Xormon users & groups

LPAR2RRD setup check result: SUCCESS

Checking STOR2RRD settings:
Opening file: /home/stor2rrd/stor2rrd/bin/storage.pl
File /home/stor2rrd/stor2rrd/bin/storage.pl is accessible
Getting STOR2RRD version
Checking Xormon mode
Executing SQLiteDB-test.sh
Getting jquery/mainLib.js
Enabling stor2rrd native UI via settings.sh
Enabling stor2rrd native UI via settings.sh responseStatus: 200 OK body: { "detail" : "UI enabled already", "status" : "OK" }
Syncing Xormon users & groups

STOR2RRD setup check result: SUCCESS

Backend configuration saved successfully

But on right corner I get:

Error

SQLite version required: 3.8.3
LPAR2RRD SQLite version: 3.7.17
Help page

(BTW: Link doesn't work: https://www.xormon.com/SQLite_install.php)

stor2rrd@monitor:~/stor2rrd> sqlite3 -version

3.8.10.2 2015-05-20 18:17:19 2ef4f3a5b1d1d0c4338f8243d40a2452cc1f7fe4

stor2rrd@monitor:~/stor2rrd> ./bin/SQLiteDB-test.sh

OK

lpar2rrd@monitor:~/lpar2rrd> ./bin/SQLiteDB-test.sh

OK

It is running on SUSE 12 SP5.

monitor:/home/lpar2rrd/lpar2rrd # rpm -qa |grep -i sqlite

sqlite3-3.8.10.2-9.15.1.x86_64

perl-DBD-SQLite-1.40-3.175.x86_64

libsqlite3-0-3.8.10.2-9.15.1.x86_64

TomasJetelina · June 2021

what is the output of http://<YOUR_LPAR2RRD_HOSTNAME>/lpar2rrd-cgi/dbwrapper.sh?procname=getSqliteVersion

TomasJetelina · June 2021

try to update perl-DBD-SQLite by following https://www.xormon.com/install-xormon.php#backend

majherek · June 2021

Hi,

on ULR I get:

[
   "3.7.17"
]

But why? Only version of SQLite installed on this server is 3.8.10.

From where lpar2rrd is taking sqlite?

lpar2rrd@monitor:~/lpar2rrd> . etc/lpar2rrd.cfg
lpar2rrd@monitor:~/lpar2rrd> sqlite3
sqlite3           sqlite3_analyzer
lpar2rrd@monitor:~/lpar2rrd> sqlite3 -version
3.8.10.2 2015-05-20 18:17:19 2ef4f3a5b1d1d0c4338f8243d40a2452cc1f7fe4

TomasJetelina · June 2021

you need to update Perl driver

zypper addrepo https://download.opensuse.org/repositories/server:database/openSUSE_Leap_15.2/server:database.repo
zypper refresh
zypper install sqlite3
zypper install perl-DBD-SQLite

majherek · June 2021

I use SLES12 SP5 (which is supported version of SLES).

I have to upgrade perl-DBD-SQLite.

zypper addrepo https://download.opensuse.org/repositories/devel:languages:perl/SLE_12_SP4/devel:languages:perl.repo
zypper refresh
zypper install perl-DBD-SQLite

And now it's working. I get:

[
   "3.32.3"
]

Thx

SQLite version problem

Comments

Howdy, Stranger!

Categories

In this Discussion