topic Re: Unable to connect to MySQL DB on GCP from Qlik Cloud Data Integration in Data Movement & Streaming

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

akaradhya — Wed, 19 Mar 2025 23:06:21 GMT

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

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

Frank_S — Thu, 12 Jan 2023 19:18:26 GMT

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...

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

TimGarrod — Thu, 12 Jan 2023 19:24:43 GMT

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/SourcesConnections/MySQL/prereq-mysql-source.htm

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.