Re: [IBMiOSS] Install of MariaDB fails

On Dec 31, 2016, at 5:28 PM, Pete Helgren <pete@xxxxxxxxxx> wrote:

I am 0 for three this week....decided to install the ZendDBi as suggested by Bryan. It seems to install, then fails with the helpful message "THE INSTALL SCRIPT RETURNED AN ERROR. CHECK THE I" and then rolls back the install. Here is what the joblog has (in part):

30 12/31/16 10:37:46.098528 QP2USER2 QSYS *STMT QP0ZEXEC
From user . . . . . . . . . : QSECOFR
From module . . . . . . . . : QP2EXERR
From procedure . . . . . . : sendmsg__FPCcN21e
Statement . . . . . . . . . : 31
To module . . . . . . . . . : QP0ZEXECUT
To procedure . . . . . . . : run__14Qp0zExecutableFv
Statement . . . . . . . . . : 6
Message . . . . : Could not load dependent PASE for i module
/QOpenSys/opt/freeware/lib/libssl.a(libssl.so.0).
Cause . . . . . : The error occurred attempting to load PASE for i module
/QOpenSys/opt/freeware/lib/libssl.a(libssl.so.0). Recovery . . . : See

And then:

30 12/31/16 10:37:46.098569 QP2USER2 QSYS *STMT QP0ZEXEC
From user . . . . . . . . . : QSECOFR
From module . . . . . . . . : QP2EXERR
From procedure . . . . . . : sendmsg__FPCcN21e
Statement . . . . . . . . . : 31
To module . . . . . . . . . : QP0ZEXECUT
To procedure . . . . . . . : run__14Qp0zExecutableFv
Statement . . . . . . . . . : 6
Message . . . . : Member libssl.so.0 not found in PASE for i archive .
Cause . . . . . : The error occurred attempting to load PASE for i progra
/usr/local//mariadb-10.1.12-os400-powerpc/bin/mysqld. Recovery . . . :
Correct the error and then try the request again.

ls - l on the folder, selecting libssl* :

bash-4.2$ ls -l /QOpenSys/opt/freeware/lib/libssl*

-rw-r--r-- 1 pete 0 6017600 May 28 2016 /QOpenSys/opt/freeware/lib/libssl.a
lrwxrwxrwx 1 pete 0 30 Oct 13 21:17 /QOpenSys/opt/freeware/lib/libssl.so -> libssl.so.1.0.2
-rw-r--r-- 1 pete 0 362538 May 28 2016 /QOpenSys/opt/freeware/lib/libssl.so.0.9.7
-rw-r--r-- 1 pete 0 528217 May 28 2016 /QOpenSys/opt/freeware/lib/libssl.so.0.9.8
-rw-r--r-- 1 pete 0 580902 May 28 2016 /QOpenSys/opt/freeware/lib/libssl.so.1.0.0
-rw-r--r-- 1 pete 0 603254 May 28 2016 /QOpenSys/opt/freeware/lib/libssl.so.1.0.1
-rwxr-xr-x 1 pete 0 695885 May 28 2016 /QOpenSys/opt/freeware/lib/libssl.so.1.0.2

A find, looking for libssl.a turns up this list:

bash-4.2$ find / -name libssl.a
/QOpenSys/QIBM/ProdData/SC1/OpenSSL/lib/libssl.a
/QOpenSys/usr/lib/libssl.a
/QOpenSys/opt/freeware/lib/libssl.a
/QOpenSys/opt/freeware/64/lib/libssl.a

And, finally, ar turns up the object in /QOpenSys/usr/lib/libssl.a

bash-4.2$ ar t /QOpenSys/opt/freeware/64/lib/libssl.a
libssl.so.1.0.2
libssl.so.0.9.7
libssl.so.0.9.8
libssl.so.1.0.0
libssl.so.1.0.1
bash-4.2$ ar t /QOpenSys/opt/freeware/lib/libssl.a
libssl.so.1.0.2
libssl.so.0.9.7
libssl.so.0.9.8
libssl.so.1.0.0
libssl.so.1.0.1
bash-4.2$ ar t /QOpenSys/usr/lib/libssl.a
libssl.so.0
libssl.so.0.9
libssl.so.0.9.8
libssl.so.1
libssl.so.1.0
libssl.so.1.0.0

So, the question is: Why is the installer for MariaDB looking at the OSS folders rather than in /QOpenSys/usr/lib/? I don't think LIBPATH is set anywhere. This installer runs on the IBM i command line, so, not sure how to fix....

--
Pete Helgren
www.petesworkshop.com
GIAC Secure Software Programmer-Java
Twitter - Sys_i_Geek IBM_i_Geek

--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.