I’m trying to connect PowerBI to my Basic Plan project.
I know there’s a paid option to run the BI Connector on your cloud, but we want to run locally on our Windows Server.
I’m having a hard time connecting mongosqld.exe to our server
BI connector is already installed and showing up in ODBC
But making the connection with mongosqld.exe is not working.
mongosqld --mongo-uri "mongodb://<URI-REPLICA-NODE-1:PORT>,<URI-REPLICA-NODE-2:PORT>,<URI-REPLICA-NODE-3:PORT>/?ssl=true&replicaSet=<URI-REPLICA-SET>&retryWrites=true&w=majority" --auth -u <USERNAME> -p <PASSWORD>
2023-03-16T15:04:14.101-0300 I CONTROL [initandlisten] mongosqld starting: version=v2.14.5 pid=8000 host=EC2AMAZ-OO1JQ7N
2023-03-16T15:04:14.102-0300 I CONTROL [initandlisten] git version: 1ba4542957c4abb8b58cf242ebfd67f7805ef59f
2023-03-16T15:04:14.102-0300 I CONTROL [initandlisten] OpenSSL version OpenSSL 1.0.2n-fips 7 Dec 2017 (built with OpenSSL 1.0.2s 28 May 2019)
2023-03-16T15:04:14.102-0300 I CONTROL [initandlisten] options: {security: {enabled: true}, mongodb: {net: {uri: "mongodb://xxx0.mongodb.net:27017,xxx1.mongodb.net:27017,xxx2.mongodb.net:27017/?ssl=true&replicaSet=atlas-xxx-shard-0&retryWrites=true&w=majority", auth: {username: "xxxUser", password: "<protected>"}}}}
2023-03-16T15:04:14.112-0300 I NETWORK [initandlisten] waiting for connections at 127.0.0.1:3307
2023-03-16T15:04:19.127-0300 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: ReplicaSetNoPrimary, Servers: [{ Addr: xxx0.mongodb.net:27017, Type: Unknown, Average RTT: 0, Last error: connection() error occured during connection handshake: OCSP verification failed: no OCSP cache provided }, { Addr: xxx1.mongodb.net:27017, Type: Unknown, Average RTT: 0, Last error: connection() error occured during connection handshake: OCSP verification failed: no OCSP cache provided }, { Addr: xxx2.mongodb.net:27017, Type: Unknown, Average RTT: 0, Last error: connection() error occured during connection handshake: OCSP verification failed: no OCSP cache provided }, ] }