Search code examples
mongodbtableau-apibusiness-intelligenceconnector

Mongodb BI Connector & Tableau: Error while trying to run mongosqld


I'm trying to connect Tableau to MongoDB using MongoDB BI Connector and this instruction (version 2.1 (current)):

https://docs.mongodb.com/bi-connector/v2.1/installation/

but I get an error in step 5:

mongosqld --schema=schema.drdl --mongo-uri=mongodb://localhost:27017

2017-07-04T15:19:44.032+0200 I CONTROL    [initandlisten] mongosqld version: v2.1.0
2017-07-04T15:19:44.032+0200 I CONTROL    [initandlisten] git version: 518180ba2c547d2cc6071f955d98ec6de730c0c9
2017-07-04T15:19:44.032+0200 I CONTROL    [initandlisten] arguments: --mongo-uri mongodb://localhost:27017 --schema schema.drdl
2017-07-04T15:19:44.032+0200 I CONTROL    [initandlisten] ** WARNING: Access control is not enabled for mongosqld.
2017-07-04T15:19:44.032+0200 I CONTROL    [initandlisten]
2017-07-04T15:19:44.038+0200 I NETWORK    [initandlisten] connecting to mongodb at mongodb://localhost:27017
error starting server: listen unix /tmp/mysql.sock: bind: address already in use

mongosqld is installed properly:

mongosqld --version

mongosqld version v2.1.0
git version: 518180ba2c547d2cc6071f955d98ec6de730c0c9

also, my mongod is running and working with the default port (27017) by running this command:

sudo mongod --dbpath /mnt/PROJET-CIRMAR-1T/

Do you have any idea that what's the problem with running mongosqld?


Solution

  • I don't know why but the problem was with the mysql.sock file. So, you can remove it or move it somewhere else and try executing the command again. At least in my case, the problem is solved and mongosqld is running! Maybe it helps someone in the future and maybe someone let us know what's the exact reason!