Can't open lib 'MySQL ODBC 8.0 Unicode Driver' : file not found (0) (SQLDriverConnect)\")"

[scroveez]

Hi,

I have an issue with a playbook running the ODBC module, here is my playbook:

• hosts: bigfoot gather_facts: false tasks:
  • name: Collect db version community.general.odbc: dsn: "DRIVER={MySQL ODBC 8.0 Unicode Driver};Server=192.168.58.120;Database=mydb;UID=myuser;PWD=mypass;" query: "SELECT @@version;" params:
    • "" commit: false changed_when: no

ERROR(full trace @ https://pastebin.com/09BZHjC4): "msg": "Failed to connect to DSN: ('01000', u\"[01000] [unixODBC][Driver Manager]Can't open lib 'MySQL ODBC 8.0 Unicode Driver' : file not found (0) (SQLDriverConnect)\")"

[root@docker devel]# ansible --version ansible 2.9.25 config file = /etc/ansible/ansible.cfg configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python2.7/site-packages/ansible executable location = /usr/bin/ansible python version = 2.7.5 (default, Nov 16 2020, 22:23:17) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)]

[root@docker devel]# python --version Python 2.7.5

[root@docker devel]# cat /etc/system-release CentOS Linux release 7.4.1708 (Core)

[root@docker devel]# odbcinst -j
unixODBC 2.3.1 DRIVERS............: /etc/odbcinst.ini SYSTEM DATA SOURCES: /etc/odbc.ini FILE DATA SOURCES..: /etc/ODBCDataSources USER DATA SOURCES..: /root/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8

[root@docker devel]# cat /etc/odbcinst.ini
[PostgreSQL] Description=ODBC for PostgreSQL Driver=/usr/lib/psqlodbcw.so Setup=/usr/lib/libodbcpsqlS.so Driver64=/usr/lib64/psqlodbcw.so Setup64=/usr/lib64/libodbcpsqlS.so FileUsage=1

[MySQL]

Description=ODBC for MySQL

Driver=/usr/lib/libmyodbc5.so

Setup=/usr/lib/libodbcmyS.so

Driver64=/usr/lib64/libmyodbc5.so

Setup64=/usr/lib64/libodbcmyS.so

FileUsage=1

[ODBC Drivers] CData ODBC Driver for MongoDB=Installed

[CData ODBC Driver for MongoDB] Description=CData ODBC Driver for MongoDB 2021 Driver=/opt/cdata/cdata-odbc-driver-for-mongodb/lib/libmongodbodbc.x64.so

UsageCount=2

Driver64=/opt/cdata/cdata-odbc-driver-for-mongodb/lib/libmongodbodbc.x64.so

[MySQL ODBC 8.0 Unicode Driver] Driver=/usr/lib64/libmyodbc8w.so Setup=/usr/lib64/libmyodbc8w.so UsageCount=1 FileUsage = 1

[MySQL ODBC 8.0 ANSI Driver] Driver=/usr/lib64/libmyodbc8a.so UsageCount=1

please advise how to fix this issue.