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 ...
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
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
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.
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:
As you see - "ksh", "ncurses" and "libstdc" .. I would expect to have them on the OS. Regards, Joerg
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.
[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)
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.