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
?
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!