AnsweredAssumed Answered

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default  value for 'last_update'

Question asked by 1_pablo on Nov 25, 2014
Latest reply on Nov 4, 2016 by Holger_Albert

Hello,

 

I keep getting this error when trying to install CAUIM on RHEL 6.5 amd64 with an exhisting MySQL 5.6 database, I do not have access to MySQL's "root" user, only a "Master" user with full permissions on "CA_UIM" database, howhever, I can change the "my.cnf" parammeters if necessary. I think that it might be a missconfiguration on "my.cnf" file, maybe "sql_mode"?

 

===============================================================================
UIM Scripts Execution Failed!
-----------------------------

========
FAILURE!
========

Please review your /tmp/ia/iaoutput.txt log file. There were failures during
the SLM database creation. You can go back and reattempt after correcting the
problem or continue to exit.

com.zerog.ia.api.pub.FatalInstallException: ===========================
runFile() failed:
File: /opt/nimsoft/nis/sql/mysql/mysql_ace_create.sqlCommand: CREATE TABLE
IF NOT EXISTS `cfg_monitor_applied` (
`mon_app_id` INT(10) NOT NULL AUTO_INCREMENT ,
`cs_id` int not null,
`grp_id` int not null,
`monitor_id` int not null,
`mon_def_id` int not null,
`app_status` int not null,
`app_message` text,
`uninstall_xml` text,
`last_update` TIMESTAMP not null,
PRIMARY KEY (`mon_app_id`),
CONSTRAINT `FK_CFG_MONITOR_APPLIED_CM_COMPUTER_SYSTEM` FOREIGN KEY
`FK_CFG_MONITOR_APPLIED_CM_COMPUTER_SYSTEM` (`cs_id`)
REFERENCES `cm_computer_system` (`cs_id`)
ON DELETE CASCADE
ON UPDATE NO ACTION,
CONSTRAINT `FK_CFG_MONITOR_APPLIED_CFG_MONITOR_DEFINITION` FOREIGN KEY
`FK_CFG_MONITOR_APPLIED_CFG_MONITOR_DEFINITION` (`mon_def_id`)
REFERENCES `cfg_monitor_definition` (`mon_def_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION
)
ENGINE = InnoDB

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default
value for 'last_update'================================


PRESS <ENTER> TO CONTINUE:

Outcomes