After deploying CABI 4.10 in a MySQL environment, the cabi probe will not start, and turns red almost immediately.
The cabi.log shows :
May 14 10:03:49:828 [main, cabi] activating wasp... May 14 10:03:49:833 [main, cabi] ... activated wasp [time taken=0 minute(s) 0 second(s) (5 ms)] May 14 10:03:49:833 [main, cabi] (42) , CABI installer failed with exit code=1 at com.ca.cabi4uim.installer.CabiInstaller.runCabiInstaller(CabiInstaller.java:247) at com.ca.cabi4uim.Probe.doConfigAndRunCabiInstaller(Probe.java:441) at com.ca.cabi4uim.Probe.setupCabiInBundledMode(Probe.java:388) at com.ca.cabi4uim.Probe.setupcabi(Probe.java:354) May 14 10:03:49:833 [main, cabi] setting the lastInstallStatus=4 May 14 10:03:49:835 [main, cabi] successfully set the lastInstallStatus=4 May 14 10:03:49:835 [main, cabi] srcFilePath=/opt/nimsoft/probes/service/cabi/cabi.log, srcFilePath.exists=true, tgtFilePath=/opt/nimsoft/probes/service/cabi/cabi_install_archive.log, tgtFilePath.exists=false May 14 10:03:51:163  Controller: Probe 'cabi' (command = <startup java>) returns no-restart code (42)
The cause for this issue is insufficient privileges on the "mysql" database which is a standard system database on MySQL.
This is a result of following the "Manual Database Creation" process documented here:
Specifically, this document contains the following GRANT statement:
GRANT ALL PRIVILEGES ON <uim_db_name>.* TO 'uim_db_owner'@'%';
MySQL 5.x environment
Issue the following MySQL query:
GRANT ALL PRIVILEGES ON mysql.* TO 'uim_db_owner'@'%';
where uim_db_owner is the username configured to access the database in the data_engine probe.