Unable to connect to MySQL DB on GCP from Qlik Cloud Data Integration

[akaradhya]

As part of  Qlik cloud Data Integration, I have completed the data gateway setup and I have a couple of DB's setup on GCP (Snowflake and MySQL). I am able to make connection to Snowflake from Cloud DI, but facing the below issue when trying to connect to MySQL 

"Status(StatusCode="Internal", Detail="SYS-E-HTTPFAIL, Cannot connect to ODBC provider. SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib '/path/to/driver/libmyodbc8w.so' : file not found")"

Initially I installed the MySQL 5.0.8 connector (Database engine 8.0.2) and later upgraded it to a 8.0.5 version. I have placed the libmyodbc8w.so file in the required location, but DI is unable to locate it. 

Kindly suggest if I am missing something here. Thanks

[Frank_S]

Hi

Have you tried to reinstall the driver?

https://dev.mysql.com/doc/connectors/en/connector-odbc-installation-binary-unix.html

The path issue seems to be the issue and reinstalling might solve the path errors.

Kind regards...

[TimGarrod · Accepted solution]

Please make sure you have completed all the steps in the pre-requisites section of the documentation. 

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/SourcesC...

Particularly editing the site_arep_login.sh and ensuring it has the appropriate library path config - 

eg - the site_arep_login.sh should have - 

export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/usr/lib64

Also verify the /etc/odbcinst.ini file as defined in the documentation link.