KB Article #181079

API Portal cannot be installed with encrypted MySQL connection

Problem

When apiportal_install.sh is run, some RPMs cannot be installed due to misconfigured MySQL encrypted connection.

The problem is caused because PHP verifies whether the hostname of the DB server matches the CN attribute of the server certificate.

Error message may look like: "start update script [...] Could not connect to MySQL. Error [date]"


Resolution

Generate new server certificate in which the Common Name (CN) attribute matches the hostname of the machine.

Doc ref.: https://docs.axway.com/bundle/axway-open-docs/page/docs/apim_installation/apiportal_install/install_software_configure_database/index.html