Mongodb BI connector error

Other MongoDB Topics
1

Dear Team, we have a mongo database service purchased from G42 cloud name DDS, however now we are trying to connect database with tableau but we unable to do that due to number of error however now we have install BI connector over a linux machine under the same vpc and I am able to connect database with cli but with BI connector configuration file we are getting issue below is the configuration I have used and error :-1:

systemLog:
  logAppend: false
  path: "/var/log/mongosqld/mongosqld.log"
  verbosity: 2

security:
  enabled: true

mongodb:
  net:
    uri: "192.168.0.101:8635"
    auth:
      username: "username I have added"
      password: "password I have added"
      source: admin
      mechanism: "SCRAM-SHA-1"

security:
  enabled: true
  defaultSource: "admin"

net:
  bindIp: 127.0.0.1
  port: 3307
  ssl:
    mode: "disabled"
systemLog:
  path: '/var/log/mongosqld/mongosqld.log'
  quiet: false
  verbosity: 2
  logRotate: "rename"

processManagement:
  service:
    name: mongosqld
    displayName: mongosqld
    description: "BI Connector SQL proxy server"

error :-1:

2023-07-24T19:47:16.103+0400 I CONTROL    [initandlisten] mongosqld starting: version=v2.14.8 pid=55062 host=mongodb-test
2023-07-24T19:47:16.103+0400 I CONTROL    [initandlisten] git version: a72154240816a45fd921fe5712dbb290aabd31ed
2023-07-24T19:47:16.103+0400 I CONTROL    [initandlisten] OpenSSL version OpenSSL 1.1.1f  31 Mar 2020 (built with OpenSSL 1.1.1f  31 Mar 2020)
2023-07-24T19:47:16.103+0400 I CONTROL    [initandlisten] options: {}
2023-07-24T19:47:16.103+0400 I CONTROL    [initandlisten] ** WARNING: Access control is not enabled for mongosqld.
2023-07-24T19:47:16.103+0400 I CONTROL    [initandlisten]
2023-07-24T19:47:16.105+0400 I NETWORK    [initandlisten] waiting for connections at 127.0.0.1:3307
2023-07-24T19:47:16.105+0400 I NETWORK    [initandlisten] waiting for connections at /tmp/mysql.sock
2023-07-24T19:47:21.106+0400 E NETWORK    [initandlisten] unable to load MongoDB information: failed to create admin session for loading server cluster information: unable to execute command: server selection error: context deadline exceeded, current topology: { Type: Unknown, Servers: [{ Addr: localhost:27017, Type: Unknown, Average RTT: 0, Last error: connection() error occured during connection handshake: dial tcp 127.0.0.1:27017: connect: connection refused }, ] }
2

Dear Team,

Kindly assist us on this.

3

Hey @Rahul_Sharma12,

G42 cloud name DDS is not a MongoDB product. Please see their documentation for more on this subject.

Using any MongoDB official tools on a non-genuine MongoDB server is not supported. Even though there are no visible issues, their correctness cannot be guaranteed.

If you need a cloud-hosted database, I would encourage you to have a look at MongoDB Atlas, as this is created and supported by MongoDB. By opting for MongoDB Atlas, you can continue to leverage the official tools you are already familiar with :slight_smile:.

Regards,
Kushagra