连接功率BI和MongoDB遥控器的问题

Question

我正在尝试连接到远程MONGODB，ALREDY已安装：

1. mongo
2. 工具
3. mongoodbc
4. mongo connector bi

我尝试使用远程设置运行mongosqld（connector bi）

log output directed to C:\Program Files\MongoDB\Connector for BI\2.14\logs\mongosqld.log
2022-04-07T10:56:11.928-0500 I CONTROL    [initandlisten] mongosqld starting: version=v2.14.4 pid=12408 host=CPX-KPKS8VEZ1B3
2022-04-07T10:56:11.928-0500 I CONTROL    [initandlisten] git version: df0cf0b57e9aac0ab6d545eee0d4451d11d0c6e9
2022-04-07T10:56:11.928-0500 I CONTROL    [initandlisten] OpenSSL version OpenSSL 1.0.2n-fips  7 Dec 2017 (built with OpenSSL 1.0.2s  28 May 2019)
2022-04-07T10:56:11.928-0500 I CONTROL    [initandlisten] options: {config: "C:\\Program Files\\MongoDB\\Connector for BI\\2.14\\example-mongosqld-config.yml", systemLog: {path: "C:\\Program Files\\MongoDB\\Connector for BI\\2.14\\logs\\mongosqld.log", verbosity: 2}, schema: {stored: {mode: "custom", source: "mongosqld_data", name: "mySchema"}}, net: {bindIp: [10.40.20.9], port: 27030}, mongodb: {net: {uri: "mongodb://10.40.20.9:27030", auth: {source: "admin"}}}}
2022-04-07T10:56:11.928-0500 I CONTROL    [initandlisten] ** WARNING: Access control is not enabled for mongosqld.
2022-04-07T10:56:11.928-0500 I CONTROL    [initandlisten]
error populating listeners: listen tcp 10.40.20.9:27030: bind: The requested address is not valid in its context.

MongoDB

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

security:
  enabled: true

mongodb:
  net:
    uri: "10.40.20.9:27030"
    auth:
      username: "GONZJIM1"
      password: "Colombia_2021"

net:
  bindIp: 10.40.20.9
  port: 27030
  ssl:
    mode: "disabled"
systemLog:  
  path: 'C:\Program Files\MongoDB\Connector for BI\2.14\logs\mongosqld.log'
  quiet: false  
  verbosity: 2
  logRotate: "rename" 

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

Answer 1

我认为这是因为您在Bindip和MongoDB IP中使用了相同的IP地址和端口号。由于数据库已经在使用该IP地址和端口号，只需将Bindip区域中的端口号更改为27031，然后查看是否成功。