No logs available for MySQL in GW10

Products

• CA API Gateway

Issue/Introduction

After migrating to Gateway 10 ova , here are no logs available for MYSQL in any node of the cluster . 

There is no mysqld.log file created in /var/logs.

Environment

Release : 10.0

Component :

Resolution

The /etc/my.cnf file on a original gateway 10 ova image  does not have a mysqld log entry in the right section .

The log-error entry in the my.cnf is in the [mysqld_safe] section so it is not read when the mysqld. is starting in normal mode. 

This is resolved with the latest CR and Platform patch .

to resolve this without installing the patches add the  error-log entry to the  mysqld section in my.cnf

edit /etc/my.cnf

add in [mysqld] 

#log file location
log-error=/var/log/mysqld.log

restart mysql service