API Gateway 9.4 has been deployed on Microsoft Azure.
Azure Database for MySQL was created along with the link "Create an Azure Database for MySQL server by using the Azure portal" on the above page but "2) Create a new CA API Gateway database" was failed with the following error message.
Error creating database when saving configuration 'Cannot create database: 'Migration failed for change set ssg-base.xml::createProcedure-toGoid::gateway:
Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE FUNCTION toGoid (prefix bigint, suffix bigint)
RETURNS binary(16) DETERMINISTIC
if suffix is null then RETURN null;
else RETURN concat(lpad(char(prefix >> 32, prefix),8,'\0'),lpad(char(suffix >> 32, suffix),8,'\0'));
end;: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)' [code:5, ERROR]'
This error was resolved by the knowledge article https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=46740 but another error was shown up.
An error occurred during configuration.
Error creating database when saving configuration 'Cannot create database: 'Migration failed for change set ssg-base.xml::1408665452836-106::gateway:
Reason: liquibase.exception.UnexpectedLiquibaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.' [code:5, ERROR]'
Release : 9.4
Component : API GATEWAY