Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
My setup is as follows
ubuntu 2 node replica set with ssl and auth enabled mongo db
installed bi connector
when running mongosqld it is giving the below message
2020-08-26T16:34:56.653+0000 I CONTROL [initandlisten] git version: 6fa82d07a176aeee28f685c3f8e8806832c769b0
2020-08-26T16:34:56.653+0000 I CONTROL [initandlisten] OpenSSL version OpenSSL 1.1.1 11 Sep 2018 (built with OpenSSL 1.1.1 11 Sep 2018)
2020-08-26T16:34:56.653+0000 I CONTROL [initandlisten] options: {}
2020-08-26T16:34:56.653+0000 I CONTROL [initandlisten] ** WARNING: Access control is not enabled for mongosqld.
2020-08-26T16:34:56.653+0000 I CONTROL [initandlisten]
2020-08-26T16:34:56.655+0000 I NETWORK [initandlisten] waiting for connections at 127.0.0.1:3307
2020-08-26T16:34:56.655+0000 I NETWORK [initandlisten] waiting for connections at /tmp/mysql.sock
2020-08-26T16:35:01.655+0000 E NETWORK [initandlisten] unable to load MongoDB information: failed to create admin session for loading server cluster information: unable to execute command: context deadline exceeded
with out ssl & auth it is sampling schemas.when i am enablingg ssl and authentication it is giving me the above message.
my odbc.ini file
DESCRIPTION = ODBC for MongoDB BI Connector
DRIVER = /usr/local/lib/libmdbodbca.so
TRACE = Off
TRACEFILE = stderr
READONLY = yes
SERVER = microsot.com
PORT = 2305
USER = root
PASSWORD = ***
DATABASE = admin
; optional SSL configuration
SSLKEY = /home/ohcadmin/mongodb/sslcert/mongor14key
SSLCERT = /home/ohcadmin/mongodb/sslcert/mongo12.pem
SSLMODE = DISABLED|PREFERRED|REQUIRED
SSLCA = /home/ohcadmin/mongodb/sslcert/ca.pem
SSLCAPATH = </path/to/ssl-ca-file-directory>
SSLCIPHER = </path/to/ssl-cipher-file>
RSAKEY = </path/to/rsa-public-key-file>
Please let me know where i am missing something
Regards,
RK
@Anonymous , refer if these can help
https://www.mongodb.com/blog/post/using-power-bi-to-gain-insight-into-your-mongodb-data
https://docs.mongodb.com/bi-connector/master/connect/powerbi/
https://docs.atlas.mongodb.com/tutorial/connect-bic-powerbi/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |