Installation CA Spectrum R9.4 on Linux fails ... re-install too even libaio applied

[Joerg Liesenfeld]

Dear all,

 

during local tests for installing CA Spectrum R9.4 on Linux(RedHat 6) the installation did fail due to missing "libaio" library (you may find appropriate info under $SPECROOT/Install-Tools/LOGS/<9.4_dir>/mysql.log). Then - applying this missing library - show still a failing CA Spectrum R9.4 re-install. Even during new installation dialog select to not preserve existing files (indicating doing truly a new install from scratch) - the installation fails for the mysql-service part. The $SPECROOT/Install-Tools/LOGS/<9.4_dir>/mysql.log covers then:

 

Installing /usr/spectrum/mysql/my.cnf with basedir = /usr/spectrum/mysql ...

Enabling InnoDB...

InnoDB has been enabled.

Waiting for mysql to start up...

150109  8:53:42 [Note] Plugin 'FEDERATED' is disabled.

./bin/mysqld: Table 'mysql.plugin' doesn't exist

....

150109  8:53:42  InnoDB: Starting an apply batch of log records to the database.

....

150109  8:53:42  InnoDB: Waiting for the background threads to start

150109  8:53:43 InnoDB: 5.5.37 started; log sequence number 1595675

150109  8:53:43 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

150109  8:53:43 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

150109  8:53:43 [Note] Server socket created on IP: '0.0.0.0'.

150109  8:53:43 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

Waiting for mysql to start up...

To resolve this problem you need to fully un-install/delete the "initially failed" Spectrum installation at all - and doing a new install from scratch. This time the install then works. Kind regards, Joerg

[zubsid]

Same issue was for me too.

 

It would have been lot easier if install doc mention installing both i686 and x86_64 packages on 64 bit machines.

[Joerg Liesenfeld]

Dear all,

 

the CA Spectrum installation Guide did not list the required libraries in detail. In addition the Linux-OS setup may cover "some libraries" already - some install options may not load "libs" which are expected. As the CA Spectrum installation could be done via a GUI the "desktop" install will be part of this topic too. Option here is, to make use of a remote workstation to apply ServicePacks/Hotfixpacks - and also the initial install to a destination host. Still - for the SpectroSERVER runtime verify if the following "library sets" are available prior to the install:

 

libxml2.x86_64, libxml2.i686

elfutils-libelf.i686

ncurses-libs.i686

ksh.x86_64

libstdc++.i686

libzip.i686

libaio.i686

 

As you see - "ksh", "ncurses" and "libstdc" .. I would expect to have them on the OS. Regards, Joerg

[Joerg Liesenfeld]

Dear all,

 

please be aware that for CA Spectrum R10 and higher - and due to the mysql 5.5 is now 64bit too - you are required to have the libaio.x86_64 installed too.

Find here:

 

[specadm@LIEJO8126 bin]$ ldd mysqld

        linux-vdso.so.1 =>  (0x00007fffba3a5000)

        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fae24c01000)

        libaio.so.1 => /lib64/libaio.so.1 (0x00007fae249ff000)

        libm.so.6 => /lib64/libm.so.6 (0x00007fae246fc000)

        librt.so.1 => /lib64/librt.so.1 (0x00007fae244f4000)

        libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fae242bd000)

        libdl.so.2 => /lib64/libdl.so.2 (0x00007fae240b8000)

        libc.so.6 => /lib64/libc.so.6 (0x00007fae23cf7000)

        /lib64/ld-linux-x86-64.so.2 (0x00007fae24e24000)

        libfreebl3.so => /lib64/libfreebl3.so (0x00007fae23a78000)

 

The install symptom is truly the same - once it fails the install over existing install appears to fail to correct the symptom.

Regards, Joerg