Any CA API Developer Portal 4.0 request fails on MySQL 5.7

Document ID : KB000010385
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

The MySQL version 5.7 has by default has the sql_mode of ONLY_FULL_GROUP_BY enabled.

This cause any CA API Developer Portal 4.0 request to fail.

We do not yet Support MySQL 5.7, neither on CA API Developer Portal 4.0 nor on CA API Developer Portal 4.1.

Therefore, this information is for internal use only.

Instructions:

You can work around the problem, set within the /etc/my.cnf: 

sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Thereafter restart the MySQL service.

 

The best way of identifying what the sql_mode string should be is to log on to mysql and execute: 

SELECT @@sql_mode; 

 

You can then take that string, removing the ONLY_FULL_GROUP_BY part and place the remainder into /etc/my.cnf on the db instance. 

 

Please see following links for further details:

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by 

https://stackoverflow.com/questions/23921117/disable-only-full-group-by