Forum Discussion
mongosqld not sampling schemas
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