MongoDB ODBC connector - BI connector

Working with Data Connectors & Integrations
1

Hello Team,

I am getting error below after configuring MongoAuth plugin
mysql80-community-release-el7-1.noarch.rpm has been installed.

[root@RH-TABLEAU-04 mysql]# isql -v MongoDBODBC

[08S01][unixODBC][MySQL][ODBC 1.4(w) Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[ISQL]ERROR: Could not SQLConnect

ODBC entry:

[MongoDBODBC]

Description=ODBC for MongoDB BI Connector

Driver=/usr/local/lib/libmdbodbcw.so

#Trace=Yes

TraceFile=stderr

ReadOnly=yes

SERVER=10.210.227.39

PORT=3606

USER=mms-automation

PASSWORD=g@d3C

DATABASE=CLM-PROD

SOCKET = /var/lib/mysql/mysql.sock

[root@RH-TABLEAU-04 tmp]# mysql --host 10.210.227.39 --user='mms-automation'

ERROR 2003 (HY000): Can't connect to MySQL server on '10.210.227.39' (111)

Kindly advise.

Joe

2

Is your mysql up and running
The path of .sock file in your isql command is not matching with that of odbc config file
/tmp/mysql.sock vs /var/lib/mysql/mysql.sock
May be some link is missing or wrong configuration